Professional Experience - Training and Instruction

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

SQLServerVideos.com

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.

Free SQL Server Videos

 

Past Presentations / 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):

    11:00 am ET: Core Tasks and Responsibilities for DBAs
    1:00 pm ET: Disaster Recovery and Data Availability
    3:00 pm ET: Managing SQL Server Performance

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

Rate: $139 (Register)

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.

To 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

Session: High Availability Isn’t Disaster Recovery

Windows IT Pro / SQL Server Magazine Virtual Conference

View On Demand - View On Demand (Free Registration)

Session Abstract

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

    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 (link)

    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.

    Introduction to SQL Server CLR Extensibility (link)

    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.

    5 Common High-Availability Mistakes (link)

    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.

    Power Up with SQL Server

    In September 2009 I presented three one-hour-long presentations on SQL Server.

    SQL Server Virtualization:

    Virtualization enables numerous benefits including improved management and provisioning and also facilitates a lower overall cost of IT ownership. But how does virtualization stack up when it comes to SQL Server? What about the prevailing wisdom that SQL Server workloads shouldn't be virtualized? Learn about the benefits, options, implementation details, and best practices for virtualizing SQL Server in real-world environments with real-world workloads.

    SQL Server High Availability

    As business reliance upon data and applications steadily increases, so too does the need for high-availability solutions. SQL Server provides a number of compelling high-availability options - but which one is right for you and for your workloads? Learn about the benefits and limitations of each approach, and gain insight into implementation details and options along while learning about the best-practices that you'll want to follow in order to ensure success.

    SQL Server Performance

    SQL Server commonly serves as the backbone for many business applications, and when it tends to slow down, many organizations commonly just assume that they need to throw more hardware at their servers to compensate. Get a solid understanding of the core concepts for SQL Server configuration, indexing strategies, code tuning, and performance profiling and learn why throwing more hardware as SQL Server performance problems should only be done as a last resort.

    Virtualization: Get the Facts

    In the Virtualization: Get the Facts online event, I spoke about the best ways to virtualize IO intensive workloads such as SQL Server.

    Session Abstract:

    Virtualization provides numerous benefits in terms of server consolidation, reduced management costs, and increased efficiency. But how well does virtualization stack-up when it comes to IO intensive workloads? Learn about options and approaches to virtualizing SQL Server along with best practices that will help you evaluate and optimize virtualization benefits for IO intensive workloads within your own environment.