Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Smiling DBA

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

Data Architecture VC hosts Nigel Sammy: TSQL Tips and Tricks

Please join the Data Architecture Virtual Chapter as they host SQL Server MVP Nigel Sammy his take for T-SQL Tips and Tricks for developers and DBAs.

Thu, Dec 19 2013 12:00 (GMT-06:00) Central Time (US & Canada)

Nigel Sammy - T-SQL: Tips and Tricks

RSVP: https://attendee.gotowebinar.com/register/5187602867480253442

Queries are running longer than expected? Your database server isn't performing as well as it should? There are many reason that this could be happening and one of them is the T-SQL being executed on the system. T-SQL offers various ways to get the information that you need but sometimes the option you choose might return the data that you want but may not be the best query structure or logic to use.
This session will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. It will also show you some tips and tricks to avoid some bad T-SQL coding habits and help you write better queries. This session is for Developers and Database Administrators.

Presenter Bio:
Nigel is a Microsoft SQL Server MVP with over a decade of technical experience and over eight years database and SQL Server experience. He's progressed through several roles in his career including Lecturer, Developer, Analyst, Database Administrator/Developer, Project Manager, Architect, Team Lead and Manager. He's the founder and current chapter leader of the Trinidad and Tobago SQL Server User Group (TTSSUG) and is also the chapter leader of the PASS Azure Virtual Chapter.

Comments

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...