Linux to Windows Authentication
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)
4,812 reads
Blog Posts
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from recommended to completely avoided. Since the release of SQL Server 2016, several options that were...
2021-03-03
63 reads
Automatic Sample Sizes for Statistics Updates
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)
346 reads
Cannot expand VMDKs with NVMe storage controller on VMware without a reboot
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)
205 reads
Daily Coping 2 Mar 2021
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
32 reads
Daily Coping 1 Mar 2021
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
12 reads
Power BI and a Star Schema
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
12 reads
Power BI Monthly Digest – February 2021
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2021-03-01 (first published: 2021-02-23)
365 reads
Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2021-03-01
50 reads
Upgrading Durable Function Extension of my Azure Function App
(2021-Feb-22) With more applications and services being placed into a vendor cloud environment, it does require almost no effort to manage and maintain the infrastructure these applications and services are...
2021-03-01 (first published: 2021-02-23)
1,131 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers