Deploying MDS Samples in SQL Server 2012

[This post was created by Jason Howell, Senior Escalation Engineer in the SQL Server Support team specializing in MDS] MDS ships 3 samples model packages in SQL Server 2012 (as of Release Candidate 0 timeframe) that you can use to show MDS and play around with the features. The sample package files live under the…

9

What are the @OlapEvent queries hanging around in my SQL Server?

If you look at current activity in SQL Server 2005 or 2008 or 2008 R2, you may notice some some sessions coming from Analysis Services where last_wait_type is TRACEWRITE. For example, when you query like this: SELECT * FROM sys.dm_exec_requests; SELECT * FROM sys.sysprocesses; Since SQL has default traces that run, sometimes a query which…

0

What permissions are needed to create new objects in an Analysis Services database?

  To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the source code which throws the error to see what conditions it…

1

SQL Profiler doubleclick does not open .trc files any more

Whenever I double-click on a profiler trace *.trc file I get the error Unrecognized command line argument. All command line arguments will be ignored. ..Please run ‘profiler.exe -?’ to see a list of valid command line arguments. I suspect this happened when I installed a component of Visual Studio called the ATL Trace Tool, which…

1