VS Conference Time! Its time to train

Couple good conferences to attend, or review recorded sessions at the end of this year. As we move to C# 5.0 and SQL 2014/2016 these session are great snapshot of info if we can parse out the marketing hype and sales pitches, Its all about the speaker as far as Im concerned, thats why I usually prefer VSLive over TechEd/Build since VSLive is not directly "owned" by MS, here schedule and links I found for Nov/Dec 2014:

2014 Events: C#/SQL related:
connect-event-live-vs NY 20141112-20141113

VS Live Orlando 2014 (if u need alumni code let me know)


Find MS Sponsored Events

Future Stuff

Other out of area conferences:
DevConnections LasVegas

Enabled Outlook Rules using VBS Script.
HOW to Enable Outlook Rules using VBS Script or Visual basic Script or VBA

I have some Outlook rules that forward email to my GMAIL  (see my old post Forward Email from Outlook to GMAIL) , In my environment I can not use Rules themselves to forward email, So I had to write a custom VBA to do it,

Well the rule works great...most of the time...For some reason Outlook disables the rules intermittently probably due to fact that it cant connect to network/net drop, There is probabpy a setting in OL to change this, however instead of relying on Outlook to keep the rule enabled I added this VBS as a periodic task,

1. Create a VBS file :

Set outlook = CreateObject("Outlook.Application")
Set colRules = outlook.Session.defaultstore.getrules()

For Each rule In colRules
'If rule.Name = @SomeName if you like
rule.Enabled = True
 
Next

 colRules.Save


2. Create Win Task to run the following command:
wscript "C:\Work\Tools\EnableRules.vbs"

Run schedule every few min or so.

Debug SSAS Dimension Attribute Issues with BIDS Helper

Ran into "A duplicate attribute key has been found during processing" issue late at night with a Cube dimension, using this tool quickly pinpointed the exact data that caused issue thus revealing where a solution was needed:

BIDS Helper 

http://bidshelper.codeplex.com/releases/view/121231

VS 2010 Find in Files stops working with BS message "find was stopped in progress"

Guess what.... U can just set focus to Find Results window and magically enter Ctrl-Break and all of sudden that fixes it....Another great wonderful bull$hIIIt VS2010 issues that causes me to spend > hours than I wish to in front of a computer...Thanks MS

who is 224.0.0.252?

If you see 224.0.0.252 in network monitor, apparently its not a virus/spyware, its ink-Layer Multicast Name Resolution, to disable it: Set this to enable via gpedit.msc:


Computer Configuration\Administrative Templates\Network\DNS Client\Turn
off Multicast Name Resolution = Enabled


via http://www.vistax64.com/vista-networking-sharing/95027-ability-disable-llmnr.html

thanks

Test File Thru=Put

Really nice file throughput tool to check read, write and dir listing, great tool to utilize to verify copy speeds between drives or networks:
https://www.raymond.cc/blog/12-file-copy-software-tested-for-fastest-transfer-speed/

JS or JQuery Get Query String Value

In JS:
var queryString = url.substring( url.indexOf('?') + 1 );
or

function queryString(keyName) {
    var query = window.location.search.substring(1);
    var vars = query.split('&');
    for (var i = 0; i < vars.length; i++) {
        var pair = vars[i].split('=');
        if (decodeURIComponent(pair[0]) == keyName) {            return decodeURIComponent(pair[1]);
        }
    }
    return null;
}

In JQuery:

Get Query String Vals:

e.g if the below mentioned is url with querystring

http://localhost/MyPage.aspx?Node1=9000%20&Node2=3000

var url = window.location.href; // or location.href
var Node1= null;
var Node2= null;

if (url.indexOf(‘?Node1=’) != -1)
{

Node1= $.query.get(‘Node1’);
 Node2= $.query.get(‘Node2′);

}

Script References for For $.query.get()  function :

<script type=”text/javascript” src=”jquery.query-2.1.7.js”></script>

<script type=”text/javascript” src=”jquery.rc4.js”></script