Azure SQL Database

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

Administration Azure SQL Database Editorials Encryption/Data Security SQL Server

Inventory control and your databases….

No, not the “what servers do you have and what do they have on them” variety necessarily.  In a previous life, inventory and point of sale systems were a focus, and one of the great things that we could nearly always point to surrounded that initial inventory of the store location – their stuff on the shelves.  So many times, […]

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 Amazon RDS Azure Azure SQL Database Editorials

Love/Hate Relationship with Unstructured Data

No doubt you’ve seen, and perhaps been working with unstructured solutions out there – DynamoDB, Azure Table Storage, and there are many other options as well.  It’s pretty cool that you can define key/value pairs and just start dumping information into the system, really without regard to structure and columns and many of the things that have traditionally made up […]

Amazon AWS Amazon RDS Azure SQL Database Editorials Open Source

Multi-Platform Development – a Pro or Con?

In working with different companies to try to define how they’ll best move forward with their data requirements, it’s increasingly obvious that multi-platform, where you have multiple database systems on tap to provide support for requirements, is an ideal solution.  By embracing the platform-agnostic approach, and looking at the requirements and using those to determine what options to consider, you […]