Tag Archives: auditing

Internal Controls

I was browsing the Internet and stumbled on a small part of a larger story that struck me. Many of you may have heard of the story of Jamal Khashoggi, the journalist for the Washington Post that was killed. I … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Republish: Can Auditing Fail?

I’m in Chicago at the SQL in the City Summit. Therefore, republishing Can Auditing Fail? as I won’t be online.

Posted in Editorial | Tagged | Leave a comment

The Uninteresting But Necessary Work

There has been a rising tide of data legislation in the last few years that asks for organizations, especially private companies, to better protect their data. The GDPR is one of the most well known, taking effect with regards to … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Finding the Right Data

For a couple years, Big Data was heavily hyped, and Hadoop became incredibly popular. In fact, so popular that Microsoft build HDInsight and Polybase to allow us to take advantage of these technologies and integrate them into our own systems. … Continue reading

Posted in Editorial | Tagged , ,

The Problems with Gods

When I was learning how to work with computers early in life, I ran across various documentation and writings that would liken the root account to being a god on the system. Over the years, I’ve seen other articles that … Continue reading

Posted in Editorial | Tagged ,

The Future of Auditing

This editorial was originally published on Dec 5, 2013. Is it being re-run as Steve is on holiday. I was reading Captain’s Share the other day and enjoying a quiet afternoon at home. It’s a science fiction book about one man’s … Continue reading

Posted in Editorial | Tagged | 1 Comment

Who’s Touching My Database

Abstract: As databases become more critical to the operation of our organizations, we are being asked to audit and report on access to both data and the configuration of our systems. SQL Server has a number of features that can … Continue reading

Posted in Presentations | Tagged , ,

Finding out Who’s Touching Your Database at DevConnections

I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready … Continue reading

Posted in Blog | Tagged , , ,

T-SQL Tuesday #81–Sharpening Skills

This is an interesting month for T-SQL Tuesday. The challenge is from Jason Brimhall to Sharpen Something, and learn something new. However, his challenge isn’t just a simple “learn something.” Instead, he writes: “This month I am asking you to … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

Architecture for Auditing

In the analog world, when we need to provide an auditing system for checking on physical activity, we usually separate out the roles of people that might record or track activity from those that perform activities. The better separation we … Continue reading

Posted in Editorial | Tagged , ,