Contents tagged with SQL Server
-
Solving SQL Server High CPU with IIS Request Filtering
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 databases the high CPU needed to be resolved quickly because it was causing issues for everyone. High CPU on a database server can often be symptomatic of a issues occurring outside the server. In this case the real issue was in fact being caused by a SQL Injection attack on a web server.
-
Upgrading SQL Server 2008 Express to SQL Server 2012 Express
Microsoft's free SQL Server Express is the perfect relational database for any one on a budget. With a 1 CPU limit and 10 GB database size limit it is more than capable of handling the average user's needs. SQL Server 2012 has been out for a while and upgrading from a legacy version couldn't be easier. Here's a recent blog post I did on upgrading from SQL Server 2008 Express to SQL Server 2012 Express:
-
How to Schedule Backups with SQL Server Express
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 include SQL Profiler. For low volume sites that do not need enterprise level capabilities, this is a compelling solution. Here is a complete SQL Server feature comparison of all the SQL Server editions.