Home

What's new for developers in SQL Server 2014

Written by TTSSUG admin on . Posted in Events

To start our events in 2014 we have two speakers from Microsoft SQL Server team, based in Redmond, WA.

EVENT DETAILS

Date: Monday 10th February 2014

Time: 9:00 am – 11: 30 am

Target Audience: Developers, Database Administrators and System Administrators.

 

Agenda:

9:00 - 9:10            Registration

9:10 - 10:10       Session 1 - Practical Uses and Optimization of New T-SQL Features

 

Speaker Information:

Tobias Ternstrom - Principal Program Manager Lead, Windows Azure SQL Database & SQL Server

 

Tobias has worked with SQL Server in a customer capacity since the mid-90s. A few years back Tobias joined the program management discipline of the SQL Server Engine team focusing on engine programmability (T-SQL, SQL). He is currently a Lead Program Manager leading a team of program managers focusing on the customer and performance experiences of Windows Azure SQL Database.

 

10:10 - 10:20      BREAK

 

10:20 - 11:20     Session 2 - New features in SQL Server Database Engine

In this session we will look closer at some of the new features in SQL Server 2014 from a developer perspective. It will also offer some insights into how the team develops SQL Server as well as what Microsoft is doing to run SQL Server in the cloud.

 

Speaker Information:

Hans Olav Norheim - Software Developer, Windows Azure SQL Database & SQL Server

 

Hans is from Norway and has worked with SQL Server since the early 2000s as a customer, a few years back before he joined the SQL Server Engine team as a developer in the engine programmability team (T-SQL/SQL). Today he focuses mostly on the distributed infrastructure running Windows Azure SQL Database.

 

 

11:20 - 11:30     Extra Q&A and Closing Remarks

 

Location:           Microsoft Caribbean Office

                              61 Mucurapo Road

                              St. James, Port-Of-Spain

R.S.V.P via email: This email address is being protected from spambots. You need JavaScript enabled to view it.

 

 

Understanding and Controlling Transaction Logs

Written by TTSSUG admin on . Posted in Events

Date: Tuesday 8th October 2013

Time: 9:30 am – 11: 00 am 

Location:             Microsoft Caribbean Office
                            61 Mucurapo Road,
                            St. James, Port-Of-Spain

Session Abstract:

This session will unravel the mysteries of the transaction log, including how you can manage your logs and optimize their performance. Transaction logging is one of the most important activities SQL Server does for you, and understanding it thoroughly means you can ensure SQL Server does the best job possible. You'll leave with tips you can implement as soon as you get back to the office.

Presenter Bio:

Nigel Peter Sammy is Microsoft SQL Server Most Valuable Professional (MVP) with over a decade of technical experience and over eight (8) years database and SQL Server experience. Currently he is a lecturer at the School of Business and Computer Science (SBCS) where he teaches the Microsoft Certified Solutions Associate (MCSA): SQL Server certification as well as other database courses for various degree programs. Nigel is also a data platform architect at SolidQ, a global provider of advanced consulting, mentoring and education solutions for the Microsoft Data, Business Intelligence, Collaboration and Development platforms.

Admission: Free

R.S.V.P via email: This email address is being protected from spambots. You need JavaScript enabled to view it.

T-SQL: Tips and Tricks

Written by TTSSUG admin on . Posted in Events

Date: Tuesday 30th July 2013

Time: 9:30 am – 11: 00 am 

Location:             Microsoft Caribbean Office
                            61 Mucurapo Road,
                            St. James, Port-Of-Spain

Session Abstract:

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 Peter Sammy is an IT professional with over a decade of technical experience and over 8 years database and SQL Server experience. He is currently a lecturer at the School of Business and Computer Science where he teaches the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 courses. Nigel is the first Microsoft SQL Server MVP in the English-speaking Caribbean and currently the only active MVP.

 

Admission: Free

R.S.V.P via email: This email address is being protected from spambots. You need JavaScript enabled to view it.

 

 

T-SQL: Tips and Tricks Session Review

Written by Nigel P. Sammy on . Posted in Articles

The TTSSUG Steering Committee would like to thank everyone that attended the session this Wednesday and we hope to see you at future sessions later this year. The session talked about T-SQL best practices and also highlighted how performance is affected by particular statements and query structure whether they are being used in applications or being used to run everyday queries from Management Studio. The presentation deck is available here.

 

 

JulyPic1  JulyPic2  

See more pics on Facebook

 

For those who wanted to attend but were unable to do so please send us some feedback so we can try to accommodate you. We appreciate the support so please feel free to volunteer to present or submit suggestions for future sessions via our email address This email address is being protected from spambots. You need JavaScript enabled to view it. .