SQL RNNR

Blog Post

Data Platform MVP 2020

I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:

It's an Honor: Microsoft MVP July 1, 2019

How...

2020-08-12

54 reads

Blog Post

Unconscious Bias

This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:

Note to Self June...

2020-08-24 (first published: )

432 reads

Blog Post

Unconscious Bias

This article helps to unearth a cultural issue that each individual needs to address on a personal level. Bias is an enemy to productive conversation.
Related Posts:

Note to Self June...

2020-08-11

1 reads

Blog Post

Disappearing Data Files

This article has just shared the power of XEvents and yet another use in helping to audit the database environment for changes. Not only do we have this powerful...

2020-07-14

2 reads

Blog Post

Extended Events Gets a New Home

One of the most versatile and awesome power tools given to SQL Server now has a new home! This new home will serve as a fabulous repository of extensive...

2020-08-20 (first published: )

421 reads

Blogs

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

By

I’m giving two online sessions soon on virtual events that are free to attend....

Read the latest Blogs

Forums

SQL Server 2025 Jobs

By Do

Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...

how to optimise whole database full of table and sp in one go using githubcopilo

By rajemessage 14195

i have subscription of github copilot which i can access in vs 2022 comunity...

Password Guidance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Password Guidance

Visit the forum

Question of the Day

Using table variables in T-SQL

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