Most Recent Blog Posts

01/29/2014 - 12:21pm

IPMuncher for Internet Facing SQL Servers

IPMuncher is a fantastic tool that offers simple functionality, great flexibility, and easy configurability—meaning that it can be used to tackle a....More
01/24/2014 - 6:08pm

The Value of a Good SQL Server Book

I’ve learned a lot about SQL Server in the past 14 year—and continue to learn more about it every day as I troubleshoot tons of problems and issues....More
12/30/2013 - 9:02pm

My Favorite Tool of 2013: CloudBerry Backup - Server Edition

I’ve increasingly been bumping into clients with the need to find a dependable, configurable, durable, and secure off-site backup mechanism and....More
12/27/2013 - 7:14pm

Cycling (and Retaining) SQL Server Logs

While it is cool to see a SQL Server running for months at a time, that ‘coolness’ is lost when everything during those 100+ days has been logged to....More
virus detected message on computer screen
12/19/2013 - 12:45am

Another Reason to Avoid Anti-Virus on SQL Server

If you install anti-virus on SQL Server, many 'bigger' anti-virus vendors either offer 'options' that let them 'monitor' SQL Server—or just plain....More
11/26/2013 - 2:53pm

Setting Up Alerts for Long-Running Transactions

Learn how to set up alerts for long-running SQL Server transactions....More
11/19/2013 - 1:47am

Common SQL Server AlwaysOn Gotchas

As part of my "5 Common Gotchas with SQL Server AlwaysOn" presentation, I mentioned that I'd provide a links and additional resources as a follow up....More
scary ghoul
10/31/2013 - 5:15pm

SQL Injection: Something Really Scary

As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-....More
Tired old dog on laptop.
10/29/2013 - 1:05pm

SQL Server and Health Checks: A Slightly Different Take

Physical health is important for database professionals. Mentally, we do lots of heavy lifting....More
man in a datacenter explaing sql server performance
10/22/2013 (All day)

Creating Simple Performance Baselines with SQL Server Profiler

Use SQL Server Profiler to create a performance baseline and then measure performance metrics that you can compare against the baseline....More
09/30/2013 - 1:03pm

SQL Server Authentication on Internet Facing Servers

If you’ve got a SQL Server that's publicly facing, make sure you've done everything you can to make it as secure as possible....More
database related words
09/24/2013 - 8:31pm

Truncating SQL Server Job History

A common maintenance task that many 'reluctant DBAs' commonly overlook is the need to keep historical information in the msdb database trimmed, or '....More
Seattle, Washington sunset over ocean
09/10/2013 - 3:39pm

Microsoft’s Retirement of the Certified Master Program

Microsoft Learning has made the decision to retire (or kill) a certification process and the SQL Server community has mostly reacted with shock and....More
08/30/2013 - 12:37pm

Database Mail Tip: Notifying Operators vs. Sending Emails

I recently discovered that to improve SQL Server's Database Mail functionality, it's more effective to send alerts and notifications to Operators....More
08/27/2013 - 12:48pm

SQL Server Tip: Assign Ownership of Jobs to the SysAdmin Account

For most of your SQL Server Agent jobs, make sure that as the jobs are created or modified, that you specify that 'sa' (or the built-in SysAdmin)....More
Contributors

Michael K. Campbell

Michael K. Campbell is a contributing editor for SQL Server Pro and Dev Pro and is an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism...
What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×