SQL Server General DBA

Running SQL Server Jobs using a Proxy Account

In most companies, roles and responsibilities are clearly defined for the various teams, whether it is the database team, application team or the development team. In some cases, the application team might own a number of jobs but they may not have direct access or the high level privileges required to run it on the […]

Getting Started with PowerShell for SQL Server

xx

Restoring a Publisher Database in SQL Server

Introduction Restoring any database is a critical task which will be  complicated by the database to be  restored being a publisher database. For the purposes of this article, I will assume familiarity with the different types of replication and their features. All   examples in this article  are with respect to transactional replication. Let us consider […]

A High Level Comparison Between Oracle and SQL Server – Part IV

Error Log vs. Alert Log SQL Server maintains a running log of its operations. This log includes information about the start-up and recovery events, user actions, backups, configuration changes, invalid login attempts, errors, warnings etc. Every time the SQL service starts up, a new log file is created. This log file is known as the […]

A High Level Comparison Between Oracle and SQL Server – Part III

Start-up and Configuration Parameters 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 the error log file; another would contain the location of the default backup folder and so […]

A High Level Comparison Between Oracle and SQL Server – Part II

Database Instance Architecture 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 structures and processes. The area occupied in the memory by a running Oracle instance is called […]

A High Level Comparison Between Oracle and SQL Server

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 have to have a broad range of skills across a number of areas. Database professionals who […]

SQL Server 2008 R2 Multi-server Administration – A First Look

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. SQL Server Utility provides a unified view of the managed instances of SQL Server providing details such as CPU […]

An overview of Master Data Services – MDS in SQL Server 2008 R2

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 for Excel, formerly known as Project Gemini). One of the main concerns of any organization is the management […]

Upgrading SSIS 2005 packages to SSIS 2008

There are couple of enhancements in SSIS 2008 from its predecessor SSIS 2005. For example, Lookup transformation has been enhanced, development environment for Script Task and Script Component has been changed from VSA to VSTA, name of certain connection providers have changed etc. If you intend to upgrade your SSIS 2005 packages to SSIS 2008, […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |