Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)

I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on...

Budgeting for SQL Saturdays

We’ve been doing SQLSaturdays for eight years at Louisville now. We’ve had a quite a wide range of budgets depending on...

What is a SARGable predicate?

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek on indexes. The term’s an abbreviation, ‘SARG’ stands for...

What is a SARGable predicate?

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...

What is a SARGable predicate?

‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...

Interview Questions for Companies

In this article I will be posting interview questions by companies. Whenever I am facing any interview or someone shares...

Azure: Creating a BACPAC from an On-Premises SQL Server Database

So to start, what’s a BACPAC?

Per the Azure documentation
When you need to create an archive of an Azure SQL database,...

Importing a BACPAC to SQL Server

We previously looked at Archiving Azure SQL Database to a BACPAC and in today’s post we are going to address...

Statistics with TSQL and R: Chi Square Test

As I move on from descriptive and  largely univariate (one variable based) analysis of data into more multivariate data – one...

Top 5 Books for Database Developers

My Top 5 series of books has proved very popular. The first post  titled Top 5 books for Enterprise Architecture was the...