Removing a PowerShell Array Element–#SQLNewBlogger

I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...

Be Careful with Missing Index Requests

Steve reminds people today that the recommendations from execution plans aren't always what you want to use when tuning your database.

Zero Statistics Sampling

The Fake Speakers

Someone generated a fake speaker profile for their conference, which Steve finds disturbing.

A New Word: Nighthawk

nighthawk – n. a recurring thought that only seems to strike you late at night – an overdue task, a nagging guilt, a looming future – which you sometimes...

Changing the Data Type of a Primary Key–#SQLNewBlogger

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....

Creating Aggregates

The Balanced Technical Manager

If you are considering moving into management as a career goal, read today's editorial from Steve, with some advice based on an interesting article from someone with experience at Facebook and Stripe.

Using ThinOptics to Read Data

As I’ve aged, I find myself struggling to read many things in my life. It started with difficulties seeing menus, but moved on to other areas. During the pandemic,...

A Lack of Privacy in Smart Cars

With new vehicles becoming more and more computerized and controlled, is data privacy an issue?