Bringing Database Devops to DevConnections

Another alliteration post. Maybe I’ll make all my titles tongue twisters to test your talents?
This is my new favorite session....

Migrating to Azure - Quirks & Tips

Recently I have moved a dozen websites and web apps to Azure. Some are small apps used by a few...

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