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...

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...

Row-level Security Just Got Better: Passing Report Credentials to Analysis Services in SQL Server 2016

A new ground-breaking feature in SQL Server 2016 allows report user context to be passed through shared data sources, enabling...

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 should be used carefully because it could often not...

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 should be used carefully because it could often not...

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...

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...

Not More Than 16 Characters?!?

Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:

I blinked when...

How To Get A Free SQL Server Indexing Book – Week 2

Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...