A Live Node

Today we have an editorial from March 29, 006 as Steve is on vacation. Today Steve talks about the problems of constantly being distracted and not focusing on one thing.

Query Plans

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable

CREATE...

Free BI Training in June

Free training from Pragmatic Works, Microsoft and SQLServerCentral. Learn about SSAS performance, SSIS Configurations, GIS in SSRS and more.

Ghost Records

The Care of Data

Security is a big concern with data, especially when there is another company involved. Steve Jones notes today that cloud vendors need to beef up their work in this area.

Identity Reseeding

I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...

The Ad Hoc Change

Almost every DBA will be asked to change data in production at some point. Too often we don't have the tools to allow users to correct errors, but when you make changes, Steve Jones reminds you that you need to be careful and still have a process.

Resource Governor

Better Writing from Hemingway

These are five rules for writing from Ernest Hemingway, which I like and recommend for use in your communications. Definitely...