The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
8 reads
I’ve 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...
2020-06-02
3 reads
Did you know that the system_health Extended Event session was running in your RDS instances? Well, it is. HOWEVER. This query, which works perfectly fine on my on premises...
2020-06-02
68 reads
Setting up a home office can be a daunting task. Doubly so when you don’t get an opportunity to plan it out and you have to set things up...
2020-06-02
There are a number of options for monitoring Power BI that I wanted to mention: Performance analyzer: Find out how each of your report elements, such as visuals and...
2020-06-02 (first published: 2020-05-18)
718 reads
It’s been a while since I typed up a blog post but life, even in the midst of a pandemic, has been busy and crazy. As you can imagine,...
2020-06-02 (first published: 2020-05-20)
787 reads
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading
2020-06-02
21 reads
The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I...
2020-06-01 (first published: 2020-05-18)
596 reads
I’ve 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...
2020-06-01
8 reads
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Microsoft SQL Server Management Studio IDE (Integrated Development Environment) is a...
2020-06-01
87 reads
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers