Most Recent Blog Posts

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
Screenshot showing how to setup sending email alerts
08/22/2013 - 11:38am

Sending SQL Server Database Mail Alerts via Amazon’s SES

Here's how to get SQL Server’s Database Mail functionality to work with Amazon's excellent (as in highly available and absurdly affordably) Simple....More
yellow envelope with email symbol on black computer keyboard
08/19/2013 - 3:40pm

A Better Way to Enable Email Alerts for Deadlocks

Here's a quick and easy way to enable email alerts for deadlocks, without requiring any system table modifications....More
chocolate 3 layer cake
07/26/2013 - 1:40pm

Disappointing News About SQL Server 2014

It looks like SQL Server 2014 will keep the artificially imposed limit of 64GB per instance (along with 16 cores max) for SQL Server Standard....More
traffic orange hazard lights
07/18/2013 - 1:32pm

Tracking Live SQL Server File Stalls

Given that SQL Server workloads are commonly I/O bound, a great way to get a sense for how a given server is keeping up with its current workload is....More
SQL Server Managment Studio alerts
06/26/2013 - 6:21pm

Enabling Email Alerts for SQL Server Deadlocks

Learn how to trigger email (or other) alerts when a deadlock occurs on any given Microsoft SQL Server....More
Microsoft SQL Server Profiler output screen
06/25/2013 (All day)

Debugging (Nested) Stored Procedures with SQL Server Profiler

Nested stored procedures (or stored procedures that call other stored procedures) are a mixed blessing and a curse. They also serve as powerful....More
06/18/2013 - 2:59pm

Configuring and Troubleshooting Database Mail for SQL Server

In the past I've blogged a bit about the importance of enabling your SQL Servers to be pro-active in terms of alerting you via email when something....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) ×