Mathom Solutions Blog-IT

links for 2009-11-06

swjohnson.nospam@nospam.mathomsolutions.com (swjohnson) — Fri, 06 Nov 2009 17:04:03 -1300

SQL Server 2008 Diagnostic Information Queries - Windows Live | Glenn Berry

It is a set of pretty heavily commented queries that are very useful for detecting and diagnosing many common performance issues with SQL Server 2008.

(tags: sql2008 performance)

links for 2009-11-05

swjohnson.nospam@nospam.mathomsolutions.com (swjohnson) — Thu, 05 Nov 2009 17:33:49 -1300

Cheat Sheet and Quick Reference Card Directory | devcheatsheet.com - Cheat Sheets for Developers.

A very large repository of various free cheatsheets, reference cards for developers, programmers and network admins. Includes subjects such as Programming Languages, Markup Languages, Query Languages, Libraries and Frameworks, Operating Systems, Version Controls, Databases, Applications, Security and others.

(tags: cheatsheets)

links for 2009-10-31

swjohnson.nospam@nospam.mathomsolutions.com (swjohnson) — Sat, 31 Oct 2009 17:02:20 -1300

Suggested Max Memory Settings for SQL Server 2005/2008 | SQL Server Central

Make sure you set the Max Server memory setting for SQL Server 2005/2008 to something other than the default setting which allows SQL Server to use as much memory as it wants (somewhere in the neighborhood of 2TB). This is very important with larger, busier systems that may be under memory pressure.

(tags: sqlserver memory)

links for 2009-10-30

swjohnson.nospam@nospam.mathomsolutions.com (swjohnson) — Fri, 30 Oct 2009 17:06:52 -1300

SQL Server Setup : Creating a merged (slipstreamed) drop containing SQL Server 2008 RTM + Service Pack 1

How to slipstream or combine SQL 2008 RTM and SP1 into one install file.

(tags: sqlserver update)

links for 2009-10-27

swjohnson.nospam@nospam.mathomsolutions.com (swjohnson) — Tue, 27 Oct 2009 17:04:16 -1300

SQL Server Version Database | SQLSecurity.com

Listing of the various SQL Server versions and links to the KB/Patch.

(tags: sqlserver versions)