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 [...]
SQL Server
Best practices for taking on the DBA role as a developer – Armando Prato covers the basics of what it takes to go from developer to DBA. This is a good article and one that’s very near and dear to my heart since I’m pulling myself away from the development world and into the [...]
