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.

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 S. Fal is an UpSearch Alum and Microsoft Data Platform MVP. He 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 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.


IT/Dev Connections 2016

 

UpSearch at IT/Dev Connections 2016

 

UpSearch at IT/Dev Connections

UpSearch’s Michael Fal proudly supported IT/Dev Connections 2016. The event was held October 10-13, 2016 at the ARIA, 3730 Las Vegas Blvd South, Las Vegas, NV 89158.

 

Presentations

To learn more about Mike Fal’s Managing SQL Server with Powershell presentation at IT/Dev Connections, visit the session details.

Managing SQL Server with Powershell by Michael Fal

IT/Dev Connections 2016

To learn more about Mike Fal’s Intro to Azure SQL Database presentation at IT/Dev Connections, visit the session details.

Intro to Azure SQL Database by Michael Fal

IT/Dev Connections 2016

About IT/Dev Connections

IT/Dev Connections 2016IT/Dev Connections (t) training sessions teach skills to developers and IT professionals. Its speakers include the most knowledgeable and accomplished developers, technology experts, and strategists in the industry.

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.


Managing SQL Server with Powershell

 

About the Presentation

Managing SQL Server with PowershellHave you dipped your toe into the SQL Server Powershell pool, but are still lost on how you can make it work for you? Maybe you’re just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

Learning Objectives

  1. Powershell basics and how they apply to SQL Server
  2. What specific Powershell tools exist for managing SQL Server
  3. Practical use cases and demos of how Powershell can be used to manage SQL Server

Session Level: 101 – Foundational

Download the Presentation

Managing SQL Server with Powershell

Presentations (Upcoming & Past)

 

About the Author

SQL Server Consultant

Michael Fal

Michael S. Fal is an UpSearch Alum and Microsoft Data Platform MVP. He 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 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.

Mike Fal Awarded Microsoft Data Platform MVP

Berea, OH – October 1, 2016 – Our warmest congratulations to Mike Fal, who has been recognized as a Microsoft Data Platform MVP for 2016. The MVP Award is Microsoft’s way of acknowledging and supporting outstanding contributions to the community. “Over the past few years, Mike has been an exceptional contributor to the SQL Server community,” […]

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.


SQL PASS Detroit – September Meeting 2016

UpSearch at SQL PASS Detroit - September Meeting

UpSearch at SQL PASS Detroit

UpSearch’s David Maxwell proudly supported SQL PASS Detroit – September Meeting. The event was held September 15, 2016 at Microsoft Heartland District Office, 1000 Town Center Dr., Suite 1930, Southfield, MI 48075.

Presentation

DBA 911 – Database Corruption by David Maxwell.

SQL PASS Detroit - September Meeting

 

Thank you to SQL PASS Detroit for hosting their September meeting. If you live in the Greater Detroit, MI area, consider getting involved with SQL PASS Detroit.

 

About SQL PASS Detroit

SQL PASS Detroit - September MeetingSQL PASS Detroit is affiliated with the Professional Association for SQL Server and has meetings on the second Thursday 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.