Confessions of a DBA – Part 3
After reading this confession, I am sure almost every DBA is going feel a churn in their stomach. They are...
2011-04-14
2,052 reads
Blog Posts
Get all SERVERPROPERTY values for SQL Server
A quick script to grab all the SERVERPROPERTY() values from a SQL instance in a table. Useful when you forget...
2011-04-14
13,380 reads
Optimising SQL Server for Sharepoint 2010
I attended the SharePoint Best Practices Conference this week in London. As a complete newbie, this event was superb - a...
2011-04-14
1,879 reads
Performance Tuning: Start to Finish
The very first ever SQL Rally is taking place in a little less than four weeks in Orlando Florida. It’s...
2011-04-14
1,347 reads
Powershell Day 14
Day 14 Tools and more info As Powershell is a global language and its open to explore. So many great...
2011-04-14
567 reads
Re-Blogging Posts
Over the last couple months, I’ve been trying to figure out what to do with some of my old posts. ...
2011-04-14
449 reads
A SQL Server Hardware Nugget A Day – Day 13
For Day 13 of this series, we will cover Intel Turbo Boost Technology. This is not like the the old...
2011-04-13
504 reads
Andy Leonard’s great idea: SQLPeople events
Not too long ago, Andy Leonard (blog|twitter) dreamed up the idea to create the SQLPeople community. The community is forming...
2011-04-13
874 reads
DBCC TraceOn – some processes are global.
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,653 reads
Powershell Day 13
Day 13 Other XML: Powershell support XML, as XML is a language which works great for windows, and it’s like...
2011-04-13
681 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 Iskandar Muda Tlpn/wa:085373737551
Jl. Iskandar Muda No.123, Sei Sikambing D, Kec. Medan Petisah, Kota Medan, Sumatera Utara...
BCA KCP MT Haryono. Tlp:085373737845
Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01 Lt.G-01, RT.5/RW.11, Wil,...
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
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