While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and don’t use NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.
Here’s the lineup you voted in for March 16th:
- 8AM Eastern: Making Your Emergency Toolkit by Rich Benner
- 9AM: SQL Injection Attacks: Is Your Data Secure? by Bert Wagner
- 10AM: Architecting Availability Groups by Derik Hammer
- 11AM: SQL Server 2017 Community Driven Enhancements by Javier Villegas
- Noon: SQL Server Containers and Clones by Paul Stanton
Recent Session Recordings
In this session, we will walk through various features of Power BI, how Power BI can transform your company’s data into rich visuals, and easy yet powerful analytics solutions for your whole organization.
This rapid-fire session goes over my learnings from the past six years of developing high performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS.
Discover how not to torture a SQL Server instance and how to avoid making choices that turn out to be not so smart in the long run.
Stack Overflow is the largest online community of developers, and the performance and reliability of our SQL Server databases are crucial to serving over 1.3 Billion page views each month with each rendered in ~10-20 milliseconds.