ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
Attend this session and learn how to leverage PowerShell to collect data from Perfmon, DMVs, and more. This session will feature demos where attendees are encouraged to send challenges to the presenter via email for demonstration purposes.
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.
Firstly we will show off Microsoft's enhancements to the Hadoop open source stack with HDInsight showing you how easy it is to get started with Hadoop. Secondly we'll explore an interesting big data use case
I know what you're thinking, Powershell is not an ETL tool. And you're probably right. But I keep running into weird requests that were just easier to fix with Powershell. I'll show you why some things are not easy in SSIS.
This session will demonstrate scripts to gather server inventory data and SQL Server and operating system performance data with PowerShell and provide reports to stay on top of your servers.
This session will include a variety of such activities including Gathering Performance Counters in several servers at the same time using posh jobs, identifying Blocked Sessions and Reading & filtering SQL Error Log even if the Instance is offline
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
It's important to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. This session will show you how to use PowerShell to gather your baseline and how to report it.
How many times have you needed to automate a restore process Asynchronous to N databases and be notified when each finalized? ...Or the SQL Server service stopped in your Server X and a notification in W task bar showing immediately what happened ?
This exciting session will be delivered by PowerShell expert James Boother and Clustering expert Mark Broadbent where we will demonstrate how to use PowerShell to perform SQL Failover Cluster administration and automate simple and complex operations.
I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)
Back (hopefully) by popular demand I'll be sharing the secrets to getting started with Powershell in a SQL Server Environment.
Powershell is a powerful scripting engine that can be used to automate admin tasks making more efficient use of your time. This session will introduce Powershell and how it can be used within a SQL Server environment.
A typical day of DBA and new features of SQL Server 2008 can help - save a minute.
We all have tried and tested methods of doing things, but may be this new dog will help you do those old tricks?
Wouldn't you rather spend your day learning all the funky new features in SQL Server 2008 than running all your daily checks over your instances? SQL Server 2008 introduced Policy Based Management which allows a fine-grained level of configuration and control of the instance's properties. The Enterprise Policy Management Framework takes this and extends it out to allow you to manage SQL 2000 and 2005 instances through policies as well.