An Eclectic Mix To Start the New Year

Database Weekly for January 8, 2022 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com Hand-picked content to sharpen your professional edge Editorial  Where the World Takes You We're launching into a new year and there are lots of "looking into the future" articles out there. Personally, I'm pretty jazzed for the coming year for any number of reasons (can you say "SQL Server 2022"?). However, I also get a little retrospective at times like this. Now, I'm not going to talk about the preceding year. Yeah, it had its challenges. Nah, I'm thinking a bit broader. I just think it's interesting where our life choices take us. In 2005, I was bummed because, at my very first PASS Summit, I couldn't get into the SQL Server Central party because I didn't register ahead of time. Today, I'm putting together this editorial which I'm going to attach to the Database Weekly mailing, all with admin privileges on SQL Server Central. Now that, my friends, is a journey. It's all about the choices we make. I never, in any way, set out to be an admin on SQL Server Central. It's the result of a number of other choices, where I did, with intent, try to make certain things happen. For example, I got my job at Redgate because I went to them and asked for it. The results are what we're looking at today. You may set out with one goal, and achieve, other, equally good things. Just make sure you're striving towards something. Anyone else found themselves in places they would never have expected? Grant Fritchey [Join the debate, and respond to the editorial on the forums](  The Weekly News All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. Vendors/3rd Party Products [Where's the best place to live as a DBA?]( Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here! [Testing a Flyway Database Migration]( Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers. AI/Machine Learning/Cognitive Services [How AI Is Making America’s Roads Safer]( From Dataversity The future of cities will center around mobility, ... [How AI Is Paving the Way for Smart Documentation Management]( From Dataversity Remember the days when we used to stand in a queue... [3 Best Practices When Using AI to Improve Compliance and Content Management]( From Dataversity Organizations are at a pinnacle time to address how to leverage intelligent technologies. As a part of their modernization strategies, AI can help companies keep up with changing expectations... Administration of SQL Server [SQL Server 2019 New Feature - Verbose Truncation Warnings for INSERT Statements]( From MSSQL Tips Learn about the more useful and helpful truncation... [Another Reason to Keep CUs Up-To-Date: Replication Error 20084]( From 36 Chambers – The Legendary Journeys I was helping out with a SQL Server upgrade recent... [How to replace an identity column with a sequence number]( From Simple Talk SQL Server provides two ways to include an increme... [SQL Server 2022 is coming]( From Steve Stedman Microsoft has announced that the next version of S... [What permissions are required for temporary tables?]( From SQLServerCentral Blogs Managing permissions is a constant issue for Datab... Analysis Services / BI on the MS Stack [Sparkline in Power BI]( From RADACAD So you want to add a sparkline in a Power BI report and wonder how to do it. Fortunately, the Power BI team recently added that functionality, and it... Azure CosmosDB [Point-in-time Restores in Azure Cosmos DB]( From SQLShack In this article, we will learn how to perform a po... Azure SQL Managed Instance [How-to find out addressable Disk Space & Files Number on General Purpose service tier on SQL MI]( From Azure SQL In the previous blog posts in the SQL MI How-Tos w... Azure Synapse (SQL Data Warehouse and Data Lake) [Handle Missing Values in Lakehouse using Azure Synapse Mapping Data Flow]( From MSSQL Tips In this article we look at how to handle missing d... Computing in the Cloud (Azure, Google, AWS) [AWS re:Post Takes on Stack Overflow]( From Petri IT Knowledgebase There’s no doubt that the Internet can be a grea... [Deploying Cloud-Native Apps Outside the Public Cloud]( From IT Pro - Microsoft Windows Information, Solutions, Tools There are times when it is better to deploy cloud-... DMO/SMO/Powershell [SQL Server Connection String Examples with PowerShell]( From MSSQL Tips In this article we look at different parameters an... [Install SQL Server and Oracle using PowerShell and Windows Containers]( From MSSQL Tips In this article we look at how to install SQL Serv... Data Mining / Data Analysis [Mathematical odds and ends]( From Statistical Odds & Ends I’ve just started a new blog, Mathematical Odds ... [Sisense’s Ashley Kramer on Data Analytics in 2022]( From Past News - RSS Feeds Ashley Kramer, Chief Product and Marketing Officer... [Data and Analytics: The Pandemic Lessons]( From Dataversity Since the onset of the pandemic, when the world plunged into a state of suspended animation, “touchless business” has become more than a boardroom buzzword, a survival mechanism. Customer... Database Design, Theory and Development [Matching Strings within One Big String]( From Sherpa of Data Continuing on with our series from last time – s... [Lean Governance Delivers Clean, Controlled Data at the Lowest Cost]( From Dataversity Going lean is all about the elimination of waste and risk. In the manufacturing world, lean methods focused on delivering a high-quality product to the customer. In the data... [Building a Data Mesh Architecture in Azure – Part 3]( From Paul Andrew Data Mesh vs Azure –Theory vs practice Use the tag Data Mesh vs Azure to follow this blog series. As a reminder, the four data mesh principals: domain-oriented decentralised... DevOps and Continuous Delivery (CI/CD) [NoOps: IT Operations Getting Closer to Automated Future]( From IT Pro - Microsoft Windows Information, Solutions, Tools While NoOps will never fully arrive, IT teams cont... [The Flyway Configuration Files]( From Product learning – Redgate Software Phil Factor offers a programmer's guide to the Flyway's configuration settings, explaining the different categories of parameters, the role of each of parameter within each category, and how to... ETL/SSIS/Azure Data Factory/Biml [Looking at Activity Queue Times from Azure Data Factory with Log Analytics]( From SQLServerCentral Blogs I’ve been working on a project to populate an Op... [SSIS Azure Feature Pack and the Flexible File components]( From World of Whatever SSIS Azure Feature Pack and the Flexible File comp... MDX/DAX [LN, LOG, LOG10, EXP – DAX Guide]( From Sqlbi LN: Returns the natural logarithm of a number. LOG: Returns the logarithm of a number to the base you specify. LOG10: Returns the base-10 logarithm of a... Microsoft News [Generally available: Support for copying dashboards added to Azure IoT Central]( From Azure Updates Start reusing tiles and dashboards through the new... [Public preview: Semantic Search update]( From Azure Updates Semantic Search, a feature of Azure Cognitive Sear... [Auto-failover groups for Azure SQL Hyperscale now in preview]( From Azure SQL We are excited to announce the preview release of ... Performance Tuning SQL Server [Identifying Recompile Causes]( From Scary DBA (Grant Fritchey) Strictly speaking, a recompile isn’t really a pe... [Serializing Clustered Columnstore Deletes]( From SQLBlog.org See one way to use a queue table to spread out spi... [Software Vendor Mistakes With SQL Server: Not Indexing For Evolving Queries]( From Erik Darling Data Fledgling Like many things, applications tend to ... [Migrating disk-based tables to memory-optimized tables of a SQL database]( From SQLShack In this series of articles, we will learn how to convert the disk-based table to an in-memory table of SQL Database. This article is the first article of the... PowerPivot/PowerQuery/PowerBI [Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 1: Creating A Dataset]( From Chris Webb's BI Blog As a Power BI administrator you want to see what?... [Concatenate Strings in Power BI Using Power Query M Language]( From MSSQL Tips In this article we look at how to concatenate data... [Exploring Streaming Dataflows in Power BI]( From Guy in a Cube Are you wanting to use streaming data? Patrick loo... [How to filter DAX for paginated reports]( DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports. Product Reviews and Articles [Book Review: Professional Azure SQL Managed Database Administration]( This book aims to introduce Azure SQL managed databases, how does it fare? Professional Development [Teaching, learning and tearing your hair out]( From Ayende @ Rahien One of my favorite activities is teaching. I love ... R Language [R Studio with great new feature – multiple code panes]( From TomazTsql With October 2021 version of R Studio (2021.09.1 P... [Little useless-useful R functions – Mastermind board game for R]( From TomazTsql Playing a simple guessing game with R. It’s called Mastermind game! This game was originally created for two people, but R version will be for single-player mode, when an... SQL CLR [SQL Server CLR User Defined Types Example]( From MSSQL Tips In this article we look at how to create a User De... Security News and Issues [People Are Increasingly Choosing Private Web Search]( From Schneier on Security DuckDuckGo has had a banner year: And yet, DuckDuckGo. The privacy-oriented search engine netted more than 35 billion search queries in 2021, a 46.4% jump over 2020 (23.6 billion). That’s... [Avoiding Cybersecurity Staff Burnout: Keeping Employees Productive and Engaged]( From Past News - RSS Feeds Cloud security professionals are already in short ... [What is Active Directory: The Ultimate Guide]( From Petri IT Knowledgebase Learn how Active Directory makes it easier for IT ... [Google Docs Comments Weaponized in New Phishing Campaign]( From Dark Reading: Dark Reading News Analysis Attackers use the comment feature in Google Docs t... [Enterprises Worry About Increased Data Risk in Cloud]( From Dark Reading: Dark Reading News Analysis The 2021 Strategic Security Survey highlights conc... T-SQL [Quantifier predicates]( Predicates in SQL are often complex and difficult to understand. In this article, Joe Celko explains the logic behind a few of the predicates: EXISTS, SOME, ANY and ALL. Tech News [Data Management in 2022: DataOps, Talent Shortages, Storage Overload]( From Past News - RSS Feeds In 2022, the burdens of enterprise data management... [Predictions for 2022: What Does the Future Hold for Databases and Open Source?]( From Dataversity Any time we stare into the crystal ball and try to... [Digital twins improve real-life manufacturing]( From Technology Review Feed - Tech Review Top Stories Before reality, there’s simulation. A 2021 missile-inceptor test conducted by aerospace and US defense technology provider Raytheon Technologies held no surprises because the company had already tested almost every... Testing Software [Crowdsourcing quality: Can the hive mind/herd mentality help you in software testing?]( From Simple Talk Crowdsourcing is one way to get a job done. In this article, Devyani Borade describes crowdsourcing quality testing of software.… The post Crowdsourcing quality: Can the hive mind/herd mentality help... Tools for Dev (SSMS, ADS, VS, etc.) [One Way to Build an SSMS Database Solution – Add a Stored Procedure and the Build]( From AndyLeonard.blog() This is the fourth post in a series named One Way ... [One Way to Build an SSMS Database Solution – Introduction]( From AndyLeonard.blog() This is the first post in a series named One Way t... Virtualization and Containers/Kubernetes [Testing SQL Server Edge and Docker on the latest MacBooks]( From MSSQL Tips In this article we look at how to setup SQL Server and Docker to run on a MacBook without the need for a Docker image that supports ARM64.  [RSS Feed]([Twitter]( This email has been sent to {EMAIL}. To be removed from this list, please click [here](. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -