Skip to Content

Development Posts

How to calculate barcode check-digit using T-SQL language

Posted June 23, 2017

By

Introduction In order to scale, it’s imperative that companies stay ahead of competition. So how can they identify, store, manage and deliver goods to... more »
0

PASS AppDev next webinar: “Introducing R”

Posted May 04, 2017

By

On May 25th the PASS Application Development Virtual Group will host a new webinar delivered by the well know Dejan Sarka and the topic will be R... more »
0

PASS AppDev Recording: “Building REST API with SQL Server using JSON functions”

Posted April 30, 2017

By

Last week Jovan Popovic (SQL Server Program Manager for JSON support and other nice things) delivered a very interesting webinar on JSON and SQL Server / Azure... more »
0

PASS Application Development Virtual Group

Posted April 11, 2017

By

I’ve been involved with PASS, once named Professional Association of SQL Server users, now just…PASS, since 2006 when I stepped up as president of... more »
0

The biggest table in your database

Posted February 11, 2016

By

You may need to know which is the biggest table (in terms of disk space usage) in the database that you are currently connected. Sometimes, this information is... more »
0

The free #eBooks series #SQLServer and .NET Blog

Posted November 16, 2015

By

The series of free eBooks “The SQL Server and .NET Blog eBook Series” by Artemakis Artemiou (@artemakis) collects dozens of articles... more »
0

How In-Memory Database Objects Affect Database Design: Hybrid Code

Posted August 08, 2014

By

In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote the on-disk code to only use features that... more »
0

How In-Memory Database Objects Affect Database Design: Hybrid Code

Posted August 08, 2014

By

In my first attempts at building my code, I strictly went with either native or on-disk code. I specifically wrote the on-disk code to only use features that... more »
0

One more reason to to understand query plans, not directly performance related

Posted January 22, 2013

By

One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming... more »
7

Utility Queries–Structure of Tables with Identity Column

Posted September 02, 2012

By

Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using... more »
6