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,496 reads
Little Java Boy
I didn’t want to repeat the Night Before Upgrade again this year, so I wrote something new. Go ahead, sing...
2014-12-14
410 reads
SSIS #117–What is the Location in the MSOLAP Connection String
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,107 reads
Contact
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
19 reads
Azure Columnstore, part 1 – The initial preview offering
With today’s announcement on the availability and support of the Columnstore indexes in the Preview version of Azure SQLDatabase, I...
2014-12-12
654 reads
Monitoring blocking and deadlocking with Extended T-SQL Collector
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,860 reads
Reblog: December 5 to December 11
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
701 reads
Friday Followup For December 12, 2014
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
436 reads
SQL Bits – Europe’s largest SQL Conference
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,406 reads
T-SQL Tricks – Trigger Your Memory
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,884 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers