Bringing database training to the community
Demystify Data Compression Jul 23, 2019, 5:30pm Andy Mallon SQL Server 2016 SP1 and newer makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added Read More …
Backup & Recovery CYA May 21, 2019, 5:30pm Matt Anderson Target Audience: DBAs, Developers, or anyone who is responsible for SQL database backups. Do you practice restores on a regular basis, but others in your organization do not? Are you Read More …
The SQL Server Performance Tasting Menu April 23, 2019 6:00pm Erik Darling You’re a DBA or Developer, and you’ve been using SQL Server for a few years. You know there are different ways to make queries faster, but you’re not Read More …
Common Troubleshooting Techniques for AGs and FCIs March 26, 2018 6:00pm Allan Hirt When things go wrong with Always On Availability Groups (AGs) or Always On Failover Cluster Instances (FCIs), it is not always apparent where to look and how Read More …
What problem does this SQL Server feature solve? October 23, 2018 6:00pm Jes Borland “I heard about this new feature, and I think it sounds great. I want to use it in my database.” Have you heard – or said Read More …
T-SQL Performance Tuning October 22, 2018 9:00am Jes Borland Everyone that works with SQL Server writes T-SQL, including you. Do you understand how SQL Server interprets queries? Join me for a day of learning strategies for making queries faster and Read More …
How to Build Your Disaster Recovery Plan Aug 28, 2018, 6:00pm Rie Irish So your boss asked for a copy of your DR plan. Once you’ve wiped that deer-in-the-headlights look off your face, you realize “We’ve got database backups,” isn’t Read More …
Relationship Goals: The SQL Server Graph Database July 31, 2018, 6:00pm Jonathan Stewart Relational databases have their strengths. Ironically data relationships are not one of them. Graph databases excel in this department using nodes and edges. They are optimized to Read More …
Real-World Case Study: Push Your App to Enterprise Scale with Advanced SQL Server Features July 17, 2018, 6:00pm Kevin Kline You have an OLTP database application which sustains a heavy mixed workload with lots of read and write transactions at Read More …
DevOps Database Administration June 26, 2018, 6:00pm Stephen Mokszycki How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern. Now you no longer have to pause and stop what you are doing to create Read More …