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.
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.
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....More