Azure SQL Elastic Pools
In this video tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to...
2018-02-21
726 reads
Blog Posts
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
327 reads
Indexing and Partitioning
Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of...
2018-02-21
3,828 reads
Power BI with different Network Visualizations
(2018-Feb-10) A few days ago Microsoft provided another update for its desktop version of the Power BI data analytical tool...
2018-02-21 (first published: 2018-02-10)
56,316 reads
Recovering a TDE protected database without the Certificate
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
3,301 reads
SQL Server Updates Tricked Me for Years
When applying a new SQL Server cumulative update, hot fix, or upgrade SQL Server doesn’t always apply all the fixes...
2018-02-21
1,203 reads
Windowing without a partition by or an order by
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER
-- No this isn't meant to...
2018-02-21
1,471 reads
Classifying Data with SSMS 17.5
I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data....
2018-02-20
790 reads
gdpr - panic part 4
In the first part of this series, we looked at where to find out more information about GDPR in the...
2018-02-20 (first published: 2018-02-08)
2,076 reads
OR vs UNION ALL - Is One Better For Performance?
Today I want to show you a trick that could make your queries run faster.
It won't always work, but when it does everyone will be impressed with your performance...
2018-02-20
6 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