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!
After installing SQL Server 2012 SP1 on your workstation, an update to SQL Server Data Tools is required before Visual Studio 2010 SP1 can again open BI projects. You can find the SSDT update links for VS2010 and VS2012 here.Continue reading →
SQL Server 2012 SP1 Is Now Available! – Microsoft SQL Server Release Services – Site Home – MSDN Blogs.Continue reading →
via Jen Stirrup’s Business Intelligence Blog: Microsoft SQL Server 2012 Latest Announcements: Hekaton, Service Pack 1 and PDW.Continue reading →
Rejected: 74% of organizations have no plans to deploy Windows 8 | TechRepublic.Continue reading →
Is PowerPivot the Next Access? – SQLServerCentral. I have tried using PowerPivot as an alternative to the dreadful, antiquated MS Query, and it does very well, and it can be a decent replacement for Analysis Services when the cube that is needed doesn’t already exist.Continue reading →
Another Stop-Gap Solution for the SQL Server 2012 Identity Crisis – SQLServerCentral. SQL Server 2012 generating non-sequential identity values? In my coding I never assume the value of a new identity field, which sometimes makes for extra work and could slow down high-volume code, but evidently some applications do assume. If yours … Continue reading →
MDS: Copying models and data to another server – SQLServerCentral. This SQLServerCentral article caught my eye because it explains a process I will soon be carrying out, moving MDS data from development to production. It looks as though the advice given could save a substantial amount of trial-and-error. Thanks to the … Continue reading →
Cumulative Update #4 for SQL Server 2012 – Microsoft SQL Server Release Services – Site Home – MSDN Blogs.Continue reading →