Azure

Amazon AWS Azure Editorials SQL Server

Multi-Database Solutions

tl;dr There is no easy answer.  But it’s important. It can be really challenging to work efficiently in a world where not only is the hosting environment typically a hybrid of on-site, off-site, public and private cloud configurations, managed and self-managed services… but also where you have multiple databases gathering different bits of information and you’re in a position to […]

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