Welcome

The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server. We are here to support the SQL Server users in the Madison, WI area. We plan to meet on the third Wednesday of every month.

Meetings are always FREE and food is provided. Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session. Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Q&A Session / Door Prizes / Wrap-up

 

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

July

18

July MadPASS Monthly Meeting

5:30 - 5:45 - Food & Networking

5:45 - 6:15 - General Q&A session & Announcements

6:15 - 7:30 - Main Presentation

7:30 - 7:45 - Q&A Session & Wrap-up

 

Third Wednesday of month

Time: 5:30 to 8:00 PM

Featured Presentation:

Learn History from Temporal Tables

Ameena Lalani, Senior SQL Server DBA NCSBN

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.

About Ameena:
Ameena started her SQL Server journey with SQL Server 2000. She is a Microsoft Certified Solution Associate on SQL Server 2016. She is a Chapter leader of Chicago SQL Server User Group. She has implemented quite a number of High Availability and Disaster Recovery solutions at various companies where she has worked. Ameena loves to Share her knowledge about SQL Server and to learn from others who like to share their knowledge. She really believes that no one is smarter than all of us combined together.

Connect with us!

 

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

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