Blog Posts

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...

2020-04-21

19 reads

DAX and Power BI Stairway Live

by Steve Jones

The Voice of the DBA

As part of the Redgate Community Circle, I’m going to be running a live class on DAX and Power BI, every Thursday, from 12MDT for about 30-45 minutes. We’ll...

2020-04-21

160 reads

New Article: Understanding SQL Server Ownership Chaining

by Brian Kelley

Databases – Infrastructure – Security

Back in January I gave a presentation to a small group of folks on foundational SQL Server security items. The last thing I covered was the concept of ownership...

2020-04-21

48 reads

Remote Work Resources

by alevyinroc

FLX SQL

We’re at least five weeks into this thing here in New York and while there are some encouraging signs, it’s more likely than not that “non-essential” workers aren’t at...

2020-04-21

7 reads

SQL Server and CPU Hyper-Threading in Virtual Environments

by kleegeek

Technobabble by Klee from @kleegeek

I recommend leaving the hyper-threaded logical cores enabled in the host BIOS, but not depending on them for performance gains. Hyperthreaded CPU cores, or logical cores, should not be...

2020-04-21 (first published: 2020-04-10)

1,612 reads

Switching between different Azure Data Factory environments

by Koen Verbeeck

Koen Verbeeck

When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...

2020-04-21 (first published: 2020-04-08)

353 reads

T-SQL Tuesday Live 21 Apr 2020

by Steve Jones

The Voice of the DBA

I’ll be hosting T-SQL Tuesday live again today, at 1:00pm MDT/3:00pmEDT/8:00pmGMT If you’re interested in taking a break, chatting, touching base with others, bring your comments, questions, thoughts, and...

2020-04-21

18 reads