A New Word: Opia

opia – n. the ambiguous intensity of eye contact The entry for this says “so much can be said in a glance, “ which I think is very true....

Connection String Confusion in SSMS

Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate...

Everything is Code

The executives at CrowdStrike testify before the US Congress, noting their software development process needs work.

Friday Flyway Tips: Searching a Migration

This was actually a cool tip I saw internally from one of the product managers, when trying to find specific text in a migration. I’ve been working with Flyway...

Statistics Histograms

Adding Row Numbers to a Query: #SQLNewBlogger

I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....

Adding Row Numbers to a Query: #SQLNewBlogger

I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....

Keep. It. Simple.

How simple should software development be? Steve notes it can be simple, but not too simple.

Starting to Estimate Disk Storage for Memory-Optimized Tables

T-SQL Tuesday #179: The Detective’s Toolkit

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...