A Thrill of Hope (DBW 2023-12-23)

Database Weekly for December 23, 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  A Thrill of Hope I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly how I had hoped or envisioned in a few ways. And, unfortunately, at least at the start of 2024, I may not see the change I’m hoping for. Still, as I look back over this past year there are many blessings that I didn’t anticipate. Connections with old friends within my tech circles and local community. New friends from different continents at conferences and work. Opportunities to learn about myself, my family, my interests, and the data technology that I never get tired of. As I realize how much I have to be thankful for, O Holy Night, one of my favorite Christmas carols, comes to mind and provides encouragement for the days that lie ahead. Even when I’m weary, there is a thrill of hope that awaits me each day. When I’m uncertain about what’s next, a new morning breaks and opportunity shines through. There is much to have hope about… and many reasons to bring hope to others. Don’t lose sight of what matters most and the opportunities that you’re given to impact the community around you for good. While our technology world may be ever changing, it’s the people that stay true and matter most. Happy Holidays… and here’s to spreading some hope in the new year! Ryan Booz [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 [Code Visibility: Browsing through Flyway Migration Files]( If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you to scan through many files, moving from file to file with a single click. This article will demonstrate how to do this with a few PowerShell scripts. [Doing Flyway Migrations for Many Different Databases and Projects]( This article demonstrates a PowerShell automation technique that will allow you to run any Flyway build or migration task on any number of projects and databases, hosted on a range of RDBMSs. It handles all connection and authentication details securely, makes it easier to automate database testing and can send detailed alerts when Flyway encounters an error. [Running Database Assertion Tests with Flyway]( A database assertion test aims to check that data within a relational database conforms to specific business rules. This article demonstrates how to run these assertion tests automatically in Flyway, checking that the queries under test always produce the expected results. AI/Machine Learning/Cognitive Services [AWS Study Finds Increasing Focus on Responsible AI]( From Past News - RSS Feeds Generative AI created mass interesting in AI but c... Administration of SQL Server [Database Compatibility Levels and SQL Server Versions]( From Curated SQL Kendra Little demands change: According to Microsoft’s documentation, “Database compatibility level … allow[s] the SQL Server Database Engine to be upgraded while keeping the same functional… [Analyze and Tune SQL Server Statistics]( Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that? Well, if we were to consider the equivalent of Maslow’s hierarchy of needs for database performances, statistics would be a foundational needs of a database system (namely the “physiological” needs) as they are one of the most fundamental pieces of information needed to build execution plans. [Lesson Learned #460: DataIO vs Buffer Pool]( From Azure Database Support Blog In the past week, we have dedicated our efforts to a service request where our customer asked questions:  Whether DataIO signifies the utilization of memory by the Buffer Pool. The rationale... Azure SQL Managed Instance [Resource Governor and Azure SQL Managed Instance]( From Curated SQL Kendra Little has a note for us: In Azure SQL Managed Instance, you get to use Resource Governor, even in the General Purpose tier. This is… Cloud - AWS [Your MySQL 5.7 and PostgreSQL 11 databases will be automatically enrolled into Amazon RDS Extended Support]( From AWS News Blog Today, we are announcing that your MySQL 5.7 and PostgreSQL 11 database instances running on Amazon Aurora and Amazon Relational Database Service (Amazon RDS) will be automatically enrolled into... Community Interests [Lessons learned from being self-employed: 5 years in]( From SQLGene – Learning SQL Slowly Content warning: burnout, health issues I have not been looking forward to writing this blog post. I started the series, inspired by Brent Ozar’s series, because being able to... Database Design, Theory and Development [Creating a Scripts Folder in SQL Compare]( From SQLServerCentral Blogs While I was at a conference recently, someone aske... MDX/DAX [Using join functions in DAX]( From Sqlbi This article describes the practical uses of NATUR... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Notebook Concurrency in Microsoft Fabric]( From Curated SQL Ed Oldham takes us through a common problem: If you are currently using Microsoft Fabric you will have some sort of capacity associated with your… Microsoft News [Hello Microsoft Entra ID, good bye Azure Active Directory]( From SQLServerCentral Blogs A couple of months ago where I work, a major produ... Oracle/PostgreSQL/MySQL/other RDBMS [GPS Data in PostGIS]( From Curated SQL Ryan Lambert clues us in: One of the key elements to using PostGIS is having spatial data to work with! Lucky for us, one big… [Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts]( From Brent Ozar Unlimited Lemme start this off by saying this is probably ir... Performance Tuning SQL Server [Normalize strings to optimize space and searches]( The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month. And that is just a summarized cross-section of our overall raw log data, which we load into a database for downstream security and analytical purposes. Every month has its own table, allowing for partitioning-like sliding windows and selective indexes without the additional restrictions and management overhead. (Taryn Pratt talks about these tables in great detail in her post, Migrating a 40TB SQL Server Database.) [The Art Of The SQL Server Stored Procedure: Locking Hints]( From Erik Darling Data None Other Locking hints are funny. Normally I see them in awful products like Dynamics, on select queries, and hilarious levels of blocking and deadlocking issues ensue. Another place... SQL [Using a SQL Tokenizer]( From Simple Talk Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so... SQL Server News [30 Years of SQL Server History]( From MSSQL Tips Everything started in 1993, 30 years ago! This fir... SQL Server on Linux [How To Manage Database Files in SQL Server 2022 on Linux]( From MSSQL Tips Learn how to add a new data file to a SQL Server o... [SQL Server on Linux and the Built-In Administrators Group]( From Curated SQL Andrew Pruski goes messing around: When I first started working with SQL on Linux one of the first things I did was to remove the… T-SQL and Query Languages [Data Types and Stored Procedures]( From Curated SQL Erik Darling plays the roles of both Goofus and Gallant here: All sorts of bad things happen when you do this. You can’t index for… [Window Function Execution Plans with RANGE]( From Curated SQL Hugo Kornelis continues a series on explaining the execution plans for window functions: This is part twenty-six of the plansplaining series. And already the fourth episode about… [T-SQL Fundamentals: Controlling Duplicates]( In this article I focus on duplicates and how to control them. In order to understand duplicates correctly, you need to understand the concepts of distinctness and equality, which I’ll cover as well. [Numeric Data Validation]( From Andy Broadsword Data validation is key when ingesting from externa... [Counting more efficiently]( From SQLBlog.org I show how to use metadata to avoid costly reads w... [The Art Of The SQL Server Stored Procedure: Local Variables]( From Erik Darling Data Nein Nein Nein Just like you can’t fix a broken bone with good vibes, you can’t fix parameter sniffing with idiocy. More on that later, though. Like many other... [Estimated Rows = 100]( From Deb the DBA A little while back, my coworker was having trouble with a query and asked me about a strange thing they were seeing in the execution plan: The estimated rows...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -