Referencing Remote Data

Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?

T-SQL Tuesday #26 – Second Changes with Date/Time

I missed the very first T-SQL Tuesday, so when this month’s topic of second chances came up, I decided to...

Time Zone

Capacity planning for new hardware

I get asked this question a lot: When getting a new application and database, what kind of hardware do I...

DBAs in Denver

I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...

Classifier Functions

Creating Strong Passwords

I was writing a presentation recently on encryption and one of the important things to show in the presentation is...

Read-only Data

Today's poll looks at read only data and how you handle the backup and recovery of this data.

SQL Server 2012 Licensing VMs without SA

I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and...

A New SMK