SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical…
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to share some thoughts about migrating your SQL Server environment to the cloud (specifically Azure). Compañero…
Microsoft presents: MySQL and PostgreSQL?
For the longest time, MySQL has been the recommended database platform for blogs and other websites. It’s free. It’s available on every version of Linux, which is the most common web server platform. If you…
What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees mentioned an interview question he’d had and wanted to hear my thoughts. How would you…
Remote Storage Sync and Restore updated
Recently, I presented my “Back up and Restore your Database with Azure Blob Storage” session to the Bellingham PASS Chapter. There are two components to the Azure Blob Storage Sync and Restore utility: Sync and…
Look, Ma, No Surprises
Last week I demonstrated at least 30% performance improvement by switching to memory optimised table-valued parameters on SQL Server 2016. This week I will demonstrate the same test using Azure SQL Database, on the Premium…
Memory-Optimized Table-Valued Parameters
November brings me back to my regular weekly posting schedule. I attended PASS Summit 2016 last week, and saw a lot of great sessions. Aside from the new stuff, what I also noticed is how…
Should I upgrade SQL Server 2012, or migrate to Azure?
[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL Server up to date. Of interest is that extended support…
Temporal Tables in Azure SQL Database
In the latest Microsoft Azure newsletter I received last week was this most excellent news: Azure SQL Database Temporal Tables generally available Temporal Tables let customers track the full history of data changes in Azure…
Azure Storage Throughput
Hot on the heels of DTUs from earlier this week, today we’re going to switch focus a little, while staying with Azure, and have a quick look at storage speeds on SQL Server running on Azure…
Database Throughput Units
Last time we briefly touched on the metric that Microsoft uses to keep your Azure SQL Database in check: the DTU, or database throughput unit. It uses a combination of CPU, I/O and log flushes/second, using…
Azure SQL Database Limits
Let’s talk briefly about resource limits with Azure SQL Database. Because we have to share resources with other users, and because Microsoft doesn’t want us affecting others dramatically, they have implemented some limits. If for…
Planning matters
It’s the 2016 PASS Summit at the end of this month, and I’ll be attending for my third year. Because I’m a glutton for punishment, I’ll also be writing bonus posts for the month of…
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 BACPAC file contains the full schema, as well as the data…
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 keep in mind is that SQL Server (on-premises, or “earthed”)…
- « Previous
- 1
- 2
- 3
- Next »