SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
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 […]
With some interesting experiences under our collective belts when it comes to working with SQL Server on AWS, it seems like it might be interesting to share some of the things we’ve learned and seen in the field. AWS’ RDS with SQL Server is a great SaaS deployment of SQL Server that gives you the benefit of the fully-managed environment […]
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 […]
When you’re working with resources that are dedicated instances, powerful instances, you can get caught up a bit in the fact that it can take a lot more to trip up those resources than perhaps you’re used to. It’s sort of like flying as the only passenger in an airplane made for commercial flight; there is likely a lot more […]
Yesterday the post was about possibly using a move of servers to help ferret out things to review in your architecture (and not using it as a chance to necessarily block access that may have been lost control of). There was a good point made in the comments – John said “Those DTUs will kill your wallet if you don’t […]
The post yesterday about moving one of our SQL Servers to RDS and a dedicated instance and all of that (read more here) was a(nother) reminder that sometimes you have to take a step back and start with the easy stuff prior to assuming you need to do the complex modifications to your system to get the results you want. […]
We’ve recently moved a heavily used SQL Server instance from a VM-based installation to an RDS (Amazon, SaaS) solution. The server instance was not dedicated (don’t get me started) and, under load, would feel the pain of that type of installation. We would see loading that would approach 90% with frequent spikes to 100% depending on what was happening, jobs, […]
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 […]
As we’ve been working with different people, and, embarrassingly, our own systems, I’ve been noticing a trend. It’s been bugging me for a while now, but I’ve not really been able to put words to it. I mentioned in the prior editorial that multi-platform was important. Basically, use the right tool for the job at hand. And then I noticed […]
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 […]