SQL Saturday #198 Feb 16, 2013

SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year.  As of now, 56 sessions are collected from 30 speakers, http://www.sqlsaturday.com/198/schedule.aspx?sat=198. Curiously last night, I pulled all speakers from the list and concluded that it will be a great event this time.

  • 19 SQL MVPs
  • 7 author/co-authors
  • 4 MCMs
  • 4 PASS User Group Leaders
  • 3 MS Employees (One of them is program manager of SQL Cloud infrastructure team)
  • 2 former MS employees (one of them was former MCM program manager)
  • One from NetApp
  • One PhD

Join us and enjoy the sessions.

SQL PASS Victoria Group

SQL PASSCome and join SQL PASS Victoria User Group in Victoria, BC and let’s talk about SQL Server. This will be a great opportunity to improve your SQL skills by learning from others and build your professional network. Meetings will be held 3rd or 4th Thursday every month at campus of Camosun College in Victoria, BC. Membership and attendance of sessions are absolutely free. The schedule for each meeting will be
5:00PM – 6:00PM – Networking.
6:00PM – 8:30PM – Presentation(s)
8:30PM – 9:00PM – Door prizes and Question & Answer session
The first meeting will be on Oct 18, 2012. Visit http://victoria.sqlpass.org/ for more details.

Vancouver Tech Fest 2012 is Coming – April 28, 2012

Vancouver Tech Fest 2012 is Coming – April 28, 2012

It will be a great place to learn different programming technologies. I will be presenting Locking and Concurrency Considerations in DB Design.
Concurrency is one of the most important things to be seriously considered while designing a complex database system. Fully understanding different level of concurrency control is the key to make your design success. Most of SQL Server internal concurrency controls are implemented through locks. We can utilized the same mechanism to customize the concurrency control for your processes. I am going to cover all of these during the session. At the end, we will talk about concurrency control with combination of different components of SQL Server.

Vancouver Tech Fest 2012 is Coming

Vancouver Tech Fest 2012 is Coming – April 28, 2012

It will be a great place to learn different programming technologies. I will be presenting Locking and Concurrency Considerations in DB Design.

Concurrency is one of the most important things to be seriously considered while designing a complex database system. Fully understanding different level of concurrency control is the key to make your design success. Most of SQL Server internal concurrency controls are implemented through locks. We can utilized the same mechanism to customize the concurrency control for your processes. I am going to cover all of these during the session. At the end, we will talk about concurrency control with combination of different components of SQL Server.

SQL Saturday 108 Redmond

SQL Saturday 108 – Redmond Feb 25, 2012

I will be presenting Parallel Task Scheduling with T-SQL. You might already attend my presentation on this before however this session will be the revised one with new features included. It’s not so difficult to write a stored procedure to execute number of tasks (SQL statements) sequentially and/or conditionally. However, things will become complex when you decide to run the code blocks within the procedure from different sessions concurrently with desired ordering and definable degrees of parallelism. In this session, we will discuss different ways to implement thread schedulers, semaphores, synchronizations, and process ordering as well as process monitoring and manipulation by using pure T-SQL.
Related Blog Posts:
Parallel Task Scheduling
Locking and Blocking

DevTeach – Vancouver May 28th – Jun 1st 2012

DevTeach Vancouver May 28th – Jun 1st 2012

DevTeach DevTeach is the place you can learn many area’s of technologies from the experts. It will have pre-conference workshops (May 28th) , 3 full days of main conference (May 29,30,31) and a Post-Conference (June 1st). It’s not free but you will get what you pay for. Earlybirds’ discount is available. Check to you if you can find your favorate speakers there, and what they are going to talk about.

I will be presenting Parallel Task Scheduling with T-SQL, Code: 422, Level: 400. You might already attend my presentation on this before however this session will be the revised one with new features included. You won’t miss this enjoyable 75-minute session. See you there.
Continue reading “DevTeach – Vancouver May 28th – Jun 1st 2012”

SQL Saturday 114 – Vancouver March 17, 2012

SQL Saturday 114 – Vancouver March 17, 2012

SQL Saturday 114 - Vancouver March 17, 2012 SQL Saturday is coming back to Vancouver this year. It is a great opportunity to get free SQL Server training, learn from people there, and network with other professionals doing the same thing you are doing. I am going to present a 2 hour session “Introduction to SQL Server Development ” and one regular session “Advanced SQL Certifications“. Come and join. See you there.

Continue reading “SQL Saturday 114 – Vancouver March 17, 2012”

TechDays Canada 2011 – Vancouver BC, Nov 15 and 16.

TechDays Canada 2011 – Vancouver Nov 15 and 16

I am going to present “The T-SQL Cookbook: What’s Cool in Microsoft SQL Server 2008 R2 and New in SQL Server 2012” at TechDays 2011 Vancouver 1:00PM 16, 2001, http://www.microsoft.com/canada/techdays/2011/. I will talk about new programming features introduced in SQL Server 2012 in the session. Ok, See you there.