SQL Saturday #85 Orlando
SQL Saturday #85 is quickly approaching. It will be held in sunny Orlando, FL so if you live in the area get ready for awesome because I am coming to town! Ok, that may have been a little over the...
Author: Bradley Schacht
Backup and Restore SharePoint 2010 Site Collection with PowerShell
One of the most annoying processes with SharePoint is backing up a site collection. There is a build in tool that you can use but it is kinda clunky and can take a while to perform the backup. I used...
Upcoming Content Preview
It has been a few weeks since I last posted. I know, I’m a slacker, thanks for pointing that out. I have a little bit of a pipeline that I am working on getting populated and just wanted to toss...
Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside a database. This can be accomplished one of many ways, the quickest and easiest is to expand the columns node...
SSIS Configurations: When and How
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible to over configure a package, so be sure that you only do what you need to in order to make...
SSIS Webinar Recording Is Up
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I did on Tuesday. If you missed it the topic was Dynamic SSIS: Configurations, Expressions and Variables. I got a lot...
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say a big thank you! We had a great time at a very successful event. I was able to help out...
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post, but I assure you that new content is on the way. I have a couple things in the works that...
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some small piece of knowledge you didn’t have when you walked into the room. If nothing else you now know that...
Search Stored Procedure Text
There will come a day, if it has not already come and gone, when you will want to search through your stored procedures because you don’t remember which one did what you want to do. Did that make sense? Because...