Agree 100%,, I will add that you will need the DBATools cmdlets https://docs.dbatools.io/ .    They even have a video on how to install it, you only need...

• This reply was modified 1 year, 7 months ago by  Learn_something_new_everyday. Reason: dupe

Agree 100%,, I will add that you will need the DBATools cmdlets https://docs.dbatools.io/ .    They even have a video on how to install it, you only need...

• This reply was modified 1 year, 7 months ago by  Learn_something_new_everyday. Reason: dupe

Jim Breffni or anyone, anyway to add logic to include/exclude events per server. Example if we have a misbehaving server that has bogus errors how can we exclude the events...

--save SQL blocking trace to a table then use this to query the table to pull out the sqlhandle

SELECT CAST(textdata AS XML)

, CAST(textdata AS XML).value('(/blocked-process-report/blocked-process/process/executionStack/frame/@sqlhandle)[1]','varchar(max)') AS BlockedProcess

...

I don't think I have ever failed a SQL test, but I never tell anyone I am even taking a test until I pass it.

I have a VM on amazon cloud and I just save my file/scripts and fire up a new vm and install the 180 eval.

Been doing this for some time...

Also you could buy/rent hosted a VM from amazon and use 120 eval edition of SQL. Once the 120 days is up just add a new VM and start over....

I found this link that gives the information you were asking for.

http://bit.ly/9WY99y

You are correct on the HUGE Logs in simple mode. I have seen 100GB logs when the data file is far less in size. We don't write the code we...

Any information on Compellent’s SAN working with SQL I could really use. I have not found any information on this SAN using SQL. The rep has promised this san can...

GPO, I agree with your comments 100%. I am no longer with that company not by choice but it worked out anyway.

The good news on that is the pain...

I was told many times in the past is it better to be right or employed?

1