This week in episode 019 I’m joined by Jared Shockley who is the Director of IT at a Radiology Practice in Washington State and a former Microsoft employee where he worked as one of the Operations Manager for MSIT/Finance. We had a great conversation where we talked about the wonderful world of data compliance. While compliance isn’t the most fun thing in the world to deal with, we IT folks do have to deal with data compliance on a regular basis. While there isn’t much that can be done with older systems, systems which are still under development can have compliance required auditing built directly into the application for just a couple hundred dollars of development time instead of spending tens or hundreds of thousands of dollars after the fact.
Today in Episode 018 I’m joined by Troy Hunt who is a Microsoft MVP for Developer Security out of Sydney, Australia. As both Troy and I share an interest in Data and Application security that is the focus of our conversation. As you can’t have a security conversation without talking about SQL Injection that did come up once or twice, including the fact that SQL Injection (or injection attacks in general) is the #1 Application Security Risk according to the OWASP Top 10 list for 2010 (the most recent year that the list is available for).
While security might not seem like an exciting topic, I had to cut the conversation short as we could have talked for hours.
Welcome to the first episode of 2013. This week in episode which is episode 017 I’m joined by Edwin Sarmiento who is a SQL Server MVP from Ottawa, Canada. In this weeks episode we give into PowerShell and why as a DBA you’ll want to learn PowerShell especially with the release of Windows Server 2012 and PowerShell 3.0.
This week in episode 016, which is the final episode of 2012, I’m joined by fellow SQL Server MVP Ben Miller (aka @DBAduck) who is an independent consultant in Salt Lake City, Utah. Ben and I have talked back in October just before the PASS Summit, which was of course a topic of conversation as was the new SQL Server 2012 server that Ben just deployed.
Enjoy the last episode of 2012, the next episode will be January 8, 2013.
From all my guests and myself have a great holiday season and a happy New Years and we’ll see you in 2013.
This week for episode 15 I’m joined by Argenis Fernandez who is a senior consultant for Microsoft Consulting Services (MCS). Argenis and I discussed some of the client projects that he’s seen over the years including some absolute SQL security disasters that we’ve both seen in our days of working within IT. It’s an interesting discussion of what not to do.
We also talk briefly about BIML which is a new language for building ETL which Argenis says that you can read about in Chapter 17 or SQL Server 2012 Integration Services Design Practices written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford (available as a paperback or on the Kindle).