Daily Coping 3 Feb 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-02-03
6 reads
Blog Posts
How to get Change Data Capture to work in an Availability Group
If you’ve ever had to implement Change Data Capture (CDC) for a database in an Availability Group, then you know that the CDC jobs don’t really consider the Availability...
2022-02-03
102 reads
Azure Files–Standard and Premium
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-02
74 reads
Checkpoint Analysis: Your Exclusive How-To with XEvents
Checkpoints are essential in SQL Server to help with the durability and reliability of data persisted in the database. When done right, you barely even notice them and performance...
2022-02-02 (first published: 2022-01-14)
488 reads
Daily Coping 2 Feb 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-02-02
7 reads
Don’t optimize for ad hoc workloads as a best practice
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held...
2022-02-02
52 reads
SQL Homework – February 2022 – “Soft” skills.
Well, it’s a new year and a new start, even if I am a bit behind the start of the ... Continue reading
2022-02-02
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks related to the CIS Center for Internet Security requirements. I have yet to write a...
2022-02-02 (first published: 2022-01-21)
1,763 reads
Setup Kerberos Constrained Delegation for Group Managed Service Accounts
Kerberos delegation is not a new concept in Active Directory; however, setting it up for Group Managed Service Accounts (gMSA) can be a bit confusing. Unlike normal domain accounts,...
2022-02-01
432 reads
SQL Server Dynamic Management View(DMV)- sys.dm_exec_requests
Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.
2022-02-01
153 reads
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered Devices
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
Forums
Creating paginated report where each page is a month in the range selected
With in the paginated report I am trying to display on each new page...
Upgrading SSIS and SSRS from SQL Server 2016
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
Question of the Day
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