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,587 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
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
Of Mice and Men
In addition to the reading list I'm still struggling to finish, I've always got other books partially started. Maybe that's...
2008-11-07
691 reads
SQL Quiz - Mistakes You've Made?
Jason Massie called me out for a new SQL Quiz that was the diabolical idea of Chris Shaw.The gist is...
2008-11-07
1,390 reads
MSSQLTips: How to setup and use a SQL Server alias
I've written my first tip for MSSQLTips.com:
How to setup and use a SQL Server alias
It's a pretty simple thing to...
2008-11-05
901 reads
Midlands PASS Chapter Meeting - November 6, 2008
Speaker: Brian Kelley
Midlands PASS Chapter - November 6, 2008 Meeting
Sponsored by Red Gate Software
The Midlands PASS chapter will hold our normally...
2008-11-03
515 reads
Professional Microsoft SQL Server 2008 Administration
When I came home from work tonight, there waiting on my was my copy of Professional Microsoft SQL Server 2008...
2008-11-03
1,163 reads
Auditing for Blank Passwords
Auditing blank passwords in SQL Server 2005 and 2008 proves a bit more challenging than in SQL Server 2000. In...
2008-11-01
1,229 reads
Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,565 reads
Out of Band Security Bulletin Release for Microsoft Windows
Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of...
2008-10-23
1,509 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers