Solving SQL Server High CPU with IIS Request Filtering

July 27, 2014 / Peter Viola / IIS, SQL Server, Windows Server 2012

The other day I was troubleshooting 100% CPU utilization on a SQL Server 2008 database server. The server had 100 or so databases of varying sizes however none were larger than a few hundred MB and each database had a corresponding web site on a separate web server. Since the server hosted quite a few […]

How to Schedule Backups with SQL Server Express

November 6, 2012 / Peter Viola / SQL Server

Microsoft’s SQL Server Express is a fantastic product for anyone needing a relational database on a limited budget. By limited budget I’m talking free. Yes SQL Server Express is free but it comes with a few limitations such as only utilizing 1 GB of RAM, databases are limited to 10 GB, and it does not […]

Finding the biggest tables in a SQL Server database

September 7, 2012 / Peter Viola / SQL Server

Have you ever struggled to figure out why your SQL Server database is using so much space? If your database is hosted on a dedicated server then perhaps it’s not an issue for you. But what if your on a server with limited storage? For example if you have a web site that is on […]