Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-12-02 (first published: 2020-11-20)
383 reads
Blog Posts
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
21 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
216 reads
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB...
2020-12-02
25 reads
Azure Stack and Azure Arc for data services
For those companies that can’t yet move to the cloud, have certain workloads that can’t move to the cloud, or have limited to no internet access, Microsoft has options...
2020-12-01 (first published: 2020-11-18)
552 reads
Daily Coping 1 Dec 2020
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...
2020-12-01
16 reads
Inspector 2.4 now available
All the changes for this release can be found in the Github Project page Mainly bug fixes this time around , but we have also added new functionality: Improvements...
2020-12-01
41 reads
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental health. I got some backlash at a couple of events for a few people on...
2020-12-01
3 reads
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental health. I got some backlash at a couple of events for a few people on...
2020-12-01
56 reads
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental health. I got some backlash at a couple of events for a few people on...
2020-12-01
9 reads
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
PT Bank Central Asia TBK. Tlpn/wa:085373737551
Jl. Insinyur H. Juanda No.54, RT.001/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
BCA KCU THAMRIN. Tlp:(+62) 8218168235
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Cikarang Tlpn/wa:085373737551
Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blok B, RW.6, Cikarang, Kec. Cikarang Utara,...
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