Hekaton Part 9: Things Hash Indexes can't do
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
409 reads
Blog Posts
So Long Seattle and Thanks for all the Fish!
I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high...
2015-10-25
577 reads
Counting Events
This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be...
2015-10-23
11 reads
Counting Events
After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is...
2015-10-23
605 reads
Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension
This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...
2015-10-23 (first published: 2015-10-19)
2,859 reads
First Day as DBA - Now What?
It's your first day at Corp of
America as DBA. The old DBA left. The sysadmins are managing the SQL Servers.
And...
2015-10-23 (first published: 2015-10-19)
4,215 reads
Improved #MinionBackup and #MinionReindex – new versions!
We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes....
2015-10-23
669 reads
PASS Summit 2015 Plans
I’m flying out Sunday morning on my usual direct flight from Orlando to Seattle. I like getting there a day...
2015-10-23
593 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
624 reads
SQL in the City Comes to Seattle in 3 Days
Last week I spoke at SQL in the City 2015 in London, and it was a great event. We had...
2015-10-23
413 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers