No matter how you name it, "hairball", "spaghetti code", "tech debt" or "DIY code", the result is the same - you are dealing with legacy code that nobody wants...
2022-01-05 (first published: 2021-12-25)
353 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-04
23 reads
In my opinion, all customers should be encrypting connections to their SQL Servers to secure data in-transit, but that’s a discussion for another day. Today, I wanted to discuss...
2022-01-04
341 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-03
14 reads
Recently my spouse and I travelled to South Africa (yes, I know there’s a pandemic on) to deal with a gloomy family matter that required in-person interaction. Being an...
2022-01-03 (first published: 2021-12-22)
187 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I learned something new about dbatools. That’s using...
2022-01-03 (first published: 2021-12-22)
329 reads
This is a very simple introduction into the creation of an Extended Event session using a template for Azure SQL DB. I demonstrate the use of the GUI to...
2022-01-02
43 reads
?? Press Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure – part 1 With this...
2022-01-02
8 reads
? Press Efficient Upserts into Data Lakes with Databricks Delta When MERGE on data lake is inefficient. Building a Data Mesh Architecture in Azure – part 1 With this...
2022-01-02
Source control is quintessential to a productive development environment. A well maintained and organized source control system is akin to having known-good database backups. Having the right tools to...
2022-01-02
42 reads
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
I've read lots of the horror stories about nested views in databases where they're...
Hello! How do I grant a user to read-write to a single database and...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers