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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


SQLSaturday #584 – Colorado Springs 2017

SQLSaturday #584 - Colorado Springs 2017

UpSearch at SQLSaturday #584

UpSearch proudly supported PASS SQLSaturday #584 – Colorado Springs 2017. The event was held March 25, 2017 at Colorado Technical University, 4435 North Chestnut Street, Colorado Springs, Colorado, 80907.

Presentations

The UpSearch team supported SQLSaturday #584 – Colorado Springs 2017 by presenting:

Intro to Azure SQL Databases by Michael Fal.

SQLSaturday #584 - Colorado Springs 2017

 

Thank you to the Colorado Springs SQL Server Users Group for hosting SQLSaturday #584 – Colorado Springs 2017. If you live in the Greater Colorado Springs, CO area, consider getting involved with the Colorado Springs SQL Server Users 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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


Thomas Hoover Joins UpSearch

We are excited to announce Thomas Hoover joined UpSearch.  He will be working as a Data Platform Consultant based in Perrysville, Ohio.  Welcome, Tom!

 

About Tom Hoover

Thomas Hoover Joins UpSearch

Tom Hoover is passionate about helping organizations use Microsoft’s data platform, especially SQL Server, to transform their business while ensuring the critical data systems maintain confidentiality, availability, and integrity.

Since 2005, Tom has specialized in Microsoft’s database platforms and data management. He is an accomplished DBA team leader with significant OLTP and Data Warehouse expertise. Tom excels at protecting data in highly secure environments while empowering users to easily access the information they need to meet their organization’s needs. Tom believes that by correctly using data, businesses can change their customer’s lives.

To learn more about Tom, visit https://upsearch.com/thomas-hoover/.

Please help me welcome Tom to the UpSearch team.

Shawn Upchurch,
Founder & CEO

Welcome to UpSearch Tom!

Fun Facts

Tom is a musician, historian, and avid reader. He is also knowledgeable in the Department of Defense Information Assurance Certification and Accreditation Process (DIACAP) and has a proven track record in managing the Plan of Action and Milestones (POAM) based on Government IA guidance and regulations for both new systems and existing SQL Server systems undergoing re-accreditation. Additionally, Tom has years of experience in ensuring compliance with various DISA Security Technical Implementation Guides (STIGs) using both approved automated tools and manual review.

Tom is married to an incredible lady and has four wonderful daughters.

About UpSearch

up-social-round

UpSearch is a leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.

UpSearch Supports National Entrepreneurship Week

Berea, Ohio — February 20, 2017 — UpSearch, LLC today announced its participation in National Entrepreneurship Week, a weeklong series of activities that celebrates the efforts and impact of entrepreneurs and small-to-midsized businesses. Led by Microsoft and supported by more than 100 companies including UpSearch, National Entrepreneurship Week will kick off on Monday, Feb. 20 […]

SQLSaturday #585 – Boston 2017

SQLSaturday #585 - Boston 2017

UpSearch at SQLSaturday #585

UpSearch proudly supported PASS SQLSaturday #585 – Boston 2017. The event was held February 25, 2017 at Microsoft, 5 Wayside Road, Burlington, Massachusetts, 01803.

Pre-Con

Mike Fal presented a pre-con, Introduction to Powershell. This full day session helped build a foundation for learning and using Powershell. You can find more details here.

 

Presentations

The UpSearch team supported SQLSaturday #585 – Boston 2017 by presenting:

Intro to Azure SQL Databases by Michael Fal.

SQLSaturday #585 - Boston 2017

 

Thank you to the New England SQL Server Users Group and Boston Microsoft BI User Group for hosting SQLSaturday #585 – Boston 2017. If you live in the Greater Boston, MA area, consider getting involved with the New England SQL Server Users Group (t) or Boston Microsoft BI 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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.


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.

Time Travel with SQL Server Temp Table

Presentations (Upcoming & Past)

  • Webinar – January 11, 2016

About the Author

SQL Server Consultant

David Maxwell

David Maxwell is a SQL Server Consultant at UpSearch.

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 leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.

SQL Server Benchmark: The Powershell Speedometer

 

About the Presentation

SQL Server Benchmark: The SQL Server Powershell SpeedometerHow fast do you think you were going? The only way to be sure is to have a reliable way to measure your performance. The challenge with SQL Server is that there are many aspects of your stack that you need to measure and understand. Powershell, with its ability to access and report on all these different levels, can give you a robust tool to benchmark your SQL Server. This session will cover benchmarking methodologies, the tools Powershell offers for capturing performance information, and will demonstrate how you can use them to measure performance statistics. After attending this session, you will understand how to effectively use Powershell to measure your database speed.

Session Level: Intermediate

View Webinar & Download Presentation

SQL Server Benchmark: The SQL Server Powershell Speedometer

Presentations (Upcoming & Past)

  • Webinar – December 7, 2016

About the Author

SQL Server Consultant

Michael Fal

Michael Fal is a SQL Server Consultant at UpSearch.

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Mike has been working with databases for more than 15 years. He continues to blog at http://mikefal.net since 2011, writing about a wide range of topics that center around data management. He is an active member, and former board member, of the Denver SQL Server User Group as well as a volunteer for the Professional Association for SQL Server (PASS).

Learn more about Michael Fal at https://upsearch.com/michael-fal/.

About UpSearch

up-social-round

UpSearch is a leading Microsoft Gold Partner for organizations who rely on Microsoft’s Data Platforms, and its mission is to enable every leader to unlock data’s full potential.