Blog Posts

Stress Cases and Data Visualization

• by Meagan Longoria

• Data Savvy

Times are stressful right now. There is an ongoing pandemic affecting people’s health and livelihoods. Schedules are messed up, kids are home. People who aren’t used to working remotely...

2020-03-26

21 reads

The Business Case for SQL Server 2019

• by Will Assaf

• SQL Tact

Thanks for joining us for the The Business Case for SQL Server 2019 webinar via Spark/Ed today, an overview of new features in and around SQL Server 2019's release but...

2020-03-26

8 reads

Time To Learn Git

• by Grant Fritchey

• The Scary DBA

I love this quote from Kevin Hill (and not because he mentions me): 3 things I can no longer justify ignoring: #dbatools Git and #Docker for my dev SQL work@cl@sqldbawithbeard@Kendra_Little and @unclebiguns@GFritchey, I blame you...

2020-03-26

24 reads

Transforming JSON to CSV with the help of Flatten task in Azure Data Factory

• by Rayis Imayev

• Data Adventures

(2020-Mar-19) Recently, Microsoft introduced a new Flatten task to the existing set of powerful transformations available in the Azure Data Factory (ADF) Mapping Data Flows - https://docs.microsoft.com/en-us/azure/data-factory/data-flow-flatten.What this new task does...

2020-03-26 (first published: 2020-03-19)

382 reads

Transforming JSON to CSV with the help of Flatten task in Azure Data Factory - Part 2 (Wrangling data flows)

• by Rayis Imayev

• Data Adventures

(2020-Mar-26) There are two ways to create data flows in Azure Data Factory (ADF): regular data flows also known as "Mapping Data Flows" and Power Query based data flows also...

2020-03-26

17 reads

T-SQL Tuesday #124 – Query Store Summary

• by Tracy Boggiano

• Database Superhero’s Blog

Happy St. Patrick’s Day (are you wearing something green)!  For March I asked everyone to blog something related to Query Store, here is a summary of in alphabetical order...

2020-03-26 (first published: 2020-03-17)

230 reads

Daily Coping–25 Mar 2020

• by Steve Jones

• The Voice of the DBA

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-03-25

9 reads

DB Automation with Azure DevOps

• by Grant Fritchey

• The Scary DBA

I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...

2020-03-25

35 reads

DRS Cluster Load Balancing Improvement for SQL Server on VMware

• by kleegeek

• Technobabble by Klee from @kleegeek

Dynamic Resource Scheduling (DRS) should be enabled for all VMware host clusters, especially those who run SQL Server. It provides for resource consumption load balancing functionality into a host...

2020-03-25 (first published: 2020-03-16)

156 reads

It’s Not April Fools – Redgate Streamed is Coming

• by Steve Jones

• The Voice of the DBA

Next week is April 1, typically April Fools Day, where we have jokes, pranks, and false stories. I’ve done my share of them, but this isn’t one. With the...

2020-03-25

16 reads