So, after previous post called "Adventures with SQL Server Management Objects", I decided to take a step back and see if I could improve my code. I wasn't happy with the while(true) loop, as if the developer…
SQL
A collection of 4 posts
Adventures with SQL Server Management Objects
Recently, I had an issue where I needed to be able to trigger a SQL Server Job from a Console Application. Now initially, I had the knee-jerk reaction of hitting the good ol' ADO.Net SQL Libraries, to invoke my…
SQL Filegroups & Blob Data: Part 2
Continuing on from this post, will be the SQL used to move our Blob Data to a different filegroup. The first step in creating a new filegroup for your all of your data is to create the actual filegroup itself.…
SQL Filegroups and Blob Data
Every now and then I get asked to do something really fun, and out of my normal purview of technology. We had a very large table in our database, filled with blob data from how we store our documents, and…