Download free Database Tools

At times we need to analyze the Size of the Database, or have to search the Object or Content in the Database, we always query system tables or create a script for self and some times we uses sp_depends,Query Analyzer and EM or SSMS but it has some limitations.

To reduce this effort we often try some third party softwares and we know that they comes at cost. Mohamed Bouarroudj of  SQLDBTOOL has 3 software to help us out and yes they are FREE!!! There are 3 tools he has developed SQLDBDiff, SQLDBSearch and SQLDBSize.

1. SQLDBDiff:  compares the schema and the data of SQL Server databases. SQLDBDiff supports SQL Server 2008, 2005 and 2000. Download SQLDBDiff from here 


2. SQLDBSearch:  find any object by its name or content in one or many SQL Server databases. SQLDBSearch supports SQL Server 2005 and 2000. Download SQLDBSearch from here


3. SQLDBSize: display size used or reserved by tables, indexes, databases, transaction logs and physical files graphically. Download SQLDBSize from here

Read More

Index Defregment Best Practice

Here is the best article on Index Defregment Best Practice published on Microsoft Web Site

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Hemantgiri S. Goswami

Microsoft SQL Server MVP

Technorati Tags: Microsoft, SQL Server, Index Defregment, Best Practice

powered by performancing firefox

Read More

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