SQL Server does a good job of working with whatever garbage we throw at it, but sometimes a helping hand is needed to smooth things out. You may have meant well when you wrote that sloppy SQL, but that predicate lurking under the surface is poisoning your performance. This talk …
Learn how StackOverflow.com can serve 12-14 million web pages per day with Microsoft SQL Server 2008 R2. They’re passionate about performance, and we’ll share the scalability lessons they learned along the way. This session is aimed at production DBAs who manage SQL Servers that need to go faster and SQL …
Big data’s ancestor is the Very Large DataBase (VLDB) and we’ve been doing VLDBs in SQL Server for years. Making the jump from managing 10-100GB databases to the terabyte level can be intimidating, but in this video shares lessons he learned along the way so you don’t have to get …
In this video, you learn how to find matches and exceptions with outer joins.
SQL Server expert Eric Johnson teaches “Accidental DBAs” the basic building blocks of SQL Server maintenance in a no-nonsense, approachable way. Topics include installation, database overview, backing up and restoring databases and more.
