Database Training Days: SQL Server Resources

In this advanced session, we will dive deeper into optimizing long-running integrity check jobs, a critical yet resource-intensive task in SQL Server management. Long-running integrity checks can monopolize system resources, reducing overall performance. This session will introduce strategic approaches and advanced techniques to accelerate these processes, ensuring a balance between maintaining data integrity and preserving system responsiveness.

We’ll explore how separating tasks, bucketizing checks, and leveraging multiple SQL Agent jobs can significantly improve the efficiency of these operations. Through real-world examples and practical demonstrations, you’ll learn to identify and address common bottlenecks, and apply fine-tuning techniques that minimize performance impacts during these crucial checks.

By the end of this session, you'll have actionable skills to optimize your integrity checks, ensuring data reliability while maintaining peak system performance.

Key Areas to be Covered:

• Techniques to accelerate integrity check jobs through task separation and bucketization
• Leveraging SQL Agent jobs for distributed workloads
• Identifying common bottlenecks in long-running integrity check processes
• Practical examples and real-world scenarios for optimizing system resources
• Fine-tuning integrity checks to minimize performance impacts on SQL Server

Speaker: Mikey Bronowski
SQL Server performance expert with extensive experience optimizing and managing complex database systems.

In this advanced session, Pinal Dave delves into sophisticated SQL Server tuning techniques designed to help experienced DBAs push their database systems to peak performance. Building on fundamental optimization concepts, this presentation offers in-depth strategies for diagnosing and resolving performance bottlenecks, advanced indexing tactics, and the effective use of SQL Server's built-in tools for performance analysis and tuning. Gain insights into fine-tuning your SQL Server instances through comprehensive discussions on partitioning, in-memory technologies, and the art of balancing workload and resource allocation. Tailored for seasoned professionals, this session empowers you to achieve top-tier performance, ensuring your SQL Server environment is optimized for speed, efficiency, and scalability.

Topics that will be discussed include:

• Advanced strategies for diagnosing and resolving performance bottlenecks
• Sophisticated indexing tactics to enhance database efficiency
• Utilization of SQL Server’s built-in tools for performance analysis and tuning
• Fine-tuning SQL Server instances with partitioning and in-memory technologies
• Balancing workload and resource allocation for optimal performance

Speaker: Pinal Dave, SQL Server performance tuning expert and independent consultant at SQL Authority.

In this on-demand MSSQLTips webcast, you'll gain invaluable insights into SQL Server auditing from one of the best in the field—Certified Information Systems Auditor, Brian Kelley. With over a decade of experience and as an accredited trainer for the CISA exam, Brian will guide you through the auditor’s approach to system auditing and apply these principles specifically to SQL Server environments. Learn how to prepare for an audit, what information and evidence auditors look for, and how to interact with auditors for maximum benefit to your organization. This session also includes a review and execution of scripts that will aid you in your next SQL Server audit.

Topics that will be discussed include:

• Understanding the auditor’s approach to SQL Server system audits
• Preparing in advance to ensure a smooth audit process
• Key information and evidence auditors seek during an audit
• Review and execution of scripts for SQL Server audits
• Best practices for interacting with auditors during the engagement

Speakers:

• Brian Kelley, Certified Information Systems Auditor (CISA) and Data Architect
• Jeffrey Surretsky, Sales Engineer at Quest Software

Join Pinal Dave in this dynamic session designed specifically for new database administrators (DBAs) eager to master the fundamentals of SQL Server performance tuning. Dive into the core concepts of database optimization and explore essential techniques that will enhance SQL Server efficiency. Through practical insights and real-world examples, you'll gain a clear understanding of how to improve database responsiveness and tackle common performance challenges with confidence. This session is your gateway to building a strong foundation in SQL Server optimization, setting the stage for your future success in database management.

Topics that will be discussed include:

• Basics of indexing and its impact on performance
• Query optimization techniques for improved efficiency
• Best practices for database configuration
• Practical strategies to troubleshoot and resolve common performance issues

Speaker: Pinal Dave, SQL Server performance tuning expert and independent consultant with SQL Authority.

In this advanced session, Pinal Dave focuses on practical and impactful SQL Server performance tuning techniques designed to help DBAs and IT professionals enhance their database systems' efficiency and responsiveness. Building on fundamental optimization strategies, this presentation explores proven methods for identifying and addressing key performance bottlenecks, effective indexing strategies, and best practices for optimizing query plans and resolving I/O issues. Gain insights into continuously refining your SQL Server environment with comprehensive discussions on system-wide performance analysis, resource monitoring, and actionable steps for ongoing performance improvements. Tailored for experienced professionals, this session equips you with the tools to cut through the noise and achieve peak performance for your SQL Server instances.

Topics that will be discussed include:

• Proven strategies for diagnosing and resolving key performance bottlenecks
• Effective indexing techniques to optimize query performance
• Best practices for query plan optimization and avoiding costly execution plan issues
• Identifying and addressing I/O bottlenecks for faster data access
• Continuous performance tuning and refinement for long-term efficiency

Speaker: Pinal Dave, SQLAuthority (https://blog.sqlauthority.com)