Previous Sessions

Meeting Archive

Got some PowerShell knowledge you'd like to share? Contact us to present!

2016

Hacking SQL Servers on Scale using PowerShell

Scott Sutherland
  @_nullbind
  blog.netspi.com/author/scott-sutherland/
Wednesday, October 19, 2016
This presentation will provide an overview of common SQL Server discovery, privilege escalation, and data targeting techniques. It will also cover how SQL Servers can be leveraged to escalate privileges in Active Directory domains. Finally, we?ll show how PowerShell automation can be used to execute the SQL Server attacks on scale. This should be useful to penetration testers and system administrators trying to gain a better understanding of their SQL Server?s attack surface and how it can be exploited.

 

Need to Speed: Pragmatic Problem Solving with PowerShell

Claudio Silva
  @ClaudioESSilva

  Archived webcast
Tuesday, September 13, 2016
Found a task that needs automation in order to save you time and also offers you a chance to learn more about the product you're working with? Why not try PowerShell? Don't have a PowerShell background? We hope this session will encourage you to get a jump start. Join Claudio Silva as he shares his vision about writing a PowerShell script from scratch and the steps you may want to go through -- all of this based on real world scenarios!

 

PowerShell, SQL and Power BI - Reducing your Context Switching

Rob Sewell
  @sqldbawithbeard
  sqldbawithbeard.com
  Archived webcast
Thursday, August 18, 2016
'Could you just tell me...?' This may cost 10 seconds of time or it may take several hours but it will definitely stop the current task and impact its completion A SQL DBA will be required to provide a myriad of information in many different ways to many different types of people, answering questions from technical teams, technology teams, other parts of the business as well as directors and external parties. In this session you will learn the why, what and how of automating the gathering, storing and displaying of information enabling self-service and reducing the interruptive calls on your time whilst ensuring that the data is correct and trustworthy.

 

The State of PowerShell, SQL Server, and SQLPS

Aaron Nelson, SQL Server MVP
  @sqlvariant
  sqlvariant.com
  Archived webcast
Wednesday, July 6, 2016
SQL Server MVP Aaron Nelson and PowerShell MVP Chrissy LeMaire discuss the past, present and future of SQL Server, PowerShell and SQLPS. Bring your questions.

 

Deploy & Manage Ola Hallengren's scripts with PowerShell

Andre Kamman, SQL Server MVP
  @AndreKamman
  andrekamman.com
  Archived webcast
Wednesday, June 15, 2016
Are you enjoying Ola Hallengren's Maintenance Solution scripts as much as I am? I've written PowerShell scripts to deploy and manage them across multiple servers. While building this I had to use more PowerShell tips and tricks than I thought I would need. I would like to share these lessons learned with you. Do you like PowerShell and Ola Hallengren's scripts? Then do not miss this session.

 

Painting with PowerShell: SQL Server Administration

Chris Sommer
  @cjsommer
  cjsommer.com
  Archived webcast
Wednesday, June 1, 2016
The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks. Join SQL Server DBA and PowerShell Nut Chris Sommer to learn how to paint your own SQL Server canvas with PowerShell.

 

Automating Your SQL Server Best Practices Word Document

Laerte Junior, PowerShell MVP
  @LaerteSQLDBA
  www.simple-talk.com/author/laerte-junior/
  Archived webcast
Wednesday, May 18, 2016
You are a consultant that needs to create a word document for your client with the best practices on SQL Server. You cannot install any kind of third party software so you will ended up doing a lot of queries and copying and paste to a word document.

PowerShell MVP and SQL Server Pro Laerte Junior bets that you will spent a lot of time doing this. What if he told you could do all this work, including color-coded alerts in the document where there are problems or best practices aren't being followed, with 2 clicks of the mouse?

In this session we will see ..well.. come with us and check this out.

 

Advanced PowerShell Development

Bryan Cafferky
  @BryanCafferky
  www.apress.com/9781484205426
  Archived webcast
Tuesday, May 10, 2016
Many people know how to use PowerShell for administration tasks but did you know you can use PowerShell for any type of application development? However, to develop effectively with PowerShell, you need to understand its unique features. In this presentation you will learn how to: maximize reuse with advanced functions using cmdletbinding, increase extensibility with script modules, add support for user interaction, efficiently access SQL Server, add support for application configuration and add support for pipeline processing.

Learn how to take your PowerShell skills to the next level. For those not familiar with PowerShell, here's your chance to see what the buzz is about.

 

You, SQL Server and PowerShell

SQL Server Tiger Team, Microsoft
  @mssqltiger
  blogs.msdn.microsoft.com/sql_server_team
  Archived webcast
Wednesday, April 20, 2016
In this session, Microsoft's SQL Server Tiger Team will talk about how some best practice checks can be automated for SQL Server instances running on your on-premise data centers and on Azure Virtual Machines. Attend this session to learn how you can leverage the POWER of PowerShell to automate health checks, keep your systems healthy and run SQL Server efficiently!

