Browse Blog Posts by Tags

All Tags » SQL 2008 R2 » sql 2005 (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server – Generate Calendar using TSQL

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

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Tue, Apr 9 2013
Filed under: Filed under: sql 2005, script, sql 2008, sql 2008 r2, sql 2012, sql 2012 r2
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.

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

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Wed, Mar 6 2013
Filed under: Filed under: sql, sql 2005, sql 2008, sql 2008 r2, sql 2012, sql 2012 r2
SQL Server # Moving MASTER database in cluster environment

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

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Mon, Dec 24 2012
Filed under: Filed under: sql 2005, sql 2000, High Availability, sql server administration, sql 2008, sql 2008 r2, sql 2012, Administration
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...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Wed, Oct 17 2012
Filed under: Filed under: sql, sql server, sql 2005, script, sql 2000, sql server 2005, Sql server 2008, sql server 2008 ctp, sql server 2000, sql 2008, sql server 2008 november ctp, sql 2008 r2, sql server 2008 R2 CTP, sql server 2008 r2, sql 2012, sql server 2012, sql 2012 r2
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...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Oct 14 2012
Filed under: Filed under: sql 2005, sql 2000, sql 2008, sql 2008 r2, sql 2012, sql 2012 r2
Last Execution Date Time of a Stored Procedure

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

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Sun, Mar 11 2012
Filed under: Filed under: sql 2005, script, sql server 2005, Sql server 2008, ms sql server 2005, sql 2008, sql 2008 r2, sql server 2008 r2

Page 1 of 1 (6 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

SQL Server – Generate Calendar using TSQL

SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.

SQL Server # Moving MASTER database in cluster environment

SQL Server # Database Backup Report using T-SQL

SQL Server # TSQL to Convert STRING in PROPER format

Last Execution Date Time of a Stored Procedure