SQL RNNR

Blog Post

System Base Tables

On January 19th, I published a post about the Dedicated Administrator Connection.  I spoke very briefly of the system base tables in that article.  Today, I want to dive...

2012-01-30

3 reads

Blog Post

Slammer, Alive…Barely

By now you must have heard of the SQL Slammer worm.  It was quite an infectious little nuisance.  The harm it caused came largely due to unpatched, unprotected SQL...

2012-01-24

2 reads

Blog Post

S3OLV February 2012

Do you recognize this person?   If you are from the Colorado Springs area, you probably do.  This is:       Troy Ketsdever (twitter) Troy will be presenting...

2012-01-23

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