San Antonio SQL Server User Group

 

Welcome to SALSSA 

San Antonio League of SQL Server Administrators

Our regular monthly meetings occur on the 3rd Wednesday of each month from 6pm - 8pm. Pizza and drinks are provided at the beginning of the meeting. We meet at New Horizons Computer Learning Center located at

New Horizons Computer Learning Center

2727 NW Loop 410
San Antonio, TX 78230

For any questions please email salssa@sqlpass.org 


Next Meeting

Wednesday,

April

18

Mike Burek: Windowing Functions

  • In-Person @ 2727 Northwest Loop 410 #103 San Antonio, Texas, United States (map)
  • 18:00 - 20:00 Central Daylight Time
  • Language: English

• Pizza and soft drinks provided

• RSVP is not necessary, please come if you can

Featured Presentation:

Windowing Functions

Mike Burek, SQL Developer

If you ever write SQL, you could benefit from windowing functions. You can do the same with hundreds of lines of code, or you can use windowing functions to make your code smaller, easier to debug, more readable, and easier to pass off to someone else to maintain. From data quality checks, to de-duplicating data, to hierarchies, there may be a windowing function for you. You may already know some windowing and aggregate functions, but do you know the features added to your tried and true windowing functions in SQL 2005, SQL 2008, and SQL 2012? Come learn some great ways to improve your coding.

About Mike:
He started by building a complete computerized inventory management system for a multi-state store. Next, he managed Texas Medicare and Medicaid claim data to keep it processing, and building new monitoring metrics. Afterwards, he processed and analyzed marketing data on tens of millions of customers and sent hundreds of millions of multi-lingual marketing messages worldwide. Upgrading those marketing skills, he then worked to process and query tune marketing data for tens of thousands of worldwide enterprise customers, bringing in tens of millions of dollars per campaign. Now he monitors database servers to keep them running well, tunes queries, and helps businesses build new ETL processes. He also runs the Austin, TX user group.

PASSChapterLogo.jpg

sql_micro_sm.gif

SQL Watchmen

 

 

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