Posts

SQLSaturday #643 – Louisville 2017

SQLSaturday #643 - Louisville 2017

UpSearch at SQLSaturday #643

UpSearch proudly supported PASS SQLSaturday #643 – Louisville 2017. The event was held August 5, 2017 at Indiana Wesleyan University, 1500 Alliant Avenue, Louisville, Kentucky, 40299.

Presentations

The UpSearch team supported SQLSaturday #643 – Louisville 2017 by presenting:

Wait Statistics – The Top 5 Waits You Should Know by David Maxwell.

SQLSaturday #643 - Louisville 2017

 

Thank you to the Louisville SQL Server and Power BI User Group for hosting SQLSaturday #643 – Louisville 2017. If you live in the Greater Louisville, KY area, consider getting involved with Louisville SQL Server and Power 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.


SQL PASS Michiana – June Meeting 2017

UpSearch at SQL PASS Michiana - June Meeting

UpSearch at SQL PASS Michiana

UpSearch’s David Maxwell proudly supported SQL PASS Michiana – June Meeting. The event was held June 26, 2017 at Harmony Healthcare IT, 53702 Generations Dr., South Bend, IN 46635.

Presentation

DBA Basics – Intro to Database Maintenance by David Maxwell.

SQL PASS Michiana - June Meeting

 

Thank you to SQL PASS Michiana for hosting their June meeting. If you live in the Greater South Bend, IN area, consider getting involved with SQL PASS Michiana (t).

 

About SQL PASS Michiana

SQL PASS Michiana - June MeetingSQL PASS Michiana is affiliated with the Professional Association for SQL Server and has meetings on the last Monday of every month.

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.


DBA Basics – Intro to Database Maintenance

 

About the Presentation

Performance tuning, index design, etc… these are great skills to have, but there are four basic tasks that every DBA should know how to do backwards and forwards without even thinking about it. They are, in this order: Restore, Backup, Index Maintenance, and Consistency Checking. After attending this session, you will be able to restore a database in a few different ways, take the right backups in order to restore that database, know how and when to maintain the indexes and statistics, and check for database corruption.

DBA Basics - Intro to Database Maintenance

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.

SQLSaturday #604 – Madison 2017

SQLSaturday #604 - Madison 2017

UpSearch at SQLSaturday #604

UpSearch proudly supported PASS SQLSaturday #604 – Madison 2017. The event was held April 8, 2017 at The Pyle Center, University of Wisconsin-Extension, 702 Langdon Street, Madison, Wisconsin, 53706.

Presentations

The UpSearch team supported SQLSaturday #604 – Madison 2017 by presenting:

Understanding and Handling Database Corruption by David Maxwell.

SQLSaturday #604 - Madison 2017

 

Thank you to the six Wisconsin SQL Server User Groups for hosting SQLSaturday #604 – Madison 2017. If you live in Wisconsin, consider getting involved with FoxPASS (t), MADPASS (t), Microsoft BI Professionals, Western Wisconsin PASS (t), WausauPASS (t) or WI SSUG.

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 #600 – Chicago 2017

SQLSaturday #600 - Chicago 2017

UpSearch at SQLSaturday #600

UpSearch proudly supported PASS SQLSaturday #600 – Chicago 2017. The event was held March 11, 2017 at DeVry University – Addison Campus, 1221 North Swift Road, Addison, Illinois, 60101.

Presentations

The UpSearch team supported SQLSaturday #600 – Chicago 2017 by presenting:

SQL Server Wait Statistics – The Top 5 Waits You Should Know by David Maxwell.

SQLSaturday #595 - Cleveland 2017

 

Thank you to the Chicago SQL Server User Group and Chicago Suburban SQL Server User Group for hosting SQLSaturday #600 – Chicago 2017. If you live in the Greater Chicago, IL area, consider getting involved with the Chicago SQL Server User Group (t) or Chicago Suburban 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 #595 – Cleveland 2017

SQLSaturday #595 - Cleveland 2017

UpSearch at SQLSaturday #595

UpSearch proudly supported PASS SQLSaturday #595 – Cleveland 2017. The event was held February 4, 2017 at Hyland Software, 28500 Clemens Rd., Cleveland, Ohio, 44145.

Presentations

The UpSearch team supported SQLSaturday #595 – Cleveland 2017 by presenting:

SQL Server Wait Statistics – The Top 5 Waits You Should Know by David Maxwell.

SQLSaturday #595 - Cleveland 2017

 

Thank you to the Ohio North SQL Server User Group for hosting SQLSaturday #595 – Cleveland 2017. If you live in the Greater Cleveland, OH area, consider getting involved with the Ohio North SQL Server 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 #581 – Nashville 2017

SQLSaturday #581 - Nashville 2017

UpSearch at SQLSaturday #581

UpSearch proudly supported PASS SQLSaturday #581 – Nashville 2017. The event was held January 14, 2017 at Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Tennessee, 37132.

Presentations

The UpSearch team supported SQLSaturday #581 – Nashville 2017 by presenting:

Understanding and Handling Database Corruption by David Maxwell.

SQLSaturday #581 - Nashville 2017

 

Thank you to the Nashville SQL Server Users Group and NashBI for hosting SQLSaturday #581 – Nashville 2017. If you live in the Greater Nashville, TN area, consider getting involved with the Nashville SQL Server Users Group (t) or NashBI (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.

PASS Summit 2016

 

UpSearch at SQL PASS Summit 2016 - A SQL Server Conference

 

UpSearch at PASS Summit 2016

UpSearch’s David Maxwell and Michael Fal proudly supported PASS Summit 2016. The event was held October 25-28, 2016 at the Washington State Convention and Trade Center, 705 Pike Street, Seattle, WA 98101.

 

Presentations

To learn more about David Maxwell’s Turbo Charged SQL Transaction Logs – Internals and Performance presentation at PASS Summit, visit the session details.

Turbo Charged SQL Transaction Logs – Internals and Performance by David Maxwell

SQL PASS Summit 2016 - A SQL Server Conference

To learn more about Mike Fal’s Powershell Jumpstart for SQL Server DBAs presentation at PASS Summit, visit the session details.

Powershell Jumpstart for SQL Server DBAs by Michael Fal

SQL PASS Summit 2016 - A SQL Server Conference

About PASS

SQL PASS Summit 2016 - A SQL Server Conference

PASS (t) is an independent, not-for-profit organization run by and for the community. With a growing membership of more than 100K, PASS supports data professionals throughout the world who use the Microsoft data platform.

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 #548 – Kansas City 2016

UpSearch at SQLSaturday #548 - Kansas City 2016

UpSearch at SQLSaturday #548

UpSearch proudly supported PASS SQLSaturday #548 – Kansas City 2016. The event was held September 24, 2016 at Rockhurst University, 1100 Rockhurst Road, Kansas City, Missouri, 64110.

Presentations

The UpSearch team supported SQLSaturday #548 – Kansas City 2016 by presenting:

Turbo Charged Transaction Logs – Internals and Performance by David Maxwell.

SQLSaturday #548 - Kansas City 2016

Powershell Jumpstart for SQL Server DBAs by Michael Fal.

SQLSaturday #548 - Kansas City 2016

Thank you to the Kansas City SQL Server User Group for hosting SQLSaturday #548 – Kansas City 2016. If you live in the Greater Kansas City, MO area, consider getting involved with the Kansas City SQL Server User Group (t).

 

UpSearch

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.