2015-12-29 (first published: 2015-12-09)
1,908 reads
Know read and write ratio before you tune database performance
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,641 reads
2015-11-26 (first published: 2015-11-02)
1,259 reads
Figure out recovery mode for each database
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
619 reads
Who are connecting to database and disconnect ...
When you want gain exclusive access to database in order to restore database
2015-11-06 (first published: 2015-10-14)
1,836 reads
Rebuild index selectively
Rebuild index is expensive most time. So you don't rebuild all index blindly.
2015-11-04 (first published: 2015-10-05)
1,753 reads
Blogs
My Organizer's Notes and Goodbye after #SQLSatBR 2019
Some 2019 tips for other SQLSat organizers from my last year as lead organizer...
Query Store stores dates as UTC
One of the powerful aspects of Query Store is the ability to directly query...
SpeedPASS Printing
By Andy Warren
Based on the great post and script from Wayne Sheffield I decided to try...
Forums
Let’s Start with Architecture
Comments posted to this topic are about the item Let’s Start with Architecture
Database Auditing
Comments posted to this topic are about the item Database Auditing
Don't Get On This Page
Comments posted to this topic are about the item Don't Get On This Page
Ask SSC