For connections to SQL, the following query will give you a table of current sessions.

SELECT *
  FROM sys.dm_exec_sessions
  WHERE session_id > 50;

Also check the file properties on both the data and log files to ensure they're not read-only.  If they're read-only because of the SAN snapshot and you don't have permissions...

Here's an article by Wayne Sheffield that explains the great technique.  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Nice article, Mickey.  I missed it when it was first published, but it sounds like the stuff I talk about all the time.

Grant addressed hardware and Jeff addressed software, so I won't go into either one except to say that I have experience with what they've both said.  Hardware and efficiency of...

Boy, what a great editorial.  Your point about the British Airway press releases and statements being vetted by lawyers sure was on point.  In fact, that's what I think is...

The article looks like it could be interesting, but without the actual XML to play with, it really doesn't give me anything to test or try.  A picture of part...

Grant, first off let me compliment you on your editorial - nice job.  Let me next tell you that my Windows 10 Pro updates itself and restarts whenever it wants...

Also, the data is written to the MDF and the log is written to the LDF.  SQL first logs (LDF) the fact that it's creating, deleting or updating something.  It...