Year: 2018

Back up all databases in a SQL Server instance

Here is one of my favorite time saving scripts, that I wanted to pass on. This script will back up all databases, except for the system databases. I did not write this script. The author is Greg Robidoux and the original link is https://www.mssqltips.com/sqlservertip/1070/simple-script-to-backup-all-sql-server-databases/ —beginning of script—– DECLARE @name VARCHAR(50)

Take home items from my 1st PASS Summit and most likely blog topics for the foreseeable future.

Besides catching up with some old friends. This conference is awesome. Everyone is very friendly, welcoming and willing to help. You truly feel like you are part of the #sqlfamily. I’ll post more about the atmosphere in the future. Power BI datasets will be available in other workspaces. For instance,

Migrate SQL Server Database to Azure SQL Database using Data Migration Assistant – part 2

The first two steps can be found at http://georgevwoods.com/2018/08/29/migrate-sql-server-to-azure-sql-server/ Part 3: Migration Assistant Open the Data Migration Assistant and click on +New to start a new Migration Choose Migration Fill in the project name and keep the defaults for the other options and click Create On the first screen, fill

Migrate SQL Server Database to Azure SQL Database using Data Migration Assistant – part 1

We will be using the Data Migration Assistant to assess and then migrate an on-prem SQL Server 2012 SP2 database to an Azure SQL Database Part 1: Download and install Data Migration Assistant To install DMA, download the latest version of the tool from the Microsoft Download Center, and then