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.
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 is one of them, beware.
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 →
