Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
10 reads
Blog Posts
SQL Server - Monitoring Table Size
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
699 reads
Webinar: Introducing Minion CheckDB!
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
833 reads
What is a Database Master Key?
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-01-19
17,089 reads
What is COPY_ONLY?
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...
2017-01-19 (first published: 2017-01-16)
2,554 reads
Attending VTUG at Gillette Stadium Tomorrow
If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG)Winter...
2017-01-18
348 reads
Automating DBCC PAGE, part 2 – determining object names on pages
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
420 reads
Do I have a Database Master Key in a database? #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18 (first published: 2017-01-13)
2,122 reads
Fastest way to create and distribute a dynamic report from SQL Server
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
223 reads
Fastest way to create and distribute a dynamic report from SQL Server
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard Atom or RSS feeds containing any data that you...
2017-01-18
22 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
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