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 [...]
