Azure SQL Database Archives

Azure SQL Database

Debugging Multi-Cloud Performance

by SiteAdmin

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...

This content is for Pro Member, Pro, Standard Member, Standard, Free, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Amazon AWS Amazon RDS Azure Azure SQL Database Editorials

Mixing Flavors of SQL Server

by Stephen Wynkoop

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

Continue Reading →

Administration Azure SQL Database Editorials SQL Server

Bridges Between Servers

by Stephen Wynkoop

Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble it in a common location. This may be the case where you’re pulling information from a SQL Server, a MySQL server, Oracle and other systems, so you can create reporting and analytics runs at the information. These bridges […]

Continue Reading →

Administration Amazon AWS Amazon RDS Azure SQL Database Editorials SQL Server

Upgrades, Tuning and SQL Server

by Stephen Wynkoop

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

Continue Reading →

Amazon AWS Amazon RDS Azure Azure SQL Database Editorials

Complexities of "It Just Works"

by Stephen Wynkoop

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

Continue Reading →

Administration Azure Azure SQL Database Editorials

Data Drift, Data Maturation and Working With It

by Stephen Wynkoop

Azure ML datasets have a new tool just out, that of looking at datasets and monitoring for data drift. Not the latest fad in racing, but rather the changing of data over time. This is quite important to be aware of on a few different levels as you work with these datasets that track behavior (more later this week) and […]

Continue Reading →

Amazon AWS Amazon RDS Azure Azure SQL Database Editorials

Cloud Services… and the bill for them. DBA Opportunity?

by Stephen Wynkoop

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

Continue Reading →

Administration Amazon RDS Azure SQL Database Editorials Ethics SQL Server

Data is Like Evidence

by Stephen Wynkoop

When you hear about breaches, so many times it’s because someone didn’t do their job protecting their SQL Server, protecting the data, or protecting the pipes that feed and move the data around. It’s a big deal – and with your (likely) cloud environment, the model and approach to all of this is changing. Chain of custody… “that records the […]

Continue Reading →

Administration Amazon RDS Azure Azure SQL Database Editorials

Old Guidelines Still Apply

by Stephen Wynkoop

Back in the day… standard advice was to get that SQL Server off the Internet, public-facing access, if at all possible. Sometimes this worked, sometimes it didn’t because of application access and other issues with moving it to a private segment. But the key is to remove those sensitive layers of access to SQL Server – control the surface area […]

Continue Reading →

Administration Amazon AWS Azure Azure SQL Database Community Editorials Encryption/Data Security

Interesting: Data Bread Lines

by Stephen Wynkoop

In reading through a post about a book that’s out about managing and living with data, there were some very interesting observations outlined. Things that are pretty apparent as you work through systems at companies with many different sources of information and raw data. The post was a book excerpt, from “Winning With Data” (Wiley). If you think about it, […]

Continue Reading →