IT Technology Blog

IT technology blog, featuring the essence for you to read the article, is to learn IT technology blog first choice

Delta Derivation With the Merge Keyword in SQL Server

Introduction Some time back my mom asked my younger brother to get butter from the grocery shop. As soon as he returned, she recalled that curd was also required. He was forced to go again and get it

Your ADO is broken

I found today that Microsoft has violated the holy rules of COM and broken their msado15.dll. The violation occurs after the installation of Windows 7 Service Pack 1 (version 6.1.7601.17514). What’s

Uploading and downloading files to/from a SQL Server database

Download source - 328 KB Introduction A while ago, I was working to find the right syntax and method for saving and retrieving files (.doc, .txt, .pdf) with regard to SQL Server 2005/2008. While I

Database Worst Practices – New Town and New Job and New Disasters

Instead of writing best practices, I am going to write about few of the worst practices which I have quite often seen in the real world. Some of them are really bad that I often wonder how those wh

Online non-NULL with values column added in SQL Server 11

Prior to SQL Server 11, when you add a new non-NULLable column with default values to an existing table, a size-of data operation occurs: every row in the table is updated to add the default value of

SqlMetalPlus- A VS Add-in to Manage Custom Changes to DBML

Download setup - 279.09 KB Download source - 258.51 KB Introduction When using LINQ to SQL in one of our projects, we came across a situation where we had to make a lot of changes to the D

How to update a table with a columnstore index

In my previous article How to use columnstore indexes in SQL Server, we saw how to create a columnstore index on a table and how certain queries can significantly reduce the IO needed and thus increas

ASP.Net 4.0 New Features

ViewStateMode – ViewState for Individual Controls ASP.Net 4.0 allows view state in a page to be more controllable from page to its child controls level. That is, view state of a control can be enable

Jquery Ajax Calling functions

Download AJAXCALLS - 131.24 KB Introduction Recently I am working on Website with the asp.net and jQuery. While working with jquery library I found that there are 5 diffrent function that used to

Javascript : A Quick Check

Download Javascript_ACheck.zip - 3.28 KB Background Many Times i have observed, user put their problem on CP forum related to Javascript. Really they don't know what the exact use of

Signum Framework Principles

Download SignumFramework_1.0_Setup.zip - 901.21 KB Download SignumFramework_1.0_Src.zip - 407.68 KB Signum Framework Tutorials Signum Framework Principles (SF 1.0)  Signum Framework T

Ajax DLL

Download source - 43.86 KB Introduction Ajax DLL is a library developed using .NET 2005 for ASP.NET 2.0/3.0/3.5/4.0. It is used to call Server side methods from JavaScript. You can pass the m

Button Tips and Tricks part-II

Introduction In this Article we are going to learn how to access the CommandArguments of the button, how to fire JavaScript function on click on the Button and prevent the Form submission, how to a

Html5 WebWorkers experiment

jQueryWall.zip   Table Of Contents Introduction jQuery Plugin Web Workers How The Demo App Works How To Run The Demo  Browser Support Html P

HW'in it with FubuMVC

After a little discussion on FubuMVC's default conventions, we finally approach our shiny goal: force our browser to display a certain phrase (that looks strangely familiar). Displaying a simple stri

Custom Membership, Role Providers, Website administration tool, and Role based access to individual files

Download source code - 256 KB Download demo - 257 KB Download database script - 0.6 KB Introduction I present here a sample custom membership provider and a custom role provider. This artic

Create Custom Controls in MVC3

Download DemoCustomControl.zip - 2.05 MB Introduction In this article I am going to share my experience in creating custom controls in ASP.NET MVC3 Razor. At the end of the article you will learn so

Reboot and Resume PowerShell Script

Download source - 1.43 KB Introduction Gone are the days where daily reboots of Windows were needed. However, when dealing with system maintenance or installing multiple applications from script

Signum Framework Tutorials Part 1 – Southwind Entities

Download Signum Framework 2.0 Binaries - 2.17 MB (also in codeplex.com) Download Signum Framework 2.0 Sources - 1.48 MB (also in github.com) Download Southwind Part1 Entities - 165.63 KB (also in

Database Mirrors with Differing Vendors

Introduction Developers are often confronted with an Enterprise-crucial database from a vendor where the risk of even reading data during production hours can be very high. One low-level solution is