Knowing the SQL syntax for basic queries doesn't prepare you for being a SQL Server DBA any more than it does for say... MySQL. The security structures are completely different....

Hrm. I don't like where that leads. Thank you for posting a follow up to what seems to be the solution. That's something I'll do some research on. I'm sure...

It does to some effect, although the numbers I saw are a couple of years old. I think it used to be a 20-30% performance hit for the databases that...

This should be required reading for all DBAs.

Start up Profiler and make sure to add Audit Login Failed to the list of events to capture (you will likely have to check Show all events to see it)....

Replace this set of lines:

IF CHARINDEX(',', @string) = 0

 RETURN @string

with

IF (CHARINDEX(',', @string) = 0) OR (PATINDEX('%,%,%', @string) > 0)

 RETURN @string

Please don't crosspost, as most of us read all the forums. I've posted a response under your thread in the Administration forum, because I saw it first, although this is...

If it's a Windows based login and you've got the Local Security Policy (or a Group Policy) which has the Audit Policy set to Success, Failure for Audit account logon...

This is true if you aren't having to take things like Kerberos and/or TLS into account. If those aren't a concern you can also forcibly alias at the client by...

That's one I haven't looked at. After such a positive post by SQLBill I may see about getting a trial version to take a look.

The virtual name has to be different from the physical node names. One option would be to rename the TS1SQL01 node to some other name (and it would make sense...

Good point, I'm thinking large scale for the enterprise... With respect to the Quest tools, Foglight is your long term monitoring solution. Spotlight is for checking when there's a problem....

Test with Local System but it shouldn't remain that way (at worst case, create a local user and run both SQL Server and SQL Server Agent under that). It looks...

It's a pinned post, so it should stay at the top if anyone browses the forum.

If you are only installing one instance on a cluster, you can install a default instance. That means it'll connect as whatever the virtual name is. For instance, if the...