Place where I Live

Read More

Difference between Stored Procedure and Function (UDF)

Functions

• can be used with Select statement


• Not returning output parameter but returns Table variables


• You can join UDF


• Can not be used to change server configuration


• Can not be used with XML FOR clause


• Can not have transaction within function

Stored Procedure

• have to use EXEC or EXECUTE


• return output parameter


• can create table but won’t return Table Variables


• you can not join SP


• can be used to change server configuration


• can be used with XML FOR Clause


• can have transaction within SP

Read More

New Version Microsoft SQL Server 2005 SP2 and Books On Line release

New version of SQL Server 2005 SP2 & SQL Server 2005 Books Online (BOL) released and now available at http://www.microsoft.com/sql/sp2.mspx

Read More

Disappearance of Jim Gray

Hi,
If you are participating in community activity regularly you must aware of Jim Gray a great guy, he is disappear near Farallon Islands: Help searching Jim Gray, a known Database Guru
http://blogs.msdn.com/dtjones/archive/2007/02/03/how-you-can-help-in-the-search-for-jim-gray.aspx

Read More

Remote Deployement of SQL Server

Hi All,

When it comes to deploying a SQL Server Remotely with Sharepoint service, we just think and search around to get the answer how do i?!!!

Here is a very good article on the Remote Deployment of SQL Server with Sharepoint Services, Refer http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc02.mspx?mfr=true for more.

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"

Disclaimer: This postings is provided "AS IS"

Read More

SQL Server : TO Blob or Not

Hi All,

In many community forums i participated i found many users ask a querstion on BLOB datatype. That is "Is it okay if i do store binary files / images / documents store in SQL Server Database?" . The answer is no.....it is always good to store the location of the Binary Files or Documents Or Images and let it handled by Front End application. Here is a wonderfull research paper published on Microsoft Site http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"

Disclaimer: This postings is provided "AS IS"

Read More

New Year Gift from Microsoft

Hi All,
I am honored Microsoft Most Valuable Professional in Windows Server System - SQL Server Competency for year 2007. A wonderfull gift from Microsoft.

Hemantgiri S. Goswami

Read More

"Katmai" - Next Version of SQL Server

Hi All,
Microsoft officials has announced in their blog at ZDNET website, They code name it "Katmai" that would be next version of Microsoft SQL Server and that's not just a SQL Server but more then that. Read more on it http://blogs.zdnet.com/microsoft/?p=217

Regards
Hemantgiri S. Goswami
Microsoft SQL Server MVP
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"

Disclaimer: This postings is provided "AS IS"

Read More

Disclaimer

This post confirms my ownership of the site and that this site adheres to Google AdSense
program policies and Terms and Conditions

-- Hemantgiri S. Goswami

Read More

Change Authentication Mode with Registry

Hi,
What if we need to change / read / write some registry entry in Server but we donot have access to server!!!! but at the same time we do have SA/Admin privilege on SQL Server (Assuming we need to change registry settings on SQL Server itself ) for example while setting up SQL Server they have installed SQL Server with *Mixed Authentication Mode* and now we need to change it to *Windows Only Authentication Mode* to do so from Query Analyzer we do have xTended Store Procedure to help us they are xp_regread and xp_regwrite
For an instance assume that your Authentication Mode is set to *Mixed Authentication Mode* to read it run below query in QA if it shows ‘0’ or '2' means that authentication mode is Mixed

EXECUTE master..xp_regread
'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'LoginMode'

Now if we wants to change it to *Windows Only* run below query in QA

declare @md int

set @md=1

EXECUTE master..xp_regwrite

'HKEY_LOCAL_MACHINE',

'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',

'LoginMode', 'reg_dword', @md

This will make changes in your Registry and change your *Authentication Mode* also.

Disclaimer : In the example above both the xTended Stored Procedure used are Undocumented so use it at your own risk and please check for its availability / support before using it.

This posting is provided * AS IS * for the shake of knowledge sharing only.

Read More

SQLServerSearch

Loading

Read More

About

Hemantgiri S. Goswami is SQL Server Specialist and Consultant, he is former SQL Server MVP. Hemantgiri is contributing to the SQL Server Community by participating in various SQL Server forums, authoring articles at:

http://www.surat-user-group.org/

http://www.sql-server-performance.com/

http://forum.sqlknowledge.com/  

http://www.sqlserver-qa.net/

http://www.experts-exchange.com  

Hemantgiri is founder and leader of the Surat User Group which primarily focusing on SQL Server and Windows OSs.

Hemantgiri S. Goswami Blogs at SQL Server Citation recent he has started writing on SQL Server in his native language Gujarati visit SQL Server Citation - Gujarati . Hemantgiri was awarded Most Valuable Professional (MVP) award by Microsoft for his contribution to the SQL Server Community.

Read More

Contact

Read More

Change settings for Welcome Screen in Windows XP

Hi,
its vulnerable to bypass welcome screen, i don't suggest to use this option but as you don't wants it you may either use standard method of login by hitting
CTL+ALT+DEL ,
start-> settings-> control panels-> administrative tools-> Local Security Policy-> Security Options-> Interactive Logon :do not require CTL+ALT+DEL --(Change the value to ENABLE)

or do a trick with
Start-> Settings-> Control Panel-> User Accounts

This postings provided AS IS

Read More

MS Released SQL 2005 Everywhere Edition CTP

SQL Server Everywhere Microsoft SQL Server 2005 Everywhere Edition CTP available :
http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en

Read More