Using Extended Events Live Data With Azure
In my last post I showed some shortcomings of Extended Events, however, it is possible to use Live Data with Azure. Let’s explore exactly how that works. To get...
2021-04-26
30 reads
Blog Posts
Changing MaxDop For Resumable Index Create Operations
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,303 reads
Daily Coping 23 Apr 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-04-23
8 reads
T-SQL Tuesday #137–Wrap Up
I hosted the blog party this month, with the invite to write about notebooks. These are a neat technology, and I’ve written about them at SQLServerCentral. This post is...
2021-04-23
30 reads
When the DBA is Deadlocked
When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable. Then, work...
2021-04-23 (first published: 2020-01-14)
602 reads
Daily Coping 22 Apr 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-04-22
18 reads
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow the system. While Azure provides all sorts of wonderful assistance within Azure SQL Database, you’re...
2021-04-22 (first published: 2021-04-19)
211 reads
The Diverse Data Platform–Dativerse.io
The other day I got a note from Ben Weissman the other day that he was running a new event, http://dativerse.io/. Not much information, but I liked this list...
2021-04-22 (first published: 2021-04-19)
180 reads
Book Review: High Performance SQL Server (Second Edition)
One of the technical books that sit on my work desk (or dining table, whichever is the case because I work from home full time now) at arm’s length...
2021-04-21 (first published: 2021-04-15)
417 reads
Calgary Data User Group with Deborah Melkin and Andy Yun
Next week on Wednesday is the Calgary Data User Group’s second event for 2021, and the second event as a member of Microsoft’s new Azure Data Community. Since last...
2021-04-21
17 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Blok M Tlp/Wa:0817-866-887
WhatsApp:0817866887 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Alamat kontak resmi BCA KCP Benhil Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Alamat kontak resmi BCA KCU SCBD Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers