PCI Compliance - resistance is futile.

The PCI Compliance talk at PTI’s Back to School event was given by Kyle Neier.  He’s a very experienced database administrator and also a leader at IndyPASS.  He’s a cool guy.  Unfortunately his PCI expert didn’t make it.  That was perfectly ok because I wanted to focus on the SQL Server 2008 R2’s feature called SQL Audit.
The good ole days?  Seriously? Back before SQL Audit it was a pain in the rear to audit at the database level.  Kyle went into this and reminded us all the pains of what we had to architect in the past decades.  I remember them well,  SQL Audit is much better than those old hacks.
I don’t have to be PCI compliant in my current function but HIPAA is similar in terms of SQL Server and SQL Audit.  The things I took from this is that any column that contains PHI I could audit, if I used Enterprise or DataCenter edition of SQL.  It’s on the list for SQL Azure features but only has 17 votes.  If you think that Audit would be useful in your SQL Azure instances like I do.  Go to the SQL Azure Feature Voting website and vote now.

Comments

Post a Comment

Popular posts from this blog

JavaScript should be your favorite language

So you think you're really cool because you're hardcore and know everything there is about PHP or C# or C++ or VB or Perl or Ruby or Python or ColdFusion or Java or ActionScript or..  I should stop right?  The thing is, as developers we've been coding in all these other languages to fit the phone, desktop, server and platform we think is best.  But we were wrong.  There is no "best" or "favorite" platform.  We shouldn't have been writing Flash apps.  We shouldn't have been writing Silverlight or Windows or Mono or XNA or Java apps.  We should have been writing HTML5 apps this whole time.  Don't get me wrong.  I don't thing that the debate of standards based apps vs native apps is over.  I think it's going to go nuclear.  Soon their will be iOS , Windows , Ubuntu , Chrome , Android , Blackberry , Firefox OS , and more to come.  They (I assume) will all probably be a little different but there will be ways to write in just HTM...
Read more

Why I won't be registering as a blogger in the state of Florida.

This blog post is about Ron DeSantis. Why am I writing about Ron DeSantis? Did he create a new JavaScript framework? No. Did I move to Florida? Nope. Did Mr. DeSantis contact me about my blog? No.  Does anyone at the Republican party in Florida know that I exist? Absolutely not. I'm writing about Ron DeSantis because he and his party in Florida are working to pass a law requiring me to register my blog with them. I'm disseminating this information to you in possible violation of a law written 1000 miles away. At the discretion of some official in Florida they may decide that I owe them money and fine me for not registering with that official. I also must tell them how much money I make off my blog post. It's just pennies by the way. https://www.flsenate.gov/Session/Bill/2023/1316  This proposed law is as stupid as the book bans. Just like the banned books, nobody is being forced to read this blog. A person has to seek this blog out. You don't have to finish reading a bo...
Read more

Cool new stream about F# from LaylaCodesIt

Image
There was a cool new series about F# on Twitch today.  It was fun to see and I haven't used F# in a long time. I felt like it was my first time while watching the stream. https://www.twitch.tv/laylacodesit  Here is my code inspired by Layla and Alyssa. https://gist.github.com/trendoid/ad4c5f3b58fc09c6a0ee472a0fd869d6 or if you want the whole project... https://github.com/trendoid/FsharpConsoleApp It just reads from a text file and prints the contents out to the console. // For more information see https://aka.ms/fsharp-console-apps printfn "Console App: Started!" open System.IO let baseDirectory = __SOURCE_DIRECTORY__ let filePath = "Text.txt" let fullPath = Path.Combine(baseDirectory, filePath) let readFilesTask (path1) =   task {     let! content = File.ReadAllTextAsync(path1)     return content   } printfn "Content: %s" (readFilesTask(fullPath).Result)
Read more