EightKB August 2022

EightkB is back! Today we announced the schedule for the next EightKB, which is happening at 1pm UTC on the 3rd of August. We have five more amazing, mind-melting...

Including reference data into a database deployment process or passing lookup tables to Production

(2022-Jun-20) As it takes a village to raise a child, it also takes a team to develop a good SQL Server database project. Previous efforts to maintain manual or custom SQL...

Snowflake Editions

You have decided that snowflake is the technology you want to use to build your next gen data platform, you have decided your cloud provider (Azure, AWS, GCP) then...

Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21

You’re invited! I’m thrilled to be co-presenting a session on the top five SQL Server virtual machine performance tuning tips with our friends at Sanity Solutions on July 21st...

T-SQL Tuesday #152 – It Depends – Manager’s Access

Deb Melkin (b | t) is hosting T-SQL Tuesday this month and is letting us rant. Who doesn’t like to rant about databases and the famous “it depends”. She...

Daily Coping 12 Jul 2022

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

SQL Server Partitioning for Performance

Often enough I get questions regarding partitioning to try to help alleviate performance issues with very large tables. A common misconception is that due to the table being large,...

Thank You Allen!

I know I can say that I’m a friend of Allen White without getting into trouble. Allen and I have a shared a lot of things over the years...

T-SQL Tuesday #152–It Depends

A great invitation this month from Deborah Melkin. I thought this was very apt, as I use this phrase often. Many of us do. This was a tougher post...

T-SQL Tuesday 152: An ORM Will Not Save You From Yourself

T-SQL Tuesday is a monthly blog party hosted by a different community member each month, and this month Deborah Melkin (blog | twitter) asks us for a database-related rant.

I...