A couple of weeks ago the Midnight DBAs were kind enough to invite me to their web show “DBAs @ Midnight” to talk about my new book “Basics of digital privacy”. It’s a video which is a bit different from what you’ll normally see here.

As this is a late night talk show style webcast, this show may not be safe for work … or kids.

I had a great time on the show and I hope you have a great time watching it.

This post is a little bit different from prior recordings which I’ve posted. The big difference here that you’ll notice is that I’m not the person doing the interview, instead I’m being interviewing for SQL Server Radio which you can find at sqlserverradio.co.il. In this recording by Matan, which was done at the SQL Rally Amsterdam, we cover a bunch of topics.

Normally Matan does his podcast in Hebrew as he’s normally recording in Israel. This recording is thankfully in English as my Hebrew is a little rusty. The part with me which is in English starts a little more than 5 minutes into the recording.

You can find the original posting on Matan’s podcast site or you can listen to the recording below.

This week in episode 029 I’m joined by Jessica Moss who is a Senior Business Intelligence & Data Warehouse Architect from Virginia.  In this episode Jessica and I talk about what a data warehouse is, and some of the problems that came come up with working through a data warehouse project.  Specifically how the language of the business, who has their own language much like IT does, can greatly impact how the data warehouse project is worked through.  Additionally you need to get people to set aside their own ideas of how things need to be done so that, at least for a while, people who are working on the data warehouse project focus on the data warehouse and it’s needs not just the needs of the line of business application which they normally work on.

This week in episode 028 I’m joined by the Midnight DBAs Sean and Jen McCown.  Sean and Jen are located in Dallas Texas where they broadcast the Midnight DBA webcast from.  In this weeks episode we talk about a bunch of different topics including some of the issues with moving from a more traditional job role as a database administrator to being an Independent Consultant, among other topics that you’ll just have to listen in to explore.  We do kind of jump all over the place.

This week in episode 027 I’m joined by Boris Hristov from Bulgaria.  Boris is a SQL Server Database Administrator and Trainer for HP in their consulting services branch of the company.  In this episode Boris and I talk about why all DBAs need to have basic presentation skills.  And it isn’t even for those DBAs who want to get into presenting, but just the normal DBAs which most of us are need to bone up on our PowerPoint and get used to standing in front of our peers at the office from time to time.

Aside from that we also chat a little bit about some of the issues that people are seeing when it comes to adopting SQL Server 2012 (hint, it’s mostly a money problem).

As always, thanks for listening and I hope you enjoy the show.

This week in episode 026 I’m joined by Chris Testa-O’neill, John Martin and Andre Kamman.  Chris is a BI consultant with CoEo based in the UK, John is a Database Administrator based on the UK and Andre is a BI and SQL Server consultant based in the Neatherlands.  In this episode, which was recorded at SQL Saturday 194 in Exeter, England, we talk all about BI Architecture and some of the things that people should be looking at when starting a BI project.

I hope you enjoy the session.

This week in episode, number 025 I’m joined by Grant Fritchey.  Grant is a product evangelist for Red Gate software which means he’s probably got the coolest job around.  His job is to talk to people about Red Gate’s products.

During the show this week we talk about some of the ups and downs of working from home and some of the tricks that we’ve learned over the years of working from home to keep yourself sane and keep being productive while working somewhere which is both distracting and isolating all that the same time.

You can find out more about grant on his blog “Home of the Scary DBA“.

In this weeks episode, which is episode 24, I’m joined once again by Karen Lopez.  Karen is a project manager and architect with Info Advisors.  She is also a fellow NASA TweetUp alumni as well as being the owner of some of the most famous and well traveled Barbie dolls in the world.  During this episode we talk about data security, and data loss.  Data loss has been a major problem recently for a lot of companies and government agencies which has led to a lot of peoples information being exposed to what ever random person found/stole it.  Karen and I talk about some of these recent data loss events and how they happened and how they could have been avoided; and most importantly why they should be avoided.   Karen has written a lot about data breaches which you can read about here.

Here are some write-ups of some of the data breaches which we talked about during the podcast.

Got Health Data? Your Penalty Exposures For Data Breaches Just Increased

Federal Department Bans Use of Portable Devices (YAFF)

Utah Health Department – Yet Another Flashdrive FAIL (YAFF)

BC Health Ministry Data Breach Affects Millions

Karen’s Data Modeling Blog at Datversity.net

Salary data

This week in episode 023 I’m joined by Chris Webb.  Chris is a SSAS and PowerPivot Consultant and Trainer based out of the UK.  Chris and I talked over Office 2013, BI and where everything BI has come from, where it is in 2013 and where it’ll be going in the future.  We also talk over some of the potential pitfalls that BI adoption has which includes the fact that people don’t deploy the new versions of Microsoft Office right away.  Hopefully things like Office 365 and SharePoint Online will help people move into the BI Space faster.  Listen in for more…

This week in episode 022 I’m joined by Gail Shaw who is a fellow SQL Server MVP and a SQL Server Consultant from Johannesburg, South Africa.  Gail is a major question answerer on some of the forums where she answers lots of SQL Server programming questions.  During this weeks episode Gail and I talk through some of the biggest problems that she sees in questions that are asked.  This includes things like BEGIN TRANSACTION, COMMIT and ROLLBACK TRANSACTION, as well as a single stored procedure that does everything, and of the biggest issues that she sees online error handling, or more specifically the lack of error handling and the improper use of error handling.