[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Tips
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
Tips
Troubleshooting
Tuning

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 Add Features to a SQL Server Instance
This article has step-by-step instructions on how to add components or features to an existent SQL Server instance.

How to Determine Edition and Platform of a SQL 2005 Media
If the media is not properly labeled, you still can examine the SQL Server 2005 media to determine to what edition it is associated and for which platform.

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.

How to Use a Configuration File to Install SQL Server
The use of configuration files to install SQL Server helps to automate and standardize SQL Server installations. Learn on this article how to run SQL Server setup and pass it as parameter a configuration file.

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.

Microsoft products that support SQL Server Always On
Microsoft products that support SQL Server AlwaysOn. Dynamics, Lync, SharePoint, System Center family, and Team Foundation Server (TFS)
Ports and Protocols Used by Microsoft SQL Server 2000
Network ports and protocols used by Microsoft SQL Server 2000.
Ports and Protocols Used by Microsoft SQL Server 2005
Network ports and protocols used by Microsoft SQL Server 2005.

Ports and Protocols used by Microsoft SQL Server 2008
Network ports and protocols used by Microsoft SQL Server 2008.

Required Drive Performance on a Database Server
Verify the performance of a storage subsystem is appropriate for a database server.

Side Effects of Using Trace Flags
Undesirable secondary effects of trace flags when used on production environments.

Speed Up Insert Performance
Some recommendations to speed up insert performance on Microsoft SQL Server.

SQL Server requirements for System Center 2012
Microsoft SQL Server requirements for most System Center 2012 components.

SQL Server support for Data Protection Manager
What version of SQL Server is required for the DPM database? What SQL Server instances of SharePoint that can be protected by Data Protection Manager?
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.