Resolutions and a big helping of T-SQL

Database Weekly for December 30, 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  Being A Bit Less Comfortable in 2024 I hate coming up with ideas for editorials, but my last editorial of the year gives me a very simple topic just staring me in the face: [New Year’s Resolutions](. Love them or hate them (or it we are honest, a good bit of both,) this end of one year and the start of another is where a lot of people take a bit of time for reflection, me included. The danger, however, is that too often we seem to think that New Year’s resolutions will be magical. We make these grand declarations that we are going to go from this person we don’t like to something closer to the perfection we so desire. Of course, the number one resolution every year is to lose weight. Honestly it is one of mine again this year and I actually wrote part of this editorial at the gym while pedalling on the recumbent bike. Usually, however, the only thing that is thin is our promises. On average, we don’t lose weight, we don’t write that novel, (we may not even read one!) Generally speaking, we don’t follow through on any of the things we promise as a resolution made rashly during the final week of the year. That is why I am going to suggest one super-easy resolution idea this year. Stretch yourself. Take a leap or a tiny hop, but just do something a little different in your life. While this change might be huge, for most of us it won’t be. It might be something you used to do but you stopped doing because life got in the way. Maybe it is something you have always wanted to do but weren’t quite sure. Big or small, just do something that is at least a bit out of your comfort zone. My stretch resolution this year is to speak at conferences again. It is something that I used to do quite often but since conferences have been returning, I have had trouble considering the idea of getting back up behind the podium. Part of it is nerves (I have never been one to exactly love public speaking in the first place), but the other part has been health. I had to cancel one conference last year and pull my submission for another because of a couple of injuries. When I was already a bit skittish about speaking again, that really didn’t help. In 2024, I have two user group meeting set up, and have submitted to 3 [SQL Saturday]( events in the past few days. If my head doesn’t explode this year during any of these sessions, I will almost certainly try do it again for years to come. Do you have a stretch resolution you think would inspire others? Put it in the comments! 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. AI/Machine Learning/Cognitive Services [New York Times Sues Microsoft and OpenAI for Copyright Infringement]( From IT Pro - Microsoft Windows Information, Solutions, Tools The lawsuit says millions of Times articles trained AI tools. Administration of SQL Server [Run SQL Query on Multiple Servers Using PowerShell – Serially]( From Ajay Dwivedi's SQL Server Blog In this blog, we explore how to execute a sql serv... [Identity Unused SQL Server Databases and Notify the DBA Team]( From MSSQL Tips In this article, we look at a process to collect d... [Forcing Parallelism: Trace Flag vs. Query Hint]( From Callihan Data Just because something works doesn’t mean it’s... Data Mining / Data Analysis [Reversion to the Mean: Unraveling a Pervasive Misconception in Business and Beyond]( From Learning Machines In the realm of business and leadership, one statistical phenomenon often goes unrecognized yet significantly influences our understanding of performance and success. This is the concept of reversion to... Data Privacy, Compliance, and Governance [The Silver Bullet Myth: Debunking One-Size-Fits-All Solutions in Data Governance]( From Dataversity Data Governance plays a crucial role in modern bus... Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [A very Microsoft Fabric themed 2023]( From Kevin Chant Reading Time: 5 minutes In this post I want to cover that fact that it has been a very Microsoft Fabric themed 2023 for me. Plus, some other... PowerPivot/PowerQuery/PowerBI [Power Query Nested Data Types In Excel]( From Chris Webb's BI Blog A year ago support for nested data types in Excel ... [How to manage relationships in Power BI Service!]( From Purple Frog Systems Managing Relationships Within Power BI Service. Th... SQL Server on Linux [Video: Installing SQL Server on Ubuntu 22.04]( From 36 Chambers – The Legendary Journeys n this video, we will show how to install SQL Server on a machine running Linux, specifically SQL Server 2022 on Ubuntu 22.04 LTS. Security News and Issues [7 Data Security Best Practices for Your Enterprise]( From Dataversity When it comes to cybersecurity, some enterprises still take it with a grain of salt. But make no mistake about it: No one is safe. Companies such as BBC... T-SQL and Query Languages [Comparing TRY Functions for Numeric Conversion]( From Andy Broadsword In the previous post we looked at how ISNUMERIC an... [The Art Of The SQL Server Stored Procedure: Wrapper Stored Procedures]( From Erik Darling Data Happenstance Wrapper stored procedures are useful ... [SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);]( From SQLStudies Alternate title: How do I tell how far I am on tha... [Local Variables in Stored Procedures]( From Curated SQL Erik Darling does not approve: Like many other thi... [The Art Of The SQL Server Stored Procedure: Dynamic SQL]( From Erik Darling Data Time Well Spent I’ve spent a lot of time on this... [The Art Of The SQL Server Stored Procedure: Temporary Objects]( From Erik Darling Data And Then You Were Gone I probably overuse temp tables. I’m the first one to admit it. But often when I choose to use one, it’s a choice between:... [The Art Of The SQL Server Stored Procedure: Parameter Sniffing]( From Erik Darling Data Responsible Reading One of the most fun parts of my job is telling people that parameter sniffing is a good thing. They’re often shocked, because the phrase has such... Tech News [5 Trends That Shaped Software Development in 2023]( From IT Pro - Microsoft Windows Information, Solutions, Tools These trends are poised to set the tone for software development operations into 2024 and beyond. The Lighter Side [Looking Forward]( From Deb the DBA It’s the end of the year so it seems appropriate that there be a look back. But I’m going to take things back a bit farther than 2023. I... [A New Word: Koiniphobia]( From SQLServerCentral Blogs koinophobia – n. the fear that you’ve lived an ordinary life. The last one of the year. I’ve enjoyed reading through this dictionary, learning new (made up) words, and... The...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -