Azure

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 […]

Amazon AWS Azure Editorials

False Sense of Security from Vendor

There’s been an interesting trend lately in several different sales calls where you’re walking through the software capabilities, listing out the different goals you have for the project, etc.  The customer (be they internal or external) eventually gets around to infrastructure and how you’ve architected the solution. Now, if it’s on-premise, this leads to a lengthy discussion (why is it […]