Browse by Tags

All Tags » sql server 2005 (RSS)
The First One
It's been a long time since I saw a vulnerability in SQL Server released. And to date, there haven't been any for SQL Server 2005, nearly 3 years after it's release in Nov 2005. That changed today I saw a note from Secunia just some in: Microsoft...

Posted 08 July 2008 13:30 by Steve Jones

TechEd - Execution Plans
Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book with the same name, I wanted to check it out. There are 3 types of plans: graphical, text, and XML. Graphical is cool, looks good, but...

Posted 13 June 2008 06:51 by Steve Jones

TechEd - Data Corruption
I went to this one, mostly because I don't understand coruption that well and Paul Randal is a great speaker. Worth going to see him if you get the chance. Run CheckDB. It's important. You need to know how long checkdb takes to run. Checkdb is...

Posted 11 June 2008 08:23 by Steve Jones

TechEd - IO and Wait Stats
Andrew Kelley, SQL Server MVP, is a good speaker, so I'd recommend his sessions if you want good technical information. IO Stats are a snapshot in time since the instance was restarted, so you must have at least two reads to compare the data. Stats...

Posted 11 June 2008 06:50 by Steve Jones