Last Weeks Top “Reading” Links #113
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-12-15
493 reads
Why You Should Benchmark Your Storage
You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And...
2014-12-15
1,283 reads
Create a clustered index and a primary key on existing tables
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes...
2014-12-15
658 reads
The Value of Writing Good
Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re...
2014-12-15
558 reads
Does a clustered index sort the rows within a page
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,376 reads
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,503 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
416 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,116 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
29 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
656 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers