What’s new on SQL SERVER 2008 SP3
Microsoft SQL Server Sustained Engineering group is pleased to announce the release of SQL Server 2008 Service Pack 3. Both the Service Pack and Feature Pack updates are available for download on the…
SQL Server Execution Context and Security
What is Execution Context? Whenever a user connects to SQL Server, it will create the User Session called Execution Content which has the all the user access details and whenever that user execute…
Moving tempdb to a new location
The following example moves tempdb from its current location on the disk to another disk location. Because tempdb is re-created each time the MSSQLSERVER service is started, you do not have to physic…
SQL Server Service Accounts
Service account for Files and folders Access MSSQLServer Instid\MSSQL\ba…
What is Database Mirroring
In the proposed database mirroring solution there will be two groups of active-passive windows clusters deployed at each location (PRIMARY SITE and Secondary Site). The Primary Site will be the prima…