RSS Feeds

Training Videos

Check out our new SQL Server Training Videos section More...

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest SQL Server Articles

50 Tips to Boost Performance of an ASP.NET Application - Part 2
50 Best Practices to ensure you maximize the performance and scalability of your application. Part 2 - Best Practices 26-50

50 Tips to Boost Performance of an ASP.NET Application - Part 1
50 Best Practices to ensure you maximize the performance and scalability of your application. Part 1 - Best Practices 1-25

Understanding WCF Hosting
This article examines the different hosting options for WCF.

SQL Server Logical Reads – What do they really tell us?
SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading…

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS
Learn how the Analysis Services Processing Task can be used to process analysis services objects such as cubes, dimensions and mining models.

Latest SQL Server Training Videos

Jack of All Trades Stored Procedure
A Jack of All Trades stored procedure is an extremely flexible and powerful sproc which accepts many parameters can return many different result types.

SQL Server 2008 - Resource Governor
New with 2008, Resource Governor is a very useful tool for DBA's to manage the resources that a session uses.

Table and Backup Compression in SQL Server 2008
Compression is a key new feature of SQL Server 2008. This training video features a full demo of both the table and backup compression facilities in 2008.

Policy Based Management in SQL Server 2008
Policy Management is a new feature of SQL Server 2008 which allows the DBA to manage SQL Server instances and objects across the enterprise through a set of defined policies.

Installing SQL Server
A full walkthrough on installing SQL Server 2005.

Latest Software Reviews

Spotlight on ApexSQL Diff - Server-based database comparison tool

Spotlight on ApexSQL Data Diff - Server-based database comparison tool

Spotlight on ApexSQL Doc 2008

ApexSQL Enforce

Embarcadero Change Manager

Latest FAQ's

	An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode
	XQuery [query()]: Attribute may not appear outside of an element
	Cannot find either column "%.ls" or the user-defined function or aggregate "%.ls", or the name is ambiguous.
	%sThe operator "%ls" cannot be applied to "%ls" and "%ls" operands.
	%sOnly 'http://www.w3.org/2001/XMLSchema#boolean?' or 'node()*' expressions allowed in conditions and with logical operators, found '%ls'
	XQuery: Unable to resolve sql:variable('%.*ls'). The variable must be declared as a scalar TSQL variable.
	%sSyntax error near '%ls', expected '%ls'.