Blog Posts

#PowershellBasics: Working with arrays

• by Kenneth Fisher

• SQLStudies

I mentioned arrays in a previous post so I figured I should talk about what they are and how to ... Continue reading

2019-12-06 (first published: 2019-11-25)

274 reads

Cleaning up the [NOT] NULL for Columns with SQL Prompt 10

• by Steve Jones

• The Voice of the DBA

SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...

2019-12-06 (first published: 2019-11-25)

290 reads

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

• by Gerard

• Gerard’s Tech

This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...

2019-12-06

127 reads

HP is the 2019 Laptop Winner

• by Steve Jones

• The Voice of the DBA

This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...

2019-12-06

18 reads

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

• by Devin-Knight

• Devin Knight

Welcome back to my series on Power Platform quick tips! In this episode you will learn how to document your flow logic with comments.

2019-12-06

4 reads

State of Database DevOps Survey

• by Grant Fritchey

• The Scary DBA

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....

2019-12-06

9 reads

Collecting Diagnostic data from multiple SQL Server instances with dbatools

• by Gianluca Sartori

• SpaghettiDBA

Keeping their SQL Server instances under control is a crucial part of the job of a DBA. SQL Server offers a wide variety of DMVs to query in order...

2019-12-05 (first published: 2019-11-24)

453 reads

Containers: Upgrading SQL Server from 2017 to 2019 RTM

• by Grant Fritchey

• The Scary DBA

Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...

2019-12-05 (first published: 2019-11-25)

223 reads

Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.

• by Kenneth Fisher

• SQLStudies

I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading

2019-12-05

9 reads

New Power BI Report Design Pre-Con in 2020

• by Meagan Longoria

• Data Savvy

I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating...

2019-12-05

47 reads