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

DBCC CHECKFILEGROUP

Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...

World is changing so DBA should

I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...

SQL Server 2016 In-Memory OLTP and After Trigger Support

SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...