Brent Ozar ( @BrentO , blog ) recently wrote a blog post about how you should Stop Worrying About SQL Server Fragmentation which prompted this twitter convo: So I thought I would write up a quick test that does the following: Create a Test DB Create a test table (Customers) that has a CreateDateTime that [...]
Posts under ‘Benchmark IT Consulting’
SQL Server 2008 R2 SP2 Now Available
From the Microsoft SQL Server Team Blog “As part of our commitment to delivering and supporting high-quality software to our customers, Microsoft is pleased to announce SQL Server 2008 R2 SP2. Customers with existing investments on SQL Server 2008 R2 are encouraged to explore Service Pack 2. Service Pack 2 for SQL Server 2008 R2 [...]
Developers… Please love your DBA – (Connection Strings)
I’ve been working alot with Resource Governor for SQL Server 2008 lately and one thing that has turned into quite a challenge is coming up with a good “Classifier Function“. After much debate I decided that the best route to go is to use the “Application Name” primarily as my deciding factor as to what [...]
#OKPASS was more than “ok” it was GREAT!
On the last PASS Regional Mentor call it was announced that (on a trail basis) the Regional Mentors would be allowed a fixed budget of money to recoup travel expenses for getting out and seeing chapters in their region. This is AMAZING for regions like mine (Canada) which span thousands and thousands of kilometers (or [...]
#OKPASS – I’m Leaving on a Jetplane
OK so this will be another first for me…. I’ve done plenty of remote presentations (via LiveMeeting) for PASS Chapters around the world but this will be the first time I’ve actually flown to another PASS Chapter (OKPASS) and presented live in person! Something that I’ve always envied about speakers in the US is how [...]
