Links to help you keep your systems fit, personal fitness is up to you.

Database Weekly for August 10, 2024 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  Getting and keeping fit Don't worry, this is a technical editorial, but the initial analogy starts a bit personal. For the past decade, I've been on a journey to get fit, facing setbacks along the way, such as surgery complications and broken bones, torn cartilage, and, most recently, broken metal implants. Throughout this time, my overall physical fitness has backslidden as I wasn't able to exercise for quite some time. In some ways, this personal struggle is similar to my experience as a database architect and administrator, highlighting how easy it is for system health to decline if not vigilantly maintained. Just as I've struggled with my physical fitness, falling into bad habits, and seeing my wellness regress, so too can database systems deteriorate without consistent care. Because of this, I often find it challenging to fully disconnect from work during vacations or sick days, not because I enjoy the work intrusion but because staying slightly connected can prevent more significant issues down the line. This simple reason has often saved me time and frustration when I return and realize what I had missed. Before I say what I mean by this, let me clarify what I don't mean. - This does not mean less documentation. It actually means more. I don’t want to spend copious amounts of time when at the Magic Kingdom helping do repeatable things. I just want to make sure that I am not surprised with some change that will cause me to lose all the physical and mental cleansing from the time I have been off from work when I have to clean up a mess. - This does not mean I want to be completely irreplaceable. Certainly not in a process sort of way, that is why we document. Being irreplaceable is a positive when it is because of an advanced skill set, not because you are only one who knows how to do some tasks. That is bad for both you and your company. What it does mean is that if some big decision comes up, I don’t want to regret missing it and getting stuck with a mess later. When I say big, that is a complicated term. As an administrator, you spend much of your time attempting to prevent disasters, big and small. You do this by designing/coding/configuring/overseeing work done to make your processes work perfectly. You want to get the design just right and keep dirty data out, and you also don’t want an extended power outage to shut down the business for good. But as a human, you want time off. So, if you ever want some free time to soar through a mountain in space, you can’t be there every second of every day. For example, say you are off for a few weeks, and it is discovered that you need a new column to store pet names in a form, which is needed in the next week. There was already a column not in use, so to keep things "easy," a decision was made to use that existing column. It would be bad if that column were named ExtraColumn1, terrible if that column were named ShoeSizeCode, and even worse if that extra column were named PetSize. At least ExtraColumn1 doesn't pretend to give you any information. If you don't know about the repurposing, ShoeSizeCode will confuse you when you see Fluffy (or Mr Whisker 13) as a value. If you are the person who is more or less regularly in charge of those decisions, you would almost certainly vehemently argue against such a mess. Renaming a column or adding a new column with the name of PetName with a reasonable data type like nvarchar(100) will take a bit more time…initially. However, it will cost far more in the time spent when someone is doing ad-hoc queries of the database and sees data that they can't interpret from context alone. This is one silly example; there are so many more examples of things that leaving others to manage while you are out that will make you queasy—for instance, messing up your backup systems, fouling up replication, changing settings that you don't notice in logs because when you come back to work…they are lots of other, more appropriate things logged. And if bad changes are made, like changing your diet from lean foods to pizza, you will have to fix it after you get back on task (along with all the other things you need to do that are waiting because you were off riding in teacups, rather than drinking from them). All it takes is for your system fitness (design, processes, etc.) to slide just a bit, and you could be on your way to a lot of work to get that fitness back. It's best to monitor and be involved for a few minutes daily so it doesn't get away from you, even if it means a few minutes a day not staring at Cinderella's Castle. 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 [Move Over, LLMs. Small AI Models Are the Next Big Thing]( From IT Pro - Microsoft Windows Information, Solutions, Tools OpenAI, Google, and Microsoft are investing in more affordable alternatives to large language models. Administration of SQL Server [Days of the Week, Bitwise Edition]( I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this work involves Task Scheduler and, be honest, who knew Task Scheduler was this complicated? On different servers, we wanted jobs to trigger on different days of the week. The way that Task Scheduler handles this programmatically is through a numeric property called 'WeeklyTrigger.DaysOfWeek.' [How to Stream Data from Azure Event Hubs into a Fabric Eventhouse]( At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This shows the commitment of Microsoft to make Fabric your one-stop shop for all things data analytics, both streaming and batch data. There are several methods to work with streaming data in Fabric, such as eventstream and eventhouse. In this article, we’ll show you how you can send streaming data through event hubs directly into an eventhouse. [Thoughts on FILESTREAM]( From Callihan Data A few weeks ago, I had a post about running into s... Cloud - Azure [Provisioning with Azure CLI and Automating a Python ETL Pipeline]( From MSSQL Tips This article teaches how to automate an ETL pipeli... Data Visualisation [using emojis to draw your audience’s attention]( From Storytelling with Data Regular readers of the storytelling with data blog... Database Design, Theory and Development [Don’t run CHKDSK while SQL Server is running]( From Born SQL On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is... DocumentDB/Key-Value/Graph/other NoSQL Databases [Improving RavenDB's Node.js bulk insert performance]( From Ayende @ Rahien During a performance evaluation internally, we ran into a strange situation. Our bulk insert performance using the node.js API was significantly worse than the performance of other clients. In particular,... General [Filesystem Access for Database Restoration via dbatools]( From Curated SQL Andy Levy shares a lesson learned: While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](. It should have been a simple… Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science) [Microsoft Fabric Lakehouse Access Control]( From Curated SQL Koen Verbeeck lets us into the lakehouse: We’re ... Oracle/PostgreSQL/MySQL/other RDBMS [MySQL Index Overviews: B-Tree Indexes]( In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL, B-Tree Indexes. Applying indexes of any type in MySQL is a nuanced task – they are used to speed up the performance of our search queries at the expense of having to be maintained when data is changed in the table. Performance Tuning SQL Server [Columnstore Key Lookups are Bad News]( From Curated SQL Forrest McDaniel does not want to perform that key lookup: I’ve read it repeatedly, columnstore key lookups are extra slow. The question of course, is why?… [Fun(?) with CPU Affinity]( From Curated SQL Rod Edwards plays with fire: Here we have the opti... [[Video] I Must Be an Idiot: Automatic Tuning Never Works for Me.]( From Brent Ozar Unlimited I don’t get it. I’ve given this feature one ch... PostgreSQL [Grant Fritchey: PostgreSQL and Instrumentation]( From Planet Postgres I’m still learning PostgreSQL and one of the thi... [Sagar Jadhav: Dispelling Myths About PostgreSQL Default Privileges]( From Planet Postgres The ALTER DEFAULT PRIVILEGES command allows us to ... [Umair Shahid: Locks in PostgreSQL – Concurrency Benefits and Performance Challenges]( From Planet Postgres PostgreSQL provides robust support for concurrency control through various locking mechanisms. Locks are critical in managing access to data and ensuring consistency and integrity in concurrent environments. Among these... [Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 4: Enhanced Merge Command.]( From Planet Postgres Welcome to Part 4 of our series exploring the exciting new features anticipated in the official PostgreSQL 17 release. In this series, we delve into newly features and discuss... PowerPivot/PowerQuery/PowerBI [Creating a Month Calendar in Power BI with the Matrix Visual]( From Curated SQL Erik Svensen knows what day it is: Last week I posted on LinkedIn an example on how we can utilize the matrix as a month… Professional Development [Clearer Writing at Your Fingertips: Introducing Write Brief with AI (Beta)]( From SQL DBA with A Beard From the team at Jetpack AI comes a new tool that ... [Roles in a Data Analytics Team]( From RADACAD In the previous article and video, I explained the... [T-SQL Tuesday 177: Managing database code]( From Curious..about data I am excited to host the T-SQL Tuesday blog party ... [6 Best SQL Training Courses for Beginners (2024 Updated)]( From SQLServerCentral Blogs We all know that choosing the right basic SQL trai... [Beyond Avatars: How Gravatar is Transforming Online Identity]( From SQL DBA with A Beard Seven things every WordPress user should know about Gravatar [Reducing Meetings and Making Them More Productive]( From SQLServerCentral Blogs I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to... The... Security News and Issues [Attackers Use Multiple Techniques to Bypass Reputation-Based Security]( From IT Pro - Microsoft Windows Information, Solutions, Tools Protections like Windows Smart App Control are use... T-SQL and Query Languages [Temporal Table History Cleanup]( From Curated SQL Chad {NAME} reads the docs: I recently built a system for collecting index usage statistics utilizing temporal tables, clustered columnstore indexes (CCIs) and a temporal… [The Internals of DATETIME2]( From Curated SQL Chad {NAME} digs in: I noticed in sys.column_store_segments the min_data_id and max_data_id columns store very large bigint values in the segments for datetime2 columns. After doing a bit more googling and tinkering, I… [Query Exercise: What Makes SELECT TOP 1 or SELECT MAX Different?]( From Brent Ozar Unlimited These two queries both get the same answer from th... Testing Software [Legacy code with really good tests is still legacy code]( From Ayende @ Rahien I got into an interesting discussion on LinkedIn ... [The risks – and rewards – of using production data for testing]( From Blog – Redgate Software Data, and the way enterprises use data in areas li... The Lighter Side [Simple Talks–Episode 3]( From SQLServerCentral Blogs The third episode of Simple Talks is out. This is ... Tools for Dev (SSMS, ADS, VS, etc.) [My Toolbox - SSMS]( From SQLServerCentral Blogs No matter how hard Azure Data Studio (ADS) is push... flyway [Using TOML Configuration Files with Flyway]( This article discusses Flyway's transition from CONF to TOML configuration files. It highlights the advantages of TOML, such as improved readability, flexibility in managing complex database configurations, and support for specifying multiple database environments. It also discusses a few of the differences to be aware of when switching existing Flyway projects to the new config system.  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -