Monthly Archives: February 2012

MSDeploy: An old topic but many Vendors and Site Administrators still haven’t adopted it! Why?

Have you ever found yourself staring at IIS settings and metadata wondering why your site no longer works the way it did yesterday? Who changed what? Have you had vendors, or developers who just say to clone your site just … Continue reading

Posted in Uncategorized | Leave a comment

Big Deal You Have Backups! But are they really worth squat? :PART 2

In PART 1 (PART 1) we discussed the methodology of storing metadata along with your backups. We also touched on the type of content one might find in a typical restore document. We continue with this topic and discuss details … Continue reading

Posted in Sql Server | Leave a comment

24 Hours of PASS

Yep it’s that time already. Yesterday I signed up for 24Hours of PASS spring 2012. I enjoyed it so much last year. Definitely helped me decide what pre-conferences I wanted to attend last year at the PASS Summit 2011 event. … Continue reading

Posted in Sql Server | Leave a comment

SSIS: Another Simple SMO Based SQL Server Script Jobs Example

Scripting SQL Server jobs can be accomplished in a few different ways, and the method demonstrated here is based on the SMO (SQL Server Management Objects) http://msdn.microsoft.com/en-us/library/ms162169.aspx This entire package is very custom to a particular environment. Therefore I am … Continue reading

Posted in Sql Server | Leave a comment

Review of attending the “Big Data with Hadoop and SQL Server” talk at NESUG

Last night I went to New England SQL Server User Group with Don O’Neill speaking about “Big Data with Hadoop and SQL Server”. Don O’Neill is the Senior Director of Engineering, Operations and Infrastructure at TripAdvisor, overseeing the company’s software, … Continue reading

Posted in Sql Server | Leave a comment

Big Deal You Have Backups! But are they really worth squat? :PART 1

The most common thing I hear lately is “Have a Restore policy not a Backup policy!”. So what is important in a restore policy? Call me anal retentive but how about everything? Ok, perhaps we can’t have the exact picture … Continue reading

Posted in Sql Server | Leave a comment