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,584 reads
Blog Posts
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
PASS, anyone?
In less than two days I'll be in Seattle for my 6th PASS Summit. I am trying to put all the...
2008-11-14
462 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,389 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
576 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
598 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
671 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
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
672 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
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers