Be My Date Next Tuesday, March 15 at 24 Hours of PASS
Category:
database-administration
Next week the Professional Association for SQL Server will be providing 24 hours of free, online training on SQL Server.
Come get your learn on.
kendra little
Dirty Pages and Statistics IO
Category:
query-performance
Warning: The DROPCLEANBUFFERS command referenced in this post is appropriate for test systems only and impacts the entire SQL Instance. If you are new to SQL Server, please use this commands with care, and be careful to read the linked Books Online documentation. Happy testing!
Corrupting Databases for Dummies- Hex Editor Edition
Category:
backup-recovery
This Post Tells You How To Corrupt a SQL Server Database with a Hex Editor in Gruesome Detail
And that’s all this post tells you. Not how to fix anything, just how to break it.
Read from the Right End of the Index: BACKWARD Scans
Category:
query-performance
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding a way to make reading data faster, without slowing down writes or creating new data structures that need to be maintained.
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Category:
tsql-programming
With every new year I think a little bit about time and dates. This posts looks a little more at that in TSQL.
Change Data Capture vs Change Tracking
Category:
database-administration
Here is a quick taxonomy of Change Data Capture and Change Tracking. I’m going to keep this short, but if you really want all the details, skip to the links at the bottom for complete information.
DBAs Needed on Microsoft Connect
Category:
database-administration
Update from Kendra (2018)** - Microsoft Connect has been retired. The current feedback system is here: https://feedback.azure.com/forums/908035-sql-server