Inspiration, memories, and a big helping of T-SQL

Database Weekly for November 25, 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  You Are An Inspiration Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, but is it? That is usually how it is used, but the definition is merely something that inspires. You can be inspired to do anything, and pretty much everything that is done was inspired by someone else. You have inspired others to do countless things whether you wanted to or not. The only question is: are you a positive inspiration? Every move you make around other people affects them. If you are writing code, you can inspire people around you by producing working code, writing effective documentation, writing thorough tests, and checking in your code when it is ready. Designing a database? Making sure that the database works well with the data sizes needed, using proper standards, and meeting the requirements will inspire the next person to change the database similarly. As a reader of this editorial on SQL Server Central, I will mostly mention technical things, but this extends to pretty much everything you do, technical and otherwise. How you treat others, clean up your workspace, etc, all will inspire others. Sometimes to be better, sometimes to be worse. Who is watching? Everyone is. Kids and adults of all ages. People who look like you and people who look nothing like you. You are very much an inspiration to them all in some way, probably very small, but possibly life changing. Every day you get to make a choice. Be a good inspiration, or a not so good one. Ideally, be a good inspiration.  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 [How to unlock your leadership potential on a cloud migration project: part 1]( If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. In part one of the two-part series, industry experts share the skills to be gained, the unique career opportunities cloud migrations offer, and the best ways to get involved. [Is your organization using MongoDB? Help the Redgate Flyway team understand your pain points.]( Is MongoDB in use within your organization? The Flyway development team are adding MongoDB support into Flyway and would like to better understand the current pain points. If you are able help, or are interested in finding out more, please participate in our 5-minute survey. [Supporting a Production Database: What’s Required]( How to plan for an effective response to database problems, as part of a broader, 'tiered' monitoring strategy for production systems, where the process to resolve any known or routine problem is provided alongside the associated alert, and any urgent issues that can't be fixed, or threaten the quality of the service, are escalated promptly to the right team. [Test Data Management for Database Migrations]( The main reason why database deployments fail is a lack of rigorous database testing, and the main reason this task is so often avoided, or delayed, is the difficulties of creating and managing all the required test data. This article will help you understand the steps to better test data management, as part of a database emigration strategy. [The Flyway Desktop CLI: Automate your Database Development Process]( Tonie Huizer explores the Flyway Desktop CLI, also known as "flyway-dev", its capabilities, and how to use it to automate the process of capturing the schema changes made to a development database and then generating a migration script to use in subsequent deployments of those changes. .NET Related Articles [AWS Step Functions in C#]( Camilo Reyes explores AWS step functions and show how they enable asynchronous processes without blocking. Apps, for example, are expected to show results within milliseconds. If a job takes longer than a few seconds, a nice approach is to run this asynchronously so it doesn’t block and force people to wait. Azure SQL [Importing Flat Files into Azure SQL DB]( From SQLServerCentral Blogs Initially, I thought I would have to use sqlcmd be... Backup and Recovery [Understanding I/O Freeze in SQL Server 2022's TSQL Snapshot Backups]( From SQLServerCentral Blogs SQL Server 2022 introduces a new feature to enable... Computing in the Cloud (Azure, Google, AWS) [How to unlock your leadership potential on a cloud migration project: part 1]( From Simple Talk If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. In part one of the two-part series, industry experts share the skills to be gained, the unique career opportunities cloud migrations offer, and the best ways to get involved. Conferences, Classes, Events, and Webinars [PostgreSQL 101: Database monitoring and optimization]( Join Ryan Booz on November 28th for his webinar on monitoring PostgreSQL databases and how it's crucial to ensure the overall health and performance of your ecosystem. PostgreSQL provides a wealth of metrics, but which ones are most important to measure and how best should you do this? In this webinar, you will gain insights and strategies to help keep your database environment running smoothly and efficiently so you can avoid some of the most common bottlenecks. [Live Redgate Product Launch: Transform your software delivery with Test Data Management]( Don’t worry if you missed Redgate’s live stream announcement at PASS Data Community Summit - you can join David Gummer, Chief Product Officer at Redgate, and Alex Yates, Senior Solutions Specialist at Redgate, live on the 29th of November and learn how test data management can benefit you in your role. [Memories of the PASS Data Community Summit 2023]( From SQLServerCentral Blogs I’ve been to a lot of conferences, and one that ... DMO/SMO/Powershell [Beginner's Introduction to PowerShell Remoting]( From SQLServerCentral Blogs Beginner's Introduction to PowerShell Remoting ... Data Warehousing [What is Microsoft Fabric all about?]( From Simple Talk In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity we will turn to the mechanics of capacity utilization, and we will... Database Design, Theory and Development [Applying Agile Principles to IT Incident Management]( Agile development has grown in popularity in recent years due to its success in delivering software on time and on budget. If you’re looking for a way to make your software development process more flexible and responsive, Agile might be a good option for you. Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Debunking Myths and Embracing Innovation with Microsoft Fabric]( From Data – Marc Over the past months, I’ve been engaging with ma... [Starting a Free Trial of Microsoft Fabric]( From Curated SQL Andy Leonard kicks off a trial: Are you interested... [Testing Fabric - Part 2]( From Jeff Taylor To quickly summarize where we are, we started test... Oracle/PostgreSQL/MySQL/other RDBMS [Learning PostgreSQL With Grant: Introducing VACUUM]( While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that are unique. One of these unique features is called VACUUM. In my head, I compare this with the tempdb in SQL Server. Not because they act in any way the same or serve similar purposes. VACUUM is a complex, deep, topic, so this article will only act as an introduction. Let’s get started. Performance Tuning SQL Server [Plansplaining part 24 – Windows on the fast track]( From SQL Server Fast This is part twenty-four of the plansplaining seri... [The quirky and wonderful self-join optimization]( From Sunday morning T Suppose you have a reasonably large table with a clustered index and a number of non-clustered indexes. If your WHERE clause filters by multiple columns covered by those non-clustered... PowerPivot/PowerQuery/PowerBI [Thoughts On Power BI Datasets Being Renamed To Semantic Models]( From Chris Webb's BI Blog Last week it was announced that Power BI datasets ... [challenges with double donuts]( From Storytelling with Data Recently, I’ve gotten a couple of questions abou... [Source Control with GIT, Power BI and Microsoft Fabric]( From Simple Talk Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with... SQL Server on Linux [SQL Server 2022 for RHEL 9 and Ubuntu 22.04 is now Generally Available (GA)]( From MS SQL Server Blog We are happy to announce that Starting CU 10 release for SQL Server 2022 , SQL Server 2022 on RHEL 9 and Ubuntu 22.04 is now generally available (GA), meaning you... Security News and Issues [3 Ways to Stop Unauthorized Code From Running in Your Network]( From Dark Reading: Dark Reading News Analysis As organizations increasingly rely on AI-developed... [Inside Job: Cyber Exec Admits to Hospital Hacks]( From Dark Reading: Dark Reading News Analysis  T-SQL and Query Languages [Strategies for queries against bit columns]( From Simple Talk Recently someone posted a question where they coul... [Changing the Data Type of a Primary Key–#SQLNewBlogger]( From SQLServerCentral Blogs A client asked this question recently: How do I ch... [Exploring a Recursive Common Table Expression in SQL Server with Examples]( From MSSQL Tips Learn how to write and use recursive CTEs in SQL S... [SQL SERVER – Escape Single Quotes]( From Journey to SQL Authority with Pinal Dave In this post, I'll cover a few methods you can use... [SQL SERVER – How to Convert Month Number to Month Name]( From Journey to SQL Authority with Pinal Dave Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post. First appeared on SQL SERVER – How to... [SQL SERVER – Fibonacci Series with T-SQL]( From Journey to SQL Authority with Pinal Dave What's fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane. First appeared on SQL... The Lighter Side [The Anatomy of a Featured Image]( From SQLBlog.org I talk about the evolution of my thinking on featu... [Why Haven’t You Disabled SA? Wrong Answers Only.]( From Brent Ozar Unlimited On social media, I asked folks, “Why haven’t y... Theory and Design [Database Normalization–Surrogate Keys in the Logical Data Model?]( From 36 Chambers – The Legendary Journeys THE VIDEO THE SYNOPSIS This video serves as a coda... Tools for Dev (SSMS, ADS, VS, etc.) [SSMS 19.2 Is Available]( From Glenn Berry Introduction On November 13, 2023, Microsoft relea...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -