SQLServerCentral Article

Mini Disaster - AC Failure

Are you prepared to handle a full or partial failure of your AC system? Ever thought about what would happen if it did happen. Once again Andy offers comments on a real world incident. While we'd all like to think it will never happen to us, we think sharing these incidents is a great way to prevent it from happening to others.

SQLServerCentral Article

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

Finding Gaps in Sequential Data Using SQL Server

By Imran2629

Comments posted to this topic are about the item Finding Gaps in Sequential Data...

Negative and Positive Numbers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Negative and Positive Numbers

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers