It is destiny that I ended up where I am today. I don't see any time soon I can live on Social Security, 401K, or IRA. I better keep on...

oh, no, you don't want a person that

"Yes, boss, I will do what you told me to do!"

Can you manage that?

Here we go again in 2012, double cooked pork. Paul said it will cause fragmentation a long time ago. I said thou should defrag a long time ago.

The title should...

Paste it into a good text editor, like PFE, where you are going to see unidentified character as '?', Replace them all with replace command.

Merrill,

Yes, monitoring software like Idera DM and Quest Spotlight does work. I use them all day long. It is the best black-box recorder you can have when CIO wants to...

1) This only query current database. I had written a query that inquire all databases. 2) Please remove schema='dbo' whereclause; otherwise you are only getting under schema dbo. 3) This...

This stored procedure is deprecated

"sp_change_users_login".

I wrote a query to find all the privilege on the old database, then decide which needs to be implemented on the refreshed dev. It...

There is very little to no use for cold backup, either at SQL Server or Oracle world. The only time you might consider for example, is you are already taking...

To me the answer should not depend on data type.

C - case

I - Insensitive

A - Accent

S - Sesitive

b and B cannot be Accent differentiated

b and B...

This audit only deals with someone directly made database connection and made changes, if that was a designated single app login, that has to be recorded by the app. We...

You should always run Robocopy from the standby host (the secondary) to copy from primary to secondary. This way the Robocopy uses secondary host resources and only reads the backup...

Robert Davis (10/5/2011)

---

What if a failover occurs but the other node fails to come online and it fails back to the original server? No alert will be raised.

What if the...

If someone took a backup into a folder only s/he knows, you are not going to find it this way. You should query msdb to find backup information.

Regards,

Jason

http://usa.redirectme.net

By the way,...

Make sure 1) the network you are sneding from is allowed to relay smtp by "smtp.gmail.com". 2) you have no firewall filtering the port traffic to the destination host/port.

It works...

That is a bogus error message I got too. The profile has to be public or the correct principal.