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 top but all parts of that thought are in fact true. I am coming to town for the event and it will be awesome. To start with if you are a SQL Server professional in any way you should come out for the day. That includes all the DBAs, .Net developers that work with SQL and of course the BI developers out...
Read More
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 once and was not impressed. PowerShell provides a quick and easy way to do site collection backups. My favorite part is that you can do the entire backup with one, uno, un, 1 (that’s all I know for the number one so… yeah) line of code. Just a little something to be careful of, you need to use th...
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 out some of the topics that I have in consideration for upcoming content. If you happen to have something you would like to see on here please feel free to email me or leave a comment. The more feedback I get on what people want to see the better your experience will be coming to this site... and yes tha...
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 inside the Object Explorer in SQL Server Management Studio (SSMS). What if you want to look at your entire database though? Running a query against INFORMATION_SCHEMA.COLUMNS is a great way to do this. This will get you much more in depth information about your tables with minimal work. I c...
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 life easier. Sometimes too much configuration can equal confusion. So the big questions, what is a configuration, when should I use it and how do I use it. Let’s tackle that first one then roll right into the other two. What is a configuration? In simplest terms a configurati...
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 of good feedback from people who attended saying it was helpful. It’s always nice to know that someone got something out of a session. I know I said I was going to be posting some samples and that sort of thing along with the link to the recording but I haven’t quite gotten t...
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 a little and take on an extra session from Julie ( Twitter | Website ) who wasn’t feeling well and was unable to make it down from Atlanta. One of the three sessions that I presented on was Dynamic SSIS where we talked about using SSIS configurations, expressions and variables to make everyone’s life easier. Consequen...