What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
158 reads
SQL Server 2016 helps with Best Practices
In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need...
2017-08-03 (first published: 2017-07-19)
4,773 reads
SQL Server Agent and Daylight Saving time
There was a bit of chat today on the SQL Community slack about UTC and Daylight Saving Time. It reminded...
2017-08-07 (first published: 2017-07-19)
2,549 reads
SQLSaturday Baton Rouge at LSU on July 29
The big finale to our SQL Summer and the last of the three Gulf South 2017 SQLSat events, our 9th...
2017-07-19
441 reads
SQL Cruise: Alaska 2017
We’re weeks away from another SQL Cruise. If you’ve never heard of this before, follow the link to read more....
2017-08-01 (first published: 2017-07-19)
1,785 reads
Default Database Reports – Disk Usage by Table
Every now and again you need to know how big a table is. Or several tables. Or all of the...
2017-08-03 (first published: 2017-07-19)
1,842 reads
SQL Puzzle 2: Eight Queens
This puzzle was first proposed in 1848 by a composer of chess puzzles called Max Bezzel and has since spawned...
2017-08-04 (first published: 2017-07-19)
2,204 reads
Celebrate! Second Anniversay Giveaway (is now over)
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
337 reads
Off Topic: Dream Car Garage: 6 Cars, $250k
I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I...
2017-07-18
257 reads
Here's a Quick Way To Generate a Running Total in SQL Server
Watch this week's video on YouTube
Historically it's been difficult to accomplish certain tasks in SQL Server.
Probably the most annoying problem I had to do regularly before SQL Server 2012...
2017-07-18
31 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