BCP is one of the fastest methods to export data to various formats like csv,txt,etc and doing this in a command mode is faster than doing it via SSMS. Let us create this simple tablecreate table test(id int, name varchar(50)) insert into test(id,name)...

In this post, we take a look at the Dynamic Management and Catalog Views related to FileStream and FileTables introduced in SQL Server 2012: sys.database_filestream_options, sys.filetables, sys.filetable_system_defined_objects and sys.dm_filestream_non_transacted_handles....

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...

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="">