Business Analytics Day Jan 11, 2017 Chicago

I hope you can join me at the Chicago Microsoft Technology Center for the PASS Business Analytics Day, on Wednesday,...

Is it safe to grant Administer Bulk Operations?

First I guess we had best start with definitions right? The permission Administer Bulk Operations and the role bulkadmin are...

Monday Coffee 2016-11-14

Communication in the workplace.
With the release of Microsoft Teams we now have a dazzlingly array of software designed to increase...

Query tuning 101: Problems with IN ()

If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...

Test Post

A Data Professional’s Story – PASS Summit 2016

This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...

Creating Custom Databases with SQL Prompt

SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself...

Friday Reading 2016-11-11

It’s Friday so no releases to Production today (ha!) which means in-between my code reviews, server audits and other tasks...

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...

How to deploy your SQL Server database to a remote server

CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server where the target database is.

First time deployment

Backup / restore...