Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
SQL Server System Configuration Values
Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?
Virtual database storage for SQL Server: Friend or foe?
Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.
Infinite Seizure - Database Weekly (2008/8/4)
This week's Database Weekly editorial examines the US policy of potentially seizing laptops for an infinite period when you enter the country.
Moving TempDB
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
Alerts for when Login Failures Strike
When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?
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
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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