09 September 2020
09 September 2020

How to make classifying SQL Server data easier

Classifying the data within an organization is not just something nice to do. It’s critical for complying with regulations such as The General Data Protection Regulation (GDPR), California Consumer Privacy Act (CCPA), The Health Insurance Portability and Accountability Act (HIPAA), The Australian Privacy Act, and a host of other privacy laws enacted throughout the world. … Read more
06 August 2020
06 August 2020

Eliminating the Fear of Missing Out (FOMO)

Many are finding the quarantine a net gain for mental health. Here’s why… The FOMO has been eliminated. There is no longer a “fear of missing out”. For the first time in memory, that type of FEAR is gone. There are no events, no places to be, nowhere to go…everyone is in the same boat. Our worlds are … Read more
25 July 2020
25 July 2020

Keeping up with SQL Server

I gave a session for the recent PASS Marathon entitled “Modern T-SQL for Better Performance.” During the session, I talked mostly about windowing functions. These functions introduced in 2005 and 2012 not only make writing T-SQL code easier, but often it’s better performing as well. In many cases, they can help you avoid self-joins and … Read more
14 July 2020
14 July 2020

Reading Books

Books are usually meant to be read in an analogue fashion. Start at page one and keep on going until the book is done. Some people take an early peek at the end of mysteries to see how they turn out, but isn’t that cheating? In today’s digital world, it isn’t easy – at least … Read more
26 June 2020
26 June 2020

Will We Still be Talking About DevOps in Two Years?

While individual buzzwords will come in and out of fashion, the ideas at the heart of DevOps aren’t going anywhere.  Like any good buzzword, DevOps may mean different things to different people. There are several good definitions of DevOps out there. My favorite definition comes from @IanColdwater, who defined DevOps in terms a teenager would understand: Devops … Read more
09 June 2020
09 June 2020

PASS Summit Goes Virtual

The PASS organization announced last week that the 2020 Summit, originally planned for Houston this November, will now be held virtually. This is bittersweet for me, since going to the Summit has been the highlight of almost every year since 2003. I had decided, however, that I would not attend in person this year unless … Read more
02 June 2020
02 June 2020

Too Much Stuff

We’ve lived in our current home for 30 years and have managed to accumulate a lot of possessions. We have closets, drawers, cabinets and a storage shed filled with things, many of which we don’t remember buying or receiving in the first place. I haven’t quite gotten into the Marie Kondo way of organizing yet, … Read more
20 May 2020
20 May 2020

Key Insights from the 2020 State of SQL Server Monitoring Report

This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded. Here are some of the key insights from the survey: Estates are growing more than ever Companies who reported over 1,000 SQL Server instances grew 9% … Read more
10 May 2020
10 May 2020

Learning New Skills

A lot of folks have taken advantage of more time at home recently to pick up new skills and hobbies. In my case, I have started learning more about 3D printing. I bought an entry level 3D printer about a year ago to have something fun to do with my grandson during the summer. The … Read more
08 April 2020
08 April 2020

Technology Makes a Difference

I’ve been working from home for several years, so I’m used to it. Many people who have never thought of doing this have found themselves working from home the past few weeks. Companies who have never given their employees a chance to work remotely are finding that it’s possible. Setting up remote workers is not … Read more
11 March 2020
11 March 2020

Virtual Reality

As a Star Trek: The Next Generation fan, I am intrigued with the idea of a Holodeck. The Holodeck on this and subsequent series is a place that the characters mostly go to for recreation or to relax. They can hang out with historical figures, view an earthly sunset, or be a part of their … Read more
10 February 2020
10 February 2020

Why Empathy is Not Enough in Tech

In 2020, my main personal goal is to reduce doing harm, and this has been mainly inspired by the work of Kim Crayton and the #causeascene Guiding Principles. Kim is a business strategist, tech leader coach, professional educator, and founder of the #causeascene movement. Tech is not neutral. Actually, it has never been neutral, nor … Read more
04 February 2020
04 February 2020

Key Findings from the 2020 Database DevOps Survey

Each year Redgate Software runs a survey to learn more about how organizations practice DevOps, especially when it relates to the database. This year, over 2000 individuals responded, and they are from diverse industries and company sizes. The key findings in the report are: Frequent database deployments are increasing: 49% of respondents now report they … Read more
08 January 2020
08 January 2020

Capturing a Mind

When the Netflix series Black Mirror began in 2011, I watched a few episodes. Recently, I “binge-watched” more to catch up. If you’re not familiar with the series, each episode is about technology, and how people must deal with it when it goes awry. For the most part, the technology featured in the series doesn’t … Read more
01 January 2020
01 January 2020

Why the Database Must be Part of DevOps

According to Microsoft, DevOps is “the union of people, process, and products to enable continuous delivery of value to our end users.” The definition doesn’t mention any frameworks or specific tools, and it’s more about communication and culture than any technology. That said, automation and tooling are critical components of DevOps as it helps organizations … Read more