Here we are with another super exciting episode of the SQL Friday, The Best SQL Server Links Of The Past Week show
Here is what I found interesting this past week in SQL Land:
Yesterday a friend asked me if it was better to always use a value of GEOMETRYCOLLECTION EMPTY as an alternative to making a geometry/geography column nullable. OGC has its own concept of database NULL, that is [GEOMETRY] EMPTY, where [GEOMETRY] can be any valid geometry subtype (that is ‘POINT EMPTY’, ‘LINESTRING EMPTY’, etc). When I asked why it mattered, he said he was tired of putting ..WHERE…IS NOT NULL in every UPDATE of SQL Server spatial data type. Sounds like reason for a blog entry.
Snapshot feature was one of the new features that were implemented in SQL Server 2005. When you drop a snapshot created on a source database in SQL Server 2005, it clears the entire procedure cache on the server.
Aaron Alton shows us a couple of more lesser know features of SSMS, continued here: http://feeds.feedburner.com/~r/TheHobt/~3/513743387/lesser-known-features-of-sql-server_15.html
Mike shows some best practices in regards to backups
Jeremiah Peschka shows you how to get things done even without sysadmin access
Jonathan Kehayias complains/rants: It is 2009, and I am shocked to find that applications today still show up with a requirement to be a sysadmin on SQL Server, and in the case of one particular application I am helping troubleshoot today, a Local Administrator on the SQL Server machine
Kevin Kline ask if the down economy has an impact on your job? Leave him a comment.
Dare Obasanjo has an interesting post about the Pros and Cons of Various Database Sharding Scheme
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future