Victoria SQL Server User Group

Meetup

Most recent meeting history can also be found on Meetup:
Victoria SQL Server User Group

Meeting Archive (pre-2014)

Date: Sept 31, 2013
Topic: Locking and Blocking(11)
  As a professional SQL Server developer, thoroughly understanding locking mechanisms is a key to writing high concurrent code. It’s as important as knowing the syntax of SQL statements. This session will help you understand how locks serve read and write operations in SQL Server and what it means to you for your day to day work.
Speaker: John Huang
  John Huang is a Vancouver based independent SQL Server consultant specializing in complex data processing, data warehouse, distributed system design, performance tuning and database administration. He has been using SQL Server since 1994. He obtained his SQL MCM/MCSM certification in 2009 and received SQL MVP award from Microsoft in 2011. He speaks in many events, local PASS chapters, global virtual chapters, TechDays, and SQL Saturdays in many cities. Currently, he heads up the Victoria SQL PASS Chapter.

 

Date: May 15, 2013
Topic: Introduction to SQL Server Reporting Services (SSRS) (20)
  Microsoft has provided us with an easy to use and feature rich reporting service since SQL 2000. Now in 2012, we have almost all the features available that we ever could ask for! And we can even have it all for FREE in the Express edition. In the first 50 min of this introduction we will be looking at how to install and configure SSRS 2012, how to build a simple report with it using the included Visual Studio, and finally, how to set automated periodic generations of the report using the client front end. In the second 50 min of the evening, we will be looking at more complex report types, how to add colourful and meaningful charts to your reports, and if time allows, we will look at extended formatting tricks and tips on the data columns and rows.
Speaker: Martin S. Stoller
  Martin S. Stoller (MCDBA, MCITP SQL DBA & SQL DEV 2005 & 2008) is a DBA, Programmer and IT Architect that learned SQL two decades ago using MS-QUERY and MS-ACCESS 1.0, and first came in contact with MS-SQL Server in its seminal version of 4.2. Currently working for Canada’s largest fuel distributor (Parkland Fuel Corporation) as their sole Microsoft Database Administrator, Martin specializes in legacy system upgrades and unorthodoxly complex ETL. http://www.linkedin.com/in/martinsstoller

  

Date: April 09, 2013
Topic: Inline Table Functions(17)
Speaker: Jonathan Mears
  Jonathan Mears has three decades of computer industry experience including early IBM PCs; mainframe and mini-systems and first started working with SQL Server in 1996. For the past five years Jonathan has been part of the Data Warehouse team at the Vancouver Island Health Authority.
Topic: Introduction to Indexed Views(17)
  After a quick refresher on normal Views, we will be looking at what Indexed Views are. Specifically how to create them, where they can and should be used, and also the diverse caveats associated with them. We will also be showing some tips on how to maintain and manage Indexed Views.
Speaker: Martin S. Stoller
  Martin S. Stoller (MCDBA, MCITP SQL DBA & SQL DEV 2005 & 2008) is a DBA, Programmer and IT Architect that learned SQL two decades ago using MS-QUERY and MS-ACCESS 1.0, and first came in contact with MS-SQL Server in its seminal version of 4.2. Currently working for Canada’s largest fuel distributor (Parkland Fuel Corporation) as their sole Microsoft Database Administrator, Martin specializes in legacy system upgrades and unorthodoxly complex ETL. http://www.linkedin.com/in/martinsstoller

 

Date: Mar 21, 2013
Topic: Columnstore Indexes in SQL Server 2012: Flipping the DW - faster bit(3)
  Columnstore indexes leverage SQL Server xVelocity technologies & is a wholly new architecture optimized for data warehouse workloads. Transparent to the app, columnstore has been shown to render queries at subsecond response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 columnstore indexes, including columnstore futures, review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade to SQL Server 2012. Learn why columnstore manifests my motto, “Change the world or go home!”
Speaker: Jimmy May
  Jimmy May is an MCM & currently works as a Principal Architect in MSIT. For 2½ years he was the Program Manager in the SQL Server product group for the SQL Server Customer Advisory Team (SQL CAT) where he ran the Customer Lab where the biggest, fastest, most interesting, & most exciting apps in the world parachuted in. Prior to that Jimmy worked for four years as a Microsoft consultant where he specialized in flipping the /faster bit for customers all over the world.

 

Date: Mar 07, 2013
Topic: How to (Ab)use Dynamic SQL(19)
  There are some important phrases that bounce around the SQL community, often without getting all the attention they deserve. "SQL injection" is one of these. Another one - "Dynamic SQL" is the back door that is frequently used by this injection. In this talk, we are going to go over some fundamentals about Dynamic SQL, so that you can write code that is both fast and SQL injection proof.Then we will then go over some simple ways to test this code - by trying to hack into the code. These simple tests are harmless, but they are easy to use and remember - and they also tell you quickly if your existing apps are vulnerable.Lastly, we will look at some good (and bad) places to use Dynamic SQL in your code.
Speaker: Malcolm Wynden
  Malcolm Wynden is a database consultant specializing in the turning data into useful things, using tools like SQL Server and the BI stack. Clients have included Honeywell, EDS, US Navy, and Pearson. Prior to SQL Server, his background included working with DB2 and Oracle, and even with Crystal Reports back in its early days. Malcolm is currently completing his MCSA for SQL Server 2012, to balance over 10 years of experience working with the product.

 

Date: Jan 24, 2013
Topic: Next Wave Of BI(17)
  Are you ready for the next wave of BI? I will be showing you how to put the power back in the hands of the analysts with Managed Self-Service BI using Excel, PowerPivot and SharePoint 2010. Say goodbye to row limitations, how about 27 million rows in excel?
Speaker: Andrew Boudreau
  Andrew Boudreau, Technical Solutions Specialist, Microsoft Canada. He has been a SQL Server DBA for about 15 years and a BI evangelist for the last 12. He worked for many years developing traditional BI solutions on the Microsoft stack but has fully embraced the power of Self-Service.

 

Date: Dec 4, 2012
Topic: Working with SQL Server Reporting Services (SSRS) using PowerShell(17)
  In this demo-heavy presentation we will look at how we can work with SQL Server 2012 Reporting Services (SSRS) programmatically using PowerShell V3. We will start with the basics of connecting to your reports and report server. This will be followed by numerous demos including, including how to connect to your report manager, list reports, render and download reports in different formats. We will also look at some known issues and gotchas that might have you scratching your heads.
Speaker: Donabel Santos
  Donabel Santos is a SQL Server MVP and is the senior SQL Server Developer/DBA/Trainer at QueryWorks Solutions, a consulting and training company in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting and integration projects with ERPs, CRMs, SharePoint and other custom applications. She holds MCITP certifications for SQL Server 2005/2008, and an MCTS for SharePoint. She is also a Microsoft Certified Trainer (MCT), and is the lead instructor for SQL Server Administration, Development and SSIS courses at British Columbia Institute of Technology (BCIT). She blogs (sqlmusings.com), tweets (@sqlbelle), speaks at SQL Server events (SQLSaturday, VANPASS, Vancouver TechFest, etc), trains (BCIT, QueryWorks Solutions) and writes (Packt, Idera, SSWUG, etc).

 

Date: Nov 22, 2012
Topic: How The Data Gets Modified(17)
  Do you really care about how the data is modified? The answer is YES! Knowing how things working under-the-hood is important for designing, coding, troubleshooting, and performance tuning. This will be a 500 level talk. I will present you what happened when you perform a DML. Some contents you may not be able to find in SQLSkills website but will be here. Don't miss it.
Speaker: John Huang
  John Huang, Certified Master of SQL Server and SQL MVP, is an independent SQL Server consultant specialized in performance tuning, data warehouse, and complex data processing. He has over a decade experience in SQL Server technologies. He loves helping people and talking about SQL Server.

 

Date: Oct 18, 2012
Topic:  Query Plan - Deep Dive (22)
  Interpretation of query plans with deeper understanding of the operations behind the scenes is one of the most important skills you need to know for writing efficient queries and diagnosing problem queries. This advanced level session will give you an in-depth look at some of the most common query plan operators and important information delivered by the query plans.
Speaker: John Huang
  John Huang, Certified Master of SQL Server and SQL MVP, is an independent SQL Server consultant specialized in performance tuning, data warehouse, and complex data processing. He has over a decade experience in SQL Server technologies. He loves helping people and talking about SQL Server.

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids