Browse by Tags

• Core Development
• Infrastructure
• My System
• Simplify
• WSS v3

• Database Default Locations in SQL Server

  I've mentioned before the importance of using multiple "spindles" when working with large SQL Server databases. Generally speaking, the recommendation is to use different RAID 1+0 arrays for data and log files -- and depending on the size and load of Read More... Posted Thursday, December 03, 2009 6:30 AM by Jeremy Jameson | 0 Comments Filed under: MOSS 2007, SQL Server

• Environment Naming Conventions

  One of the challenges I see in organizations that I work with is the lack of naming conventions for various environments -- or sometimes naming conventions that provide little or no value. For about the last ten years, I've been a strong proponent of Read More... Posted Tuesday, June 09, 2009 5:42 PM by Jeremy Jameson | 0 Comments Filed under: My System, Simplify, MOSS 2007, Core Development, WSS v3, SQL Server, Infrastructure

• Shrinking All Database Files in SQL Server

  Here is another SQL script that I keep handy in my toolbox: Shrink All Database Files.sql . Unlike the script that I shared in my previous post that simply truncated all transaction logs to free up disk space, this script is suitable for running in a Read More... Posted Friday, May 30, 2008 7:50 AM by Jeremy Jameson | 6 Comments Filed under: MOSS 2007, SQL Server

• Copying a SQL Server Database to Another Environment

  A couple of weeks ago I was troubleshooting a performance problem with the variations feature in Microsoft Office SharePoint Server (MOSS) 2007 and I needed to copy the content database to another environment for further analysis and testing. An easy Read More... Posted Monday, October 29, 2007 7:03 AM by Jeremy Jameson | 1 Comments Filed under: MOSS 2007, SQL Server