Browse by Tags

Tagged Content List
  • Wiki Page: SSRS: How to Group Same Row Data with One Column Having Varying Data

    This article is the outcome of my answer to this question in the SSRS forum. Consider this sample data DECLARE @sample_data table ( [ Year ] varchar (5), Emp_id varchar (30), Name varchar (30), Accomplishments varchar (30) ) insert @sample_data...
  • Wiki Page: SSIS: Move a Folder from one Drive to Another Drive Using the File System Task

    When I tried to answer the question in this thread - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/cec6c11f-ec2c-48e2-9c14-199c640ebb05/move-folder-using-file-system-task , I came to know about the fact that using File system Task by setting the option Operation = Move Directory , we can...
  • Wiki Page: SharePoint 2013: How to open list forms in dialog box instead of navigating to another page.

    Table of Contents Steps to force to open the dialog box for list forms: About Calendar List In SharePoint 2010, when you try to add new item to list, edit item or view item dialog box gets opened. And once you have done with the action you remain on the same page, so minimal to and fro navigation...
  • Wiki Page: BizTalk and SSL Transport

    Table of Contents Introduction Secure Sockets Layer (SSL) SSL One-way SSL Two-way Configure SSL within an BizTalk adapter SSL Demystified See Also Introduction Secure transport can be provided by HTTPS, which is a combination of the Hypertext Transfer Protocol (HTTP) with SSL/TLS protocol to...
  • Wiki Page: BizTalk Server: Tracking Dependencies Between Artifacts

    Table of Contents Introduction BizTalk Server 2013 Previous BizTalk versions See Also Introduction One of the new out of the box features of BizTalk Server 2013 is the ability to track dependencies between artifacts. The BizTalk Server Administration console provides a UI-driven experience to see...
  • Wiki Page: BizTalk Server 2013: Test BizTalk artifacts with Visual Studio 2012

    Table of Contents Introduction Test an instance of a document schema Testing a map Unit testing of BizTalk artifacts Unit testing of a schema Unit testing of a map Unit testing of a pipeline Wrap up See Also Introduction Testing is an important aspect of (BizTalk) application life cycle. Before...
  • Wiki Page: TechNet Guru Contributions - July 2013

    Table of Contents Introduction How to Enter 1) Create a new TechNet article 2) Tell us about it Categories BizTalk Forefront Identity Manager SharePoint 2010 / 2013 Small Basic SQL Server Analysis Services, PowerPivot SQL Server Database Engine SQL Server Reporting Services, Power View, & SQL Server...
  • Wiki Page: Finding Floor and Fraction of the Decimal Number

    Today I presented a solution for a very common request - given a decimal number, find its floor (I am using this Wikipedia definition ) as well as its fraction. This is the solution as appeared in that referenced thread: DECLARE @amount MONEY; SET @amount = 812.85; ...
  • Wiki Page: How SQL Server Determines Type of the Constant

    Table of Contents Problem Definition Explanation Conclusion See Also Problem Definition There was an interesting question asked recently in Transact-SQL forum "Basic doubt in Round function" . The problem was stated as following: SELECT ROUND(744, -3) produced...
  • Wiki Page: SET ANSI_PADDING Setting and Its Importance

    Table of Contents Problem Description Investigation Resolution Script to correct problem in the whole database Default Database Settings See Also Other Languages Problem Description Recently I got an interesting escalation to solve for the client. Our VFP based application was getting the following...
  • Wiki Page: SQL Server Resource Re-Balancing in Failover Cluster

    The poster asked how to automatically adjust SQL Server's max server memory setting following a cluster fail-over - see here . I provided the following script with suggestions for how it could be tailored for their environment. USE [ master ] GO /****** Object: StoredProcedure [dbo...
  • Wiki Page: T-SQL: Group by Time Interval

    Table of Contents Simple Problem Definition Solution Complex Problem Definition and Solution See Also Simple Problem Definition A question was posted today in Transact-SQL forum " Counts by Time Interval " The thread originator wanted to know how to find how many jobs were completed...
  • Wiki Page: Location API in Windows Phone 8

    Table of Contents Overview Introduction Location Provider technologies Getting the Current Location in Windows Phone 7.5 Capabilities Geolocator in Windows Phone 8 Background Location Tracking Overview This article will introduce the Location features in Windows Phone 8 and how the windows phone...
  • Wiki Page: How to Handle a Huge Collection of Strings in VB.Net

    Table of Contents Introduction Collection Classes in .Net A More Capable Solution for Strings Implementing the Collection Recursive Helper Methods Adding Strings to the Collection Removing Strings from the Collection Finding Strings in the Collection Implementing the SearchableStringCollectionEnumerator...
  • Wiki Page: SQL Server 2008+: Merge (Unity is Strength - Strengthen your Performance by Merge)

    Table of Contents Problem Definition Solution MERGE Points to note Conclusion Problem Definition In SQL Server for each DML transaction (Insert, Update, Delete) we need to write separate statements which will be executed one by one in SQL Server execution engine. Let's give a basic...
  • Wiki Page: Connecting to SSAS Cube using Silverlight

    Some time back when I was watching a presentation of a third party reporting product, I saw some nice animated charts. I wanted to create something similar to those charts and when I checked on SSRS, unfortunately what I wanted isn't possible with SSRS. So I moved into Silverlight Charts and I...
  • Wiki Page: FIM 2010 R2: How to Bulk Import Attributes Flow Rules into a Synchronization Rule in the Portal

    Table of Contents Overview Pre-requisites Create Synchronization Rules in the Portal Create Powershell scripts Configure attribute flows in Excel Using the powershell scripts Items to Note Overview I had to create 6 Sync rules each one with 100+ attribute flows. It would take me at least 2...
  • Wiki Page: Create an Analog Clock in a Windows Store Application

    This sample uses xaml and C# to create an analog clock in a windows store application. Xaml allows you to vary the angle of lines when drawn on the screen. I used an ellipse as the background of the clock. We will draw 3 lines for the hour, seconds, and minute hand on an analog clock. A rotate transform...
  • Wiki Page: Een analoge klok maken in een Windows Store Applicatie (nl-NL)

    Dit voorbeeld gebruikt xaml en C# om een analoge klok te maken in een windows store applicatie. Xaml laat u toe de hoek van lijnen weergeven op een scherm te laten variëren. Ik heb een ellips gebruikt als achtergrond van de klok. We zullen drie lijnen tekenen voor de uur, seconden en minuut wijzer...
  • Wiki Page: FIM 2010 R2: How to Make a Connection to Oracle Database 11g

    Table of Contents Pre-requisites Install Oracle client 11g on the FIM Server Configure Oracle MA Oracle DB connectivity tips Pre-requisites Install FIM 2010 R2 on Windows 2008, SQL 2008. If you are using Windows 2012 or SQL 2012 then install FIM 2010 R2 SP1 Get the following Oracle...
  • Wiki Page: Baumstrukturen mit LINQ abfragen (de-DE)

    Dieser Artikel ist die deutsche Übersetzung meines zuerst auf Englisch erschienen Artikels How to Query Trees Using LINQ . (Gerichtete) Bäume gehören zu den häufigsten Datenstrukturen in der Informatik. Wie sie mit LINQ genutzt werden, ist aber weniger offensichtlich. Dieser Artikel definiert...
  • Wiki Page: BizTalk Server: Importing Certificates

    Table of Contents Introduction Other People Store Personal certificate store Importing certificates Microsoft Management Console CertWizard See Also Introduction BizTalk Server depends mainly on security provided by certificates and uses them for encryption, decryption, signing and verifying digital...
  • Wiki Page: How to Query Trees Using LINQ

    A (directed) tree is one of the most common data types. But how do you use trees in LINQ? This article introduces a generic LINQ-Extension which solves the problem, gives an example and discusses alternatives. Table of Contents Motivation Solution Usage Example Contradictions and alternatives...
  • Wiki Page: WPF/MVVM: Binding the IsChecked Property of a CheckBox to Several Other CheckBoxes

    Table of Contents Introduction Grouping in XAML Data Templating Defining a GroupStyle The binding Selecting all CheckBoxes Introduction This article provides an example on how you can use a three-state Checkbox control to set the IsChecked property of several other related CheckBoxes in a data...
  • Wiki Page: SharePoint 2010: Reverse Engineering SharePoint WSP Packages

    Table of Contents Reverse Engineering SharePoint WSP Packages Introduction Audience Getting Started Delving Deeper Reverse Engineering SharePoint WSP Packages Disclaimer : Please note that this article is scoped to internally developed WSP Packages only. The terms and conditions that you accept...
Page 5 of 9 (205 items) «34567»
Can't find it? Write it!