SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

Understanding Scans And Seeks

There is a popular theory on scans and seeks: “Scan reads through the object (table/index) from top to bottom looking for the records that it needs while seek goes directly to the part of the object that it needs and reads to where the data that it needs ends. This is obviously a must more […]

SQL Server Security Audit (Part 2) – Database Level Audit

Once the Server Level audits described in Part 1 of the Security Audit series are complete, databases should be considered next. A number of steps can be taken to audit database level security. Database owners A database owner can perform any action in the database. This includes granting access rights to the database to other users. […]

SQL Server Analysis Services ( SSAS ) – Introduction

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. Analysis Services supports OLAP by letting the user design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. For data mining applications, Analysis Services lets the […]

SQL Server Security Audit (Part 1) – Server Level Audit

Although security is a major component of database administration, it is sometimes overlooked in favour of convenience. User accounts are given elevated permissions to save time, patches and hot-fixes are not applied timely and best practices are often not followed. Over time, the server becomes vulnerable to potential breaches of security. As the DBA, you […]

Using Transfer SQL Server Objects Task and Execute SQL 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 Transfer Logins Task and Transfer Database Task in SSIS I discussed how to use the Transfer Logins Task and Transfer Database Task […]

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 […]
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 |