SSAS #39–Building Optimal and Well-Tuned Dimensions
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...
2014-12-14
1,509 reads
The Analysis Services Performance Guide from bunch of Microsoft Analysis Services experts have been updated since 2005 edition for 2008 R2...
2014-12-14
1,509 reads
I didn’t want to repeat the Night Before Upgrade again this year, so I wrote something new. Go ahead, sing...
2014-12-14
419 reads
MSOLAP is a native OLE DB provider for Analysis Services
A common task during ETL is to process the OLAP dimensions and the...
2014-12-13
3,126 reads
The best way to contact me is via email, please feel free to reach out at info@centinosystems.com and you will be replied to promptly.
Thank you!
2014-12-13
32 reads
With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...
2014-12-12
659 reads
Monitoring blocking and deadlocking hasn’t always been easy. Sometimes, the tools available in SQL Server are not as friendly as...
2014-12-12
1,868 reads
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-12-12
707 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-12-12
443 reads
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,412 reads
I was scanning Twitter the other day and saw a note from someone that they had written a query using...
2014-12-18 (first published: 2014-12-11)
7,888 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers