|










| |
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.
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.
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.
- Using Transact-SQL for Full-text Indexing in
SQL Server 2005
- Useful t-sql statements when working with full-text indexing
|