MVP Deep Dives II
I have written a chapter for MVP Deep Dives II, which is being released at PASS Summit 2011 in Seattle! I’ll use this part of the Pubs page to answer FAQ about my chapter (as they occur). The scripts used in the chapter are freely available under “Source Code” (I’m chapter 37) on the SQL Server MVP Deep Dives 2 page on Manning.com.
For information on the first Deep Dives book, see the SQL Server MVP Deep Dives page on Manning.com.
Tech Sessions I Present
I present a certain set of sessions, and I try to make recordings and materials from all of those sessions available. If you don’t see what you’re looking for here, email me at Jen@MidnightDBA.com and I’ll see if I have it.
| Session | Resources |
|---|---|
Code Sins |
Presented at 24Hours of PASS Spring 2011:
Other recordings:
|
| Code Sins Abstract: It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend. | |
Overview: SQL Server |
Presented at SQL Saturday #63 Dallas 2011:
|
| Overview SQL Server Abstract: Err…I’ll get back to you. But this is a bare bones introduction to SQL Server. | |
Beginning T-SQL |
Presented at SQL Saturday #41 Atlanta, 2010: |
| Beginning T-SQL Abstract: If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance! | |
T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code
|
Presented at 24 Hours of PASS Fall 2010:
Other recordings: |
| T-SQL Brush-up Abstract: You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. And what’s more, we’ll look and BRAND-new features like SQL Server Denali’s new SEQUENCE object! This session is chock full of code examples, including before-and-after demos and how-to illustrations. | |
Unraveling Tangled Code – A Spellbinding Tale of Victory Over Chaos |
Recording from EDMPASS presentation (July 2011) |
| Abstract: Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins, tame subqueries, and refactor dynamic SQL. We will emerge victorious! | |
Petri Articles:
- Introduction to Indexes in SQL Server, 12/2010
- How to Create and Edit a Report in SQL Server Reporting Services, 11/2010
- SQL Server Reporting Services: An Introduction, 11/2010
- String Data Types in SQL Server: VARCHAR vs. CHAR, 6/2010
- How to Design and Build SQL Server Tables – Part 1 of 2, 5/2010
- How to Design and Build SQL Server Tables – Part 2 of 2, 5/2010
Pingback: Twitted by MidnightDBA