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...
Administration
Analytics, Reporting and Fine Line of Privacy
It can be very challenging to pull together reporting, analytics, data privacy expectations and support for legislation for information in your systems. People – those users that you support – are learning to request more and more from reporting. They’re expecting systems to be smarter about the information stored in your databases. Azure does amazing things with analytics, looking at […]
Bridges Between Servers
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 […]
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 […]
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 […]
Data Drift, Data Maturation and Working With It
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 […]
Complexities of Deep Customer Knowledge
It’s the dream, really, to know more about your customers. To know how they use your services or goods and how you can better serve them. To have some sort of predictive knowledge about what they’ll want and to be able to be right there, right on time, just as they need, so they’ll never stray. This requires information – […]
With Privacy Laws Come New and Different Storage Requirements
It’s a pretty commonplace thing now to be meeting with a client and talking through their requirements, the tossing in the “what about data privacy and ownership – what are your requirements there,” question. It’s not a small thing, and it’s something that has been morphing over time. I think the morphing part comes from uncertainty and fear. Uncertainty because […]
The Great Hack, The Creepy Line, and Our Job
These are some really intriguing movies (Netflix, etc.) – they’re finally talking about data, data use, data ownership, privacy, customization (sort of) and all sorts of things that have significant implications on our career ethics and responsibilities. When you watch these, they can quickly lead to a rabbit hole of TED talks, blog posts and more. Probably result in some […]
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 […]