As an added bonus, this session will also cover some of the new enhancements available in SQL Server 2016 setup which will allow you to implement these best practices while installing SQL Server!

 

High Class PowerShell: Objects and Classes in PowerShell

Robert Cain, SQL Server MVP
  @arcanecode
  arcanecode.com
  Archived webcast
Wednesday, April 6, 2016
In this session we will focus on the ability to create custom objects in PowerShell, covering PowerShell versions 3 to 5. We'll then look at the new Class and Enum types included with PowerShell 5, and how to incorporate classes into your own modules.

This session is for people already familiar with PowerShell and are wanting to take their skills to the advanced level by learning how to create their own objects and classes.

Related blog post containing code

 

SQL Server's sqlcmd on Linux using Windows Authentication

Chrissy LeMaire, PowerShell MVP
  @cl
  netnerds.net
  Archived webcast
Tuesday, March 22, 2016
You've heard that SQL Server will soon be available on Linux, but did you know that the client tools have already been ported *and* they support Integrated Authentication? Watch as PowerShell MVP and SUSE Certified Linux Administrator Chrissy LeMaire shows SQL Server MVP Aaron Nelson how to install Linux, join an Active Directory domain, login as a domain user, and execute a SQL query against SQL Server using sqlcmd. PowerShell/Linux command line equivalents will also be discussed.

Blog: SQL Server Client Tools, Linux and Integrated Authentication in a Few Easy Steps
Introduction to PowerShell for Unix people

 

Documenting SQL Server with PowerShell

Sander Stad
  @SQLStad
  sqlstad.nl
  Archived webcast
Wednesday, March 16, 2016
Documentation is mostly overlooked and only comes up when a problem arises. What if you'd have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show you show how easy it is to use PowerShell to retrieve information from your servers. He'll detail what can be used to document your servers, how to retrieve the information and what should be documented. In the end you no longer have an excuse not to document your servers.

Documenting SQL Server with PowerShell on Simple Talk
The PSSQLLib module

 

PowerShell Unbound - Tips & Tricks

Jeff Wouters, PowerShell MVP
  @JeffWouters
  jeffwouters.nl
  Archived webcast
Monday, February 29, 2016
This session is all about tips 'n tricks you can use in PowerShell. Mostly practical, some improve performance of scripts and others are just plain fun.

 

2015

Maintain SQL Server Performance Baseline with PowerShell

Allen White, SQL Server MVP
  @SQLRunr
  sqlblog.com/blogs/allen_white/
  Archived webcast
Monday, November 23, 2015
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

 

PS C:\> Get-Started -With 'PowerShell for SQL Server'

Mike F Robbins, PowerShell MVP
  @mikefrobbins
  mikefrobbins.com
  Archived webcast
Wednesday, June 17, 2015
What's this thing called PowerShell? Why should I care? And what can it do for me? During this beginner level session, PowerShell MVP and scripting games winner Mike F Robbins will be covering all of those questions and many more that are all too common among PowerShell noobs such as: How do I figure out what the commands are? And how do I extend PowerShell's functionality to manage products like SQL Server? The first beta of PowerShell was released 10 years ago and with it now being part of Microsoft's common engineering criteria, it's not going away any time soon so what are you waiting for?

 

Stupid PowerShell Tricks

Jim Christopher, PowerShell MVP
  @beefarino
  beefycode.com
  Archived webcast
Friday, May 22, 2015
Let's face it - I'm no SQL guy, and you're no .NET developer. But that just means there is a ton we can learn from each other. Come spend an hour hearing and sharing practical, time-saving PowerShell hacks you can start using today. Start taking your one-liners and turn it into a crisp, clean, reusable PowerShell!

 

Carpe Scriptum! Make the PowerShell ISE Work for You

Jeffery Hicks, PowerShell MVP
  @jeffhicks
  jdhitsolutions.com
  Archived webcast
Thursday, May 14, 2015
Hopefully you know that when it comes to writing PowerShell scripts and tools, you should be using at least the PowerShell ISE. If you are, odds are you are spending too much time writing PowerShell commands. In this presentation you will learn a how to get the most out of the PowerShell ISE. From snippets, to customizing the look and feel, to creating your own add-ons you'll be eager to open up the ISE and get started.

 

Simplifying SQL Server Migrations with PowerShell

Chrissy LeMaire, PowerShell MVP
  @cl
  netnerds.net
  Archived webcast
Thursday, May 14, 2015
Imagine migrating SQL Server databases, logins, jobs, operators, and other SQL Server components with just a single command; this is what PowerShell can do for you. In this session, I'll discuss the reasons DBA's migrate SQL Server instances, some of the tools and techniques that are used, and the objects that are most commonly migrated, along with considerations that must be made for each. Then, I'll perform a few migrations using PowerShell scripts available within my sqlmigration repository on github. Code specifics and current limitations will also be discussed.

 

PowerShell Tips and Tricks for SQL Server Administration

Mike Fal
  @mike_fal
  mikefal.net
  Archived webcast
Friday, April 17, 2015
Have you dipped your toe into the 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.

 

Making PowerShell useful for your team

Rob Sewell
  @sqldbawithbeard
  sqldbawithbeard.com
  Archived webcast
Thursday, March 19, 2015
You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team. I will show you how you can achieve this by demonstrating An easy way to learn the syntax How to explore SQL Server with PowerShell How to turn your one off scripts into shareable functions How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions Where else to go for help

 

PowerShell Building Azure Quick VMs

Max Trinidad, PowerShell MVP
  @MaxTrinidad
  maxtblog.com
  Archived webcast
Thursday, February 19, 2015
This is a PowerShell Azure via to quickly create Virtual Machines in it's basic form. It will give you a quick way to get you started with Microsoft Azure. Live Sample demo will be shown.

 

2014

PowerShell Desired State Configuration

Steven Murawski, PowerShell MVP
  @StevenMurawski
  stevenmurawski.com
Wednesday, June 18, 2014
Desired State Configuration offers a lifeline to those of us who are forging our way through data centers with racks of snowflake servers, those servers whose configurations are lovingly hand crafted by proud sysadmins. While we stand proud on those 'works of art', other sysadmins curse our names when troubleshooting applications that behave differently on servers that are intended to be the same. Those same sysadmins tremble in fear of ever having to re-create those undocumented, intricate environments. DSC promises to deliver us from this chaos and bring our configurations forward into a well documented, version-able artifact. DSC has several moving parts that can be daunting at first glance. Join me in exploring the structure of Desired State Configuration and the in-box and custom resources required to drive it.

 

Restoring SQLServer Databases with PowerShell

Johan Bijnens
  @alzdba
  www.mssqltips.com/sqlserverauthor/146/johan-bijnens/
Wednesday, May 21, 2014
Build plan of approach to structured point in time restores of databases ( e.g. from Production to QA ) using PowerShell as an easy helper tool to ensure all steps are being performed.

 

Windows PowerShell Best Practices

Ed Wilson, Microsoft
  @scriptingguys
  scriptingguys.com
Wednesday, April 23, 2014
Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences

 

SQL Agent Job Status Reporting With Windows PowerShell

Kendal Van Dyke, Microsoft
  @sqldba
  kendalvandyke.com
Wednesday, March 26, 2014
A critical, yet tedious, task DBAs perform on a daily basis is making sure SQL Agent jobs have run properly. Manually checking each instance is slow and doesn't scale beyond a handful of servers. Agent alerts are helpful but can easily get lost and forgotten in your inbox; Monitoring tools make things a little easier - provided every one of your instances is monitored. What we really just need is a simple and efficient way to see the status of jobs across all instances. Windows PowerShell is a perfect fit for the task, and in this session you'll learn how to automate building a daily report so that you can see what's happening with SQL Agent jobs in one place.

 

Avoiding the PowerShell Gotchas

Don Jones, PowerShell MVP
  @concentrateddon
  donjones.com
Wednesday, February 19, 2014
Join Windows PowerShell MVP Don Jones for a fun- and fact-filled session on 'PowerShell Gotchas.' These are the tips and tricks that are tough to tease out on your own, but once you conquer them the shell will be friendlier and even more powerful. If you're a PowerShell novice, this will keep you out of trouble; if you're an accomplished expert, this will help you help others achieve the same lofty heights. Start 2014 off right by connecting with PowerShell community, overcoming 'the gotchas,' and amping up your PowerShell sk1llz!

 

2013

SSIS - Integrating PowerShell in a ScriptTask Component

Max Trinidad, PowerShell MVP
  @MaxTrinidad
  maxtblog.com
Monday, November 18, 2013
This session will demostrate how you can reuse a PowerShell script in SSIS 'Script Task' component as part on a ETL flow. I'll be showing some basic .NET Script code in both C# and VB. I'll be adding some useful tips when re-using existing PowerShell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Session Level: Intermediate

 

Building Your Test Lab with Client Hyper-V & PoSh

Aleksandar Nikolic, PowerShell MVP
  @alexandair
  powershellers.blogspot.com
  Archived webcast
Wednesday, August 21, 2013
With Windows PowerShell 3.0 and the new Client Hyper-V available in Windows 8, it is so easy, and fun, to automate creation of your demo environment or a test lab infrastructure. You can easily convert ISO files to VHDs, deploy your VMs, configure networking, and create a test domain. Join us for this demo-heavy session to see all the steps.

 

Creating HTML reports with PowerShell

Jeffery Hicks, PowerShell MVP
  @jeffhicks
  jdhitsolutions.com
Wednesday, July 17, 2013
Creating HTML reports on one hand is almost brain-dead easy in PowerShell. But using it with style takes a little more work. Wouldn't you like to add a little pizzazz to your HTML reports that you create in PowerShell. In this session I'll offer some tips and tricks for creating great looking, or at least better looking, HTML reports including stylized alternate rows and embedded graphics.

 

PowerShell Fundamentals for Beginners

Mike F Robbins, PowerShell MVP
  @mikefrobbins
  mikefrobbins.com
  Archived webcast
Wednesday, June 19, 2013
PowerShell IS where Microsoft is going for the administration of its products. If you're not actively trying to learn PowerShell today, you're soon going to be well behind the learning curve of the average IT pro. This session will start from zero and cover the basic fundamentals of PowerShell that will get you started on the right track to becoming a PowerShell Hero.

 

2011

Extend your T-SQL Scripting with PowerShell

Max Trinidad, PowerShell MVP
  @MaxTrinidad
  maxtblog.com
Wednesday, November 16, 2011
I'll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we'll be creating a solution that put together all this techniques.

 

SQL Server Performance Monitoring with The Scripting Guy

Ed Wilson, Microsoft
  @scriptingguys
  scriptingguys.com
Wednesday, July 20, 2011
Monitoring the performance of a SQL Server is one of those 'floss your teeth' type of activities. Everyone knows you are supposed to do it, but it is annoying and so very few people actually do it. Luckily, this can change. In Windows PowerShell 2.0 an easy to use cmdlet was introduced that permits quick ad-hoc queries of literally hundreds of performance counters. This means that the enterprising Database Administrator can easily check specific performance counters and take the appropriate action. But how does one go about this? In this session, Microsoft Scripting Guy (and author of six books on scripting) discusses finding appropriate performance counters, performing quick checks of specific counters, baselining specific counters, and developing robust monitoring solutions. It is a fast paced, demo heavy presentation taught by one of the world's leading Windows PowerShell experts.

 

Using PowerShell to Rapidly Deploy SQL Server

Michael Wells
  @sqltechmike
  sqltechmike.com
Wednesday, June 15, 2011
This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, agent jobs, and stored procedures.

 

Central Auditing of SQL Permissions with PowerShell & TSQL

Nicholas Cain, SQL Server MCM
  @SirSQL
  sirsql.net
Wednesday, May 18, 2011
As a DBA it can be a challenge to know who has permissions to what SQL instances and what objects. The more instances you have the more complex that task. In this presentation I'll share a method using PowerShell and TSQL that can be used to capture permissions from all of your SQL instances and load them into a centralized location. We'll even take it a step further by auditing those permissions so that we can quickly and easily identify any that might have changed.

 

PowerShell provisioning of Hyper-V Servers

Marco Shaw, Former PowerShell MVP
  @marcoshaw
  marcoshaw.blogspot.ca
Wednesday, April 20, 2011
Marco provides an overview of using sysprep for Windows Server 2008R2, and SQL Server 2008R2, which also now supports this feature. This is especially useful when wanting to get up a new (lab or even production environment) quickly. He will be doing this using only Microsoft Hyper-V & Windows PowerShell without any other external tools.

 

.NET Powers Activate! Form of PowerShell

Eric Humphrey
  @lotsahelp
  erichumphrey.com
Wednesday, February 16, 2011
PowerShell's cmdlets can be pretty powerful on their own, but that's only part of the power of PowerShell. The .NET Framework is the basis of the PowerShell environment. As such, you have a vast library of operations at your disposal. Learn to use its abilities and save the day without needing a monkey with a bucket.

 

2010

PowerShell Grab Bag

Aaron Nelson, SQL Server MVP
  @sqlvariant
  sqlvariant.com
Wednesday, December 15, 2010
In this short grab bag session we'll go over a bunch of new scripts that I've built over the last few weeks. Things like: checking free space on mount points, checking SQL agent for failed jobs, polling instances to make sure they're available, checking the status of log shipping across multiple targets, emailing result sets and scheduling all these with SQL Agent. We'll also go over zipping files and checking remote registries (including why on earth you would ever want to do that?!). Even better, we'll go over how to not zip files that have already been zipped. The final grab from this session: for all the Summit attendees out there, I'll share with you my script to download all the session videos from the 2010 Summit

 

Automation in the DBA World

Chad Miller
  @cmille19
  sev17.com
Wednesday, October 20, 2010
Chad Miller presents an introduction to PowerShell as a command line for one-off tasks or automation in the DBA world. Basic PS principles and syntax are covered. Get your proverbial DBA feet wet with a tool that can make your database and sysadmin life better than it was before! Bigger, stronger, faster. (Cue Bionic Man theme)

 
Back to Top