SQL Server Articles

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 Container Tasks in SQL Server 2008 Integration Services I discussed the different types of container tasks such as For Loop Container, Foreach Loop [...]

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

A commonly altered setting is Maximum Degree of Parallelism (MAXDOP), which controls the maximum number of CPUs that can be used in executing a single task. For example, a large query may be broken up into different parts, with each part executing threads on separate CPUs. Such a query is known as a parallel query. [...]

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

SQL Server Integration Services (SSIS) is a Business Intelligence tool used by database developers or administrators to perform extract transform & load (ETL) operations. SSIS 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 database developers and administrators had their [...]

This article will describe the following Ajax extension related controls: ScriptManager, ScriptManagerProxy, Timer, UpdatePanel, UpdateProgress and List View in ASP.NET 3.5.  The article will be divided into two parts; the first section covering Ajax extension related controls and how these controls have fundamentally change the approach of web development, the second will cover the List [...]

A SQL Server database administrator (DBA) will be aware of server enhancement techniques to ensure the smooth running of the servers. Being aware of enhancement options available enables to DBA to provide the best server performance to users and clients without interruptions or outages. The ability to identify the faulty component in a SQL Server [...]

Introduction Previously discussed was how to integrate SQL Server Analysis Services (SSAS) with Excel 2007 in the article, Accessing Cubes from Excel 2007. Visio 2007 is another tool available in Office 2007 that can be used to connect to a SSAS database. There are two reasons why Visio is not an automatic choice to connect [...]

There are several factors that affect the performance of an application. This includes SQL Server (the program itself), the SQL Server configuration settings, the application’s Transact-SQL Code, the operating system (server and client), the hardware (server and client), the network hardware and bandwidth (LAN and WAN), the number of clients, client usage patterns, type and [...]

VSTA support for Script Task and Script Component Unlike SQL Server 2005, SQL Server 2008 provides VSTA (Visual Studio Tools for Applications) environment for writing Script Tasks and Script Components instead of VSA (Visual Studio for Applications) environment. VSTA includes all the standard features of the Visual Studio environment, such as the color-coded Visual Studio [...]