Tom LaRock’s recent post – SQL University – Creative Writing Week – got me thinking about the act of writing. Although interesting, his post sparked two thoughts in my head – about reading and inspiration.
Reading
I love reading. There have been years when I’ve read over 100 books. Admittedly, I was required to read about 60 [...]
SQL Server
Database Manager for IIS 7 RC Preview IIS 7 has a lot of great features built-in, not the least of which is its ability to host mini-apps. Ever use PHPMySQLAdmin? Ever wish you had a tool like that for SQL Server? Now you do. Developers rejoice, you no longer need to install SSMS after [...]
SQL Server
Update Statistics Before or After an Index Rebuild? Colin Stasiuk talks about when you should update stats in relation to rebuilding/reorganizing indexes. I’m not just linking to this because I was the catalyst for his blog post, but because there are some great things in here and I learned a lot from it.
Best Practices [...]
SQL Server
Set based random numbers George Mastros points out that generating a random number using RAND() in a set-based operation will always return the same value for every row in the result set. What’s a DBA to do? Luckily, George also covers a great way to get around this predicament.
Hardware for SQL Server 2008 Andrew [...]