Webcast: 10 T-SQL Development Tips for SQL Server
In this webcast we will look at things you should be aware of when developing T-SQL code for your SQL Server databases. We will look at how to get maximum performance to quick troubleshooting for solving problems to protecting from security threats. In this webcast, we look at ten tips to keep in mind as you develop in SQL Server. Whether you are new to T-SQL development or have been developing T-SQL code for many years, you’ll probably pick up a tip or two in this free webcast.
To develope T-SQL scripts for Microsoft SQL Server can be challenging because of several factors. Some challenges include:
* Write complex T-SQL queries: Developers often struggle with writing T-SQL queries that perform well and scale in large numbers of rows. This requires a systematic approach to writing ‘difficult’ T-SQL scripts.
* Learning curve: For users who are new to writing SQL statements, understanding Transact-SQL, the Microsoft implementation of the SQL standard, can be challenging.
* Handle dependencies: When working with a large codebase, it is difficult to find and map dependencies across the SQL code.
* Manage large tables: Using soft transactions can lead to large tables since the system never removes records, which can be both an advantage and a drawback.
About the Presenter
Tim Smith began working with technology in high school, helping his 1A Texas high school place and win in the TCEA competition. He continued his journey with a heavy interest in data, especially predicting future outcomes with the stock market, global resource use, and individual success markers. He works as a SQL Server database administrator and developer at Amherst Securities and as a Senior MongoDB database administrator and developer at RS Consulting Partners He also teaches Mastering ETL Development Through Automation on Udemy.
Please register to view the webcast replay.