Erin Welker

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.

Articles
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.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 5

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
Jul 8, 2014
blog

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and makes replication much easier to manage....More
Red restore key on computer keyboard
Jun 24, 2014
blog

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....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) ×