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: January 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
0 comments, 510 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…
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, 660 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, 125 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…
2 comments, 196 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 1 January 2012