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,298 reads
Blog Posts
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,945 reads
Live, Learn, and Grow
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
330 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
92 reads
SQL Saturday Wheeling 2018
Third time in a month, I will be presenting Machine Learning Server, this time at SQL Saturday Wheeling
2018-04-25
11 reads
SQL Server Nested Transactions Probably Don't Work How You Think
SQL Server allows you to nest multiple transactions but the results of doing so are completely not obvious.
Take the following...
2018-04-25
50 reads
State of the Cloud Database: April 2018
It’s an exciting time to be a database professional. The technology is advancing quickly, large datasets are easier to handle than ever before, and the cloud is opening up...
2018-04-25
7 reads
Webinars, and Azure, and SQL… OH MY!
Hello everybody! Thank you once again for stopping by and reading. April has been pretty busy with presentations, and I...
2018-04-25
109 reads
What is a DBA?
If you’ve worked in the data industry for more than few minutes then you’ve probably heard the phrase The DBA...
2018-04-25
329 reads
24 Hours of PASS – April 25th–26th
Well, it is that time of the year, again. PASS puts on a 24 Hours of PASS where 1 hours...
2018-04-24 (first published: 2018-04-18)
2,311 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers