Yes, with the ALTER LOGIN command. http://technet.microsoft.com/en-us/library/ms189828%28v=sql.100%29.aspx. If it's a Windows domain login then they shouldn't need to worry about changing the password in both places because the...

You can use the KILL command to kill a session or get a report of the progress of a previously-issued KILL command. See http://technet.microsoft.com/en-us/library/ms173730%28v=sql.100%29.aspx. They cover orphaned transactions.

That's something new to me too. I've heard and read that mirroring has been targeted for termination in a future release of SQL Server and that AlwaysOn is the...

abhas (12/11/2013)

---

Hi,

I am having a table with SchoolDate column. In this column I need to enters all the dates in the range.

for example start date = 02/25/14 and...

Back to the Future

Density

jasona.work (12/11/2013)

---

Gotta love Oracle...

If a node in a RAC cluster loses communication with the cluster for a minute or two, it gets evicted. So far, so good. Except...

You must have a step in your SSIS package that's trying to run a command shell. I can't speak to much of anything about SSIS because I don't know...

This did teach me what dutil.exe was. Since I don't know SSIS, it won't come in handy for now, but at least I got to learn something. Thanks...

TDE is for the entire database and requires Enterprise Edition.

For SQL 2008, individual column encryption is possible using keys and certificates. I would start at http://technet.microsoft.com/en-us/library/bb510663.aspx. Make sure...

Digestion

Eating

Tom, the interesting thing about Gail and Grant responding on this topic is that they're both published online and in books. I've read things written by both of them...

Love the access to other rows in the set. Still waiting for 2012. Sigh.

Yup - It make me research it as well. Thanks for the question.