Daily Coping 1 Apr 2021
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...
2021-04-01
40 reads
Easy SSIS Package Compare
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal...
2021-04-01
117 reads
Azure SQL – Saving Costs
When moving to a cloud model for your database stack no doubt you will be involved in a costing exercise. The good news is if you have Software Assurance...
2021-04-01
41 reads
Easy SSIS Package Compare
I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal version, but the visual comparison format was a problem. Really, we couldn’t decide how to actually compare packages on screen in a way that makes sense for users.
2021-04-01
925 reads
Serverless Azure SQL DB can show incorrect data space usage in the Portal
A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...
2021-03-31
45 reads
SQL Agent Jobs – When Success is Failure
Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of...
2021-03-31
458 reads
Zeroing out a transaction log file does not use zeroes
I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not...
2021-03-31
56 reads
Daily Coping 31 Mar 2021
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...
2021-03-31
24 reads
Generate a Random Number for Each Row in a Query {a better way}
A couple of years ago I wrote a post on how to generate a random number in SQL Server. https://sqlundercover.com/2017/06/22/generating-random-numbers-for-each-row-over-a-specified-range-and-other-funky-stuff-you-can-do-with-them/ It’s ok and it works, it’s also a method...
2021-03-31
5,038 reads
WordPress.com Design Update for a More Intuitive Experience
As technology products grow, it’s important to evolve. We’ve updated WordPress.com’s interface to make it more coherent and logical, allowing everyone to use it more intuitively.
2021-03-30
22 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers