5 SQL Server Best Practices worth a quick check, starting with backing up the master database and testing it, and rebuilding indexes online to cut downtime.
SQL SERVER – Find Queries using Parallelism from Cached Plan
A script by Feodor Georgiev that finds queries using parallelism from the cached plan, along with their plans. Please avoid running it on a busy production server.
Stop Blaming the User: Let Constraints Catch Bad Data
Blaming the user is the oldest joke in IT. Here’s why it fails, and how NOT NULL, CHECK, UNIQUE and foreign keys stop bad data before it lands.
SQLAuthority News – Exam 70-433 – MCTS – Microsoft SQL Server 2008, Database Development
I finally used my expiring Prometric voucher to take Exam 70-433, MCTS: SQL Server 2008 Database Development. Here is how it went at the test center.
A Monthly Health Check You Can Run in Ten Minutes
Run a SQL Server health check that reviews backups, integrity-check evidence, file growth, users, build level, and space without guessing health.
How to Learn a New SQL Server Release Quickly
Evaluate new SQL Server features with a focused reading plan, version checks, three relevant experiments, and a record of operational tradeoffs.
SQL SERVER – Find Largest Supported DML Operation – Question to You
Best practice says the log should be twice the size of the largest supported DML operation. But how do you measure that? Share your ideas with me.