Author: Stephen Wynkoop

Editorials

Encryption – Thoughts from The Cloud

Ben has been writing about encryption a bit, and of course if you head to the site, you can check out the ongoing series we’ve been doing that goes through all of the different aspects of controlling and encrypting your data. (check it out here – it’s pretty comprehensive!) One area that seems to still be a challenge is that […]

Editorials

Data, Data… But wait, there is more!

Last week I wrote about the data flows that the military is facing – and the sheer volume of these and what they mean to the people responsible for managing that data. In addition, I mentioned that I think the issue of analyzing and working with that information is substantial. Since there are really two different "modes" of working with […]

Editorials

Updating Your Administration Checklists

As you build out systems and solutions that are taking advantage of the cloud and cross-platform capabilities, it’s important to remember to circle-back and update your checklists and overall procedures so you make sure things are managed correctly. Cloud-Based elements to keep track of include the many new aspects of managing your servers and instances once you move to the […]

Editorials

Is SQL Server Tuning Hands-Off?

As I was talking with a DBA, we were talking about the different pieces of SQL Server – from performance to disaster recovery management and beyond. I was surprised when they indicated that performance and tuning were not something they allocated a lot of time to. The payoff just wasn’t there. I figured they were simply brilliant and had tuned […]

Editorials

Denormalization – Just Say No…?

When I wrote about denormalizing your tables, it was with an eye to optimizing things for different data use cases. While do I do think there are cases where it can be helpful, one of the comments received was important as you consider how you want to address this. From Jim: "***[E]very*** time I have denormalized, I have later regretted […]

Editorials

A Special Announcement

We’ve just launched Class Pass, the option to have full access to all courses and virtual conferences (and more goodies are on the way) from SSWUG.ORG. It’s a great way to take your time with courses, while at the same time staying up to date on skills and having the references you need. Have you seen the class directory? And […]

Editorials

What Do You Need For BI?

If you read over the reviews of the BI conference last week, you see that there were high hopes from some for a mobile solution. I thought it was intriguing to read the comments though and see that not everyone agrees that that’s the next frontier for BI. What do you think should be next? Personally, I think mobile is […]