Azure. Business Intelligence. SQL Server. Nerd Stuff.
by Bradley Schacht · Published July 13, 2011 · Last modified October 13, 2015
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...
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...
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...
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...
Business Intelligence / Speaking
by Bradley Schacht · Published June 9, 2011 · Last modified October 13, 2015
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...
Business Intelligence / Speaking
by Bradley Schacht · Published June 7, 2011 · Last modified October 13, 2015
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...
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...
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...
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...
by Bradley Schacht · Published April 24, 2011 · Last modified October 13, 2015
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they are not so good when you start talking about parallel processes or containers. What follows is a little bit of...
