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
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
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
(last updated: 2018-04-18)
This is Part 3 of 2. Yes, you read that correctly. You see, way back at the very...
2018-04-16
272 reads
Podcast: Big Data Solutions in the Cloud
In this podcast I talk with Carlos Chacon of SQL Data Partners on big data solutions in the cloud. Here is...
2018-04-16
175 reads
Podcast: Big Data Solutions in the Cloud
In this podcast I talk with Carlos Chacon of SQL Data Partners on big data solutions in the cloud. Here is...
2018-04-16
540 reads
Execution Plan Shortcoming in Extended Events
I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for...
2018-04-26 (first published: 2018-04-16)
1,703 reads
Free Session, Free Beer, Free Food - # Not the GDPR News
This is a final call for attendees. We are have the last few seats available in out #Not the GDPR news -...
2018-04-16
349 reads
Azure SQL Database vCore
vCore based performance levels are very new, currently in preview and not yet rolled out to all Azure regions (The...
2018-04-24 (first published: 2018-04-16)
2,375 reads
I’ve gotten a transaction log full error but when I look it’s not full??
Every now and again I’ll get an error telling me a transaction log is full. This can be for any...
2018-04-23 (first published: 2018-04-16)
2,292 reads
Exploring the Caves of Code Analysis in #SQLPrompt
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-04-25 (first published: 2018-04-16)
2,303 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers