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
9 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
259 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
5 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)
312 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)
177 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)
331 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)
182 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
11 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
9 reads
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-03-26
4 reads
I was asked to do a review of the book Microsoft Power BI Performance...
A while back I wrote about how to use a Cross Platform (or Clusterless)...
Introducing SQL Server 2025 - Enterprise Ready AI SQL Server 2025 is an upcoming...
is this even possible ?
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers