Update: The contest is closed. Winners have been announced over here. Thanks for playing.
Who wants an MSDN 2010 subscription?
Due to my over-involvement in the development and database community, Microsoft gave me three MSDN licenses to give away. I’m not sure who I should give them to, so I thought about how to give them [...]
Let’s say that you want to clear out your old backup history. Why would you want to do that? Let’s also assume that your maintenance plans (yes, maintenance plans) have not been cleaning up after themselves.
If this has happened over a small period of time, you can just do this:
EXEC sp_delete_backuphistory DATEADD(m, -1, GETDATE());
But what [...]
SQL Server
Deploying Databases From Visual Studio Team System Database Edition Grant Fritchey has written an article about using Vistual Studio Team System Database Edition to deploy databases and database changes. If you haven’t taken a look at Data Dude, now is the time to do so, it’s a great product!
Declarative Database Development This is a [...]
In two weeks, Andy Leonard will be presenting remotely for CBusPASS, the friendly Columbus PASS chapter.
Come pay us a visit. It will be a good time.
Here is the information from the CBusPASS website:
Topic
Incremental Loads, Change Data Capture, and SSIS 2008
Abstract
Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data [...]
Denis Gobo started up a new meme about your first computer and favorite games.
My first computer was a Tandy 1000SX with 640KB of RAM that my family got when I was 9 or 10, I think. My dad quickly overclocked it to an astounding 7.6 MHz of pure Intel 8088 power and added a 20 [...]