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
Tip : Make your SQL Server database changes backward compatible when changing a relationship
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...
Tip : Make your SQL Server database changes backward compatible when renaming an entity
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...
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,...
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...
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....
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...