Recap - SQL Saturday #32 Tampa
This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.First, I just want to...
2010-01-24
509 reads
Blog Posts
SQLSaturday 32 – Tampa Recap
I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend. As I said in my...
2010-01-24
564 reads
XML Index - ALTER INDEX with REBUILD Issue
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
667 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,087 reads
SQL Saturday #32
I presented a one hour session at SQL Saturday #32 in Tampa on Powershell ETL: "In this sesssion we will look...
2010-01-23
427 reads
We Are Microsoft (GiveCamp Dallas)
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
739 reads
Book Review: K2: Life and Death on the World’s Most Dangerous Mountain
I read Life and Death on the World’s Most Dangerous Mountain by Ed Viesturs ($18 @ Amazon) over the holiday break....
2010-01-22
739 reads
DBA Checklist Updated
I have recently updated and revised my DBA Best Practices Checklist, which is hosted on www.Simple-Talk.com. The goal of the...
2010-01-22
814 reads
Final Reminder – SQLSaturday #32 in Tampa on Jan 23, 1010
I’ve had to cancel my plans to attend, which also included plans for a late lunch at the Green Iguana...
2010-01-22
539 reads
Microsoft – Follow best practices!
Best practice is to use parametrized queries to enable plan reuse. Will someone please tell Microsoft this.
Presently dm_exec_cached_plans on...
2010-01-22
1,021 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