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.

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.

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.

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

 

About the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

In today’s world, you’re more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014, it actually becomes easier.

In this session, we’ll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.

Session Level: Intermediate

This session was presented at PASS Summit 2014.
Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Download the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

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 101 for the SQL Server DBA

 

About the Presentation

PowerShell 101 for the SQL Server DBAThe more you have to manage, the more likely you’ll want to automate your processes. PowerShell scripting language will make you truly effective at managing lots of servers. But it’s more than just a scripting language – it’s an interactive shell that stores data for you and allows you to implement ad-hoc solutions quickly and easily. Within the PowerShell environment you can easily manage both SQL Server instances and the Windows servers themselves, giving you a ‘best of both worlds’ environment that puts you in control. This session will introduce you to SQL Server PowerShell and show you how to use it to manage SQL Server across many instances.

Session Level: Intermediate

Download the Presentation

PowerShell 101 for the SQL Server DBA

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

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.

 

Manage SQL Server Efficiently with PowerShell Remoting

 

About the Presentation

Manage SQL Server Efficiently with PowerShell RemotingYou have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. SQL Server PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously.  In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.

Session Level: Intermediate

Download the Presentation

Manage SQL Server Efficiently with PowerShell Remoting

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

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.