Administration

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