Introduction to this blog series
After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...
2021-03-30 (first published: 2021-03-22)
1,388 reads
As technology products grow, it’s important to evolve. We’ve updated WordPress.com’s interface to make it more coherent and logical, allowing everyone to use it more intuitively.
2021-03-30
12 reads
I’ve never used the FETCH or OFFSET commands for pagination, but I have heard of them. I ran across them recently and decided to experiment a bit. One note:...
2021-03-29
306 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-29
7 reads
There are a lot of uses for Query Store, but one of the most interesting is as an upgrade tool. We all know that upgrades in SQL Server can...
2021-03-29 (first published: 2021-03-22)
315 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-03-29 (first published: 2021-03-22)
182 reads
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations - whether they be Azure SQL or the traditional on-premises SQL Server.
The post...
2021-03-26 (first published: 2021-01-05)
343 reads
I recently wrote about how I teach, in response to a T-SQL Tuesday post from 2010. This is a continuation of that theme, suggested by my own editor. Thanks,...
2021-03-26 (first published: 2021-01-13)
187 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-26
13 reads
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-03-26
14 reads
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers