Using Tempdb

Column Mean in R

Daily Coping 10 June 2020

I’ve 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...

Missing Data

During a watch repair, Steve misses some data.

Next week is EightKB–The SQL Server Internals Conference

Next week, on Wednesday, June 17, 2020, the EightKB conference takes place. As with other events, it’s online, and it is full of high level content. It looks to...

Adding the Social Headline Topic

The world is changing, and the activism is infectious. I’ve tried to be fairly apolitical and unoffensive for most of my career. I definitely have not always succeeded, but...

Daily Coping 9 June 2020

I’ve 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...

The Order of Operations

T-SQL Tuesday #127–Non SQL Tricks

Today is T-SQL Tuesday, with this month being hosted by Ken Fisher. This is an interesting topic, looking at tips, but ones outside of SQL Server. Since many of...

What's a Normal SQL Server?

Many of us have worked in environments that have a number of SQL Server instances. Different versions, editions, and mostly different hardware profiles. We deal with different applications and software that places different demands and requirements on our database systems. Some of us are even dealing with multiple datastores, trying to integrate SQL Server with […]