Archive for June 2009
Changing Collation of SQL server Database
Posted by: Manpreet Singh on: June 30, 2009
As we all know that collation is a important part of Sql server storage engine. The collation defines who data is stored in Sql Server. The physical storage of character strings in Microsoft® SQL Server™ is controlled by collations. A collation specifies the bit patterns that represent each character and the rules by which characters [...]
SQL Installation Server Setup Checklist
Posted by: Manpreet Singh on: June 26, 2009
Before Install
Create at least one new Active Directory account for SQL Server.
This is best practices, and a popular shortcut is to run all of the database servers under the same service account. I’ve run into two problems with this approach. First, I’ve had a sysadmin repeatedly fat-finger the service account password, thereby locking out [...]
ISCSI and SQL Server
Posted by: Manpreet Singh on: June 22, 2009
ISCSI is a great new technology in the world of storage. It is the standard which provide storage interface by carrying SCSI command over TCP/IP network. It helps organizations to consolidate storage and provide host with a illusion of locally – attached disk storage. Microsoft fully supports Microsoft SQL Server when it is deployed on [...]
Understanding SQL Server Database Restore Process
Posted by: Manpreet Singh on: June 1, 2009
Restore is very important part of whole database administration process. Understanding the internal working of restore process helps administrators to create disaster recovery processes for organizations. Restoring a SQL database is the process of using full or differential backup files and their subsequent Transaction log files to roll the database forward to a certain point. [...]
