SQL Server Database Administrator

A recovery model is a database configuration option that controls how transactions are logged, whether the transaction log is backed up, and what restore options are available for the database. The recovery model you choose for your database has both data recovery implications and performance implications, based on the logging the recovery model performs or doesn’t perform. There are: Simple recovery model Full recovery model Bulk-Logged recovery model  --Configure Recovery Models SELECT name, recovery_model_desc FROM sys.databases alter database dbname set recovery full /*Full recovery is the recommended model for a production database because it provides the most recoverable configuration. If you import data periodically by using a bulk mechanism, you can temporarily change the recovery model for your database to Bulk-Logged to get better bulk-load performance. Then, when the import process ends, return your database to the Ful...

To enable macros in Microsoft Excel 2007  Step 1.       Open Excel 2007 and click the Office button in the upper left corner of the screen. At the bottom of this menu, click the Excel Options button. Fig 1: Step 2.        Click the  Trust Center  button on the left. Then, at the bottom right, select  Trust Center Settings Fig 2: Step 3.   In the new window that appears, choose Macro Settings from the sidebar and select Disable all macros with notification from the list of options that appear. This option keeps macros disabled but notifies users when macros attempt to run, allowing users to decide on a case-by-case basis which macros to enable. Click OK to exit this window. Fig 3: Step 4. For the new settings to take effect, it will be necessary to close Excel and reopen it. A security dialog box should appear beneath the Office...

To know the Product version  and Service Pack of installed SQL Server . Run the Query select 'Version',@@version union all select  'Product' ,serverproperty('product') union all select 'Productlevel',serverproperty('productlevel') union all select 'Product Version',serverproperty('productversion') union all select 'Edition',serverproperty('edition')

How to install SQL Server 2005 step by step