Browse by Tags

Tagged Content List
  • Wiki Page: IEnumerable<T> Vs. IQueryable<T>

    I am sure most of you have seen the following interfaces when you write code with .NET Framework. IEnumerable IEnumerable<T> IQueryable IQueryable<T> Have you ever wondered what these really are. Let’s see the beauty of them and let’s have a dig into IEnumerable<T>...
  • Wiki Page: How to Compare Two Tables Definition / Metadata in Different Databases

    This article is about the example on T-SQL Script to compare two tables definition / metadata in different databases . The T-SQL Script [used to compare two tables definition / metadata in different databases] in this article can be used from SQL Server 2012 and above version because I have used...
  • Wiki Page: How to Check the Syntax of Dynamic SQL Before Execution

    This article is about the system function sys.dm_exec_describe_first_result_set that can be used to check the syntax of dynamic SQL before execution. This system function sys.dm_exec_describe_first_result_set was introduced in SQL Server 2012. Create sample table and insert sample data : ...
  • Wiki Page: How to Put a Sequence in a Column Already filled

    Suppose we would like to create a sequence in a table already filled with data. I found out this solution to be pretty easy: CREATE TABLE SEQ (COK NVARCHAR( 10 )) insert into seq values ( 'York' ),( 'Boston' ),( 'Chicago' ) select * from seq --step 1 , I create a table...
  • Wiki Page: SQL Server Columnstore Index FAQ

    The SQL Server xVelocity memory-optimized columnstore index stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 through the current version, in many cases by a factor of 10 to 100. We'll...
  • Wiki Page: AD RMS (Windows Server 2008 R2) and SQL Server 2012 Install Steps

    Adding AD RMS on Windows Server 2008 R2 with a SQL Server 2012 backend is supported, but a hotfix (KB2619256) must be installed. The problem is that the hotfix will only install after some of the AD RMS components are installed. To get around this "Catch 22" situation, you can install using...
  • Wiki Page: FIM 2010 R2: Creating a Custom Metaverse Object Deletion Rule Using C#

    Table of Contents Overview Solution requirement Contoso synchronization information Proposed design Code logic MV Extension Object deletion code I recently wanted to create a custom object deletion rule, and searched for some sample code on the Web that I could reuse. Since I could not find any...
  • Wiki Page: Clarification on Issues Resulting from the Use of Supernets in ConfigMgr 2007

    We have received a number of requests for more information in response to the following two blog posts: Known Issue: Supernets in Active Directory sites used as site boundaries Some ConfigMgr 2007 clients never install packages, report status of “Waiting on content” The statement that...
  • Wiki Page: Script to Create or Drop All Primary Keys

    I wrote a script to generate create or drop statements for all primary keys in a SQL Server database. It was originally published on my blog in 2009, but this is a better place to post it. The community has the ability to correct or enhance the script here. I did not test the script on a database that...
  • Wiki Page: How to Script the Export/Modify of Active Directory Objects Attributes

    Table of Contents DSQUERY Powershell Quest Powershell Script Find some specific attributes for a OU users using powershell Find users attributes (Users input from a Text file) Below example for user attributes How to reset the passwords for some specific users How to update the manager field for bulk...
  • Wiki Page: Service broker + trigger based data auditing

    I was assigned task to build our own Data Audit mechanism in SQL Server 2005 last year. There were number of articles and scripts on the internet about asynchronous auditing with service broker. I decided to get the best out of those articles and scripts and create my own trigger + service broker...
  • Wiki Page: Using reference-type arguments in a workflow (WF)

    Prior to the release candidate for .Net Framework v4, it was allowed to use arguments of a reference type with no wrapping or transformation. However, this led to some confusion concerning how reference types were passed to multiple instances of a workflow, so in the release version of .Net 4, some...
  • Wiki Page: SQL Server - sqlcmd.exe

    The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job. This utility uses OLE DB to execute Transact-SQL batches...
  • Wiki Page: BizTalk Server 2013: WCF-SQL executing a stored procedure in Windows Azure SQL Database

    Table of Contents Introduction Use Case Scenario Creating a database, table, and stored procedures in Windows Azure SQL Database Create a database Create a table in Windows Azure SQL Database through the management portal (Silverlight) Create stored procedures in Windows Azure SQL Database through the...
  • Wiki Page: ADDS PowerShell (CMDLET, ADSI & .Net) to Expedite Your Tasks

    Table of Contents CMDLET ADSI PowerShell ADSI(Active Directory Services Interface) commands 2. How to find the Group members for a Group. 3. Listing an OU Contents 4. Finding FSMO using .Net Namespace "System.DirectoryServices" 5. Finding All attributes & Properties How to get the Property...
  • Wiki Page: SSIS: Import Excel to table - Cannot convert between unicode and non-unicode string data types

    When data is imported from Excel to SQL Server table using SSIS and if the destination table has column of data type VARCHAR, we will end up with error "Cannot convert between unicode and non-unicode string data types" . As far as my knowledge, I know there are two solutions: i)...
  • Wiki Page: How to Post a Wiki Article Announcement to the FIM Forum

    A community is about helping each other and sharing information. One method to share information and also to collaborate with others in a community is to write a Wiki article . For FIM, you can already find a broad collection of helpful articles on the Wiki site. To improve the discoverability...
  • Wiki Page: Windows To Go Step by Step

    Introduction Windows To Go workspace is an enterprise feature of Windows® 8 that enables users to boot Windows from a USB-connected external drive. Windows To Go drives can use the same image that enterprises use for their desktops and laptops, and can be managed the same way. Offering a new mobility...
  • Wiki Page: SQL Server Samples Readme

    The SQL Server 2012 samples provide a variety of databases and files that you can use to learn about new and existing features. This article is the consolidated Readme for each sample in the SQL Server 2012 release. It provides prerequisite information, installation instructions, and links...
  • Wiki Page: Load Testing BizTalk Server Solutions with Visual Studio 2010

    Table of Contents Introduction Creating a Visual Studio Unit Test to Submit Documents to BizTalk Server Set Visual Studio 2010 Test Project Options Create a new Visual Studio 2010 Solution with a Test Project Update the Code in the Test Project and add an Application Configuration File to the Test Project...
  • Wiki Page: Code Sample: Regular Detection and On Demand Detection Leveraging the same Script Instance

    Here is the sample management pack: < ManagementPack ContentReadable = "true" xmlns:xsd = " http://www.w3.org/2001/XMLSchema " xmlns:xsl = " http://www.w3.org/1999/XSL/Transform " > < Manifest > < Identity > < ID >Demo<...
  • Wiki Page: Using XML File as Data Source for Visual Studio Data Driven Testing

    Scenario : Using XML file as data source for Data driven testing in Visual studio 2010 Ultimate Error Observed: The unit test adapter failed to connect to the data source or to read the data. For more information on troubleshooting this error, see "Troubleshooting Data-Driven Unit Tests"...
  • Wiki Page: Simulating Touch Input in Windows 8 Using Touch Injection API

    Table of Contents Introduction Prerequisites Touch Interactions Simulating Tap Simulating Hold Simulating Drag Simulating Pinch/Pan Simulating Rotate Simulating Cross-Slide References Introduction Windows 8 comes with multiple input types. Windows 8 devices often have multi-touch screens that enable...
  • Wiki Page: Custom MDX Query for Excel Filters

    More Often we may want to write custom Filters for Cube Data retrieved through Excel. You can achieve it through VBA or simply by adding few iterations on Excel. We can Achieve Custom calculations by simply adding OLAP PIVOT TABLE Extension to EXCEL . A common scenario would be building a 13 week...
  • Wiki Page: Active Directory: Duplicate Object Name Resolution

    Table of Contents Objects in Active Directory Should Have Unique Names How Duplicate Objects Can Be Created When a Duplicate RDN in an OU or Container is Detected When a Duplicate sAMAccountName in Domain is Detected Community Resources Objects in Active Directory Should Have Unique Names When...
Page 1 of 45 (1,105 items) 12345»
Can't find it? Write it!