My articles published on SearchSQLServer.com from January 2014 to September 2014
The following is the list of my articles published on SearchSQLServer.com from January 2014 to September 2014. To read these...
2014-09-09
922 reads
Clustered Columnstore Indexes – part 40 (“Compression Algorithms”)
Continuation from the previous 39 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
It’s time to take a look into the algorithms that Microsoft is...
2014-09-09
312 reads
T-SQL Tuesday #58 - Passwords
This month’s T-SQL Tuesday topic is passwords. I’m neither a DBA nor server/system admin, so the only passwords I get to manage are my own. But there’s still lots to...
2014-09-09
11 reads
The BBQ Crawl at SQL Saturday #300
This weekend is SQL Saturday #300 in Kansas City. I’ll be traveling Friday for the event, hoping to arrive in...
2014-09-08
728 reads
New Add-on for SSMS: T-SQL Flex
Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then...
2014-09-11 (first published: 2014-09-08)
10,885 reads
Tip: RECOVERY_PENDING is not the same as RECOVERING
I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating....
2014-09-08
924 reads
I'm Speaking at SQL Saturday 300 - Kansas City and a Few Questions About SQL Saturdays!
This is just a short update. I will be speaking at SQL Saturday Kansas City! I really hope to see...
2014-09-08
596 reads
SQLSaturday Orlando Marketing Plan-Part 41
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is...
2014-09-08
522 reads
Better Presentations–Fonts
This is part of a series of tips for speakers to make your presentations better.
Please, please, please, learn how to set...
2014-09-08
829 reads
Parameterization Part 4: Handling Non-Uniform Data Distribution
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,138 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...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Forums
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....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers