Goal Progress for Feb 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. February became more of a work month for me, and...
2022-03-01
27 reads
Daily Coping 1 Mar 2022
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...
2022-03-01
30 reads
Heap Tables
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have...
2022-03-01
430 reads
SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
11 reads
SQL Homework – March 2022 – Formatting
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries ... Continue reading
2022-03-01
42 reads
Recipe 7: Finding Unused Tables
Welcome toa new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the xesmarttarget...
2022-03-01
357 reads
Setup Resource-Based Kerberos Constrained Delegation for Group Managed Service Accounts
In my previous post, I discussed how to setup Kerberos constrained delegation and a limitation of using that method. This post will discuss how we can used resource-based Kerberos...
2022-03-01
293 reads
Expert Series webinar – Understanding SQL Server on VMware Storage Options
I’m thrilled to be presenting a new session on SQL Server-on-VMware storage performance tuning as part one of four in the ActualTech Media Expert webinar series this Friday, March...
2022-02-28
66 reads
Dynamically Map JSON to SQL in Azure Data Factory
We’re reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We’re storing the data in a relational table (SQL Server, Azure SQL...
2022-02-28
1,680 reads
A New Command Palette in SQL Prompt
I’ve gotten used to using the Command Palette in VS Code/ADS/Sublime Text regularly to find some setting or change something. What felt strange at first has become a habit...
2022-02-28
135 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
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now
Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers