Blog Posts

T-SQL Tuesday #147 Invitation – Upgrade Strategies

• by Steve Jones

• The Voice of the DBA

It is time for T-SQL Tuesday #147 and this month I get to be the host. Since I’m in charge, I usually try to ensure I remember what this...

2022-02-01

13 reads

Creating Azure DB for MySQL – Single Server

• by Arun Sirpal

• All About SQL

Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...

2022-01-31

18 reads

Daily Coping 31 Jan 2022

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

2022-01-31

10 reads

DP-900 Preparation Guide

• by Steve Jones

• The Voice of the DBA

This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...

2022-01-31

29 reads

Trusting the Fine Print or connecting Azure Data Factory with Salesforce

• by Rayis Imayev

• Data Adventures

(2022-Jan-19) David Eldersveld once said that a “cool solution is a completely insecure solution” - David Eldersveld on Twitter. That puzzled me, but only for a little while, since I...

2022-01-31 (first published: 2022-01-20)

161 reads

Two Clustered Indexes?

• by Grant Fritchey

• The Scary DBA

Everyone knows that you only get a single clustered index, right? Wouldn’t it be great though if you could have two clustered indexes? Well, you can. Sort of. Let’s...

2022-01-31 (first published: 2022-01-18)

432 reads

Ohio North Database Training User Group Presentation 1 Feb 2022

• by kleegeek

• Technobabble by Klee from @kleegeek

I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST.  It is exciting for me to kickoff...

2022-01-29

11 reads

CosmosDB and Consistency

• by Steve Jones

• The Voice of the DBA

I was doing a little work with CosmosDB recently, and there were a few things that surprised me about the platform.  I’m also not 100% sure I completely understand...

2022-01-28 (first published: 2022-01-17)

193 reads

Daily Coping 28 Jan 2022

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

2022-01-28

7 reads

Get SQL Server Configuration using T-SQL

• by rajendragupta16

• DBBlogger

As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share

2022-01-28

262 reads