Automatic Seeding & Compression
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-31
1,082 reads
Getting the Hyperlink from Excel
I had a spreadsheet of data that contained hyperlinks. In this case, it was a series of Microsoft Knowledge Base...
2017-08-30
720 reads
Columnstore Indexes – part 111 (“Row Group Elimination – Pain Points”)
Continuation from the previous 110 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
The topic of the Segment Elimination (aka...
2017-08-30
700 reads
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max...
2017-08-30
358 reads
System-Versioned Temporal Tables
Every once in a while, I like to take a moment and learn something new about the latest SQL Server...
2017-08-30
1,204 reads
You might be a DBA if
I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be...
2017-08-30
1,883 reads
SSMS and MFA support for Azure SQL DB
Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...
2017-08-30
2,262 reads
Speaking at SQL Saturday Spartanburg (#681)
I am so happy to announce (and honored to be selected) that I will be speaking at SQL Saturday Spartanburg...
2017-08-30
495 reads
Offline Microsoft Documentation? Download it!
On my last article I shared how we can now Contribute to Microsoft Documentation. Today I bring another quick tip...
2017-08-30
3,155 reads
Ich werde Deutschland beriesen
Guten Tag!
OK, switching back to English for the rest of this.
I’m going to be spending a few weeks in Germany...
2017-08-30
538 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