PowerShell ISE Crashes

Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to...

PowerShell ISE Crashes

Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh...

Happy Thanksgiving Readers!

I wanted to take a moment and wish an easy week in the office and a Happy Thanksgiving to everyone!
 

The...

Fun with PowerShell: I made a game

So we got to playing around with PowerShell last week – one son is making a game hack, and the other...

Query Store and Plan Cache Plans Compared

Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...

SQL Live Conference – December 2-7 in Orlando

I am proud to contribute to this year’s Live360 conference, to be held in Orlando Florida at the Royal Pacific...

Running SQL Server with Docker on the Mac

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Dealing with multiple AD accounts

To help promote the seperation of duties one of the things my company has done is to divide our permissions...

What is the SQL Server Trustworthy database property?

I ran across an interesting property set in a SQL Server database for a customer, the property is called “Trustworthy”. ...

How to migrate SQL Database to Azure SQL Database using SSMS Export/ImportMigrating SQL Database to Azure SQL Database using SSMS Export/Import
Contents

Introduction
Creating the .bacpac file using SSMS Export
Importing the .bacpac...