- "... a scholar and a true gentleman." - Buck Woody, Microsoft's "Real World" SQL Server DBA.
- Agresso AskSSC Assyst Axios Azure Backup Book Review Books Career Certification Cluster Configuration CSV CTE DBCC Denali Deployment Design Disaster Recovery Documentation Education Error Message ETL Execution Plans Full Text Indexes Indexing Installation IT Management Kaseya Kindle Maintenance Maintenance Plans Management Meme Monday Memory Migration Misconceptions Monitoring MSDB Myths Normalization People Performance PowerShell Programming red-gate Restore SQL Agent SQLBits SQL Monitor SQLPrompt SQLSaturday SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQLSouthWest SSMS ssmstoolspack SSRS T-SQL T-SQL Tuesday Tools Training Troubleshooting Un-SQL Friday Upgrade User Group Virtual Machines Windows 2012 WordPress WTF XML
Tag Archives: AskSSC
Here’s the scenario: You’re rebuilding a DR environment, and have a set of Full, Differential and transaction log backups to restore. How to script this to run with minimal interference? The Approach Assumptions: All your backups are in subdirectories named … Continue reading →
Once again, the “smart indexing in SQL2000” question has raised its ugly head on AskSSC. Those of you in SQL2005 and above have the opportunity to use some fine index maintenance scripts from Ola Hallengren and Michelle Ufford (among others, … Continue reading →
Typical. You answer a question only to find that the answer you provided isn’t what the original poster was looking for by reading the dozen or so comments that arrived on the question while you were figuring out your answer… … Continue reading →
T-SQL Tuesday this month is hosted by Jen “MidnightDBA” McCown, (blog|twitter) blogger, twitterer, and one of MS’s most recent MVPs. Congrats, Jen! The subject for discussion is “Resolutions”. Not “New Year’s Resolutions”, but that’s what I’m going to be looking … Continue reading →