Community and T-SQL Coding Love Abounds

Database Weekly for December 9, 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  Love Love is many a splendored thing. It is also a much-abused word with many different (and twisted) meanings. The type of love I wish to speak about today is not friendship, nor the kind of thing that makes your heart go pitter patter in the springtime, but rather the type of love known as [storge]( or familial love in the data community. It is not the same as friendship either. I do have many people I consider friends in the community, but far more that are like family. I have been a member of the data community (previously the SQL Server community!) for over 20 years. Over these years, it has been wonderful to see our family grow into something extraordinary, like a Norman Rockwell family painting that everyone always wants their extended families to be like, but rarely actually are. I spend less time each year with my extended family than with my SQL family. From conferences (PASS, SQL Saturday, etc.), forums, and especially X (or Twitter if you aren't into that whole brevity thing), I typically know more about SQL'ers lives than my actual aunts and uncles. It is a phenomenon that, every so often I pause to ponder. This SQL family comprises people from tremendously different employers with very different viewpoints. Still, we share one subject rather deeply: data. Like a typical family, we rarely talk politics or religion at holiday gatherings (PASS Summit, or the lesser holidays, like SQL Saturdays), just the topic of our common bond over food and drink, occasionally stretching into topics like Lego and science fiction movies (though one must be careful, as some of these topics do border on a type of religion for many of us). I can't quite figure it out because, for the most part, our gathering around such a business-oriented topic as data shows little financial gain at its center. Keeping our names in the public does help the digital resume, and I helped hire quite a few of my compatriots when my previous company needed training or a second (or third) opinion about technology. But not nearly enough to merit 100s of hours spent preparing training materials to go out and present for free (or nearly so, compared to consulting income.) I am still impressed with how many people stick around the community to help others, even when they have made their name. Some fade away, thinking they will make a million dollars from the community. Still, our core community has been around for many years, adding more and more great people every year. Louis Davidson (@drsql) [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 [What is subsetting, what are the advantages, and how does it make test data management easier?]( As data grows and databases become larger and more complicated, data subsetting provides a method of working with a smaller, lighter copy of a database to make development and testing faster and easier. In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and what’s prompting conversations about it? [Using Database Models and Flyway for Automating Routine Development tasks]( Database models have all sorts of useful applications during Flyway development to help us automate those repetitive development tasks that otherwise slow down delivery. This article shows how models can help us automate mundane tasks such as generating a build script for any version of a database or deleting the data from every table. [Integrating SQL Monitor into a Tier-1 Alert and Notification System]( SQL Monitor provides detail-level diagnostic data that will allow an expert to drill down to establish the cause of, and a fix for, any database problem. However, with support for webhooks, it can also contribute alerts to the sort of "Tier 1" alerting and paging system that an operations team might use to get an immediate notification of an urgent problem, anywhere on the network, and then coordinate a timely response. [Tracking Development Changes using Flyway and Database Models]( A database model is a standard document that represents the logical design and structure of a database. If we save a model each time Flyway creates a new version of the database, then we can find out what's in each version, and get an overview of how that structure changed between any two versions. This has all sorts of uses in team-based database development work. Administration of SQL Server [SQL Server Diagnostic Information Queries for December 2023]( From Glenn Berry Introduction These are my SQL Server Diagnostic In... [You should be running on SQL Server 2022]( From Born SQL It’s me again with my apparently semi-annual blo... [SQL Server: Optimize for Ad Hoc Workloads – use or not use]( From Simple Talk I used to believe this option was something almost... [Send an Alert when a SQL Server Database Configuration Changes]( From MSSQL Tips There are times when a SQL Server database change ... DMO/SMO/Powershell [Removing a PowerShell Array Element–#SQLNewBlogger]( From SQLServerCentral Blogs I saw an article on this and realized I had no ide... Data Mining / Data Analysis [Decoding Efficiency in Deep Learning, A Guide to Neural Network Pruning in Big Data Mining]( Harnessing the computational capabilities of artificial neural networks, deep learning algorithms have the ability to model complex patterns and make accurate predictions based on these patterns. This makes them particularly valuable in big data mining, a field that deals with extracting meaningful information from substantial datasets. ETL/SSIS/Azure Data Factory/Biml [How to make the most of Azure Data Factory?]( From MSSQL Tips Learn how Microsoft Azure Data Factory (ADF) stand... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Fabric family]( From Kevin Chant Reading Time: 2 minutes In this post I want to co... [Microsoft Fabric: Lakehouse and Data Factory in Power BI environment]( In this article, I will demonstrate how to create ... [Spreading your SQL Server wings with Microsoft Fabric Lakehouses]( From Kevin Chant Reading Time: 7 minutes In this post I want to co... Performance Tuning SQL Server [Optimising Sort Operators in Window Functions]( From Andy Broadsword We’re on quite a roll with window functions thes... [Plansplaining part 25 – Windows without upper bound]( From SQL Server Fast This is part twenty-five of the plansplaining series, and the third part that covers window functions. I have already explained how basic window functions work, with or without a... [Performance Impact of SQL Server Check Constraints]( From MSSQL Tips This article explores check constraints in SQL Ser... Professional Development [How Has Inflation Affected Your Salary? Let’s Find Out Together.]( From Brent Ozar Unlimited The 2020s have been tough: a pandemic, a recession... T-SQL and Query Languages [The Art Of The SQL Server Stored Procedure: What You Need To Know]( From Erik Darling Data For Your Eyes Only I’ve been keeping a mental li... [The Art Of The SQL Server Stored Procedure: ANSI/SET Options]( From Erik Darling Data Top Down I start off all of my stored procedures w... [The Art Of The SQL Server Stored Procedure: How To Leave Good Comments]( From Erik Darling Data Attn Pls. Most code I look at has been a disaster ... [Examples Using PIVOT and UNPIVOT]( From Callihan Data How can you PIVOT or UNPIVOT data in SQL Server? W... [The Art Of The SQL Server Stored Procedure: Formatting Code]( From Erik Darling Data Spaces First, a list of things that are horrible: Tabs Leading commas All lowercase All uppercase Not putting new things on new lines (from join on where and or... [SQL Server CROSS APPLY and OUTER APPLY]( From MSSQL Tips Learn about SQL Server CROSS APPLY and OUTER APPLY... Virtualization and Containers/Kubernetes [Orchestrating a MySQL Container on Kubernetes]( If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its own to manage a single MySQL instance or multiple instances has certain drawbacks, such as lacking the ability to orchestrate multiple instances, scale, and provide services for external clients, in this blog we’ll explore how Kubernetes addresses these limitations and what to do when you’re facing problems.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -