Elastic Query in Azure SQL Database and Views

The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...

Learning Azure Data Platform

One of the issues I’ve seen with Azure is that is changes rapidly. It’s cool in that new things get...

Monday Morning SQL Break – June 13, 2016

Usually on my Monday posts, I include a pretty bland cookie cutter header. Nothing to extravagant, just an introduction.  It’s...

Protecting Against Delete without Where

If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

The CHECK constraints unlike behaviours

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

SQL Community n Speaking Assignments

Dear All,

It has been a while since I became less active on this blog. Reason for the same being that,...

The COUNT function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...