How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-12-03
3,056 reads
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-12-01
1,744 reads
Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,582 reads
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,338 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,113 reads
Careful with the New MCM Requirements
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
676 reads
Want to Make Your SQL Server Run Faster for Free?
I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...
2010-11-19
2,207 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-18
3,382 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,841 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
881 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 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
BCA KCP Kapasari No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasari 81, Kapasari, Kec. Genteng, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
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