Scary Data Collection

More and more data is being captured and analyzed all the time. At the same time, there are varying expectations of privacy that aren’t always shared between the subjects of data and the collectors. Steve has a few thoughts on how this will play out for data professionals.

Lengthen a Primary Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post recently where someone needed…

Securing Code Early

Last year I started to get alerts from Microsoft Repos that someone had put a piece of security information in their code that pertained to one of my Azure services. At first I was worried, but then I realized this was the public version of AdventureWorks we maintain in Azure. We’ve published the login so […]

Getting the next value

Capturing the Application Time

Most of us work with the time in a variety of ways in our applications. Temporal tables use the time on the server,but Steve notes today that we might want to capture other types of time.

Renaming a login

Generating an SSH key on Windows

I needed an SSH key. First I needed to the WSL subsystem, and once I had that working, I could do the work I needed to do: get an…

Canine Corgi Completion Contest

Steve is putting on a new contest for you with some fun prizes. Put on your creative hat and submit an entry. Contest ends April 21, 2019.

Executing Child Packages

Building a Database Engine

Someone tried to build a database engine from scratch. While not something Steve wants to do, it’s an interesting exercise.