mailto:Kimberly@SQLskills.com

http://www.sqlskills.com/training/

Our Spring Show Lineup Speaks for Itself! April 16-22, 2016 in Orlando, Florida

40 SQL Sessions, 3 SQL keynotes, and 9 workshops:

Saturday, April 16: Intro to SSIS with Tim Mitchell

Sunday, April 17

SQL Server 2014 and 2016 New Features and Capabilities with David Pless and Tim Chapman

Developer's Guide to SQL Server Performance with Brent Ozar and Jeremiah Peschka

Monday, April 18

Performance Troubleshooting using Waits and Latches with Paul Randal

Analyzing and Improving I/O Subsystem Performance with Glenn Berry

PowerShell for the DBA from 0-60 in a Day with Ben Miller

Friday, April 22

Queries Gone Wrong: Statistics, Cardinality, Solutions with Kimberly Tripp

Leveraging SQL Server in the Cloud with Brent Ozar and Jeremiah Peschka

Building Better SSIS Packages with Tim Mitchell

Industry-experts and Microsoft speakers Sessions on performance tuning, troubleshooting, coding / development, query tuning, architecture,

fragmentation, & much, much more – learn real-world solutions & bring back immediate ROI

See more information online at www.SQLintersection.com

Covering

versions 2008

and higher with

special sessions

on SQL 2014 and

SQL 2016

SELECT … WHERE member_no = 12 (@1 tinyint)SELECT … WHERE [member_no]=@1

SELECT … WHERE member_no = 278 (@1 smallint)SELECT … WHERE [member_no]=@1

SELECT … WHERE member_no = 62578 (@1 int)SELECT … WHERE [member_no]=@1

(n)varchar(max)

sp_executesql

SELECT … WHERE member_no = 12

DECLARE @mno int = 12 SELECT … WHERE member_no = @mno

CREATE PROCEDURE procname ( @parameter1 int ) AS DECLARE @mno int = 12 SELECT … WHERE member_no = @mno SELECT … WHERE member_no = @parameter1

sys.dm_exec_cached_plans