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,953 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
10 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
17 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
8 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
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...
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
7 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
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...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers