Which Blogs Do I Recommend?
One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...
2018-03-07
377 reads
Simply Debugging
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...
2018-03-19 (first published: 2018-03-07)
2,062 reads
Live Query Statistics – SQL Server 2016
SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works...
2018-03-07
175 reads
Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...
2018-03-06
14 reads
Finding Top Offenders with Extended Events
This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...
2018-03-06
295 reads
Azure SQL Database Managed Instance is now private preview
Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...
2018-03-06
302 reads
Packt $10 Sale
One sale today, my Getting Started with SQL Server 2016 Administration video. You can get this for $10 today, and...
2018-03-06
340 reads
Table Internal Sync Rule–Substituting the Sync Column
I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it...
2018-03-06
388 reads
Book Review: SQL Server 2017 Machine Learning Services With R
Disclaimer: I’m one of the Technical Reviewers for this book.
With the rising demand for cloud computing and wide adaptation of...
2018-03-19 (first published: 2018-03-06)
2,706 reads
Identify the owner and then change the owner of a SQL Agent Job
In this post and video you will learn how to identify the owner and then change the owner of a...
2018-03-16 (first published: 2018-03-06)
21,904 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