Amazon RDS

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

Did you know there is additional reporting available? (SQL Server RDS)
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 […]

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