Partitioning 3: Beyond just partition elimination
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,860 reads
Blog Posts
Speaking at Techorama 2019
I’m delighted to announce I’ll be giving a talk at Techorama 2019. It’s one of the best events I’ve ever been to and I’ll be in the good company...
2019-03-04
9 reads
Speaking: Rochester SQL Server User Group March 2019
Probably a bit late getting this posted but I will be speaking at the March 5, 2019 meeting of the Rochester SQL Server User group (RSVP link). I don’t...
2019-03-04
2 reads
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management...
2019-03-04
497 reads
system_health Extended Events in Azure SQL Database
The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the...
2019-03-04
7 reads
Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)
I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...
2019-03-04
9 reads
Weekly reading #5
Last week was busy the busy one. The SQL Bits, SQL Server CTP 2.3 and other great stuff have come...
2019-03-04
342 reads
Last Week Reading (2019-03-03)
Hey everyone! I was very busy at the SQLBits conference last week, but it did not stop me to prepare...
2019-03-03
307 reads
Data story behind a Global Fishing Power BI report
(2019-Mar-01) The first time I heard about the Data For A Cause initiatives was at one of the Power BI meetups in Toronto....
2019-03-01
814 reads
Practical Web Scraping–More Reading
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-03-01
625 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers