Monthly Archives: June 2016

OBJECT_ID()–#SQLNewBlogger

Posted on June 8, 2016 by way0utwest

  One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in SQL Server. For example, I was looking at STATS_DATE recently, and it has this definition. STATS_DATE (object_id, stats_id) In … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Abstraction

Posted on June 7, 2016 by way0utwest

One of the core tenets of good software design is to abstract away details in any particular part of an application. We want to use well defined and constructed interfaces so that the implementation of any particular method or section … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Abstraction

InsideSQL–The Deep Dive

Posted on June 7, 2016 by way0utwest

There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near Liverpool Stree and the Moorgate stations. And I want to go. I can’t. I’m a bit traveled out, my family … Continue reading →

Posted in Blog | Tagged , | Comments Off on InsideSQL–The Deep Dive

A New Sample Database

Posted on June 6, 2016 by way0utwest

When I started working with SQL Server we had the pubs database. This was in SQL Server 2014, and I only used it because code samples from the Internet used it. It wasn’t a great database, but it was consistent … Continue reading →

Posted in Editorial | Tagged | Comments Off on A New Sample Database