I was reading a post talking about some SQL encryption technologies and statements (because, you know, that’s what I do just sitting around…) and found a new potential vulnerability that I’d never really considered before. I don’t pretend that I know *all the things* about security and encryption – it’s a constant process to keep learning and figuring out what […]
Editorials
Security and Profiling Tools May Be A Security Risk
There are many tools you can use to work with SQL Server and provide guidance and information about things that need attention in your systems. From best practices analyzers to classification tools, to performance management tools – there are a whole host of utilities that can help in significant ways. However, as you’re deploying and using these tools, it’s critical […]
Cloud Challenges: Updating Environments
Something that is becoming a significant effort in working with SQL Server and other systems in the cloud (whether it be on AWS or Azure or other services) is the fact that updates are happening nearly constantly. There have been other columns about that here on SSWUG, but it’s important to take a few minutes and think through your implementations. […]
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 – […]
How People Use Data, Is Changing Fundamental Tools
There is a great post by Haroon Choudry on LinkedIn, talking about whether SSRS’s days are numbered. In particular, is the use of PowerBI overshadowing the need for SSRS – and where do the respective data tools live, and where are they headed? These are clearly very different tools, and clearly very different applications. Or are they? It’s interesting that […]
Vacation Planning – in just 7 Minutes
Going on a vacation/holiday, but only have 7 minutes to get some tips to plan? We’ve got you covered. Check it out:...
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 […]
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 […]
Brings New Meaning to “Show Your Work”
(Or: Fail Forward Fast) It’s said, and said frequently, that you learn more from your failures than from your successes. Given that a lot of us tend to have plenty of failures to learn from, we can certainly hope that that’s true. However, in order to learn from your failures, you have to know what you did that lead up […]
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 […]