- 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
Creating a Linked Server to DB2
Procedure to create a linked server from SQL Server 2008 R2 via ODBC to an IBM
- A summary of the
information available on Microsoft SQL Server Books Online about Database
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
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
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
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 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
This query let's you find out how each session was classified in Resource
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
Network ports and protocols used by
Microsoft SQL Server 2005.
- Ports and Protocols Used by Microsoft SQL
- Network ports and protocols used by
Microsoft SQL Server 2000.
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
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
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