Blog Posts

Daily Coping 20 Jan 2021

• by Steve Jones

• The Voice of the DBA

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

2021-01-20

6 reads

It’s 2021, so why are you reading this?

• by Randolph West

• Born SQL with Randolph West

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking. There’s also a high likelihood that you live in the United States. The technology industry...

2021-01-20

21 reads

Security Updates for SQL Server Jan 2021–CVE-2021-1636

• by Steve Jones

• The Voice of the DBA

There was a security bulletin (CVE-2021-1636) for SQL Server, an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. SQL Server has released...

2021-01-20 (first published: 2021-01-13)

393 reads

These little things about Azure Data Factory

• by Rayis Imayev

• Data Adventures

(2021-Jan-12) Small data that is hard to be noticed but in a long run makes the greatest impact, little things that are not well apricated but eventually become those final...

2021-01-20 (first published: 2021-01-12)

358 reads

Azure SQL vCore vs DTU

• by Arun Sirpal

• All About SQL

If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision to make. That being should...

2021-01-19

60 reads

Create an S3 Lifecycle Policy with PowerShell

• by Sheldon Hull

• Sheldon Hull

First, I’m a big believer in doing infrastructure as code.
Using the AWS SDK with any library is great, but for things like S3 I’d highly recommend you use a...

2021-01-19

4 reads

Daily Coping 19 Jan 2021

• by Steve Jones

• The Voice of the DBA

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

2021-01-19

4 reads

Logical crossroads in Azure Data Factory (IF and Filter operations)

• by Rayis Imayev

• Data Adventures

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...

2021-01-19

29 reads

Power BI: Data Model Optimization

• by DataOnWheels

• DataOnWheels

Saving the Day from Delay Part 1 Optimizing your data model can be a daunting task. If you read the intro to this series, you know one of the...

2021-01-19 (first published: 2021-01-13)

407 reads

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)

• by Kevin3NF

• Dallas DBAs

Welcome to a new year, and a new look at what I’ve learned in my time as a beginner and junior DBA. So, I’ve been in this DBA gig...

2021-01-19

54 reads