SQL Server Webcasts and Videos
Upcoming Live SQL Server Webcasts
-
Azure SQL Database Performance Monitoring and Optimization
Many organizations have already deployed or plan to deploy databases in the cloud, both in Infrastructure as a Service (IaaS) and Platform as a Service (PaaS) implementations. People who move to the cloud might think everything's completely hands-off, but monitoring and optimization is even more critical because you share resources and have no control over the infrastructure. So, how do you address your SQL Server performance challenges?
-
SQL Server Performance Tuning Hints and Tricks
The goal of this presentation is to give you a set of steps you can follow that will detect and fix a lot of the most common SQL Server performance issues you'll encounter.
-
Improving SQL Server Virtual Machine Storage Performance
Whether you are running in an on-premises or cloud environment, your virtualized storage may not have the performance needed to support your user base. Don’t be misled, there are options in SQL Server, Windows and your infrastructure beyond upgrading your SAN or hardware to improve your performance.
On-demand SQL Server Webinars
Amazon AWS
- Best Practices for running SQL Server on AWS Elastic Cloud Compute (EC2)
- Building Clusters to Protect SQL Server in the Cloud
- Database Migration to the Cloud with Zero Downtime
- Delivering Microsoft SQL Server High Availability on AWS
- Deploying Applications in Azure without Configuration Limitations
- Deploying SQL in the Cloud: 5 Things You Need to Know
- Extending your SQL Server environment using the cloud
- Getting Cost-Effective High Availability for SQL Server in the Google Cloud
- High Availability, Disaster Recovery, Low Cost Storage in Virtual and Cloud Environments
- Journey to the Cloud: Topologies to Consider for HA SQL in the Cloud
- Protect Your SQL Server Data in the Cloud
- Protect Your SQL Server Data in the Cloud - Three Ways to Avoid Downtime
- Right-Sizing Your Cloud Consumption on AWS
- Secrets to Fast, Easy High Availability for SQL Server in AWS
- Secure SQL Server on AWS EC2 and RDS
- SQL in the cloud - FAQs, common misconceptions and resources to make your life easier
- SQL Server High Availability and Disaster Recovery in the Cloud
- SQL Server High Availability/Disaster Recovery options in AWS - Cross Availability Zones, Region Replication and Recovery
- SQL Server in The Cloud: High Availability and Disaster Recovery in Azure, AWS and Google
- SQL Server on AWS Cloud: One Customer's Journey and Experience
- SQL Server on the Google Cloud Platform
- Surprise! Welcome to Your First Cloud Bill
- The Case for Cloud: SQL Server Cost Optimization on AWS EC2
- The more things change… DBAs versus Sysadmins in cloud availability
- Voice of Experience: SQL Expert Shares 5 Best Practices for SQL Server HA in the Cloud
- What you should know about high availability for SQL Server in AWS
Analysis Services Administration
Analysis Services Development
- Accelerating Answers with Analysis Services
- Building a Data Mart with Integration Services
- Evolution of SQL Server Self Service Business Intelligence
- Gain a competitive edge with Data Analytics
- Taking on your first SQL Server Business Intelligence project
Analysis Services Performance
- Improve SQL Server Business Intelligence Analysis Performance
- SQL BI: Simple Steps to Serious Performance Improvements
- SQL Server BI Best Practices
Application Development
- DBA Code Reviews Done Dirt Cheap
- Managing SQL Server Source Code
- Setting up a SQL Server sandbox development environment
- SQL Server 2012 Data Tools
- SQL Server Continuous Integration Horror Stories
Auditing and Compliance
- 7 Tips and Tricks for Auditing SQL Server
- An Introduction to Auditing & Compliance for SQL Server
- Auditing SQL Server Using Extended Events
- Building an Auditing Framework for SQL Server
- Checklist, Scripts and Reports for a SQL Server Security Audit
- Deploying and Maintaining SQL Server Configuration Standards
- How to capture who did what in your SQL Server databases
- Introduction to Auditing Features in SQL Server
- Performing a SQL Server Security Risk Assessment
- SQL Server 2008 New Auditing Features
Availability Groups
- Fundamentals of SQL Server AlwaysOn Availability Groups
- SQL Server AlwaysOn: Availability Groups & Clustering in 1 hour
- SQL Server Availability Group Monitoring
- SQL Server high availability with AlwaysOn - First Look
Azure
- Azure Site Recovery and other Disaster Recovery Options for SQL Server Cloud Deployments
- Best Practices for Migrating SQL Server 2008 to Azure
- How to survive the next Azure outage
- Microsoft Azure SQL Database Security and Compliance
- Moving your SQL Server 2008/2008 R2 to Azure - Everything Enterprises Need to Know!
- Storage and High Availability Options for SQL Server in the Cloud
- Taking advantage of Azure’s latest features for your next SQL Server deployment
Backup
- Are the native SQL Server backup and recovery utilities holding you back?
- Building a Rock-Solid SQL Server Backup Solution
- Designing a SQL Server Backup Strategy
- Everything you wanted to know about SQL Server backups and more
- MSSQLTips.com Q and A: SQL Server Backup and Recovery
- See how to avoid five incredibly painful SQL Server backup and recovery mistakes
- SQL Server Backup and Restore - things you need to know
- SQL Server backup automation and best practices
- SQL Server Backup Strategies - architect a solid backup foundation
- SQL Server Backup Strategies: One Size Does Not Fit All
- Top 10 SQL Server Backup Mistakes and How to Avoid Them
Clustering
- Dodge the Gotchas of SQL Server Clustering: 5 Expert Tips that Could Save Your Bacon
- Enabling SANLess SQL Server Failover Clusters in the Amazon EC2 Cloud with DataKeeper
- Failover Clustering in the Cloud - Understanding Your Options
- Implementing a SANLess SQL Server Cluster in Under an Hour
- Increasing Your SQL Server Availability Options with SIOS DataKeeper Cluster Edition
- SANLess SQL Failover Clustering on the Ground and in the Cloud
- SQL Clustering 101: Building Clusters to Protect SQL Server in Cloud Configurations
- SQL Clustering 102: Highly Available SQL Deployments in Azure IaaS - What You Need to Know
- Understanding Windows Server Cluster Quorum options for SQL Server Clustering in the Cloud
- Why Clustering for SQL Server High Availability?
- Windows Clustering for SQL 101: A Practical Guide to HA and DR for SQL Server
Comparison Data and Objects
Compression
- Backup compression and storage deduplication: A perfect match?
- Leveraging compression for SQL Server performance
Constraints
Data Quality Services
- Contact Data Quality - From Start to Finish
- Fundamentals of SQL Server Contact Data Cleansing
- Getting Started with SQL Server's New Data Quality Services
- How to Roll your Own Value, RegEx and SoundEx Pattern Profiler in SSIS
Database Administration
- Demystify Database Development with Aqua Data Studio
- Eating the Elephant: Cloud Database Migration Considerations
- Growing Pains: Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
- How can a DBA Participate in DevOps?
- How to Reduce Latency and Boost Your SQL Server Performance
- Is the DBA Dead?... or alive and preparing for the future
- Key Benefits of Working with Azure Resource Manager
- Managing a Multi-Platform Database Environment
- Managing SQL Server - Versions, Editions, and Licenses
- Managing your SQL Server Infrastructure
- Modernize your SQL Server environments with Tegile Flash
- MSSQLTips.com Q and A: SQL Server DBA Best Practices
- Saving Your Sanity - The 3 Essential Tasks to a Successful Cloud Migration
- Secrets of SQL Server Webcast: You Inherited a Database, Now What?
- Spanning the Clouds - High Availability and Disaster Recovery in Modern IT for SQL Server
- SQL Server Database Administration Checklist
- SQL Server Database Administration Tips, Tricks, and Best Practices
- SQL Server Myths Debunked... Or Are They?
- Techniques to manage SQL Server sprawl
- The Cloud won't fix that - A Panel Discussion
- The Evolution of the Database Administrator
- The SQL Developer's Guide to Solving DB Administration Headaches
- Troubleshooting SQL Server Connection Issues
- Under the Hood with SQL Server Fundamentals
- Using Automation to Simplify SQL Server Management
Database Console Commands DBCCs
Database Design
Database Mirroring
- Database Mirroring Concepts
- SQL Server 2008 and Flash Storage: High Availability with Database Mirroring
DBA Best Practices
- Common SQL Server development mistakes and how to avoid them
- SQL Server Development Best Practices
- Surviving The First Week As The New DBA
Disaster Recovery
- Evolve Beyond Disaster Recovery to IT Resilience
- Experts' Perspective Webcast: Expanding Your SQL Server Recovery Horizons
- Modern Strategies for SQL Server Disaster Recovery
- Providing High Availability to an Existing SQL Server Workload
- Recovering from Ransomware in Minutes
- SQL Server and Networking High Availability\Disaster Recovery Best Practices
- SQL Server Cloud Continuity at Its Best with Zerto
- SQL Server Data Recovery
- SQL Server HA and DR strategies that can cut your TCO by $800,000
- Understanding Disaster Recovery Options for SQL Server
Dynamic Management Views and Functions
Encryption
- Encrypting Data with SQL Server
- SQL Server 2008 Encryption Enhancements
- SQL Server Transparent Data Encryption Alternative from DBDefence
Fragmentation and Index Maintenance
Functions - User Defined UDF
Hardware
- Break Out of Your Silo - Know Your SQL Server Storage!
- Speeding up SQL by Maximizing Disk IO
- SQL Server 2014 in a Flash
- SQL Server, Storage and You - Part I: Storage Basics
- SQL Server, Storage and You - Part II: SAN and NAS
- SQL Server, Storage and You - Part III: Solid State Storage
- Thinking Outside the SAN(box)…
- Utilize SQL Server Storage Effectively
High Availability
- 5 Common High-Availability Mistakes
- Achieving High Performance and High Availability for SQL Server
- Achieving IT Resiliency for SQL Server in the Cloud
- Are You Making the Right Choices for SQL Server HA?
- Ask the Expert: Live Q&A about High Availability in the Cloud for SQL Server
- Availability Options and Requirements for SQL Server 2008 in Azure
- Avoiding the Next Cloud Outage - Keeping SQL Server Up and Running through Disaster
- Ensure High Availability for your Virtualized SQL Server Workloads
- Expert Insight: Practical Strategies for Getting High Performance in SQL Server High Availability Environments
- High Availability and Disaster Recovery Solutions for SQL Server 2017 on Linux
- High Availability for SQL in VMware without Raw Device Mapping
- High Availability Options with SQL Server 2012
- How to Protect SQL Server in the Cloud
- Keeping the peace with your Sys Admins while Providing SQL Server High Availability
- Leveraging Storage Spaces Direct for SQL Server High Availability
- Multi-site SQL Server architectures that make use of Microsoft Azure and Flash Storage
- New, Easy Way To Eliminate SQL Performance Issues In VMware
- Options for SQL Server Scalability and Availability
- Protecting SQL Server in the Cloud
- SQL Server High Availability & Disaster Recovery in the Public Cloud
- True Story: Learn the Innovative Strategy a Fortune 100 Company Used to Get HA and High Performance
- What's New with High Availability in SQL Server 2016 and Windows Server 2016
- Windows Server 2016 High Availability Options, what every SQL Server DBA needs to know
Indexing
- Index Tuning – Unplugged
- Indexing and SQL Server®-What's Old and What's New
- Introduction to SQL Server Indexing
- Making the Most of Indexes in Microsoft SQL Server
- SQL Server Indexing Best Practices
- SQL Server Indexing Tips and Tricks
- Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
- The good, the bad and the ugly of Microsoft SQL Server 2016 Query Store
Integration Services Best Practices
- SQL Server Integration Services Best Practices and Tuning Tips
- What's New for Business Intelligence in SQL Server 2016
- What's new in SQL Server Integration Services 2016?
Integration Services Development
- Best Practices for SQL Server ETL Development
- Beyond the Basics - Take Your Biml Skills to the Next Level
- Cleaning, Validating and Enhancing the SQL Server Data Warehouse Contact Dimension
- Executing, Configuring and Scheduling SQL Server 2016 Integration Services Packages
- Getting Started with SSIS - Part1
- Improving Data Quality with SQL Server Integration Services
- Introduction to Biml - Generating your SSIS packages from scratch
- Make the most of SQL Server Integration Services Script Components
- Migrating SQL Server Integration Services to the Cloud
- Simplifying and Centralizing Universal Data Quality in SSIS
- Survival of the Fittest: Melissa’s Matching Approaches for Golden Record Management
Integration Services Upgrade
Licensing
Maintenance
Master Data Services
Monitoring
- Are Your SQL Servers Healthy?
- Bridge the Silos of SQL Server and Infrastructure Problems with Machine Learning
- Database Performance Monitoring for Relational Databases
- Extend SCOM to Optimize SQL Server Performance Management
- Free SQL Server tools to manage, optimize and monitor your environment
- Identify and Eliminate SQL Server Performance Issues
- Managing and Monitoring Hybrid SQL Server Database Environments
- Monitor and Troubleshoot SQL Server Performance
- Monitoring SQL Server
- Monitoring SQL Server - For Free!
- Need a clear path to database health? What if you had a GPS for SQL Tuning?
- Simple and effective SQL Server monitoring
- Solving the Mystery of SQL Server Performance Issues
- SQL Server Monitoring Best Practices
- SQL Server Monitoring Meets Machine Learning
- SQL Server Performance Advanced Monitoring and Best Practices
- SQL Server performance monitoring – anywhere, anytime, on any device, for anybody!
- SQL Server Performance Monitoring in the Cloud
- SQLRx Part 1: Top PerfMon Counters for Analyzing SQL Server Performance Issues
- Storage Performance and Capacity Monitoring Done Right
- Ten tips for proactive SQL Server performance monitoring - Part 1
- Ten tips for proactive SQL Server performance monitoring - Part 2
- The right database monitoring tools make all the difference, see how the SolarWinds solution delivers!
- Top 5 Things Every SQL Server DBA Should Monitor
- What Are Your SQL Servers Doing While You're Sleeping?
Other Database Platforms
- Differences and Similarities of Working With and Supporting Multiple Database Platforms
- Zero Impact Data Migration – Oracle to SQL Server
Performance Data Warehouse
Performance Tuning
- 100 Times Faster: Experiences making SQL Server Fly
- 2X Faster SQL Server - How I/O Reduction Software for SQL Server Eliminates the 2 Silent Killers of Performance
- Analyze your query plan like a Microsoft Engineer! (SQL Server 2016 Edition)
- Announcing Extraordinary SQL Optimization: Advanced Machine Learning Analytics Meets SQL Server Domain Insight
- Avoiding SQL Server and Virtualization Performance Mistakes
- Cross Platform Database Performance Monitoring
- Dealing with Network Latency Issues and the impact on SQL Server Performance
- Exploring the Plan Cache to Optimize SQL Server Performance
- Getting Started with SQL Server Query Tuning
- How to improve SQL Server Performance with Data Caching
- How to Reduce Latency and Boost Your SQL Server Performance
- Improving SQL Server Queries by Reading and Understanding Execution Plans
- Introduction to SQL Server Query Store
- Introduction to SQL Server Statistics
- Knowing What to Fix - Understanding Your SQL Server's Performance
- Learn to Fix SQL Server Storage Bottlenecks and Boost SQL Application Performance – No New Hardware
- Making SQL Server Queries Run Faster
- Matching Bare Metal Performance: The Cost of Building Really Fast SQL Server VMs
- Maximizing Microsoft SQL Server Performance
- Performance Faceoff: Oracle, SQL Server or Sybase - Which is the best performing?
- Performance Tuning SQL Communications
- Performance Tuning Your SQL Server Database and Maybe Even Your Data
- Resolving the Database Performance Problem Blame Game
- Solve Real World SQL Server Performance Issues with SolarWinds Database Performance Analyzer
- SQL Server 2008 Performance Improvements
- SQL Server Performance and Scalability
- SQL Server Performance Troubleshooting and Query Tuning
- SQL Server Performance Tuning Scripts, Tips and Tricks
- SQL Server Performance Tuning Without Changing Any Code
- SQL Server Performance Tuning: Controlling Parallelism
- SQL Server Query Tuning
- SQL Server statistics and how they impact performance
- SQL Server Wait Stats from A to Z
- Troubleshooting when the issue is not SQL Server
- Understanding SQL Server Query Execution Plans
- Understanding Your Database Performance in SQL Server
- Utilizing Free Tools to Optimize and Tune SQL Server
- Your SQL Server is Slow, Let's Make it Fast
PowerShell
Professional Development Career
- 15 Traits of Top Performers
- Branding Yourself as a SQL Server Professional
- Building Blocks for Your SQL Server Career
- Conducting an Effective SQL Server Job Search
- Interview Coaching for SQL Server Professionals
- Resume Writing for SQL Server Professionals
- Skills Development Strategies for SQL Server Professionals
Professional Development Interviewing
Professional Development Job Search
Replication
- Getting Started with SQL Server Replication
- Improving Performance By Scaling Out With Transactional Replication
- MSSQLTips.com Q&A: SQL Server Replication
- Optimize transactional operations and reporting from multiple data sources
- Use Cases for Replicating SQL Server Data
Reporting Services Development
Reporting Services Overview
Restore
- Automate Backup Recovery Before Problems Arise with SQL Safe Backup
- Restoring SQL Server databases: the options and steps
Security
- 5 steps every DBA should take to secure their SQL Server environment
- Building a Successful Database Security Model
- Common SQL Server Security Mistakes
- Don’t Be the Next Data Breach - How to Secure SQL Server in the Cloud
- Identify and Protect Confidential SQL Server Data
- Lock Down SQL Server Security
- Monitoring, Securing and Protecting SQL Servers in Amazon RDS
- Ransomware. Are you putting your SQL Server at risk?
- Security Best Practices for SQL Server Databases in the Cloud
- Security, Compliance, and SQL Server
- SQL Injection: What it is, how it happens and how to stop it?
- SQL Server Database Security & Compliance with GreenSQL
- SQL Server Database Security Best Practices
- SQL Server Security Essentials
- SQL Server Security for Developers
- Stop SQL Injection - The Number 1 SQL Server Exploit
- Ten Security Tips for SQL Server
- The liability of data: Securing data in SQL Server
- Top-Down SQL Server Security
- Understanding SQL Server Security Options
SQL Injection
SQL Server 2016
- Global Address Data Quality - Storage, Correction, and Verification
- New Paradigm for Performance Tuning in SQL Server 2016
SQL Server 2017
SQL Server Agent
- 10 Ways to Improve SQL Server Automation
- 5 ways monitoring SQL Server Agent jobs can make your job easier
- Job Management Beyond SQL Server Agent with JAMS
- Managing SQL Server Agent Jobs Across Your SQL Server Farm
- Monitoring and Managing SQL Server Scheduled Tasks
- SQL Server Integration Services Management and Automation
- Taming the beast: How to manage SQL Server Agent Jobs
- Troubleshooting Performance Issues with SQL Server Agent
SQL Server Configurations
SQL Server Management Studio
SQL Server on Linux
- SQL Server – on Linux!
- SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love.
Stored Procedures
System Databases
- Care and Feeding of Your SQL Server System Databases
- SQL Server Performance Tuning - TempDB Best Practices
- Tempdb: Performance and Manageability
T-SQL
- Building blocks for managing your SQL Server code
- Database development best practices
- Development Tips for SQL Server
- Improving SQL Server Performance by Writing Faster T-SQL Code
Tools
- Get your SQL Server in shape for the New Year with Spotlight on SQL Server
- Get your SQL Server in shape this Spring with Spotlight on SQL Server
- Get your SQL Server in shape this Summer with Spotlight on SQL Server
- Improving the DBA’s Quality of Life with SQL Sentry
- MSSQLTips.com Q&A: SQL Server Data Tools
- SentryOne Tools for Productivity and Performance on Physical, Virtual, and Cloud Environments
- SQL Server DBAs – Do you have Mobility Tranquility?
Upgrades and Migrations
- How to Save Significant Time When Upgrading to SQL Server 2014
- Managing SQL Server Upgrades using the Query Store and Compatibility Level Settings
- SQL Server 2008 - First Look
- SQL Server 2008 New Features
- SQL Server 2012 / 2014 - is it worth the effort of upgrading
- SQL Server 2014 New Features
- Upgrade Strategies for Highly Available SQL Server Environments
Views
Virtualization
- Is HA pitting SQL Database Admins against VM Admins? Keeping the Peace with SANLess clusters.
- Key Insights for Meeting your SLAs for SQL Server in VMware Environments
- Managing Performance in a Virtualized SQL Server Environment, Part 1 - Configuration
- Managing Performance in a Virtualized SQL Server Environment, Part 2: Memory
- Managing Performance in a Virtualized SQL Server Environment, Part 3: CPU
- Performance insights and tuning of Physical & Virtual SQL Servers
- Save Big by Right Sizing Your SQL Server VMware Environment
- Successfully Virtualizing SQL Server
- Virtual Simplicity: Kevin Kline and Mattias Sundling's Easy Tricks for Managing Virtualized SQL Servers
- VMware Guest Based High Availability Clusters - Ways to Protect SQL and Maintain Flexibility
