Daily Coping 4 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-04
23 reads
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
75 reads
Daily Coping 3 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-03
36 reads
Disabling Non-Clustered Indexes For Fun and Profit
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-09 (first published: 2021-03-02)
1,161 reads
Steps for a Successful Data Migration Session at Microsoft Ignite
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-08 (first published: 2021-03-02)
174 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
41 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
65 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-08 (first published: 2021-03-01)
187 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
22 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-05 (first published: 2021-03-01)
1,047 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers