Import website (IIS) logs into SQL Server using Log Parser and PowerShell
Here's a little PowerShell script I whipped up to import the TechnologyToolbox.com log files into a SQL Server database for some "quick and dirty" analysis.
There are 18 entries for the tag SQL Server.
Here's a little PowerShell script I whipped up to import the TechnologyToolbox.com log files into a SQL Server database for some "quick and dirty" analysis.
In this post, I'll show you how I quickly restore the Production database for TechnologyToolbox.com to the corresponding Development and Test environments...
A little more than three years ago, I blogged about the default recovery model for various SharePoint databases . In that post, I described how I would often toggle the SQL Server databases in SharePoint development environments from the default Full...
One of the "good habits" I've developed over the years while creating applications is scrutinizing the interaction between logical or physical tiers. Given the nature of solutions that I'm typically involved with, this often involves examining how many...
When upgrading Team Foundation Server (TFS) -- or, really, any application that utilizes SQL Server Reporting Services -- you might choose to restore your data to a new environment (for example, to migrate to new hardware, or to validate the upgrade in...
A little over two years ago, I wrote a post about installing Visual Studio 2005 Service Pack 1 , in which I mentioned setting the MaxPatchCacheSize registry setting to 0 (in order to save some significant disk space while installing the service pack)...
I've been a bad blogger this month. Almost a month ago, I wrote a post about using Web standards with Microsoft Office SharePoint Server (MOSS) 2007 , but I noted that there would be more to come on that subject in the near future. Well, almost a full...
Yesterday we encountered a bug while trying to deploy a new SQL Server database from a Visual Studio database project using the VSDBCMD.EXE utility, following the prescriptive guidance on MSDN: How to: Prepare a Database for Deployment From a Command...
For a little over a month, Windows Update was failing on one of the servers in the "Jameson Datacenter" (a.k.a. my home lab). Specifically, KB 970892 simply would not install on JUBILEE -- my Systems Center Operations Manager (SCOM) 2007 VM, that I use...
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...