Monthly Archives: February 2018

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

Classifying Data with SSMS 17.5

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition. This is a quick look at this … Continue reading

Posted in Blog | 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

Use the Proper User for Azure MySQL DB

I wrote about migrating the MySQL database from a third party provide to Azure MySQL DB recently. This was due to the provider raising the price substantially for me to host the site. However, after migrating the data, I ran … Continue reading

Posted in Blog | Tagged , , | 1 Comment

dbatools and Orphaned Users

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading

Posted in Blog | 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

Enabling Guest in a Database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The guest account exists in all your databases. This is installed by default, and guest is used to map … Continue reading

Posted in Blog | 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