hemanth.damecharla (12/7/2011)

---

Automating daily tasks is not only easy with Posh but, fun as well 🙂

Chad Miller's MSCS code on poshcode site is a wonderful starting point if you want...

Samuel Vella (12/7/2011)

---

Use cases:

Dev environment with 100's of tables, stored...

Lowell (12/6/2011)

---

ALZDBA (12/5/2011)

---

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you...

Thank you, Mohammed.

Samuel Vella (12/7/2011)

---

skron (12/6/2011)

---

I have found Powershell to be invaluable to me as a DBA. I have been able to...

Did you commit the alter table statement ?

What's the @@opentran count for that session ?

Thank you, Roy. I hope it gets people started.

skron (12/6/2011)

---

I have found Powershell to be invaluable to me as a DBA. ...

There is no need for two tables having a FK relationship to be able to use it in a join condition.

I would check:

- the sqlserver errorlog

- the default trace (it records object creation and delete)

and off course as already suggested a sqltrace will throw light on this issue.

Co-ordinate it with...

Do I read "a new addict" ? 😀

GilaMonster (12/5/2011)

---

ALZDBA (12/5/2011)

---

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you...

Does Powershell come in to picture ?

http://ask.sqlservercentral.com/questions/36601/powershell-export-multiple-tables-to-csv

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you run DBCC...

Is your query "select Users.UserName from Users" producing results ?

Are there usernames that return NULL in stead of a valid value ?

Did you notice

Msg 512, Level 16, State 1,...

aim for uniformity of management and apply the same backup strategy on all your instances.

If you cannot do that, use sqlagent to schedule your backup jobs for the wanted databases.

Double...

just a little but crucial warning;

- double check your jobs aren't launched using sqlalert(s) ! If a jobs can be launched by a trigger and you disable the job, when...