[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 
Tips

 

 

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

Tips related to SQL Server and SQL Server tools installation, repair and removal.
 


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 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 manually uninstall SQL Server
This article has step-by-step instructions on how to uninstall all versions of SQL Server and how to troubleshoot issues that may arise while uninstalling SQL Server.

How to manually uninstall SQL Server 2005
Procedure to manually uninstall a failed installation of Microsoft SQL Server 2005.

How to Manually Uninstall SQL Server Compact 4.0
Procedure to manually uninstall SQL Server Compact when you are unable to uninstall due to errors like ''preparing file location''.
 
How to Manually Uninstall SQL Server Management Studio.
Learn how to manually uninstall SQL Server Management Studio versions 18 and 19.

How to Repair SQL Server Management Studio
Learn how to repair SQL Server Management Studio for troubleshooting when it stops working or crashes.

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.

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

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

 

Other 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.

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

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.

Running SSIS packages from the Command Prompt.
Learn how to use DTEXEC to run SSIS packages from the Command Prompt.

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 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.