Category Archives: Meeting

September meeting – Thursday 19th

Dave Morrison – Myth Busters! Busting Common TSQL Myths

We are very pleased to have Dave visit us again this month

In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis. We will look at areas such as Indexing / SARGability, joins & sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have.

Questions and Requests from members

Following the interesting and useful Q & A session last month there are a couple of questions and requests that we will cover in the second session. Again, if you have any questions or would like opinion from the group on a SQL Server topic then please bring the thoughts and even a way to demonstrate your point and we will happily try to include everything. The key one I would like to cover is a question about error handling in TSQL as I think there will be lots of opinions and techniques that we can share.

August meeting details

Matija Lah – SQL Server and XML Query
We are very pleased to have a remote session from Matija this month as one of the most popular sessions as voted for recently by user group attendees.
Session details.
XML was added to the collection of SQL Server native data types in SQL Server 2005. Being a complex data type, not only is XML accompanied by a set of dedicated T-SQL functions, but also with a complete querying language. In this session you will learn about the Microsoft SQL Server 2008 implementation of the World Wide Web Consortium’s XML Query Recommendation, and learn how to compose XML data – from existing SQL Server data or simply "from scratch", how to retrieve (relational) data from XML Documents to be used in a SQL Server database, and how to manipulate XML data using Transact-SQL and the XML Data Manipulation Language (XML DML). You’ve already mastered all the primitive SQL Server data types, why would XML be an exception?