New version of ASP.NET provides lots of way of binding data to the data controls like Grid View, Repeater etc. You can now bind this controls with strong type. I have earlier written a blog post about How we can use Model binding with ASP.NET 4.5 and Vi...

SQL is especially designed for technical personnel. SQL syntax is highly abstract, the logic is hard to understand, and only those with strong technical background can grasp it. However, in the business office workspace, the non-technical personnel will usually need the query and process data by themselves. They hope there is a reporting tool with a technical requirement as low as almost zero, and a computing capability as strong as SQL tool. ...

MS SQL Server 2012 was released back in April 2012. The previous release 'SQL Server 2012 RC' was a safe bet and is still increasingly used for production by many corporate organizations. ...

You may worked with xml and you may aware of title mentioned in this post. Today when I was working to collect information from one table which having xml column, I was trying to open xml data result set from query analyzer with new query window. For so...

ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the database to SIMPLE. In this post, we attempt to explore why the recovery model is reset....

Recently, Bill Jelen aka Mr Excel came up with a podcast that showcased a visualization that he termed as the “100% Visualization”. I have never seen this visualization before and I am not sure whether Stephen Few would approve of it. But I found the co...

I have created a video tutorial for Visual studio 2012. Where I have shown different kind of searching options. ";" alt="">

Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often used in telling family stories. Except ascendants. I never really understand what this word means until I ran into this wor...

In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...

Often developers use Import wizard from SSMS or SSIS to import data from a text file into a table. You may or may not import it successfully based on the nature of the data. Create a text file named test.txt with the following data id|name|address1|rame...