Professional Association for SQL Server

Meeting Archive

 

 

Topic: A Game of True or False
Date: Wednesday, April 17, 2013
Speaker:

Roy Ernest. Roy Ernest is the chapter leader of Curacao SQL Pass user group.

 

Location: Rustenburg, Asiento. Map
Overview: This presentation gives general information about all aspects of SQL Server.

 

                   Topic: Banishing RBAR
 Date: Thursday, March 22, 2012
Speaker:

Wayne Sheffield. Wayne is an experienced Sr. Application DBA. He has autored many articles. You can read Wayne's articles at:

http://www.sqlservercentral.com/Authors/Articles/Wayne_Sheffield/380617/

Location: Rustenburg, Asiento. Map
Overview: This presentation focused on Banishing RBAR.

 

        Topic: 

Parallel query processing in SQL server 2008

         Date:

Thursday, May 26th, 2011

   Speaker: Rohan is the Treasure of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports.                                                                                               .
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation  focused on Parallel query processing with in SQL Server 2008.The Power point presentation can be downloaded here.

 

 
 

        Topic: 

High Availability in SQL Server 2008, Part 1

         Date:

Thursday, January 27, 2011

   Speaker: Roy Ernest:
Roy is the president of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports. He has also written numerous technical and non technical articles. His articles can be found at SQL Server Central website.         
                                                                                       .
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation focused on one of the methods available for High Availability. The method chosen for this presentation is Database mirroring.
 

 

 

        Topic: 

1)Performance monitors                                                                              2)Comparing Table Variables to Temporary Tables (NetMeeting)

         Date:

Thursday,December 2nd, 2010

   Speaker:

1)Mauri Payne:Mauri works as a Network Administrator at PinnacleSports. He has quite a bit expereince in setting up SQL Servers for high transactional systems. He is also in charge of application security.                                

2)Wayne Sheffield.is an experienced Sr.Application DBA. He has authored many articles. You can read all of Wayne's articles at: http://www.sqlservercentral.com/Authors/Articles/Wayne_Sheffield/380617/.

   Location:

Rust & Burgh, Asiento (Emmastad)

  Overview: This presentation will focus on Performance monitors and Comparing Table Variables to Temporary Tables."Comparing Table Variables to Temporary Tables", will be a net meeting, conducting remotely from USA.
Wayne's presentation slides can be downloaded here.

 

 

        Topic: 

Tally Table and Pseudo Cursors

         Date:

Thursday,September 30th, 2010

   Speaker: Jeff Moden.Jeff Moden is Microsoft SQL Server MVP. He is currently working for DiscoveReady as a Sr.Application DBA.You can read more about Jeff at http://www.linkedin.com/pub/jeff-moden/6/b90/344
   Location:

Buurt centrum, Janwe. Map

  Overview: This presentation was focused on Tally Table and Pseudo Cursors. This was a net meeting, conducted remotely from USA.                                                 Presentation slides can be downloaded here.

 

 

        Topic: 

Query execution plan in SQL Server 2008

         Date:

Thursday,August 22nd, 2010

   Speaker: Roy Ernest.                                                                                                   Roy is the president of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento, Curacao.

  Overview:

This presentation was focused on  getting rid of blockings using row level versioning  in SQL Server.                                                                Presentation slides can be downloaded here.

 

 

        Topic: 

Transparent Data Encryption (TDE) in SQL Server 2008

         Date:

Thursday, July 22nd, 2010

   Speaker: Roy Ernest.                                                                                                   Roy is the president of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento, Curacao.

  Overview: This presentation focused on getting rid of blockings using row level versioning  in SQL Server.                                                                                      Presentation slides can be downloaded here.

 

 

        Topic: 

Getting rid of blockings using Row Level Versioning in SQL Server

         Date:

Thursday, May 27th, 2010

   Speaker: Roy Ernest.                                                                                                   Roy is the president of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento, Curacao.

  Overview: This presentation focused on how to use execution plan to get rid of blockings using row level versioning in SQL Server.                                             Presentation slides can be downloaded here.

 

 

        Topic: 

How to use execution plan to get rid of bad query performance

         Date:

Thursday, April 22nd, 2010

   Speaker: Joe Chang                                                                                                    Also known as the Cost Based Optimizer (CBO).
Joe Chang is a freelance consultant specializing in SQL Server, database architecture, design, performance tuning, and scalability analysis.
You can read his blog on www.qdpma.com.
   Location:

Hilton, Curacao.

  Overview: This presentation will focus on how to use execution plan to get rid of bad query performance.Presentation slides can be downloaded here.

 

 

        Topic: 

Transactional Replication in  SQL Server 2008

         Date:

Thursday, March 18th, 2010

   Speaker: Kevin Batey                                                                                                   Kevin is currently working as a software development team lead with  Pinnacle sports. He has over 10 years of  experience with SQL Server and Microsoft products .
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation was focused on Transactional Replication in SQL Server 2008.The Power point presentation can be downloaded here

 

 

        Topic: 

Designing High Performance I/O for SQL Server

         Date:

Thursday, February 18th, 2010

   Speaker: Jimmy May ,MCM, MCDBA, MCSE, MCITP: DBA + DB Dev                              Jimmy May is currently working as Sr. Performance Consultant for  SQL Server at Microsoft ACE team (Assessment, Consulting, & Engineering ) in Redmond USA. He is well known with in the SQL community and his blog can be found at: http://blogs.msdn.com/JimmyMay/  .
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation was focused on Designing High Performance I/O for SQL Server.The Power point presentation can be downloaded here

 

 

        Topic: 

Resource Governer on SQL Server 2008

         Date:

Thursday, December 3rd , 2009

   Speaker: Roy Ernest                                                                                                  Roy is the president of SQL PASS Curacao and he works in the DBA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation was focused on the 3 W's(What,When and Why) of Resource Governor in SQL Server 2008.                                                           Presentation material can be downloaded here

 

 

        Topic: 

Policy Based Management In SQL Server 2008

         Date:

Thursday, October 22nd , 2009

   Speaker: Rohan works in the DBA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation  focused on features of Policy Base Management in SQL Server 2008 and how to implement it in your organization.                                     Presentation material can be downloaded here

    Sponsor:

Pinnacle sports

 

 

        Topic: 

Power Shell

         Date:

Thursday, September 24, 2009

   Speaker: Johanna Curiel                                                                                        Johanna Curiel works in the QA Department of Pinnacle Sports.
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation is focussed on how you can use Power shell as a tool to make the job easier for Developers, It professionals and DBA's.The Power point presentation can be downloaded here

    Sponsor:

Pinnacle sports

 

 

        Topic: 

Tips and Tricks of SQL Server Management Studio 2008

         Date:

Thursday, August 27, 2009

   Speaker: Bill Wunder                                                                                                  Bill is the Database Manager of Pinnacle Sports. He was the MVP for the years 2003, 2004, 2005 and 2006.
   Location:

Rustenburg, Asiento. Map

  Overview: This presentation was designed to show how you can leverage SSMS 2008 to take control of your Database development. This included central registration and other tips and tricks of using SSMS 2008.The Power point presentation can be downloaded here.

    Sponsor:

Pinnacle sports

 

 

 

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

Sponsors

PASSChapterLogo100.jpg 

 
 


 

 
     
cage-aids
cage-aids
cage-aids
cage-aids