Make your SQL Server database changes backward compatible when changing a relationship
Tip : Make your SQL Server database changes backward compatible when changing a relationship
Monthly Archive: July 2010
SQL Server 2008 SP1 CU #9 is available
The SQL Server Release Services team recently announced that they have released a new Cumulative Update for SQL Server 2008 SP1: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/07/19/cumulative-update-9-for-sql-server-2008-service-pack-1.aspx This update will bring you to build 10.00.2789. From the looks of...
Make your SQL Server database changes backward compatible when renaming an entity
Tip : Make your SQL Server database changes backward compatible when renaming an entity
OT: How to make a bajillion dollars
It's pretty simple: buy the penny auction software that QuiBids* uses, get a hosting account somewhere, and go to town. * or Swoopo, or BigDeal, or BidCactus… the list goes on and on and...
T-SQL Tuesday #8: How Learning Has Changed
When I started my technical career, the only way to learn about programming was from books and magazines. I remember writing my first HTML page and finding it quite similar to the Vic20 days,...
SQL Server 2008 SP2 (CTP) is available for testing
While I don't recommend you rush out and deploy this to your production instances today, it might not be a bad idea to get a head start on testing the fixes in SQL Server...
Splitting a list of integers : another roundup
Last August, I wrote a lengthy post about how I handle splitting up a list of integers that are passed into a procedure as a comma-separated list. I am still using this method today....
Welcome to the jungle, CLR!
I've always been very reluctant to use the CLR. On a completely unrelated tangent recently, I begrudgingly threw CLR into the ring of a string splitting performance test (blog post forthcoming). Actually, the reason...