Training and Instruction

I love SQL Server. I also love sharing what I've learned. To that end, I really enjoy speaking and presenting.

SQL Server Videos

SQLServerVideos.com is a site that features over 4 hours of free, top-notch, video training. Visitors to the site can learn how to use SQL Server, see tips and tricks, and increase their understanding by watching free 10-15 minute videos with no strings attached.

SQLServerVideos.com represents both an example of my love of teaching and instruction, as well as an overview of my approach to detail as videos on the site are accompanied by links to additional, relevant, resources that help viewers continue learning after they complete each video.

Past Presentations and Events

Essential Skills for SQL Server DBAs

SQL Server Pro eLearning Series

December 18, 2013 - On-Demand Registration ($119/attendee)

Whether you are considering a new career as a DBA or have been reluctantly thrust into the DBA role within your organization, becoming a successful DBA requires significant skill, effort, and determination. To succeed as a DBA, you must competently juggle an attention to detail, solid technical prowess, a strong sense of organization, and a real knack for interacting with people. Learning the ins and outs of these requirements takes time. But when guided by experts who’ve succeeded as professional DBAs, you can more quickly gain insights into how to successfully address these issues more efficiently.

Therefore, if you're drawn to the challenges of being a DBA – or just need to learn where to start when it comes to managing mission-critical data and all the dependencies that have been thrust upon you – you'll want to join independent SQL Server expert (and former DBA), Michael K. Campbell for an informative, insightful, three-part eLearning seminar that covers essential Skills that every SQL Server DBA should know.

This eLearning series will meet for three sessions (approximately 75 minutes each):

  • 1st Session: Core Tasks and Responsibilities for DBAs
  • 2nd Session: Disaster Recovery and Data Availability
  • 3rd Session: Managing SQL Server Performance

Archived sessions will be available 24 hours after the end of the live event.

Practical SQL Server 2012 Improvements for Businesses

SQL Server Magazine eLearning Series

April 26, 2012 - On-Demand Registration ($139/attendee)

Among other things, SQL Server 2012 promises improved availability and increased business insight. But are these features and promised benefits really worthwhile for your organization - and is there anything you should really be excited about? To find out, join independent SQL Server experts Stacia Misner and Michael K. Campbell for a frank and informative overview of essential SQL Server 2012 features that will provide your organization with practical benefits.

Session 1: An Overview of SQL Server 2012's AlwaysOn Features

Microsoft has gone a bit crazy with naming in SQL Server 2012 by virtue of the fact that two distinct new features are both being called 'AlwaysOn'. Microsoft is to be forgiven, however, since both of these new features provide very powerful and compelling options for addressing High Availability requirements.

o learn more about SQL Server AlwaysOn Failover Clustered Instances (FCI) and SQL Server AlwaysOn Availability Groups, join Michael K. Campbell for an overview of why these features are needed, how they work, what they can potentially replace, and why they're viable for your High Availability needs.

Session 2: Disaster Recovery Best Practices and SQL Server 2012

SQL Server 2012 provides great new disaster recovery and high-availability benefits that promise to shake up the HA/DR landscape. Which, in turn, begs the question: what does SQL Server 2012 mean for best-practices surrounding backups, disaster recovery, and the implementation of high-availability solutions?

Join SQL Server expert Michael K. Campbell for an informative overview of how Indirect Checkpoints, SQL Server AlwaysOn Availability Groups, and even Partially Contained Databases can help improve RPOs and RTOs while simultaneously addressing long-standing pain-points stemming from disaster recovery and high availability management.

Avoiding 5 Common SQL Server Backup Mistakes

SQLServer Pro Web Seminar

April 17, 2012 - View On-Demand (Free Registration)

As businesses become increasingly reliant upon data for day-to-day operations, backups take on an increasingly important role. Yet, sadly, many DBAs simply aren't as prepared as they need to be when it comes to ensuring that they have regular, viable backups on hand to protect against disasters. More importantly, many DBAs fall prey to a number of common backup mistakes—only to discover the costly consequences of these mistakes when it’s too late.

To learn more about five common backup mistakes and how to avoid them, join independent SQL Server consultant and expert Michael K. Campbell for an informative overview of the most common mistakes that DBAs make when it comes to backups. You’ll learn about simple techniques that you can employ to ensure that your backups are solid and that your data is safe.

Optimizing Windows Workloads

WindowsITPro Web Seminar

April 3, 2012 - View On-Demand (Free Registration)

Today's IT landscape is awash in competing demands—from the need to address increased regulatory compliance to more capital expenditures such as the rollout of new business intelligence or collaborative solutions. Yet one thing remains the same: IT organizations are increasingly expected to do more and more within less and less time—and typically with smaller and smaller budgets. Consequently, without a comprehensive, strategic, approach to systems and workload management, it’s entirely too easy for IT departments to become organizational liabilities instead of strategic business assets that they wish to be.

Essential Techniques for SQL Server Memory Management

Windows IT Pro / SQL Server Magazine Virtual Conference

October 25, 2011 - View On Demand (Free Registration)

Failure to properly provide or configure memory for SQL Server workloads can lead to significant performance problems on otherwise healthy systems. Join independent SQL Server expert Michael K. Campbell for an informative overview of essential techniques for sizing, analyzing, and tuning SQL Server memory.

By attending this event you will learn about ways to easily spot potential memory configuration problems and learn about in-depth techniques for determining if and when SQL Server is encountering memory pressure or bottlenecks. You’ll also learn about best practices for tuning and modifying SQL Server workloads to help decrease memory pressure and more efficiently use memory in cases where you may not be able to afford or add more RAM when needed.

Keeping Mission Critical Applications Available

Windows IT Pro / SQL Server Magazine Virtual Conference

View On Demand - View On Demand (Free Registration)

Session: High Availability Isn’t Disaster Recovery

High Availability (HA) solutions are a proactive approach to addressing the potential for disaster. However, High Availability solutions aren’t a replacement for a proper disaster recovery plan. In fact, HA solutions make some form of disaster worse than it would be otherwise. In this session, you'll learn about SQL Server disasters that can't be addressed by HA solutions, and you’ll gain valuable insights into how to mitigate the potential cost and down-time associated with addressing and correcting for these kinds of disasters—as a way of helping ensure greater overall uptime and availability. Specifically, you’ll learn:

  • why RPOs/RTOs are an important baseline
  • why HA solutions aren’t the same as disaster recovery
  • about disaster recovery requirements
  • best practices for HA and disaster recovery

SQL Server Disaster Recovery and Prevention

Windows IT Pro / SQL Server Magazine Virtual Conference

April 28, 2011 - View On Demand

Despite increasing trends towards the use of SQL Server High Availability (HA) solutions to pro-actively mitigate down-time, HA solutions simply can't protect against all forms of disaster - especially database corruption. DBAs therefore need to utilize a defense-in-depth approach that properly emphasizes regularly scheduled and tested backups along with the need to regularly check for and know how to properly address problems stemming from data corruption.

By attending this event with independent SQL Server expert Michael K. Campbell, you'll learn about best practices for using BACKUP, RESTORE, and DBCC commands to keep your organization's data protected in the event of disaster. You'll also learn how to confidently implement regular backups and address problems with database corruption in emergency scenarios - while gaining practical insight into how to mitigate down-time and decrease data loss.

SQL Server Remote Availability

Windows IT Pro / SQL Server Magazine Virtual Conference

February 23, 2011 - View On-Demand

Are you confident that your data is as protected as it needs to be in order to ensure business continuity even in the face of a disaster? Many organizations today are focused on ensuring that mission-critical data meets stringent service level agreements to ensure high-availability in the case of system or hardware failures. But have you done enough to ensure business vitality in the case of a system-wide failure or the loss of an entire data center?

Join independent SQL Server expert Michael K. Campbell for an informative review and overview of how Remote Availability (RA) differs from Disaster Recovery (DR) and High Availability (HA) solutions. By attending this seminar you'll learn about evaluating the degree of protection that your data needs, and gain valuable insights into how to set up, manage, and test your own RA solutions. You'll also learn about common pitfalls, considerations, and overall best-practices for helping ensure business continuity in the face of potential disasters.

MSSQLTips Seminars

Various Webinars done for www.mssqltips.com

During the summer of 2010 I had the opportunity to present three of MSSQLTips.com's monthly Webcasts.

These webcasts are still available online at the links listed below.

Common SQL Server Security Mistakes

Juggling user and application access requirements against the need to keep critical data and systems protected from unauthorized users can be a daunting task - especially given the seemingly complex nature of SQL Server security for users unfamiliar with the basics. Join independent SQL Server Expert Michael K. Campbell for a webcast that will take the mystery out of SQL Server through a review of basic concepts and best practices. By attending this webinar, you'll learn about SQL Server Authentication basics for users and applications, learn about escalation and injection attacks, examine ways to get SQL Servers to securely interact with other servers and applications, and review security gotchas that can crop up in disaster recovery and other complex scenarios.   (LINK)

Introduction to SQL Server CLR Extensibility

Microsoft has long billed the ability to extend SQL Server with the .NET Framework’s Common Language Runtime (or CLR) as a panacea to a myriad of woes. Join independent SQL Server expert Michael K. Campbell for a free webcast that will look at the hype, mystery, and confusion out of when and how to extend SQL Server with the CLR. By attending this webcast you’ll learn about potential CLR pitfalls, review best practices, and see first-hand how easy it is to extend SQL Server with CLR functionality.   (LINK)

5 Common High-Availability Mistakes

High availability solutions are the pro-active counterpart to a solid disaster recovery plan and are increasingly becoming more and more commonly deployed. If you’ve already deployed an HA solution or are planning on it, join independent SQL Server expert Michael K. Campbell for a free webcast that provides an overview of the top mistakes and problems organizations are prone to make when deploying HA solutions.   (LINK)