MSSQLTips.com: How to Audit SysAdmin Logins
One of the first things I tried to do when logon triggers came out with Service Pack 2 of SQL...
2008-11-14
2,589 reads
PASS Board of Directors Part 5
Looks like I'm still in the game! Just received word from Kevin Kline (Past PASS President). Here are the candidates:
Andy...
2008-11-14
1,312 reads
In remembrance of veterans and their families
Illiad has been running a series on his UserFriendly comic strip about veterans. It started on Monday and has continued...
2008-11-14
719 reads
Find the TCP port used by a named instance
We know for SQL Server default instance, if TCP/IP protocol is used, the default TCP port number is always 1433....
2008-11-13
1,408 reads
Google Blogs & Images
I'm using a Goggle blog for another project and overall it works fine, no complaints. I've also switched to using...
2008-11-13
580 reads
Not Going to the PASS Summit
I've been asked by a few folks whether or not I'm going to the PASS Summit. The answer is I'm...
2008-11-13
599 reads
SQLSaturday #6 - Canceled
Just heard back from Allen White, due to his schedule and minimal success creating a true team effort plans for...
2008-11-12
544 reads
Last Minute Prep
Next week is the PASS Summit for 2008 in Seattle and I'm trying to close down the work I need...
2008-11-12
672 reads
Redoing Work
I hate redoing work. I really try to make sure that I pay attention to what I'm doing, slow down...
2008-11-12
673 reads
Latest Orlando User Group Meeting & Assorted Attendees
We had our meeting on November 11, 2008, with 27 people attending. Our featured speaker was Jessica Moss, SQL MVP...
2008-11-12
538 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers