SQL Server Webcasts and Videos
Upcoming Live SQL Server Webcasts
-
Clustering SQL Server - What you need to know before getting started
In this webinar, Dave Bermingham, Microsoft Datacenter and Cloud MVP, will detail everything you need to know about clustering SQL Server.
-
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.
-
Database Performance Tuning for Virtualized Database Instances
Join us for a look at how Database Performance Analyzer provides detailed performance data for SQL Server database instances running in VMware® ESXi environments. Virtualization provides many benefits, but how do you know if the vSphere is negatively impacting database performance? What about a nightmare scenario where nothing changed with the application or underlying database, yet users complain of performance issues?
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
- Azure SQL Database Performance Monitoring and Optimization
- 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
- Improving SQL Server Virtual Machine Storage Performance
- 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
