Category Archives: Editorial

Build a Career Radar

I got started in database work during an internship. I was asked to program some Lotus 1-2-3 spreadsheets to help a department. I was pretty proud of the mess I made, since it helped someone with scheduling. Another person noticed … Continue reading

Posted in Editorial | Tagged | Leave a comment

An AI Loophole

I’ve been working through some of the GDPR legislation, trying to find ways to explain this more clearly to customers and ensure that our products make sense in light of this law taking effect. Redgate is focused in this area … Continue reading

Posted in Editorial | Leave a comment

Brush Up on Your ETL Skills

Many of us that work with data will find requests and demands to import or export data at some point. Plenty of us have regular processes that perform these actions, and we may regularly troubleshoot or enhance these activities. In … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Virtual Data

Yesterday I republished an editorial from 2014 for the holiday. The topic was production subsets of data, which has been something that many data professionals have struggled with for years. Many of us have built scripts to delete, change, obfuscate, or alter … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

Template Configuration

One of my goals this year is to really spend some time learning more about Extended Events (XE). I’m somewhat embarassed that almost a decade after their introduction in SQL Server 2008, I have a fairly rudimentary grasp of the … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Muddle Through

I used to work in the restaurant business. I got started after my first year at college, landing a job waiting tables in a new hotel. It was eye opening for me to see just how stressful and difficult that … Continue reading

Posted in Editorial | Tagged | 2 Comments

Valentines Day for Data Professionals

It’s Valentine’s Day today, and if you’ve forgotten, you still have time to do a little shopping or show your partner that you value them. While this isn’t a public holiday in any country that I know of, many people do want … Continue reading

Posted in Editorial | Tagged | Leave a comment

Cloud Safe

I saw a question recently from an individual that was trying to decide if it made sense to move their databases to the cloud. In this case, management wanted to move, but the technical staff had concerns about Disaster Recovery … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Production Scripts

One of the most useful parts of SQL Server is the SQL Agent scheduler. Over the years I’ve used this subsystem to automate work and ease the administrative burden of running a SQL Server instance. At times I’ve even used … Continue reading

Posted in Editorial | Tagged | Leave a comment

What to Read in 2018

Last week I was looking for Database Weekly links and ran across Gail Shaw’s list of books from 2017. It’s an interesting list of fiction, and I might pick up a few this year if I run out of ideas. This … Continue reading

Posted in Editorial | Tagged | Leave a comment