Script Individual User Rights in a Database with PowerShell
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,428 reads
Stored Procedures to Store and Get Database Users with All Permissions
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,780 reads
A Busy/Accidental DBA’s Guide to Managing VLFs
Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...
2009-12-21
864 reads
How to Shrink TempDB in SQL 2005
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,043 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
BCA KCP Kertajaya No.Telp 083831617937
Whatsapp.083831617937 Jl. Kertajaya No.35, RT.001/RW.10, Manyar Sabrangan, Kec. Mulyorejo, Kota SBY, Jawa Timur Surabaya,...
BCA KCP Kenjeran No.Telp 083831617937
Whatsapp.083831617937 Jalan Kenjeran No.98, Simokerto, Tambakrejo, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
BCA KCP Kapas Krampung No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapas Krampung 126-126A-B Surabaya, Jawa Timur, Indonesia 60133
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