Hi Jeff,

I've just tried out to split a CSV file content using the CSV Splitter using following code.
I experience an issue to make it work as I...

Hi,
this article is interesting.
Could you please tell me if I'm wrong but the formula you defined:

Days Remaining = (Free space in files)...

Hi dav0id,

many thanks for reporting this error.

I've updated the contents so that it can be updated in the article.

Cheers,

Great article. Looking forwards to the next stair level 🙂

OK, it worked.. problem with a firewall..

Thanks for the help.

Hi,

thanks for sharing.

While I was reading the script, I've noticed a little display bug:

if($changestatus.returnvalue -eq 0)

{

...

Hi WAL,

here is the output for each servers.

nameroute_idprincipal_idremote_service_namebroker_instancelifetimeaddressmirror_address

AutoCreatedLocal655361NULLNULLNULLLOCALNULL

SampleServiceRoute655401SampleServiceTargetC3A0E781-C11F-4A2D-B777-02538364F23FNULLTCP://192.168.98.93:4022NULL

nameroute_idprincipal_idremote_service_namebroker_instancelifetimeaddressmirror_address

AutoCreatedLocal655361NULLNULLNULLLOCALNULL

SampleServiceRoute655421SampleServiceSourceDBEC22F6-2B9A-4761-8404-5809B6F96893NULLTCP://192.168.96.90:4022NULL

I followed exactly the script you provided.

As you suggest, there might be a problem in contacting the target service.

The configuration is as follows :

192.168.98.xx for the source and 192.168.96.yy for...

Hi,

sorry for the delay.. I had to do some other tasks before coming back to this...

As I followed the scripts attached to the article, there is a [SampleServiceSource] on...

Hi.

Here is the command I executed for ssbdiagnose

# ------------- Configuration --------------------

$TargetServer = "MyServ"

$TargetDbName =...

After reading everything and I tried to run from attached scripts, I can't manage to get it work.

I'm trying to run Service Broker on two separate servers. The code to...

Hi, thanks for this article.

While running the code you provided, there is a little syntax error at

CREATE ENDPOINT ServiceBrokerEndpoint AUTHORIZATION $(LoginName)

STATE= STARTED AS TCP

( LISTENER_PORT=4022, LISTENER_IP= ALL...

Hi, thanks for sharing.

This seems interesting but it doesn't work against a 2008 R2 instance.

Reason:

Msg 207, Level 16, State 1, Line 245

Invalid column name 'physical_memory_kb'.

You could use an sp_executesql based...

Answer provided:

http://dba.stackexchange.com/questions/122262/how-to-run-sp-askbrent-with-expertmode-1-in-powershell

Hi,

thank you for your comments.

@Dscheypie, if you want to keep the data in some 'archive form' or aggregated form and so on, you can create your own...