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 'Differential database' WHEN b.[type] = 'L' THEN 'Log' WHEN b.[type] = 'F' THEN 'File or filegroup' WHEN b.[type] = 'G' THEN 'Differential file' ...

Read More

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 with a CAPITAL letter. E.g. If a string is - “Hello, how are you?”, String in Lower format = “hello, how are you?” String in Upper format = “HELLO, HOW ARE YOU?” and String in Proper format = “Hello, How Are You?”   Implementation Ideally, SQL Server...

Read More