Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
213 reads
I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
215 reads
Welcome to a 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...
2022-03-02
135 reads
I’m heading to SQL Bits this weekend, and will be in London most of next week for the conference. I’m excited. SQL Bits is my favorite conference, as I’ve...
2022-03-02
14 reads
In hindsight, I should have done this differently. In a previous post I discussed how I carved up 18TB of storage into various storage pools. Now that I have...
2022-03-02 (first published: 2022-02-18)
619 reads
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
8 reads
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
9 reads
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
377 reads
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
267 reads
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
168 reads
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
The post Building Effective Data Governance Framework: Top Areas to Focus On appeared first...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Comments posted to this topic are about the item Do You Want a Microsoft...
Comments posted to this topic are about the item The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers