How to Go Live on SQL Server 2022 (2023-04-29 DBW)

Database Weekly for April 29, 2023 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  Sharing the Code I don't know how many of you use the ScriptDOM. I haven't really used it, but was very impressed with [Mala Mahadevan's Stairway Series]( on the topic. I have recommended this to a few customers that were looking for some complex code analysis features, which go beyond what [SQL Prompt]( or [SQL Fluff]( do. I noticed this week that [ScriptDom has been open sourced by Microsoft](. [The code is available on GitHub]( which means you can fork it and change it. Or submit PRs. No idea if Microsoft will take them, but if you write solid, useful code, they might. I like that more and more Microsoft is open-sourcing and sharing code that they write. Usually, their repos aren't for software they sell, but maybe they will change that at some point. There are over 5000 repos in their account right now, including one for [VSCode]( which I use almost every day. While I don't plan on contributing or even bug-fixing, I bet some of you might. I might contribute to the docs, which I do regularly for the [SQL Server docs](. There are a lot of changes here, but there are a few marked [way0utwest](. BTW, if you don't want to do your own PRs, send me a note. I'm happy to edit the docs and submit changes. I am a fan of open-source projects, because I do think collaboration is useful in many situations. While I don't expect many people to actually make changes to software, some will. Some, like me, will correct docs, and others will find issues in the code and report them. All of those efforts help us improve software, and I am all for higher quality software. Now if we could get Microsoft to open-source SSMS, maybe a few of you would find ways to improve that application. Steve Jones - SSC Editor [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 [Redgate opens its doors to cross-database DevOps Test Data Management]( A constant challenge for many development teams is how to include test data management in the development process. Testing with consistent, realistic and compliant datasets, and bringing the database into CI and DevOps pipelines, has been shown to catch data-related issues long before they reach customers. Step in Redgate Clone, Redgate’s new DevOps test data management tool that provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases. [The Journey to Team-based Development with Flyway]( This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database. AI/Machine Learning/Cognitive Services [Amazon, Microsoft, Google Expect Future Cloud Gains From AI Moves]( From IT Pro - Microsoft Windows Information, Solutions, Tools The Big 3 public cloud providers see gains and pro... Administration of SQL Server [SQL Server DBCC Commands: DBCC FREEPROCCACHE]( From Steve Stedman DBCC FREEPROCCACHE is a DBCC command in Microsoft SQL Server that can be used to clear the procedure cache, which is a region of memory that stores the execution... [How to Go Live on SQL Server 2022]( From Brent Ozar Unlimited You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate... [Find out how fast is your SQL database growing using the backup metadata from msdb]( From SQLServerCentral Blogs Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance.  Now... The... [SQL Server 2022 Cumulative Update 3]( From Glenn Berry On April 13, 2023, Microsoft released SQL Server 2022 Cumulative Update 3. This is Build 16.0.4025.1. By Microsoft’s count, there are 9 public fixes and improvements in this CU,... Azure Databricks, Spark and Snowflake [How to transpose a DataFrame from columns to rows in Spark?]( From Hadoop in the Real World Unfortunately there is no built in function to tra... [SQL Server vs. Snowflake for Data Warehousing]( From MSSQL Tips In this article, we will compare the warehouse con... [How Snowflake Creates and Detects Deadlocks]( From MSSQL Tips In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock. [DATA GOVERNANCE IN SNOWFLAKE]( Data governance has become an essential agenda item for many organizations. The reasons are varied, but two of the most compelling ones are: (1) as the number of data assets grows, it becomes harder to properly control access to them; and (2) new and more stringent privacy regulations are increasing the calls for compliance. Azure SQL [Lesson Learned #345: How to get the most from Azure SQL Database - Session Delivered]( From Azure Database Support Blog This last April 27 we had a great opportunity and ... [Spreading your SQL Server wings with Azure SQL Database]( From Kevin Chant Reading Time: 5 minutes In this post I want to cover spreading your SQL Server wings with Azure SQL Database. As part of a series of posts about... [Bring your SQL expertise to the Data Lake with Serverless SQL Pools | Data Exposed: MVP Edition]( From Azure SQL Big data analytics is within easy reach of SQL developers and analysts by using Synapse Analytics Serverless SQL Pools. Data stored in Azure Data Lake can be analysed at... Azure Synapse (SQL Data Warehouse and Data Lake) [Install SqlPackage to work with dacpacs for serverless SQL Pools]( From Kevin Chant Reading Time: 3 minutes In this post I want to co... Career, Employment, and Certifications [Will My Career Benefit from Becoming a Citizen Data Scientist?]( From Dataversity As a team member within a business environment, yo... Community Interests [On being a woman and a data professional]( From SQLServerCentral Blogs This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at the end of these... The... Computing in the Cloud (Azure, Google, AWS) [Azure Advisor VM/VMSS right-sizing recommendations with custom lookback period]( From Azure Updates You can now customize the right sizing recommendations for virtual machines and virtual machine scale sets to make them more relevant and actionable for your workloads. Conferences, Classes, Events, and Webinars [PASS Data Community Summit 2023 registrations are open!]( In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more. [EightKB 2023 – Schedule and Registration]( From DBA From The Cold The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the... [EightKB 2023 – Schedule and Registration]( From SQLServerCentral Blogs The schedule for EightKB 2023 Edition has been announced! We’re kicking off at 1pm UTC on May the 24th…here’s the schedule: – N.B. – If you click on the... The... [DEI Mental Health and Wellness Day – 2023]( We are proud and honored to announce DPWIT-Mental Health and Wellness Day, May 5th,2023, DMO/SMO/Powershell [PowerShell: How to find Special Characters in a String]( Sometimes special characters are a nuisance. If you are trying to create some user accounts in on-premise or cloud environments, you should avoid special characters in usernames. In this blog post I will show how to find this special characters. Data Visualisation [what clutter can we eliminate?]( From Storytelling with Data Final days to register for the May 5th in-person *storytelling & presenting data* masterclass in Chicago! Join Cole and the SWD team for our last in-person public workshop of... Database Design, Theory and Development [Star Schema vs Snowflake Schema Considerations]( From MSSQL Tips Sometimes people say to avoid the snowflake schema and stick to a clean star schema. Why is that? Is something wrong with creating a snowflake schema? DocumentDB/Key-Value/Graph/other NoSQL Databases [How to properly remove or decommission a node from an Elasticsearch cluster?]( Shutting down a node abruptly is not the right way to decommission or remove a node from the Elasticsearch cluster. Doing so will cause your shards which are replicated to go down in replication and it could cause disruption to the clients who are currently consuming data from Elasticsearch. ETL/SSIS/Azure Data Factory/Biml [Adding microseconds to a timestamp in Azure Data Factory]( From SQLServerCentral Blogs (2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects... The... [Unroll multiple arrays in a single Flatten step in ADF]( You can now easily unroll multiple arrays inside a single Flatten transformation in Azure Data Factory and Azure Synapse Analytics using a data pipeline with a Mapping Data Flow. [ADF: Replacing carriage returns in Data Factory expression language]( From The Bit Bucket This one had me stumped lately. I had an variable in ADF where the value contained carriage returns. I needed to remove them. I guessed that would be easy:... [FIX: Data Factory ODBC linked service fails to Apply and returns Internal Server Error]( From The Bit Bucket I was working with a client who has having trouble debugging an ADF pipeline, related to an ODBC linked service not working as expected. The user had configured the... HA/DR/Always On/Clustering [What is Log Send Queue, Redo Queue and Redo Rate in Availability Groups?]( From Greg's Ramblings SQL, Programming and IT Life A quick description of 3 metrics that SQL tracks in Availability Groups. These metrics are important when evaluating the health of your Availability Group, and knowing what sort of... Hardware [Intel Core i3-13100F Review: Higher Pricing, Smaller Gains]( From Tom's Hardware US We put Intel's quad-core Core i3-13100F and 13100 ... [How to Upgrade a Laptop SSD]( From Tom's Hardware US Upgrading to an SSD is a quick way to grab a speed... MDX/DAX [Rounding errors with different data types in DAX]( From Sqlbi Different rounding differences can appear in DAX depending on data types and operations performed: knowing these details helps you write more robust DAX formulas and avoid comparison errors. Microsoft News [Microsoft Confirms Windows 10 Feature Updates Ending After 22H2]( From Tom's Hardware US Microsoft closes the door on further Windows 10 fe... [Microsoft Changes Windows Server 2022 Licensing Policies]( From Petri IT Knowledgebase Microsoft is changing its Windows Server 2022 licensing policies to... The post Microsoft Changes Windows Server 2022 Licensing Policies appeared first on Petri IT Knowledgebase. Oracle/PostgreSQL/MySQL/other RDBMS [PostgreSQL Schema: Learning PostgreSQL with Grant]( An important aspect of building and managing a database is organizing the objects within your database. This can be accomplished using schemas within a database and PostgreSQL supports the use of schema for these types of functions. [Nine ways to shoot yourself in the foot with PostgreSQL]( Previously on Extreme Learning, I discussed all the ways I've broken production using healthchecks. In this post I'll do the same for PostgreSQL. [Why Learn PostgreSQL?]( From SQLServerCentral Blogs At Redgate, we’ve spent a lot of time adding PostgreSQL functionality to our DevOps tools. We’ve also hired an advocate, Ryan Booz, to help us spread the word and... The... Performance Tuning SQL Server [YouTube Days: A Little About Parameter Sensitivity In SQL Server]( From Erik Darling Data A Little About Parameter Sensitivity In SQL Server... [YouTube Days: A Little About Key Lookups In SQL Server]( From Erik Darling Data A Little About Key Lookups In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing... [YouTube Days: A Little About Sorts In SQL Server Query Plans]( From Erik Darling Data A Little About Sorts In SQL Server Query Plans I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and... [YouTube Days: A Little About Filtered Indexes In SQL Server]( From Erik Darling Data A Little About Filtered Indexes In SQL Server I’m working on ramping up my recording and streaming setup now that life has settled down a little bit, and publishing... PowerPivot/PowerQuery/PowerBI [Change the Default Output on a Power BI KPI Visual]( From MSSQL Tips In this article, we look at how to enhance and cha... [Better version control for Power BI datasets]( From Richard Swinbank Version controlling a Power BI PBIX file along with all its data can be problematic, for reasons of both size and privacy. In this post I look at managing... [Why Load Testing Power BI Is Important]( From Chris Webb's BI Blog Test performance of your Power BI reports when multiple users are running them at the same time Product Reviews and Articles [SQL Query Design Patterns and Best Practices]( This book aims to improve your SQL queries using design patterns, how does it fare? [Exporting SQL Data Compare Results to Excel]( From SQLServerCentral Blogs I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t... The... Product Upgrades and Releases [Updated First Responder Kit and Consultant Toolkit for April 2023]( From Brent Ozar Unlimited This month’s big changes are performance tuning ... [Announcing Degree of Parallelism Feedback Limited Preview]( From Azure SQL Today we are excited to announce that the Degree o... [ScriptDOM .NET library for T-SQL parsing is now open source]( From Azure SQL ScriptDOM is a powerful .NET library for code parsing, generating an abstract syntax tree (AST) that can be leveraged to apply code formatting, detect antipatterns, and more. We are thrilled... [Azure SQL—General availability updates for late-April 2023Â]( From Azure Updates General availability enhancements and updates released for Azure SQL and Azure SQL Managed Instance in late-April 2023 [General Availability: Centrally Managed Azure Hybrid Benefit for SQL Server]( From Azure Updates Today, we’re officially announcing the general availability for Centrally Managed Azure Hybrid Benefit for SQL Server. [Preview: Introducing DCesv5 and ECesv5-series Confidential VMs with Intel TDX]( From Azure Updates Today, we’re excited to announce the expansion of our Confidential VM family with the launch of the DCesv5-series and ECesv5-series in preview. Featuring 4th Gen Intel® Xeon® Scalable processors,... R Language [R for Everyone: Analytical Superpowers in under 10 Minutes!]( R is a powerful programming language and environment for statistical computing and graphics. In this post, we will provide a quick introduction to R using the famous iris dataset. SQL Server Security and Auditing [Securing SQL Server: Cross DB Ownership Chaining]( From Steve Stedman Cross DB Ownership Chaining is a feature of SQL Server that allows one database to access objects in another database, even if the two databases are owned by different... Security News and Issues [Security Risks of AI]( From Schneier on Security Stanford and Georgetown have a new report on the s... Software Development [How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ]( From Java, SQL and jOOQ. Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is a parameter of a table type that can be passed to a stored procedure or function. For... T-SQL and Query Languages [Updating an Always Encrypted Column]( From Callihan Data When recently troubleshooting an issue, I needed to update a database record to test application functionality. Because the table had an Always Encrypted column, some extra steps were needed... [Searching between two date values in SQL Server]( From MSSQL Tips Learn different ways to select data between two dates using various techniques along with how to improve performance for very large tables. Tech News [Amazon Starts Round of Layoffs in AWS Cloud Division]( From IT Pro - Microsoft Windows Information, Solutions, Tools The cuts affect workers in the US, Canada, and Cos... Web [How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks]( Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. To understand this, we need to understand CSRF in detail.  [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -