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
335 reads
Blog Posts
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,846 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,542 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,465 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,244 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,475 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
793 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
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...
2018-02-20
205 reads
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers