SQL Server security best practice

Security! This is the word comes in mind of every concerned person when it come...

11/23/2006

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_regwriteFor an instance...

SQLServerSearch

Loading google.load('search', '1', {language : 'en'}); google.setOnLoadCallback(function(){ var customSearchControl = new google.search.CustomSearchControl('010232843459758051198:qdjwgrri5kk'); customSearchControl.setResultSetSize(google.search.Search.LARGE_RESULTSET); customSearchControl.draw('cse'); }, true)...

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

11/12/2006

Contact

Loading....

8/02/2006

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 hittingCTL+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 withStart-> Settings-> Control Panel-> User Accounts This postings provided AS ...

7/06/2006

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

7/05/2006

Securing Microsoft SQL Server

Hi,their are several ways to secure your SQL Server1). Strengthen Password Mechanism2). Using NTFS File System3). Change the Port of SQL Server other than default4). Use named instance5). Set firewall6). Using Windows Authentication7). Using EFSi would suggest to refer below links for more :http://vyaskn.tripod.com/sql_server_security_best_practices.htmwww.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx -- C2 Audithttp://www.sql-server-performance.com/ck_database_encryption.asp http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp...

7/01/2006

Login fail for user %s

Hi,if you get an error message like "Login fail for User %s , not associated with trusted connection"here is a KB for your reference.http://support.microsoft.com/kb/889615http://support.microsoft.com/kb/555332/en-usThis posting provided AS ...

Upgrade help to SQL Server 2005

Hi,here is a reference article for those who wants to upgrade to SQL Server 2005http://www.microsoft.com/technet/prodtechnol/sql/themes/default.ms...

Microsoft SQL Server 2005 SP 1.0

Hi,MS released Service Pack Version 1.0 for SQL Server 2005 ,here is download linkhttp://www.microsoft.com/downloads/details.aspx?FamilyID=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC&displaylang=...

Download BPA for Microsoft SQL Server 2000

Hi,here is a download link for Best Practices Analyzer Tool for Microsoft SQL Server 2000 1.0http://www.microsoft.com/downloads/details.aspx?displayla%20ng=en&familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=...

Handling Deadlock in Microsoft SQL Server

Hi,I have found wonderfull KB for handling deadlock conditions in SQL Serverhttp://support.microsoft.com/kb/118552/en-us just F...

Not associated with a trusted SQL Server connection

You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005http://support.microsoft.com/kb/889615/en-...

Microsoft SQL Server doesn't exists or access denied

Hi,whenever you get an error like "SQL Server does not exists or access denied"refer below KBhttp://support.microsoft.com/kb/328306/en-...

Troubleshoot Microsoft SQL Linked Server

Hi,this is a KB for How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server http://support.microsoft.com/kb/306212/en-...

Authentication Method Troubleshooting in ASP / SQL

Dear all,here is a KB link FYI for Authentication methods for connections to SQL Server in ASPhttp://support.microsoft.com/kb/247931/en-...

3/07/2006

Cause for T-Log become Full and how to reduse it

Hi,i would suggest to refer below KBs and threads ,for cause of Transaction Log becoming full and how to reduce Locks and how to stop it :Causes of SQL Transaction Log Filling Uphttp://support.microsoft.com/?id=110139http://www.support.microsoft.com/?id=317375How to stop the transaction log of a SQL Server database from growing unexpectedlyhttp://support.microsoft.com/?kbid=873235and threads:http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/391579b8149281a4/b40ed8742075475d#b40ed8742075475d?sa=X&am...

2/21/2006

GMAIL Drive

Hi All,today when i googling i reckon for GMAIL Drive , i google it to find out that still project is continue or not here is a link for GMAIL Drive project on source forge http://pgd.sourceforge.net/ and http://www.viksoe.dk/code/gmail.htm its damn easy working with this you can backup your important document with this tool , it provides funcationality for backup of documents by just drag and drop...

2/19/2006

MSN Screen Saver

Hi,Today i have download MSN Screen Saver, you can personlized it the way wants you can add RSS feeds as per your choice , you can the whether information of your city,can display photos,can see news also.... nice Screen Save...

2/10/2006

A Web Forum for IT Professional and Student

Dear All,we have started a Web Forum for IT pepole , out main goal is to serve our best to the society , students of the IT Colleges and IT Professionals by this we can share the knowledge and help peers and offcourse we can also learn something new.Hope you will also enjoy with us ....I must give credit to my friend Neelesh Desai to support me to host the Web Forum on his website , Developement team of the Snitz to develop such a good software.here is a URL of our Forum hosted Aastha Computershttp://www.aasthacomputers.com/forum or...

2/09/2006

Auditing MS SQL DML Statements

Hi,i have wrote an article on "Auditing MS SQL DML Statements" , how to Audit insert / update / delete statements to get information from which system and who execute the statements , this will gives you power to audit your database without third party software. It uses INSERTED and DELETED tables to get the records that are updated/deleted and inserted.click here to read full articl...

Backup Non System Database at Once

Hi,To take backup of MS SQL Non System Database at once, i have wrote a small script for that , click here to read MS SQL Script...