Author Archives: Jorge Segarra

Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly

Posted on February 13, 2012 by Jorge Segarra 7 Comments

SSIS Expressions Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables, connection strings, properties for almost anything, etc. One huge issue that tends to trip up a lot of folks, … Continue reading →

Monday Morning Mistakes, Syndication, Tips

Monday Morning Mistakes: Remote Connectivity to SQL Server

Posted on January 23, 2012 by Jorge Segarra 4 Comments

Inspired by common emails and questions I  see, I figured I’d do a series of blog posts on common mistakes folks make with SQL Server called Monday Morning Mistakes (or #sqlM3 for short, since we all love quick hashtags these … Continue reading →

Monday Morning Mistakes, Syndication, Tips

Estimated Completion Time for Backups and Restores

Posted on December 30, 2011 by Jorge Segarra 1 Comment

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show estimated time of completion for a database restore in progress on SQL Server. The script will also show you estimated … Continue reading →

DBA, Syndication

SQL University: Virtualization Basics

Posted on November 17, 2011 by Jorge Segarra Leave a comment

This week we’re going to talk about a topic that has been gaining steam in the last few years and as it has it has started impacting database administrator’s worlds more and more: virtualization. Why do I make this statement? … Continue reading →

SQL University, Syndication, Virtualization

SQL Server 2012: Business Intelligence Edition

Posted on November 3, 2011 by Jorge Segarra 7 Comments

Well this was quite the little surprise this morning. Microsoft announced a new edition to the SQL Server lineup for 2012 – Business Intelligence edition. In addition to a new edition (funnily I don’t see Datacenter in that lineup) we … Continue reading →

Syndication