Recipe 6: Auditing Successful Logins
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-02-28
42 reads
Blog Posts
SQL Server Execution Plan - Displays Estimated and Actual number of rows
This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More
2022-02-28 (first published: 2022-02-16)
560 reads
T-SQL Linting in an Azure Devops Build Pipeline
Linting is a process where a code analyzer is run to find programmatic errors, bugs, “stylistic constructs” or anti-patterns. For example, in Python there are specific modules that help...
2022-02-28
41 reads
Published Azure Arc-Enabled Data Services Revealed - Second Edition
I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed - Second Edition available now at Apress and your favorite online...
2022-02-26
28 reads
Daily Coping 25 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-25
18 reads
DirectQuery to Power BI Datasets
A new feature has been added to the Power BI Desktop toolset and it’s a very nice one. The official name is “DirectQuery for PBI datasets and AS”. It...
2022-02-25
56 reads
OLTP Star, Snowflake, and Galaxy Schemas
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-25 (first published: 2022-02-09)
681 reads
You can’t use GO in dynamic SQL.
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-25 (first published: 2022-02-10)
726 reads
Daily Coping 24 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-24
20 reads
I’m writing a SQL Server security presentation and I need your help.
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going ... Continue reading
2022-02-24
4 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Menara Palma Telpon/WA:08137887595
BCA KCP Menara Palma Telpon/WA:08137887595.Ariobimo Sentral, Gedung Menara Palma, Jl. Hr. Rasuna Said Ground...
BCA KCU MUARA KARANG Tlpn/Wa 0853.7373.7551
Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
BCA Finance WTC Mangga Dua Tlpn/Wa 0853.7373.7551
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers