SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP - Blogs

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.

How to collect cluster Information using TSQL

Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating inventory of servers. Logging into each server and collecting information is bit tedious when you have hundreds of server in your environment. I have spent sometime and created a…

1 comments, 153 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 April 2013

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 day.
Showing the events in…

0 comments, 244 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 9 April 2013

SQL Server – Generating PERMUTATIONS using T-Sql

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 is to be permuted…

0 comments, 106 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 11 March 2013

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 to retrieve…

0 comments, 144 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 6 March 2013

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:

Connect to the Server…

0 comments, 376 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 24 December 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, 220 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, 472 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 14 October 2012

Troubleshooting Oracle Link Server - Part2

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…

0 comments, 320 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 1 September 2012

SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL

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 employee record inserted into the… Read more

2 comments, 516 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 27 March 2012

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 possible to get this…

3 comments, 327 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 11 March 2012

Moving MASTER Database

In my previous post we see how to move MSDB database, today we will see how to move or relocate MASTER database. While moving MASTER database we’ll have to consider few other things like changing start-up parameter for SQL Server Service. I will also mention those stops here for… Read more

0 comments, 174 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 8 March 2012

Moving MSDB to new location

In recent past we have a situation where in we required to move MSDB, Model and Master databases to new location, the reason being faulty drive. While moving system databases to new location we need to be extra cautious. Let’s see the process step-by-step.

Step 1: Let’s query sys view…

2 comments, 171 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 6 March 2012

Register for SQL Server 2012 Virtual Launch

`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed what’s new in SQL Server 2012 setup, MS has released SQL Server 2012 training kit and made it available for us to download. In recent past, I have… Read more

0 comments, 94 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 5 March 2012

Download free eBook for SQL Server 2012

Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second draft of this book. SQL Server MVP Ross Mistry and Stacia Misner has covered Administration and BI part, there are 10 chapters in total divided in two part, they…

0 comments, 925 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 February 2012

When DBCC INPUTBUFFER disappoints

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement

 
SELECT * FROM 
MASTER..SYSPROCESSES
WHERE BLOCKED != 0

Yes, I’ve found the culprit SPID that is occupying more resources, using DBCC INPUTBUFFER(SPID). so, instead of seeing what…

0 comments, 489 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 30 January 2012

Rebuild System Databases

Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation goes like:
FB Friend: Hi
I : Hi
FB Friend: I need your help
FB Friend : My SQL Server is not starting...
I : What is an error you…

2 comments, 595 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 January 2012

Revamping SUG 2nd Meeting

Friends,

Last Saturday, 21st we have 2nd meeting of SUG members and this time we made progress – I, Vinay and Matang was present in meeting .We have discussed following :

We have decided that portal management will be done by I, Vinay and Matang initially, here are the module…

0 comments, 118 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 23 January 2012

Roles and Responsibilty of SQL Server DBA

What is a role of a DBA in an organization?
What are the daily activities of a DBA?
What shall I check on regular basis?
What all processes shall I automate ?
What are the precautions, I have to take additionally?

These are the common question being asked in-common on…

0 comments, 182 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 1 January 2012

Wishing you all a very Happy and Prosperous new year, may success comes to your doorstep

Image source : Top CNN News

0 comments, 0 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 31 December 2011

What’s new in SQL Server RC0 setup

Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read More
MS SQL Server 2012 RC0 includes new edition – SQL Server Business Intelligence, Read More
Service Pack 1 is the minimum requirement for Windows 7 and Windows Server 2008 R2 operating systems, Read more

0 comments, 103 reads

Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 28 December 2011

Older posts

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog