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.

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,” […]

Azure SQL Database Presentation

 

About the Presentation

Azure SQL Database PresentationIn this Azure SQL Database presentation, Michael Fal introduces how Azure SQL Databases are still something new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft’s Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.

Session Level: Beginner

Download the Presentation

Azure SQL Database Presentation

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.

Exploring SQLPS, the SQL Server Powershell Module

 

About the Presentation

Exploring SQLPS, the SQL Server Powershell ModuleA big hurdle for using Powershell and SQL Server together is the SQLPS module. Both old and new users of SQL Server Powershell don’t completely understand its capabilities. In this session, we’ll talk about the cmdlets you may not know about, tricks to save time using the provider, and even a few gotchas on how the provider works that can save you some time and energy. When we’re finished, you will have a deeper understanding of how you can use SQL Server and Powershell together.

Session Level: Beginner

Download the Presentation

Exploring SQLPS, the SQL Server Powershell Module

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.

Managing SQL Server Availability Groups

 

About the Presentation

Managing SQL Server Availability GroupsHave you built SQL Server Availability Groups only to be suddenly surprised by all the gotchas and hurdles that pop up? Are you struggling with keeping your Availability Group running smoothly without a lot of management on your part? This session will cover what happens after you have created an Availability Group and how to manage it. We will review tips, tricks, and patterns for handling all the considerations that running this popular high availability solution. After this session, you will be prepared for managing your Availability Groups and how you can streamline that management to make your availability strategy more robust.

Session Level: Intermediate

Download the Presentation

Managing SQL Server Availability Groups

Presentations (Upcoming & Past)

 

Want to Learn More About SQL Server Disaster Recovery?

If you'd like to learn more about how UpSearch can support your SQL Server disaster recovery initiative, visit SQL Server Disaster Recovery or contact us today.

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.

Powershell Jumpstart for SQL Server DBAs

 

About the Presentation

Powershell Jumpstart for SQL Server DBAsSQL Server Powershell can be hard. As a language, it is fairly complex and provides a large array of functionality. Fortunately, you can teach yourself how to use Powershell with tools that are built right into the language. This session will cover some Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, taking the mystery out of the code and helping you start writing your own Powershell scripts. The key to learning Powershell is using it and this session will give you a launchpad to start building your own tools.

Session Level: Beginner

Download the Presentation

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.