Lock Scenarios Using sys.dm_tran_locks
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
The Benefits and Detractions of Remote
Working from home during the pandemic is likely to change many things, and Steve discusses a few today.
Getting Started with Automatic Database Branch Switching
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control.
Group By in SQL Sever with CUBE, ROLLUP and GROUPING SETS Examples
In this article we look at different examples of how to use GROUP BY with your SQL Server queries and the different results you get with the various options.
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
Getting Started with Data Masker for SQL Server: I Want to Mask A Database
Grant Fritchey explains what's involved in masking a SQL Server database. It can seem a daunting task, but it all becomes a lot more logical if you start from a plan, based on agreed data classifications, and then use a tool like Data Masker to implement the masking, and track progress.
Right-Sizing Row Mode Query Memory Requirements
When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be used for other processes or some operations will spill to disk. Microsoft has added Memory Grant Feedback to help overcome this issue. In this article, Greg Larsen explains what you need to know about this new feature.
What's a Normal SQL Server?
Many of us have worked in environments that have a number of SQL Server instances. Different versions, editions, and mostly different hardware profiles. We deal with different applications and software that places different demands and requirements on our database systems. Some of us are even dealing with multiple datastores, trying to integrate SQL Server with […]
Challenges and trends for Database Monitoring in 2020
Nearly 1000 database professionals took part in this year's State of Database Monitoring survey. Providing insights into how they monitor their estates, the technologies they work with, what their biggest challenges are, and emerging trends for 2020. For the detailed analysis of the responses, download your free copy of the report.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Teuku Umar Denpasar. Tlp:(+62) 8218168236
Jl. Teuku Umar No.91, Dauh Puri Klod, Kec. Denpasar Bar., Kota Denpasar, Bali 80228
BCA KCP Bulevar Hijau Tlpn/wa:085373737551
Ruko Sentra Niaga 2, Jl. Harapan Indah Raya No.1A Blok SN-2, Pejuang, Kecamatan Medan...
BCA KCP Business Park,Telpon/Wa 0821-8200-239
Rukan, Jl. Meruya Ilir Raya No.88 Blok B-1 & B-2, Meruya Utara, Kec. Kembangan,...
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