Holy Foreign Keys and Indexes
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
A Performance Troubleshooting Methodology for SQL Server
When healing a sick SQL Server, you must forget the idea that there could ever be a simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assembling, the various pieces of the puzzle so that you have a complete understanding of what is going on inside of a server.
Stairway to T-SQL DML Level 1: The Basic SELECT Statement
There are lots of different aspects of managing data in a SQL Server database. Before you can get into the complex management issues associated with managing application data you need to start with the basic of retrieving data from a table. To return data from a SQL Server table you use a SELECT statement. In this level I will be cover the components of the basic SELECT statement and how you can use it to retrieve data from a single SQL Server table.
The 2011 SQLServerCentral Party at the PASS Summit
Once again SQLServerCentral is hosting a party at the PASS Summit in Seattle on Oct 11 at the Washington State Convention Center. Read about how you can get tickets.
The DR Test Schedule
Planning for disaster recovery entails a lot of different items, but testing is an important one. If you don't test your plans, you can't be sure they will work. This Friday Steve Jones asks how often your test.
Writing Maintainable Code
Writing maintainable code is hard. It must be understandable, testable and readable. Any one of these can be tricky, and together they seem pretty daunting. Thankfully, Michael Williamson makes it look easy to become a code craftsman.
Automatic Alert Generation in the event of SQL Server Cluster Failover
We had a requirement where we were asked to generate automatic email notification in the event of a failover.
Come Find Me at the Summit
Steve Jones reminds you to network anytime you're at and event, and especially a large conference like the PASS Summit.
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers