Author: Stephen Wynkoop

Editorials Security SQL Server

TIL: Columnar Encryption Might Be Susceptible to Abuse

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

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

Editorials PowerBI SharePoint / BI SSRS

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

Administration Editorials

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