Importing a BACPAC into Azure SQL Database
In our final look at migrating a database to Azure SQL Database, we will import a BACPAC file. From previous weeks we know that a… Read More »Importing a BACPAC into Azure SQL Database
Moving a database to Azure SQL Database
This week we will actually move a database into Azure SQL Database, using the first of two of Microsoft’s recommended methods. The main thing to… Read More »Moving a database to Azure SQL Database
Should I move my on-premises database to Azure SQL Database?
This week is a shorter post than last week, but it answers a very important question: Should I move my on-premises database to Azure SQL… Read More »Should I move my on-premises database to Azure SQL Database?
An Introduction to Azure SQL Database
It’s the second half of 2016, and Azure is the new hotness. I’ve raved about Blob Storage, virtual machines, AzCopy, and all those good things.… Read More »An Introduction to Azure SQL Database
Backup Retention Policies
Today’s post is just a bunch of questions, but they are very important questions, all around the main topic of a Backup Retention Policy. How long do… Read More »Backup Retention Policies
What is physical storage anyway?
My friend Jason asked me about his MySQL database export file last week, whether it was sufficient to create a new database. I replied saying… Read More »What is physical storage anyway?
PSA: Check Your Backups
This post comes to you from the Spanish countryside. I travel a lot these days, sometimes even for work. The best part about travelling, apart… Read More »PSA: Check Your Backups
AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage
SQL Server 2016, released last month, now lets us back up our database files to two locations simultaneously. This is very good news if we’re running… Read More »AzCopy 101 – Copying SQL Server backup files to Azure Blob Storage
Do you need access to Production?
During a recent client meeting about a database migration, I realised that I have never logged into a SQL Server on their production environment. My… Read More »Do you need access to Production?
The Transaction Log Is Very Resilient
Last week I wondered whether a log backup chain would survive a database migration. Unsurprisingly, the answer is “yes”. I also asked if a log… Read More »The Transaction Log Is Very Resilient
The Resilience of the Log Backup Chain
Much has been written about the log backup chain in SQL Server, where we are able to restore a database to a point in time using… Read More »The Resilience of the Log Backup Chain
Career Limiting Moves – Reply All
In a recent episode of a Netflix show called Grace & Frankie, a vitriolic and profanity-ridden email with very damaging statements was accidentally sent to… Read More »Career Limiting Moves – Reply All
Career Limiting Moves – Assigning Blame
I worked for a vendor implementation partner in the early part of my career, and oftentimes that meant having to set up a training lab,… Read More »Career Limiting Moves – Assigning Blame
Career Limiting Moves – Dropping a Table
In this new series, I will share some things that took place early in my career that could have resulted in my looking for new… Read More »Career Limiting Moves – Dropping a Table
Saving Time By Splitting Files for a Backup
During a recent engagement with a client transferring large files from on premises to Azure Storage, we discovered that files over a certain size are automatically… Read More »Saving Time By Splitting Files for a Backup