The list of builds for SQL Server 2008 R2 up to CU12 for SP1 and CU6 for SP2.  Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render?  Read more...

This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.  Read more...

Amazon now offers SQL Server 2008 R2 in their RDS service. It's an easy way to get working with SQL Server with a minimal investment.  Read more...

Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)  Read more...

This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.  Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

A list of SQL Server 2008 R2 Data Types and Storage Sizes.  Read more...

Read more...

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.  Read more...

This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.  Read more...

This article will show you how to install SQL Server on to a Windows Core Server host.  Read more...

The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.  Read more...

As your business grows, the number of applications grows as well, as do the SQL Server instances to support these applications. As a SQL DBA, you need to have a multi-server management dashboard that proactively tells you about the resource utilization on each SQL Server instance.  Read more...

Find out what you need to learn for the SQL Server 2008 Administration certification exams.  Read more...

The list of builds for SQL Server 2008 R2 up to CU12 for SP1 and CU6 for SP2.  Read more...

The list of builds for SQL Server 2008 R2 up to CU12 for SP1 and CU6 for SP2.  Read more...

Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.   Read more...