Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Mid October Free Training from PASS Virtual Chapters

By Aaron Nelson,

Introduction to PowerShell
Getting started with Steam Insight and Complex Event Processing Applications
Using Microsoft BI Tools to Access Oracle Applications Data

_____________________________________________________________

Introduction to PowerShell
Wednesday October 20th 12 pm EDT (GMT-4)
Chad Miller

Chad will get us started with an introduction to PowerShell as a command line for one-off tasks or automation in the DBA world. Basic PS principles and syntax will be 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)

Chad Miller
Chad hails from the land of rocket launches, oranges, and alligators where he started the Tampa PowerShell User Group. Chad is the DBA for SQL Server and Manager of Database Administration for a shop supporting SQL Server, Oracle, and Informix, acts as coordinator for the SQL Server PowerShell Extensions CodePlex project, and maintains an active blog at http://sev17.com/author/chad-miller/.

How do I attend? Registration for the event is now open.
*When you register you'll get a calendar reminder for the event.
_____________________________________________________________

Getting started with Steam Insight and Complex Event Processing Applications
Wednesday October 20th 12 pm EDT (GMT-4)
Chris Coneybeer

Today we find our systems and users need to be able to quickly collect, analyze, and act upon data that is being streamed from an unlimited number of devices or systems in our enterprises. Frequently, this raw data is being collected from many different sources such as sensors on production lines, usage events from a website, or even just consumption data from a power meter. Generally this raw data goes through a time consuming process of collection, aggregation, and then querying before it can be used for business process decisions. SteamInsight is a new platform included with SQL Server 2008 R2 that is used to build Complex Event Processing (CEP) applications that are used to monitor these raw data streams. Using StreamInisght your applications will have the ability to analyze, correlate, and use the data contained in streams while it is in-flight. This is done by creating adapters that are responsible for monitoring streams and then writing queries against the adapters. During this session we will discuss what StreamInsight is, what stories it addresses in system architectures, and then we will look at some examples of using the Stream Insight platform and getting started with your own queries.

Chris Coneybeer
Chris is a C#/SQL developer with over 10 years of development experience working with Microsoft stack. Currently Chris works as an independent developer for small business and working in the banking industry as a contractor. Since his move the Phoenix area Chris has discovered the value and rich experience that community provides by sharing ideas and having open discussions. Chris enjoys working on connected systems and finding ways to leverage data for technology workers. During the years he has worked with VB6, VB.NET, C#.NET, ASP/ASP.NET, AJAX, XML, WCF, SSRS, SSIS, T-SQL, and other assorted technologies. His current interests include WCF, EF and WF improvements in the 4.0 framework along with SQL2008R2. Chris is the Vice-President of the Southeast Valley .NET User Group (SEVDNUG) in Chandler Arizona which supports local .NET developers through regular meetings and events. Recently he also gotten more involved with the Phoenix Connected Systems User Group(PCSUG) as Membership Director and is working with the leadership to grow the reach of the group.

How do I attend? Live Meeting link

_____________________________________________________________

Using Microsoft BI Tools to Access Oracle Applications Data
Wednesday October 20th 12 pm EDT (GMT-4)
Daryl Orts

One of the challenges in using Microsoft's BI tools (Reporting Services, Analysis Services, Excel, PowerPivot) to access Oracle applications data lies in building metadata models to make sense of the data. Whether you're accessing the data directly in the transaction database or building a data warehouse, you'll need data models that make sense of the Oracle database schema.

This beginner to intermediate level presentation will discuss design approaches for building these models, including commercial products available from the presenter, Noetix Corporation

How do I attend? Live Meeting link

Total article views: 693 | Views in the last 30 days: 1
 
Related Articles
BLOG

Parsing Windows event logs with PowerShell

Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possib...

BLOG

Querying Oracle from Powershell Part 1

In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Befo...

BLOG

Powershell Get-EventLog and Event Log messages

This post explains how to list Event Log Messages with Powershell Get-EventLog  , on multiple server...

ARTICLE

PowerShell Basics

Powershell. I have seen the word but what is it? This article gives you a basic introduction to what...

FORUM

SQL Server 2005 vs Oracle 9i for JAVA Application

SQL Server 2005 vs Oracle 9i for JAVA Application

Tags
bi    
free training    
oracle    
powershell    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones