Stay up to date with weekly industry insights

the latest trends in web design, inbound marketing, mobile strategy and more...

Dan Sales Recent Posts

Part 1: Administering SQL Server Express on AWS EC2

We start the first of a two part series on Administering SQL Server Express on AWS EC2.

Administering SQL Server Through Amazon’s Relational Database Service

We look at administering databases in Amazon's RDS and how to work around the access limitations that come with operating databases in AWS.

Using SQL Decryptor to Work With Encrypted SQL Server Objects

We look at how to get started using dbForge SQL Decryptor to work with encrypted SQL Server objects such as stored-procedures, views, triggers, or functions.

Using System Stored Procedures to Monitor Your SQL Server Instance

We look at how to use the sp_who2 and sp_monitor system stored processes to find valuable data about your SQL Server instance.

Using SQL Server Profiler to Collect Valuable Performance Metrics

We look at how to get started using SQL Server Profiler to run a trace on your SQL Server instance and collect valuable performance metrics.

Using SQL Server Activity Monitor to Learn About Resource Waits

We look at how to examine resource waits in SQL Server Activity Monitor and determine how they are affecting your SQL Server instance.

Examining Expensive Queries with SQL Server Activity Monitor

In the second part of our blog series, we look at how to use SQL Server Activity Monitor to examine expensive queries and improve performance.

Getting the Most Out of SQL Server, Part 1: Using Activity Monitor

We take a look at the valuable data that SQL Server Activity Monitor can provide when managing your SQL Server instance.

Migrating from Ektron to EPiServer: Minimum Server Requirements

We look at the minimum hosting requirements for Ektron and EPiServer and how they will affect site owners who are migrating from the former to the latter.

Terminating SQL Server Blocking Processes

Following up on a previous post about finding blocked processes in SQL Server, we share some ways to resolve these processes

The End Is Near: End-of-Life for Windows Server 2003

The End-of-Life date for Windows Server 2003 is July 14, 2015. What does this mean for your hosted servers?

Getting to Know Your WordPress Database

Learn about how a WordPress site's data is stored in the database and some common ways to update this data.

SQL Server Locks, Blocked Processes, and Two Easy Ways to Find Them

Hosting tips and tricks: learn about SQL locks and how to find the blocked processes that they can cause.

5 Best Practices for CMS Database Adminstration

These recommended best practices can help ensure the stability, security, and performance of your CMS database.

What Advantages Does Load Balancing Provide for Web Servers?

We discuss three advantages that hardware load balancing can bring to your web hosting environment: scalability, redundancy, and flexibility.