Blog

SQLYoga – XML Result sets with SQL Server
14-May-2013
SQLYoga – XML Result sets with SQL Server

Recently, found that people making much complex code to have an XML in application. I have found that they return result set in Table to the application and have applied code to convert that data table to XML by Asp. Net application. When I review the process, I have suggested that why don’t you use the XML feature of the application. They surprised the simple use of it and make their life easy. Let me have sample query to generate XML result sets in SQL Server database.

SQL Yoga – Read XML with T-SQL statement in SQL SERVER
03-May-2013
SQL Yoga – Read XML with T-SQL statement in SQL SERVER

In my previous post, “XML Result sets with SQL Server”, we review to generate result sets in XML from SQL server. Then I got a comment from the team, to also have post to read XML in SQL Server.

SQL SERVER: T-SQL to find out when database was restored
29-Oct-2012
SQL SERVER: T-SQL to find out when database was restored

Recently, we have found that our testing database has been restored on the server and we lost our recent work. We have to identify that at what time the database has been restored, so we can know that what are the changes need to be restored again on the database

SQL SERVER: Find executing queries
23-Aug-2010
SQL SERVER: Find executing queries

Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.

28-Dec-2009
SQL SERVER: How to remove cursor

Many times developer ask me that How can they remove Cursor?  

SQL SERVER: How to Read Excel file by TSQL
23-Dec-2009
SQL SERVER: How to Read Excel file by TSQL

Many times developers asked that, they want to import data from Excel file.

Community TechDays at Ahmedabad - Great Event
09-Oct-2009
Community TechDays at Ahmedabad - Great Event

There was a great event held by Microsoft and PASS (Professional Association of SQL Server) in Ahmedabad on 3rd October 2009. This was very big event where 250+ attendees attend the excellent session of Vinod Kumar, Pinal Dave, Jacob Sebastian and Prabhjot Singh Bakshi. There were Four technical sessions by these excellent speakers.

22-Jul-2009
SQL SERVER: Reset Setup Values, when SQL SERVER is started/restarted

We have a requirements to clear all setup values when SQL SERVER is started/restarted and we need to setup default values to setup table.

04-Mar-2009
SQL SERVER: How much space occupied by Each Table with sp_MSforeachtable procedure

Today, I came across requirement where I need to perform an action on all of the tables within a database. For example, How much space occupied by each table.