Azure

Administration Amazon AWS Azure Azure SQL Database Community Editorials Encryption/Data Security

Interesting: Data Bread Lines

In reading through a post about a book that’s out about managing and living with data, there were some very interesting observations outlined.  Things that are pretty apparent as you work through systems at companies with many different sources of information and raw data.  The post was a book excerpt, from “Winning With Data” (Wiley). If you think about it, […]

Amazon AWS Amazon RDS Azure Azure SQL Database Editorials SQL Server

SQL Server instance growth, management

I was reading an interesting article in DBTA (April/May 2018, “The Headaches of Microsoft SQL Server Sprawl“) and it was clear that so many of us are facing some pretty significant challenges when it comes to managing SQL Server instances.  Particularly true if you consider “SQL Server instances” to include your Azure instances and/or managed instances on Azure and AWS. […]

Azure Editorials

How Do You Select Your Next Database Engine?

There are many choices for your next database project.  Of course it depends somewhat on the types of information you’re working with, and the types of functionality you require.  In addition, up-time requirements will likely come into play. But what if so many of the different access methods you have today were possible and you could pick the engine behind […]

Administration Amazon AWS Amazon RDS Azure Azure SQL Database Editorials

Planning that next platform upgrade or migration

Completing a migration, whether it’s for version-to-version migration or for platform updates or even moving to a cloud-based solution from an on-premises solution, is a major project.  Even a sideways version swap, accompanied by a platform change can mean all sorts of things in terms of settings, features, capabilities that may have to be modified, for sure have to be […]

Administration Azure Azure SQL Database Editorials Encryption/Data Security Ethics Security

Data Architecture Challenge – “Active Archives”

Perhaps one of the biggest challenges that we’re all working through right now is working with the volumes of data on hand, and maintaining it in a usable way. We’ve been working with a couple of different clients to create ways to either use some of Azure’s Elastic Database approach, or move different information bits to different systems that would […]

Administration Amazon AWS Azure Editorials Ethics Security

Critical Data Recovery is Multi-Faceted

Yesterday, the post was about cyber-attack recovery.  Talking about the need for a more comprehensive recovery mechanism and approach than just “restore to the most recent backup.”  As mentioned, this also applies to failover systems.  In many cases, people will put in failover systems (or cloud-based services that are highly unlikely to go down) and figure they’re covered. But the […]

Amazon AWS Azure Editorials

Handling Downtime and the Cloud

Yes, it happens.  Things happen, systems fail, someone trips over a cable (hopefully not so much these days in major data centers), etc.  What has struck me though is that your options for dealing with downtime when you’re hosting (and it doesn’t matter if it’s “stretch” services or hybrid or entirely cloud) in these types of services, are limited. If […]