Tag Archives: Azure

It’s Azure T-SQL Tuesday #103

Posted on June 12, 2018 by

I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being in the Azure cloud, but I’m glad this one came along. The invitation is from Björn Peters, and he asks … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Cleaning up Azure Client IPs

Posted on May 29, 2018 by

I travel around, and as a result, I may find myself accessing my Azure databases from different locations. Since it’s a quick click and login to add my IP from SSMS, I’ll end up with multiple ones. I don’t want … Continue reading →

Posted in Blog | Tagged , | Leave a comment

Pause and Backtrack

Posted on May 23, 2018 by

One of the main functions for anyone that manages a database is ensuring that they can recover the system in the event of any issues. My view is that restores are the most important skill and task that need to … Continue reading →

Posted in Editorial | Tagged , , , | Leave a comment

Python Jupyter Notebooks in Azure

Posted on April 18, 2018 by

There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I can’t remember who, but I did click on the Azure Notebooks link and was intrigued. I’ve gotten Jupyter notebooks running … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

A New SQL Server Edition

Posted on March 17, 2018 by

I first heard about this edition of SQL Server over a year ago, and at the time I wasn’t sure there was much of a market for it. Microsoft disagreed, and they moved forward, putting this in preview and then … Continue reading →

Posted in Editorial | Tagged ,

Use the Proper User for Azure MySQL DB

Posted on February 20, 2018 by

I wrote about migrating the MySQL database from a third party provide to Azure MySQL DB recently. This was due to the provider raising the price substantially for me to host the site. However, after migrating the data, I ran … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Should We Move to Azure?

Posted on November 8, 2017 by

This editorial was originally published on May 23, 2014. It is being re-published as Steve is out of the office, with a few minor editorial changes. Update: We made a number of changes last year, upgraded the forums, and have continued … Continue reading →

Posted in Editorial | Tagged ,

A Tour of SQL Server Security Features

Posted on October 18, 2017 by

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading →

Posted in Presentations | Tagged , , , ,

The Cloud is Better In At Least One Way

Posted on October 16, 2017 by

Many people don’t see the cloud platform as necessarily better run than what they do in their local data center. That might be true, and certainly the caliber of people, their experience, responsiveness, and more can make a big difference … Continue reading →

Posted in Editorial | Tagged ,

Remove an Active Lease on a Blob in Azure

Posted on September 12, 2017 by

I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted. I found later that deleting a VM doesn’t necessarily remove the disk blob. Here was one way that I removed … Continue reading →

Posted in Blog | Tagged , ,