SQL Server General DBA

Context Switching or Database Impersonation using EXEC AS

By default, when a user establishes a connection to SQL server, a session starts and ends when the user disconnects from SQL Server. All operations and activities during an established session are performed under the security context of the logged on user; it means SQL Server checks permission of the user to perform any operation. […]

Transfer Logins Task and Transfer Database Task in SSIS

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Execute SQL and Bulk Insert Tasks in SSIS I discussed how to use the Execute SQL and Bulk Insert tasks which are […]

Practical Database Change Management (Part 2)

Moving on from Part 1 in the Change Management series we now turn our intention to the implementation of the database change. Step 5: Supply a proper change script Again, this may sound obvious, but trust me, it isn’t. Just ask your DBA’s and I bet they can tell you some interesting war stories. But […]

Practical Database Change Management (Part 1)

Introduction For the majority of people databases are “just” a place to store and retrieve data from. Many people realize only in cases of hardware failures and/or other unplanned outages, that a software component named “database” exists and that this component prevents the systems from working. Recent evidence of this mindset can be found here […]

Execute SQL and Bulk Insert Tasks in SSIS

Introduction SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article entitled Using Data Profiler Task and FTP Task in SQL Server 2008 Integration Services I discussed how to use the Data Profiling Task […]

Container Tasks in SQL Server 2008 Integration Services

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform extract transform & load (ETL) operations. SQL Server Integration Services has come long way since the early days of Data Transformation Services (DTS) which was initially introduced by Microsoft in SQL Server 7.0. Most […]

Analyzing SQL Server Permissions

One of the most important responsibilities of a SQL Server Database Administrator is to ensure that the managed SQL Servers instances are completely secure. Securing SQL Server is not as simple as ensuring that the unused features of SQL Server are not enabled unless required. The last article titled Surface Area Configuration Using Policy Based […]

Surface Area Configuration Using Policy Based Management

The SQL Server Surface Area Configuration Tool (SQLSAC) was a utility introduced by Microsoft in SQL Server 2005 to help SQL Server Database Administrators or Developers manually turn on features which are off by default in the product. The previous article titled Using the SQL Server 2005 Surface Area Configuration Tool explains how database administrators or […]

New Features in SQL Server 2008 Management Studio – Part 3

The article titled New Features in SQL Server 2008 Management Studio – Part 1 discussed new features such as Activity Monitor, Intellisense Support and Region Outlining that are available in SQL Server 2008 Management Studio. The second article New Features in SQL Server 2008 Management Studio – Part 2 discussed more new interesting features such as […]

New Features in SQL Server 2008 Management Studio – Part 2

The previous article titled New Features in SQL Server 2008 Management Studio – Part 1 discussed some of the new features available in SQL Server 2008 Management Studio; namely Activity Monitor, Intellisense Support and Region Outlining. This article continues to explore the new features available within SQL Server 2008 Management Studio (SSMS).  These features can be used by database […]
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 |