Tips.

Back Up the Reporting Services Encryption Key
Procedure to back up the encryption key for Microsoft SQL Reporting Services.

Configuring Antivirus for MSSQL servers
Known and possible issues with antivirus software. Exclusions from virus scanning.

Creating a Linked Server to DB2
Procedure to create a linked server from SQL Server 2008 R2 via ODBC to an IBM DB2 database.

Database Snapshots

A summary of the information available on Microsoft SQL Server Books Online about Database Snapshots.

Determining  Server Name using T-SQL
How to determine the Server Name using T-SQL.

Hardware Sizing Microsoft SQL Server
Resources to help determine hardware needs for Microsoft SQL Server deployments.

How to Disable SSL on Reporting Services
These are detailed steps to disable SSL (Secure Sockets Layer) on SQL Server 2005 Reporting Services.

How to install SQL Server 2005 SP3
SP3 setup requirements, pre-installation tasks, installation, post-installation tasks.

How to install SQL Server 2008 SP2
SQL Server 2008 SP2 setup requirements, pre-installation tasks, installation, post-installation tasks and rollback plan.

Installing Umbraco CMS with Microsoft SQL Server
Umbraco is an open source content management system based on .NET technology that works on IIS and uses Microsoft SQL Server.

Know What Sessions Were Assigned to Each Workload Groups
This query let's you find out how each session was classified in Resource Governor.

Microsoft Atlanta
Cloud-tool for monitoring the configuration of SQL Server instances.

Ports and Protocols Used by Microsoft SQL Server 2000

Network ports and protocols used by Microsoft SQL Server 2000.

Using Transact-SQL for Full-text Indexing in SQL Server 2005

Useful t-sql statements when working with full-text indexing

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.