Erin Welker


Erin Welker is an independent Microsoft SQL Server consultant, author, trainer, and presenter, specializing in business intelligence and performance. She has been working with SQL Server since version 1.11.

Debugging and Logging in SSIS - 28 Mar 2008 1
Easily debug packages, Control Flow tasks, and Data Flow tasks and log package-execution information using the debugging and logging capabilities in SSIS.
Data-Type Conflicts 2
Find out how to assign a compatible data type to the data destination(s) early in the pipeline to avoid data-type conflicts.
Upgrade Your Analysis Services Terminology
The new terminology in SQL Server 2005 Analysis Services (SSAS) can seem intimidating, but you can simplify it by using this vocabulary equivalency chart.
Scripting a Cube in XMLA
Virtually any object in Analysis Services 2005 can be scripted in XMLA. Here's a checklist for scripting objects and a sample script.
Moving Cubes from Analysis Services 2000 to 2005 2
Deciding to upgrade from Analysis Services 2000 to 2005 might be a no-brainer, but figuring out how to move your cubes can be a more complicated process. Here are some key concepts to help you decide whether to migrate or rebuild your cubes.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Nov 3, 2015

Climb the Steps Toward Data Quality Success

Melissa Data's Data Quality Analyst Joseph Vertido explains how Gartner defines the critical data quality steps to prevent bad data from entering your systems in the first place, and then keep it clean over time....More
Sep 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×