Encryption/Data Security

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

Interesting: Data Bread Lines

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

Administration Azure SQL Database Editorials Encryption/Data Security SQL Server

Inventory control and your databases….

No, not the “what servers do you have and what do they have on them” variety necessarily.  In a previous life, inventory and point of sale systems were a focus, and one of the great things that we could nearly always point to surrounded that initial inventory of the store location – their stuff on the shelves.  So many times, […]

Administration Azure Azure SQL Database Editorials Encryption/Data Security Ethics Security

Data Architecture Challenge – “Active Archives”

Perhaps one of the biggest challenges that we’re all working through right now is working with the volumes of data on hand, and maintaining it in a usable way. We’ve been working with a couple of different clients to create ways to either use some of Azure’s Elastic Database approach, or move different information bits to different systems that would […]

Administration Editorials Encryption/Data Security Ethics Security SQL Server

PowerBI, Using that Data, IoT and the Borg

Yesterday Ben posted about where, exactly, the responsibility for security lays.  Is it with the DBA?  The network team?  Is it with the person or team that could have prevented the latest breach?  It’s a great question.  Make sure you check out the post if you haven’t seen it yet.  (Here’s a link) As we continue this revolution into more […]

Editorials Encryption/Data Security Security SQL Server

Security Ignorance is Bliss – But Not in a Good Way

I’ve been poking around more and more about security, about best practices and about data protection.  I have spent a good deal of time watching the tried and true “Securing Your SQL Server” type sessions and trying to understand what is critical and what you can do about it. Security expert Duncan McAlynn (LinkedIn) sent me over a great video […]

Editorials Encryption/Data Security

Metro? What Is Behind It All?

SSWUGtv – SQL Server 2012 With Stephen Wynkoop In todays edition Steve interviews Gareth Swanepoel. Gareth talks about SQL Server 2012, extended events wizard and interface – how to performance tune, and more. Watch the Show Metro – What Is Behind It All? I’d like to wrap up my concerns about the Metro design principles with another epistle from David […]

Editorials Encryption/Data Security

Windows Metro ? The Lowest Common Denominator

Windows Metro – The Lowest Common Denominator The title is to get your attention. The fact is that Windows Metro will not necessarily be the Lowest Common Denominator anymore than other devices supporting tablet/smart phone style manipulations, primarily touch screens. Many good hardware devices are designed around the Android OS, which the Metro look and feel appears to emulate in […]

Editorials Encryption/Data Security

JavaScript – Not You’re Fathers Scripting Engine

Featured Article(s) System Health Session Dashboard – Error Summary Report In the first post of this series, I had talked about displaying the events reported by the system health session extended session on SQL Server 2008 versions and higher. The next set of reports will show the errors which by the error_reported extended event. Featured White Paper(s) Encryption & Key […]