2003, 2008, 2008 R2 SQL Server 2000, 2005, 2008, 2008 R2, 2012 */ sp_configure 'show advanced options',1 RECONFIGURE WITH OVERRIDE GO sp_configure 'xp_cmdshell',1 RECONFIGURE WITH OVERRIDE GO DECLARE @TimeZone NVARCHAR(100) ,@ProductVersion SY...

Introduction Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011. The idea was to show a Calendar for the selected month and each cell of the calendar should display the scheduled events of that ...

Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic which I could manage to come up at that point is shared in the below script. DECLARE @Value AS VARCHAR(20) = 'ABCC' --Mention the text which i...

Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are times when we need to find out records matching a criteria from all the tables of a SQL Database and today I will explain you a simple way ...

Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine. In recent past we had a situation where customer asked us to move MASTER database to new location, below are the steps I have taken: &#...

Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_n...

Problem Statement SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does not provides any direct way to convert it to PROPER format. A string/text is said to be in a PROPER format if all the words i...

It's my bad that I did not made a post since long lately. I would not make an excuse like I was busy, rather, I would say I am little lazy DBA, but I now onward I will try to post blog more frequently. Well, if you remember, earlier I have posted ...

Introduction Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is - Where, EmployeeID id the UniqueID alloted to every new employ...

On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question. Actually speaking, without explicit logging or tracing, it is no...