Microsoft Power Query for Excel

Microsoft Power Query for Excel In this post we will learn about Microsoft Power Query for Excel.Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.The add-in can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=39379.Here we will use Power Query for data modelling and structuring the data

What Is A Cursor?

What Is A Cursor? In this post we will discuss about What Is A Cursor?.A cursor keeps track of the position in the result set, and allows you to perform multiple operations row by row against a result set.We can also fetch cursor rows and perform operations on them in a loop just like using any

How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE

How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE In this article we will discuss How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE.The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system.In order to use XP_CMDSHELL you need to be a

How To Hide An Instance Of SQL Server

How To Hide An Instance Of SQL Server In this article we will learn How To Hide An Instance Of SQL Server. Sometime in your organization you has been asked for hiding an Instance of SQL Server. In earlier post we have dicussed How To Enable and Disable XP_CMDSHELL Using SP_CONFIGURE. Hiding an SQL Server Instance will help

Progress Bar Example In Asp.Net

Progress Bar Example In Asp.Net In this post we will learn how to use Progress Bar Example In Asp.Net.We are using a DropDownList with having locations of different cities, Submit button on click of Submit button the data is loaded in ASP.Net GridView. Also there’s HTML DIV which is used to display the loading progress image till

IIF() Function in SQL Server 2012

IIF() Function in SQL Server 2012 In this post we will discuss about IIF() Function.The IIF function means “Immediate IIF”.IIF is a shorthand way for writing a CASE expression.This functions take three arguments. If the first argument is true, it will return the second argument as result or it will return the third argument as

Date and Time Data Type in SQL Server 2008

Date and Time Data Type in SQL Server 2008 In this post we will discuss about Date and Time Data Type in SQL Server 2008. SmallDateTime: Defines date with the time of the day in 24-hour clock format. Requires fixed 4-bytes to store data. It can have date between January 1, 1900 through June 6, 2079 and time between