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.
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
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