Solving a slow running query issue with UNION
That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!
I recently encountered...
2015-03-09 (first published: 2015-02-25)
8,812 reads
Blog Posts
SQL Saturday Oklahoma City, OK: 422 August 29th, 2015!
We're proud to bring back the OKC SQL Saturday for the 5th year in a row! We have 3 precons...
2015-03-09
758 reads
Transaction Logging in In-Memory OLTP (Hekaton)
In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into...
2015-03-09
1,112 reads
Upcoming Events Where We Can Chat
I get around quite a bit.
Next week I’ll be visiting three cities in Germany talking to user groups in Frankfurt,...
2015-03-09
657 reads
Why You Shouldn’t Skip the Infrastructure/Security Architecture Review
It’s not usual for development projects to undergo an architecture review, but too many times these reviews consist only of...
2015-03-09
264 reads
Data Compression– a unique feature of SQL Server TIP #91
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually...
2015-03-08
641 reads
SQLBits, Incremental Statistics and Demo Fail
So another great SQLBits is done and dusted, many thanks to the team, helpers and sponsors for putting on such...
2015-03-08
480 reads
In-Memory OLTP & Deadlocking – my SQLBits sessions
After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in...
2015-03-07
587 reads
DevOps, the DBA, and the word “No”
Check out this DevOps Reactions animated GIF and caption.
It’s funny on multiple levels, but it also makes me both mad...
2015-03-06 (first published: 2015-02-24)
6,816 reads
Friday Followup For March 6, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-03-06
375 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers