Are you attending SQL PASS Summit 2013 in Charloote, NC, Octorber 15-18? Use SUM224CH to get $150 off.

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 – 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 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 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 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” →