Mike Hinds (10/9/2014)

---

I don't work for Idera. That said, three or four times a year I run the Idera Password Checker (part of SQL Admin Toolset) against all my SQL...

ZZartin (10/8/2014)

---

Well technically you could find all the user logins that don't have strong passwords enforced on them, enable that for all the logins then force them to change their...

GilaMonster (10/8/2014)

---

Just be careful of any possible legal implications (what happens if someone uses the same password for your system and their online banking, you cracked their password as part...

Regarding enforcing password policy, is it possible to enable it (for checking password complexity) but disable for the following?

CHECK_EXPIRATION

password history initialization

Account lockout duration, account lockout threshold, and reset account...

Thanks for all the info - had to get some thoughts on this before I gave up. What about running a trace on setting up a new user with...

Koen Verbeeck (10/8/2014)

---

DBA From The Cold (10/8/2014)

---

I'm not sure that you will be able to script this out (as you cannot see what users' passwords are).

I would ensure that users...

Here is a link to the product page, although I think you have to contact them for a trial.

What methods are you using for intrusion detection - at the database...

Evil Kraig F (2/4/2014)

---

Agree with Jason above. Usually to do this you build a cursor around your temp table, then wrap it in EXEC( @sql) or an...

ssms-man (12/6/2013)

---

No support for SSMS 2005, but you can work with SQL 2005 through SSMS 2008 or SSMS 2012.

That's what I was hoping. I will be using it with...

Great - Thanks. I will check it out.

So no support for SQL 2005?

Thank you both - the SSMSBoost was the first and only one I found prior to posting, but I couldn't find a good description for "•Added support to Registered Servers...

I have both if you would like to take a look?

I have a feeling that it's bad parameter sniffing - chasing that down now. If nothing comes up there, then I will update stats on all tables EXCEPT the...

I use Ola Hallengren's maintenance solution, so stats are being updated nightly based on threshold.

The query uses a better plan after rebuilding the index, but could it possibly be bad...

Any other ideas? We basically have a table for each month with the same structure and this is even happening with the historical tables that have no inserts and...