Subscribe to this blog
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Hemantgiri S. Goswami is working as a Consultant at Surat, INDIA. He has been a Microsoft SQL Server MVP three years running; he also moderates multiple SQL Server community forums including http://www.sql-server-performance.com and http://www.sqlserver-qa.net. He actively participates and speaks at local user group events organized under the aegis of www.surat-user-group.org, DotNetChaps and CSI Surat chapters, of which he is a founding and active member. He regularly publishes article on his blog space http://www.sql-server-citation.com. He has recently taken up a new initiative - blogging about SQL in his native language Gujarat through his blog http://sqlservercitation-gujarati.blogspot.com. He is an Author of the book SQL Server 2008 High Availability.
Archives: October 2012
SQL Server Database Backup Report using T-SQL
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_name as DBName,
b.backup_start_date,
b.backup_finish_date,
CASE
WHEN b.[type] = 'D' THEN 'Database'
WHEN b.[type] = 'I' THEN…0 comments, 218 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 17 October 2012
SQL Server # TSQL to Convert STRING in PROPER format
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 in that string/text starts… Read more
1 comments, 470 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 14 October 2012