T-SQL Tuesday #80 – SQL Birthday Present
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and...
2016-07-12
767 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Possible Infinite Recompile Was Detected for SQLHANDLE
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log....
2016-07-01
2,270 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,512 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
781 reads
AG Worker Thread Blocked by Log Backup
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...
2016-06-15 (first published: 2016-06-06)
2,119 reads
What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...
2016-06-08 (first published: 2016-06-01)
2,695 reads
Attendee Questions from My #24HoP Presentation
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
791 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,177 reads
My 24 Hours of PASS Session Files
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
987 reads
Why I'm not attending PASS Summit 2016
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,098 reads
Blogs
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
T-SQL Tuesday #200 - I Bet It's Bad if I See...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
ALAMAT BCA KCU PONTIANAK TLP/WA 08218200174
Telp Cs:(0821)8200174 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota...
ALAMAT BCA KCU TANJUNG PANDAN TLP/WA 08218200174
Telp Cs: (0821)8200174 Jl. Jend. Sudirman No.17, RT.008/RW.04, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten...
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers