Is It Possible To Conditionally Index JSON Data?
Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):
At first glance it sounds like...
2018-05-01
9 reads
Bert Wagner
In-Memory OLTP: A Case Study
Watch this week’s episode on YouTube.
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start...
2018-04-25 (first published: 2018-04-17)
2,952 reads
The Forgotten Fourth SQL Server Recovery Model
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
7 reads
The Forgotten Fourth SQL Server Recovery Model
Watch this week's video on YouTube
SQL Server recovery models define when database transactions are written to the transaction log. Understanding these models is critical for backup and recovery purposes...
2018-04-24
16 reads
In-Memory OLTP: A Case Study
Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...
2018-04-17
14 reads
In-Memory OLTP: A Case Study
Watch this week's video on YouTube
When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it. All I could think was "my queries...
2018-04-17
7 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month's T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different...
2018-04-10
9 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month’s T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way...
2018-04-10
429 reads
3 Essential Tools For The SQL Server Developer
This post is a response to this month's T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different...
2018-04-10
6 reads
Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger
Watch this week’s episode on YouTube.
In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning...
2018-04-10 (first published: 2018-04-03)
2,038 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers