03-May-2013SQL 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.
14-May-2013SQLYoga – 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.
29-Oct-2012SQL 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
09-Oct-2009Community 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-2009SQL 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.