Got some PowerShell knowledge you'd like to share? Contact us
Hacking SQL Servers on Scale using PowerShell
|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
|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
|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.
|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.
|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.
|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.
|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.
|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.
|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!
|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
|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
|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.
|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.
|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?
|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!
|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.
|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.
|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.
|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
|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.
|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.
|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.
|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
|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.
|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!
|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
|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.
|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.
|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.
Extend your T-SQL Scripting with PowerShell
|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
|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
|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
|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
|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
|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.
PowerShell Grab Bag
|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
|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)