Posts

SQLSaturday #698 – Nashville 2018

SQLSaturday #698 - Nashville 2018

UpSearch at SQLSaturday #698

UpSearch proudly supported PASS SQLSaturday #698 – Nashville 2018. The event was held January 13, 2018 at Middle Tennessee State University, 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132.

Presentations

The UpSearch team supported SQLSaturday #698 – Nashville 2018 by presenting:

Working with Temporal Data in SQL Server by David Maxwell.

SQLSaturday #698 - Nashville 2018

 

Thank you to the Nashville SQL Server User Group and Nashville BI User Group for hosting SQLSaturday #698 – Nashville 2018. If you live in the Greater Nashville, TN area, consider getting involved with the Nashville SQL Server User Group (t) or Nashville BI User Group (t).

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLSaturday #680 – Kansas City 2017

SQLSaturday #680 - Kansas City 2017

UpSearch at SQLSaturday #680

UpSearch proudly supported PASS SQLSaturday #680 – Kansas City 2017. The event was held October 7, 2017 at Rockhurst University, 100 Rockhurst Road, Kansas City, Missouri, 64110.

Presentations

The UpSearch team supported SQLSaturday #680 – Kansas City 2017 by presenting:

Working with Temporal Data in SQL Server by David Maxwell.

SQLSaturday #680 - Kansas City 2017

 

Thank you to the Kansas City SQL Server User Group for hosting SQLSaturday #680 – Kansas City 2017. If you live in the Greater Kansas City, MO area, consider getting involved with Kansas City SQL Server User Group.

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


SQLSaturday #629 – Indianapolis 2017

SQLSaturday #629 - Indianapolis 2017

UpSearch at SQLSaturday #629

UpSearch proudly supported PASS SQLSaturday #629 – Indianapolis 2017. The event was held August 12, 2017 at Ivy Tech Noblesville, 300 N 17th St, Noblesville, Indiana, 46060.

Presentations

The UpSearch team supported SQLSaturday #629 – Indianapolis 2017 by presenting:

Introduction to Database Administration by David Maxwell.

SQLSaturday #629 - Indianapolis 2017

Handling Temporal Data in SQL Server 2016 by David Maxwell.

SQLSaturday #629 - Indianapolis 2017

 

Thank you to IndyPASS for hosting SQLSaturday #629 – Indianapolis 2017. If you live in the Greater Indianapolis, IN area, consider getting involved with IndyPASS (t).

About PASS SQLSaturday

up-social-round

The PASS SQLSaturday program provides tools and knowledge needed for groups and event leaders to organize and host a free day of training for SQL Server professionals. To learn more about PASS SQL Saturday, visit http://www.sqlsaturday.com/about.aspx.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.


Time Travel with SQL Server Temp Table

 

About the Presentation

Time Travel with SQL Server Temp TableIn many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it’s calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it’s useful to be able to look back in time through our data. Solutions like Change Data Capture or trigger-based audit tables are usually slow, and require a lot of extra code to be effective. Fortunately, SQL Server 2016 introduces system-versioned tables, also known as Temporal Tables, which track data through time with far less overhead than other solutions. In this session, you’ll learn how to create temporal tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for temporal tables and the knowledge to implement them.

SQL Server Temp Table

Presentations (Upcoming & Past)

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.