• Jumping between database Name and ID in SQL Server

    If you're using DMVs or quering the master Database, you'll need to know your database id, and some query results returned with Database Id and your want to know is this my database ?
    a quick jumping between database id and name
    From ID to Name
    select DB_NAME(1);
    From Name to ID
    select DB_ID('master');
    you'll find this Handy to quick locate the info related to your database
  • VDI & LYNC

     

    It is doable given the following conditions:

    • Users are LAN users (preferred for Video)
    • Terminal Server is Windows Server 2008 R2 SP1 (to utilize Remote FX USB Redirection feature only available in SP1)
    • Client is Windows 7 SP1 (for the same reason)

     

    XenDesktop with RemoteFX With Lync and the Lync application is virtualized by App-V.

    This video from TechED 11 Europe.

    http://blogs.microsoft.co.il/blogs/ronenb/archive/2011/03/29/vdi-and-lync.aspx

     

    Announcement on Citrix

    http://blogs.citrix.com/2010/11/18/microsoft-lync-office-communicator-on-xendesktop-5/

     

    Press on Right Arrow on the below link

     

    http://hdx.citrix.com/hdx-realtime

     

     Thanks to Hussein and team for providing some of the info

  • Free Cool Tools: Microsoft Analytics for Twitter

    Analytics for Twitter allows users to query Twitter directly in Microsoft® Office Excel 2010. Utilizing the free PowerPivot Excel Add-in users can perform their own analysis such as who are the top Tweeters, what #hashtags are they using and do they have a positive or negative tweet tone.

     

    Download Analytics tools from here..... 

    http://www.microsoft.com/download/en/details.aspx?id=26213

     

    You need Power Pivot.....

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609

  • Lync PowerPack Official Release

     

    The Lync team has released these great additional features.  The Lync Power Pack applications are being made available as part of the broader Lync Adoption and Training Kit.  With this release of the Power Pack, five new applications join the previously released IM an Expert app.  These applications are:

     

    -        Conversations Analyzer - Conversations Analyzer is an application that reviews your Lync instant messaging (IM) conversation history and gives you scores for your use of trust-building language in day-to-day communications with business associates and friends. Conversations Analyzer applies trust rules to determine the occurrence of words and phrases that have a positive or negative effect on trust. Only your IM conversation history is reviewed. The results are not uploaded anywhere. The scores are meant to be used only by you.

     

    -        Conversation Translator - Conversation Translator provides a real-time language translation service for Lync instant messaging (IM) conversations. With Conversation Translator, both the sender and receiver can converse in their native language, and Conversation Translator handles the translation. Powered by the Microsoft Translator Web Service, Conversation Translator currently supports translation between 35 languages.

     

    -        Information Dashboard - Information Dashboard helps you start a conversation with a remote contact by providing current information about the contact's location. For example, if you are calling a coworker or a client in Shanghai, China, you can open Information Dashboard and enter the location of Shanghai before making the call. Information Dashboard will return the day, date, time, whether you are calling during regular working hours, the weather forecast, and a news feed of articles related to the location. A contact’s location is saved after you set it and is recalled automatically when you start a new conversation.

     

    -        Tabbed Conversations - Tabbed Conversations provides a tabbed conversation window to allow multiple instant messaging (IM) conversations in a single window.

     

    -        Group Chat Stress Tool - You can use the Group Chat Stress package to help verify your Microsoft Lync Server 2010 and Microsoft Lync Server 2010 Group Chat hardware deployment. Group Chat Stress is made up of two applications: Group Chat Stress Tool, a UI application, and Group Chat Loaders, the stress engine (which has no UI). Use Group Chat Stress Tool to create the configuration files for the loaders and to distribute the binaries to the remote machines that will be running the loaders. Use Group Chat Loaders to apply the specified load parameters on the Group Chat Server.

     

    Also, here is the first of two Channel 9 interviews on IM an Expert –

    http://channel9.msdn.com/posts/Lync-IM-an-Expert-Part-1-of-2

     

  • Outbound call routing time condition

    In order to create an outbound route policy based on a time condition in order to prevent certain users from making PSTN calls after working hours

    you need to do them with powershell script and windows task scheduler

     

    so the example below shows that i created two voice policies one called "WorkTime" and the other one is "AfterWork"

    and assigned routing for working time as well as disabling all the PSTN routes from the "AfterWork"

    Now i created 2 scripts at the c:\ root folder; first is wt.ps1 and that contains the wroking time policy

     #Import-Module lync

    #Grant-CsVoicePolicy –Identity "Ken Myer" –PolicyName "WorkTime"

    #Grant-CsVoicePolicy –Identity "Adam Barr" –PolicyName "WorkTime" 

     

    and the aw.ps1 which containg the after work policy

    #Import-Module lync

    #Grant-CsVoicePolicy –Identity "Ken Myer" –PolicyName "AfterWork"

    #Grant-CsVoicePolicy –Identity "Adam Barr" –PolicyName "AfterWork"

     

    now from the Task Scheduler i had to create a task job  at 9:00 AM with the CSAdministrator credential that runs the Working time script, as well as the after work script at 5:00 PM

     

    Voila! Now i tested it on my demo machine and it works like charm!