Using AzCopy with Batch Files and Task Scheduler

As regular readers of this blog will know, I’m a big fan of AzCopy, especially now that it has a sync option to keep local data synchronized with blob storage. In a recent release of the tool, Microsoft introduced a new switch to ensure that old files are only flushed from the destination when using
-> Continue reading Using AzCopy with Batch Files and Task Scheduler

What is a container anyway?

Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. | ̄ ̄ ̄ ̄ ̄ ̄ ̄|| CONTAINERS || ARE NOT | | VIRTUAL || MACHINES || _________| (__/) || (•ㅅ•) || /   づ — Ian Coldwater ⎈ (@IanColdwater) June 9, 2019 I felt like this
-> Continue reading What is a container anyway?

A short Azure SQL Database Edge explainer

On Thursday May 2nd, 2019, Microsoft announced a new edition of SQL Server targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere. From the Venturebeat article: It supports ARM and x64-based edge gateways and machines, and offers low-latency analytics that combine data streaming and time-series data, with in-database
-> Continue reading A short Azure SQL Database Edge explainer

It’s a UNIX system. I know this.

Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of which came from Jeff “Dreamboat” Goldblum. One other line that seems to be making a comeback is the title of this post, uttered by the character
-> Continue reading It’s a UNIX system. I know this.

mirror

AzCopy finally gets a sync option, and all the world rejoices

I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going with offsite backups. One of the ways I’ve leveraged Blob Storage is with SQL Server backups. I even wrote a Sync and Restore command-line toolset to keep files and folders in sync between an on-premises
-> Continue reading AzCopy finally gets a sync option, and all the world rejoices

construction

The cloud is not just someone else’s computer

A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not, the cloud is more than just a bunch of 1s and 0s hosted on someone’s hardware. The problem with my statement was the word “just”. I’ve presented several times on
-> Continue reading The cloud is not just someone else’s computer

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 book that I can point to and say “Yes, that’s the name I invented for myself when we moved to
-> Continue reading SQL Server 2017 Administration Inside Out

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 Conference I will be presenting at the Compañero Conference, which takes place over two days, October 4 – 5 (that’s
-> Continue reading Compañero Conference and SQL Modernization Roadshow

Volcano

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 Restore. I wrote the Sync tool to work around difficulties I’d experienced with Azure Blob Storage’s Infinite Lease, and limitations
-> Continue reading Remote Storage Sync and Restore updated