When SQL Server is installed, a number of
Windows registry keys are also created. These registry keys specify various
parameters values required by the instance. For example, one registry key would
specify the location of ... [Read Full Article]
When an Oracle instance is created, it is
nothing but a collection of some structured areas in the server’s memory and
some background processes spawned to interact with it. Oracle literature quite
extensively describes these memory ... [Read Full Article]
Organisations often employ a number of
database platforms in their information system architecture. It is not uncommon
to see medium to large sized companies using three to four different RDBMS
packages. Consequently the DBAs these companies look for often ... [Read Full Article]
One of the most useful new features of SQL 2008 R2 for DBA’s
is the ability to manage and administer multiple instances of SQL Server from a
central location using the new SQL Server Utility tool.
The key new features of SQL Server 2008 R2 relate to the
management of organizations’ master data (Master Data Services - MDS ),
administration of multiple servers (SQL Server Utility), and processing large
amounts of data (PowerPivot ... [Read Full Article]
There
are several enhancements
in SSIS 2008 such as enhanced lookup transformation, the development environment for
Script Task and Script Component changing from VSA to VSTA, etc. ... [Read Full Article]
In most organizations backup
plans are implemented using full differential and transactional log
backups. The normal scenario would be take a full backup on Sunday (off peak hours),
differential backup daily at mid-night and transactional log backups on hourly
basis.
