I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Comparison: Switching Tables vs. sp_rename – An interesting walk-through that evaluates the differences between using the sp_rename system stored procedure and the partitioning support SWITCH statement, courtesy of the The Database Whisperer (Michael J Swart).
- Insecure Metadata – A look at SQL Server Metadata security, by Ben Nevarex shows how even when your environments adhere to best practice they could still be giving away exploitable information.
- Restoring SQL 2005 Master Using LiteSpeed – If you are Litespeed user and you have not had to restore your master database using the tool then I strongly advise you to review this first hand experience account from Thomas La’Rock.
- SQL Server 2008 Diagnostic Information Queries (Late November 2009) – Here is a nice list of SQL Server diagnostic queries courtesy of Glenn Berry.
- Free Tool for SQL Server Encryption Key Management – Everyone likes a freebie.
- Upgrading the SSC SQL Servers: Part 1 – An interesting discussion from Brad McGehee about working on the SQL Server Central upgrade project.
- Odd that you can’t create a filtered index on a deterministic persisted calculated column – An interesting scenario shared by Greg Low.
- Performance impact: UNION ALL views, ANSI_PADDING, and bad query plans – An interesting Demo, kindly provided by Linchi Shea
- Who is Active? v9.57: Fast, Comprehensive DMV Collection – What’s Really Happening on Your Server? – Here is the next release of Adam Machanic’s very useful script for identifying what is happening right now on your SQL Server instance.
- Aren’t DBA’s Just System Admins for Databases? – More and more IT professionals are waking up to the fact that there is a whole lot more to the humble DBA. Perhaps it is time that you considered yourself as a Data Professional, Buck Woody discusses.
Misc Techie Stuff
- Intel unveils 48-core cloud computing silicon chip – Not sure if the terminology “cloud computing” should really be being used here but a very interesting development nonetheless.
- Google set to offer property dimension to UK mapping – Well it was only a matter of time really that once Google Maps had launched and become established, this was the next logical business move. Not good news for property websites!
- Troubled £12bn NHS IT system to be scaled back – There must be UK Public Sector IT projects that are or have been successful? Let me know about them!
That’s it for this week. If I’ve missed anything that you think is worth mentioning then be sure to let me know. Fire me an email or a tweet on Twitter. Have a great weekend!