Most Recent Blog Posts

Exclamation marke on yellow road sign
09/09/2014 (All day)

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a....More
synchronize key on computer keyboard
09/05/2014 - 2:07pm

AlwaysOn Availability Groups and SQL Server Jobs, Part 4: Synchronizing Server-Level Details

When setting up HA or HA+DR solutions with SQL Server AlwaysOn Availability Groups, it's critical to remember that the basic unit of failover in....More
09/04/2014 - 6:01am

AlwaysOn Availability Groups and SQL Server Jobs, Part 3: Defining Batch Jobs

I commonly find that many organizations will set up regular tasks to go out and delete abandoned carts—or shopping carts that haven’t been touched in....More
Fork in walking path
08/28/2014 - 2:59pm

AlwaysOn Availability Groups and SQL Server Jobs, Part 2: Putting AlwaysOn into Context

Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high....More
start here sign
08/26/2014 - 2:53pm

AlwaysOn Availability Groups and SQL Server Jobs, Part 1: Introduction

While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from....More
SQL Server Management Studip Options screenshot
08/05/2014 (All day)

SQL Server Management Studio’s Ugly ANSI_PADDING Bug

Learn more about the problem with SQL Server Management Studio's generation of scripts with ANSI_PADDING OFF along with a helpful solution....More
Save money red computer keyboard key
07/30/2014 - 3:20pm

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Baby duck swimming alone
07/15/2014 - 12:43pm

The Marginalization of SQL Server Standard Edition

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory....More
07/08/2014 (All day)

Replication: Sometimes More is Less

The unconventionality of having two publications for complex, unruly databases typically ends up saving huge amounts of time over the long haul and....More
Red restore key on computer keyboard
06/24/2014 - 12:53pm

AlwaysOn Availability Groups and Third Party Log Readers

When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery....More
Young man smiling while working on computer
06/19/2014 - 6:01am

Stored Procedures: Still Relevant

Even if SQL Server database developers are totally committed to using ORMs, it's still worthwhile to assume that once you start storing lots of data....More
egg carton with missing brown egg
06/11/2014 - 1:04pm

Missing Indexes Correlated Against Execution Costs and Counts

Here's a query that every DBA should have in their toolbox....More
RoboCopy New Job Step screen shot
06/03/2014 - 3:05pm

Off-Box Copies of SQL Server Backups with RoboCopy

Check out what could be called a poor man's approach to getting copies of your SQL Server backups off-box and to a secondary or tertiary location....More
Time to start sign with clock and clouds in background
05/20/2014 - 1:16pm

SQL Server DBA Tip: One Time Schedules

Creating and using one time schedules represent a great way to verify if a job will work or not—without having to wait hours or days to see if you....More
New SQL Server Agent Job Step computer screen shot
05/13/2014 - 6:46pm

SQL Server DBA Tip: Credentials and Proxies

In situations where elevated permissions are needed to execute particular SQL Server jobs, or more importantly, steps within given jobs, a more....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) ×