Powershell and Data Masking with SQL Provision
Just a quick post here after the PASS Marathon Webinar during which I talked about the GDPR effects around the...
2018-03-13
1,116 reads
SQL Saturday Colorado Springs, and a full-day class with the MidnightDBAs!
Edit: Now with discount code! We’ll be speaking at SQL Saturday Colorado Springs on Saturday March 24. The day before that, we...
2018-03-13
344 reads
Crazy Data Science
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...
2018-03-13
354 reads
T-SQL Tuesday #100: What’s New With Scalability Groups in SQL Server 2026
Welcome to T-SQL Tuesday #100. In a community filled with ADD people like the SQL community (myself included), who would...
2018-03-23 (first published: 2018-03-13)
2,457 reads
T-SQL Tuesday #100: Looking Forward
The future, 100 months from now: It’s Monday, 6 July 2026. It’s been quite a week since SQL Server Update...
2018-03-13
293 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code. It turned into the 3rd most popular post ever...
2018-03-13
24 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
4,653 reads
Looking Forward for T-SQL Tuesday #100
It’s T-SQL Tuesday #100. Amazing. I can’t believe this has been going for so many years. I’m proud that I...
2018-03-13
792 reads
SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)
It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16? Not...
2018-03-13
18 reads
Getting Started With R In SQL Server 2017
Prior to SQL Server 2016, running R on Microsoft platform required an installation of the R Language and its environment...
2018-03-22 (first published: 2018-03-13)
4,320 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers