Blog Posts

2020 Advent of Code–Day 3

• by Steve Jones

• The Voice of the DBA

This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 3. Part 1 Day 3 was...

2021-03-03 (first published: 2021-02-24)

17 reads

Linux to Windows Authentication

• by andyfenna

• Gosql.co.uk

As you are all very well aware Linux to Windows for access to SQL Server can be a slippery slope to doom. So I have decided to create an...

2021-03-03 (first published: 2021-02-25)

56 reads

Automatic Sample Sizes for Statistics Updates

• by Matthew McGiffen

• Matthew McGiffen DBA

Looking at how SQL Server samples your data when doing auto-stats updates. Part of a series on understanding statistics, to help you achieve optimal performance of your queries on...

2021-03-02 (first published: 2021-02-24)

250 reads

Cannot expand VMDKs with NVMe storage controller on VMware without a reboot

• by kleegeek

• Technobabble by Klee from @kleegeek

After doing some digging today with a Client, we hit a roadblock on something that I need to share with using the NVMe virtual disk controller on the VMware...

2021-03-02 (first published: 2021-02-23)

90 reads

Daily Coping 2 Mar 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-03-02

7 reads

Disabling Non-Clustered Indexes For Fun and Profit

• by Andy Galbraith

• Nebraska SQL from @DBA_ANDY

One of the frequently quoted ETL best practices is to disable your non-clustered indexes during a data load.  Basically the conventional wisdom is that you disable the non-clustered indexes,...

2021-03-02

6 reads

Steps for a Successful Data Migration Session at Microsoft Ignite

• by kleegeek

• Technobabble by Klee from @kleegeek

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as much as I am. I was going through the content catalog for this year’s conference...

2021-03-02

4 reads

A New Git Default Branch

• by Steve Jones

• The Voice of the DBA

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint, he had htis neat trick: git config --global init.defaultBranch main Apparently, this is a new...

2021-03-01

7 reads

Daily Coping 1 Mar 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-03-01

3 reads

Power BI and a Star Schema

• by James-Serra

• James Serra's Blog

I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...

2021-03-01

14 reads