What I'm Up To

Upcoming Events
New Recordings
  • SQL in the City Streamed – Free Redgate training livestreamWatch
  • How DevOps Keeps DBAs Safe from Being Automated Out of a JobWatch
  • Redgate Evangelist YouTube Channel: Tutorials on Database DevOps –New videos each week – Watch
  • DevOps: What, who, why and how? – 1 hour – Watch
  • Get Inspired: Celebrate the Careers of Three DevOps Heroes – 1 hour – Watch
  • What ‘Digital Transformation’ means, and how you can use it to advance your career– 1 hour – Watch
  • Can This Team Succeed at DevOps? Panel discussion – 1 hour – Watch
  • SQL In the City Streamed – Watch the whole stream
    • Crucial data privacy and protection insights for 2010 – with Richard Macaskill – 45 minutes – Watch
    • The four keys to unlocking DevOps – 30 minutes – Watch
  • The Best of 2018 and Predictions for 2019 (Panel with Steve, Grant, and Kathi) – 1 hour – Watch
  • What We’ve Learned about Adopting Database DevOps, and What to Avoid (MVP Panel with Guest Panelist Tony Maddonna) – 1 hour – Watch

Adding Microsoft MVP Contributions with PowerShell – Lessons Learned using the MVP API

No Comments
One of the things that brings Microsoft MVPs together each year is complaining about the pains of reporting community contributions to Microsoft. This is a typical first world problem, but with a history of reporting tools ranging from temperamental Infopath forms to websites where you painstakingly click here and there for hours, there have been reasons for the complaints. This year I decided to try out using PowerShell to add my contributions. This has been available for about a year thanks to François-Xavier Cat and a few friends, but I’d completely forgotten that it was possible until William Durkin reminded me about it on Twitter. First time ever, I didn’t wait until the last minute to start thinking about my annual contributions. Instead, I took a little time to learn about how this works — and now I’ll keep my contributions in a spreadsheet and then upload them right before…
Read More

Where do data breaches come from?

No Comments
I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and a bit of what I learned. Verizon publishes the ‘Data Breach Investigations Report’ annually  The 2018 edition of this free report by Verizon Enterprise Solutions is the 11th edition — they’ve had some practice. The reports are extremely well detailed, and shockingly, they’re even entertaining to read. The reports don’t claim to discover all data breaches. After all, not all data breaches are discovered, and those that are discovered aren’t necessarily reported. 2,216 breaches, analyzed The 2018 report covers 53,000 incidents, defined as “a security event that compromises the integrity, confidentiality or availability of an information asset”.  It also covers 2,216 breaches, which are defined as “an incident that results in the confirmed disclosure — not just potential exposure — of data to…
Read More

Why You Should Take the ‘State of Database DevOps Survey’ Today (even if you don’t do DevOps)

1 Comment
The survey contains 32 questions and should take less than 10 minutes to complete. Update: The survey is now closed, thanks folks! When I began working with databases, nobody talked about DevOps. It was a few years before I heard the words ‘Agile’ and ‘Extreme Programming’, (which I still read as “EXTREEEEEEMMMMME programmin!”). A lot has changed since then. But a lot hasn’t changed as well.  Please help us track the history of how we work with databases by taking the Redgate State of Database DevOps survey today. I believe it’s helpful to our whole community to participate in this survey, and this post explains a few reasons why.  The survey… Is hosted by SurveyMonkey, no login is requiredTakes around 10 minutesAllows you to remain anonymous OR provide contact info to get a chance at winning a $250 Amazon gift cardIs for everyone who works with databases, regardless of whether you use…
Read More

Create dynamic agenda slides with PowerPoint Zoom

1 Comment
There was a time when I saw PowerPoint as a necessary evil – a way of conveying ideas that I wasn’t crazy about, but which worked. These days, my perspective has changed quite a bit. I’ve become a PowerPoint fan for a couple of reasons. First, I’m more proficient with PowerPoint, so I can put together presentations quickly and my slides carry greater impact.  Also, the PowerPoint team has added features that I believe help me deliver presentations more effectively. This describes one of those features: the new ‘Zoom’ functionality. ‘Zoom’ is about dynamic presentations (rather than ‘zooming in’) I think it’s incredibly important to give your audience context for where you are in a presentation — especially in a talk longer than 5 minutes. I like to give folks an outline of the narrative at the beginning of the talk in the agenda. While I’m going through the material,…
Read More

Join me for an upcoming webinar, “Data Masking: Insights & Actions”

No Comments
Click the image to register for the webcast There has never been a better time to start a project to champion data privacy In a recent Harris poll sponsored by the payment company Stripe, over 1,000 C-level executives were asked to rate which factors they feel are most threatening to their business. The #1 item that executives rated as “somewhat” or “very” threatening to the success of their business is security / data breaches. The #2 rated threat to these businesses? Increased regulation.  Data masking mitigates these top threats One of my very first jobs when I began in IT was to build out environments for developer and test teams at a software development company. At first, we didn’t mask any of this data. After problems arose, we began masking only a single field. That was a huge mistake. In this upcoming free webcast, I’ll share the following in just 30…
Read More