Welcome to Megan’s Space at Far2Go.net. You’ll find a brief introduction to me and this website here. This is my SQL Server blog. The Health and Nutrition section has moved to another part of the website.
(Note: user account creation has been disabled for this blog)
Indexed Views – SQLServerCentral.
This post describes an interesting feature that I have never been able to use. Unfortunately, indexed views come with a fairly long list of restrictions and I always seem to run afoul of at least one of them.
Before I migrated to SQL Server 2012, I was using Visual Studio 2010 Premium, which included Database Projects. It was a great feature that, once I figured out how to use it, enabled me to keep track of all my schema changes automatically, and to deploy them to production in a controlled way that allowed for backing them out again. Unfortunately, it didn’t work for me with SQL Server 2012.
I have had to disable WordPress user registration due to spambot issues. If you want an account then you may contact me using a comment, below, or via one of my ‘social media’ links.
This change does not affect my Health and Nutrition blog, which is located in a different part of the website, outside the blog.
For the last few weeks, on and off, I have been experimenting with setting up SharePoint 2013 Enterprise in order to explore its Business Intelligence features. Maybe you can just read about it and understand, but I need to try things.
Performing a clean installation of SQL Server 2012 SP1 on the (new) production servers seems to have resolved a number of issues relating to MDS.
My upgrade to SQL Server 2012 SP1 from CU4 went well except for one glitch. After the upgrade was complete, MDS showed no models!
