Resources For IT Professionals
Get this Tag RSS feed
Tag Cloud
Wiki  > All Tags > has code
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>...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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 : ...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013

  • 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...
    on22 Sep 2013
Page 1 of 84 (2,100 items) 12345»