SQL Server Articles


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

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

Upgrade SSIS 2005 Packages to SSIS 2008

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. If you intend to upgrade your SSIS 2005 packages to SSIS 2008 it may be a challenging task especially if it uses the Script Task or Script Component […]

Windows Server 2008 Print Management

xx

ASP.NET 4.0 – New Features

By Joydip Kanjilal and Bhupali Khule ASP.NET 4.0 is neither a revolutionary change nor a refactoring of the existing ASP.NET. Instead, it consists of a number of small-scale changes that allow developers to have a strong control of certain frequently used events. What makes ASP.NET 4.0 more effective than the already existing versions of ASP.NET […]

Using The Data Mining Query Task in SSIS

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 Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS I discussed how to use the Analysis Services Processing Task to […]
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 |