Tony Davis

Swallowing the Camel

There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]

2014-09-15

167 reads

Blogs

SQL Server Containers Are Boring

By

Not really, but sort of. The beauty of containers, at least in a dev/test...

Public Role Permissions – Back to Basics

By

If you are being serious in your role, then the amount of times you...

It’s interesting how an OR short circuits.

By

I recently did a post on the case expression short circuting and received a...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Always on AG and SQL Upgrade

By Admingod

Looking to upgrade from SQL Server 2014 to SQL 2016 which has always on...

Migration from server to server

By rrizzojr

I recently migrated from Windows 2003 SBS running SQL 2005 Express along with SSMS...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers