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

If I recall correctly, you can use UNICODE data type for multilanguage support, refer http://msdn.microsoft.com/en-us/library/bb330962(v=sql.90).aspx and http://www.sqlservercentral.com/articles/Miscellaneous/globilizationinsqlserver/1946/ hth Heman...

Mustaq, Let us take an example of here, suppose you are writing a book - 100 pages book. While writing a book you are asked to skip 3~4 lines on each page, at the end you may have skip total 15~20 pages. That mean, the book is 80~85% full. In si...