We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and Azure) in play. The application is a fairly typical .net web-based application that does calls to Azure SQL DB and AWS RDS at various times and places. The issue we’ll see from time to time surrounds lag time between the...
Amazon AWS
Mixing Flavors of SQL Server
It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to rely on, and we’re seeing those choices pay off in terms of management, performance, and cost savings. The “flavors” I’m speaking of? AWS RDS SQL Server, Azure SQL DB specifically. Our event platform is based […]
Upgrades, Tuning and SQL Server
One of the areas that is coming up more and more frequently with the ability to move from version to version of SQL Server pretty fluidly with the cloud is that of tuning and tweaking your systems as you upgrade. Before any gets concerned, yes, these things apply if you’re working with on-premises systems, and these apply if you have […]
Complexities of "It Just Works"
There is a lot of talk about technical debt – that thing where systems have been allowed to run because, well, they work. Why poke a sleeping troll, or whatever that saying is. Don’t fix it if it ain’t broke. But this leads to technical decay that can be hard to quantify and hard to pull into any kind of […]
Selecting a Data Platform
The whole process of selecting the right platform and the right tools to support it is continuing to become more and more complex. It’s not just a matter of selecting a provider, but an approach to getting the job done. There are many different things to consider at different levels of this choice, and it will depend quite a lot […]
Cloud Services… and the bill for them. DBA Opportunity?
So much has been written about DBAs, the cloud and the impact cloud-based resources and services have on the role of the DBA. There’s no doubt the impact has been substantial. In many cases, however, it’s been a good thing. The mundane “noise” of managing databases has become a game of options. You have the option to have a fully-managed […]
Security or Convenience?
According to MorningBrew, the current Smartphone market is a bit of a complicated one. While nearly half of the world relies heavily on these devices, the market for them is unstable right now, as people either hang on to their older models or opt for more affordable ones. Upgrade, Upgrade, Upgrade!Samsung’s newest model, the Samsung 10+ 5G costs a pretty […]
Multi-Database Solutions
tl;dr There is no easy answer. But it’s important. It can be really challenging to work efficiently in a world where not only is the hosting environment typically a hybrid of on-site, off-site, public and private cloud configurations, managed and self-managed services… but also where you have multiple databases gathering different bits of information and you’re in a position to […]
SQL Injection – More tools…
It’s incredible to me when you sit and watch the injection attempts against your public web properties. I realize that most are bot-oriented attempts, that there aren’t people sitting at the other end of most of those connections (no one types that stuff in, give me a break)… but still, someone felt that was a better use of their time […]
Beware the Complacency of “It just works”
For awhile now, things have been getting very stable, very reliable and the workloads of managing data are even beginning to split. Some of the management is being done by outside folks, some by automated processes and, overall, things run extremely well. It’s led to a bit of a strange trend in systems we’ve been reviewing. “Strange” because it seems […]