New Tip on Searching Schema

Quote

"One must learn by doing the thing, for though you think you know it, you have no certainty until you try." -Aristotle

New Tip - Formatting a Report

Here's my latest tip about formatting SQL Server Reporting Services Reports:

Rob Sullivan on SQL Server's Last Breath

This is my friend, Rob Sullivan, talking about the pressure SQL Server is getting from competition.

Rob Sullivan: SQL Server's Last Breath from NDCOslo on Vimeo.

New SQL Tip on How To Find Bad Queries

In this video, I show SQL Server 2012 Profiler, Performance Monitor, and how to link the two together:

How to Start Reading SQL Execution Plans

This morning I watched Grant Fritchey's SQL Pass 2012 session about reading execution plans. I'd highly recommend watching it, or seeing it in person when SQLPass comes around again next October. Grant had this slide to teach us where to begin when reading the cache plan.

 In summary, Grant says that execution plans can be overwhelming, but if you start with these six things, you'll probably find what you're looking for.

 Grant also wrote this blog post, detailing the same information: Home of the Scary DBA - Execution Plans, Where to Begin

Chart Porn Part 2: This is Hans' recent video with more numbers