Privacy – not just a problem for the legal and risk management departments anymore. These days, issues of privacy, security, and data ethics are squarely in the DBA’s court. We just added Steve’s session, Data Ethics, Protection, and Privacy, to the PRO library. Want to learn more? Check that out HERE. As data is critical to organizations, the DBA’s job […]
Encryption/Data Security
Weird Shift Going on with Data Reputation
There’s an odd thing happening with data. I say “odd” but really it’s expected I suppose with the privacy concerns, privacy mandates and wild-wild-west of managing information that we’re all facing right now. With so many new regulations, so many new expectations, and so much fear about data mis-use, I suppose it’s probably to be expected. Essentially, when I talk […]
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, […]
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, […]
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 […]
Have We Crossed a Threshhold with SQL Server Security?
It seems like we’re (finally) moving into an implementation phase with SQL Server and data security. By that I mean, it seems like we are close to having the tools we need for various places in the lifetime of information and, for a good majority of them, those tools do indeed provide the cover to implement good security. Application firewalls and […]
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 […]
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 […]
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 […]
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 […]