Daily Coping–3 Apr 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...

Have You Deployed an Availability Group?

Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.

RANKX Parameters

Code from Redgate Streamed

I presented a session today at Redgate Streamed and did a number of demos. The code consists of a few flies, which I’ve made available here: BasicUnitTesttsqlt.zip. This consists...

Daily Coping–2 Apr 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...

Even More Memory Optimized Table Limitations

Learn SSIS and ADF for Free

It’s not from SQLServerCentral, though I hope to do more training across the next few months. Andy Leonard is offering Free Training for People Who Have Lost Their Jobs....

Moving to a New SqlClient

DotNet developers, if you’re using the System.Data.SqlClient, stop. Move over to Microsoft.Data.SqlClient now. It’s easy to do, well, it’s relatively easy to say that. The actual work isn’t that...

Next Person Up

Steve wonders today about the need to compete in our jobs, especially with employers that view us as resources.

Cursors Without Performance Penalties

Imagine how coding might take place if cursors were as efficient as complex SELECT statements.