SQL Server security best practice

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

3/30/2009

2009 PASS SUMMIT UNITE

Its a time to get register for the great event, yes I am talking about the the SQLPASS Summit 2009 event to be happen during Nov 2~5 at Seattle; there are lots of saying about this event and there are more then single good reason to join the event explore the reasons "Why to attend SQLPASS SUMMIT?"Get the full details of 2009 PASS Summit UNITE and get registeredGet early bid rate, do register for your seat at 2009 SQL PASS Summit UNI...

TechNet Webcast: SQL Server 2008 Capabilities for Meeting PCI Compliance Needs

There will be a web cast on SQL Server 2008 Capabilities for Meeting PCI Compliance Needs at 1 PM Pacific Time, get registerhttp://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032404173&EventCategory=4&culture=en-US&CountryCode=...

3/27/2009

Download SQL Server 2005 SP3

SQL Server 2005 SP3 has been released, download SQL Server 2005 SP3 hereSQL Server 2005 SP3 can be applied on below SQL Server editions:* SQL Server 2005 Enterprise * SQL Server 2005 Enterprise Evaluation * SQL Server 2005 Developer * SQL Server 2005 Standard * SQL Server 2005 Workgroup...

3/19/2009

Change the Collation setting in MS SQL Server

How to Change the Collation Settings for specific database or how to change the Collation Settings for specific column? This question can be found multiple times on the ms sql server forums, so I've decided to pen down it on the,Simple!! Once can use Alter Database command to change the collation settings for the specific database, below is the command you've to execute: ALTER DATABASE testDB COLLATE French_CI_AI ; GO     photo...

How to know version of MS SQL Server

"How to check which version of SQL Server I am on" this is a commonly asked question in SQL Server community; I have created a script which can be run in MS SQL Server 2000 and MS SQL Server 2005 you may download script from hereread complete FAQ on it he...

3/09/2009

Community launched | Surat SQL Server User Group | DotNetChaps

Hi,We have formed a Technical Community User Group. The aim of this User Group is to share/exchange what all we have in terms of the knowledge.We have two separate forums for MS SQL and for Dot Net technology to avoid confusion. You may post all your queries pertaining to MS SQL at http://www.surat-user-group.org and if you are having a query in .Net (be it asp .net, c# or vb .net) please post it to http://tech.groups.yahoo.com/group/DotNetChaps/http://www.surat-user-group.org is having an association with SQLPASS (http://www.sqlpass.org)...