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
11 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,957 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
15 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
19 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
18 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
10 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
13 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
433 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
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,040 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers