Dec 6, 2009
Something for the weekend: SQL Server Links 04/12/09
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!