The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

TSQL Best Practices – Notes from the Field

Wed, Jul 19 2017 20:30 Eastern Daylight Time

RSVP: None

TSQL Best Practices – Notes from the Field

TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring when the data is a lot larger. I will go over several key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. The concepts in this session are a great foundation to begin with even for the veteran SQL person. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.


Ben Miller

Ben has been a member of the SQL Server Community since 2000. He is currently working at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults on SQL Server problems. He is a SQL Server MVP a SQL Server MCM, and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US, as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration and uses SMO and PowerShell regularly. He teaches DBAs how to use PowerShell as well. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook)

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids