Editorials

Amazon AWS Amazon RDS Editorials

Did you know there is additional reporting available? (SQL Server RDS)

DBAs are all about transparency – transparency hopefully about what’s going on with the SQL server.  Things like connections and utilization and all of that.  You have many standard tools that monitor and analyze your SQL Server, but you also have access to other tools native to the AWS platform.    It’s surprising the granularity you can drop down into […]

Editorials

Design is Critical for Your Systems

The (now) age-old question of “are DBAs going away” is something that’s been beaten up here and other places.  One of the first things that usually puts this to rest is the discussion of design.  It’s a little strange to watch the pendulum swing back and forth – disk became really inexpensive and people stopped worrying about storage; servers became […]

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