Pages

Thursday, September 27, 2012

October Free Training from Pragmatic Works


Date:  October 2, 2012, 11:00AM EDT


Informatica and SSIS offer similar functionality for moving data around your organization, but scratch below the surface and you will find some big differences in how these tools approach common ETL problems. If you are interested in migrating ETL processes to Integration Services, then this webinar will be highly beneficial. We will cover some common patterns found in Informatica, and explain how to get the same results from SSIS. For more advanced Informatica scenarios, we will also cover the use of PragmaticWorks’ Task Factory components to fill in some of the gaps in Integration Services.


Speaker: Jody Roberts
Topic: SQL Server Distributed Replay
Date: October 4, 2012, 11:00AM EDT


The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning. Similar to SQL Server Profiler, you can use Distributed Replay to replay a captured trace against an upgraded test environment. Unlike SQL Server Profiler, Distributed Replay is not limited to replaying the workload from a single computer .Distributed Replay offers a more scalable solution than SQL Server Profiler. With Distributed Replay, you can replay a workload from multiple computers and better simulate a mission-critical workload. The Microsoft SQL Server Distributed Replay feature can use multiple computers to replay trace data and simulate a mission-critical workload. Use Distributed Replay for application compatibility testing, performance testing, or capacity planning. In this session we will cover the following: what is SQL Server Distributed Replay, Distributed Replay concepts , benefits of Distributed Replay, when to use Distributed Relay.


Speaker: Brad Schacht
Topic: SharePoint for Business Intelligence
Date:  October 9, 2012, 11:00AM EDT


Are you aware of the many features SharePoint has to offer the Business Intelligence world? In this session, you'll get an overview of SharePoint 2010 and how to integrate it with your current or new BI infrastructure. We'll discuss the general use of SharePoint for BI and basic setup and installation of the farm, then fly over a completed SharePoint site. You'll tour SharePoint Central Administration, learning how to allow your site to take advantage of many BI features such as PowerPivot, Excel Services, and Reporting Services. With the release of SQL Server 2012, you'll also get a sneak peak at some improvements available in SharePoint for those who want to be on the cutting edge of this growing technology. Forget the slides – this tour will be all demo!


Speaker: Sanil Mhatre
Topic: Understanding Parameter Sniffing & Making It Work For You
Date:  October 11, 2012, 11:00AM EDT


Parameter Sniffing is usually thought of as the bad guy, in association with a performance problem in your database. Contrary to the popular belief, Parameter Sniffing is usually the good guy, continuously working under the hood to help your database applications run faster. However, it can sometimes go wrong, causing severe performance degradation of your queries. In this session we will discuss the workings of Parameter Sniffing and demonstrate how it helps improve the performance of your database applications. We will also explore how Parameter Sniffing can go wrong and its impact. Several ways to fix bad Parameter Sniffing will be demonstrated to help make an appropriate choice for your scenario.


Speaker: Adam Jorgensen
Topic: Roping the Elephant - Big Data and BI Live
Date: October 16, 2012, 11:00AM EDT


Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!


Speaker: Mike Davis
Topic: Informatica vs. SSIS: Smack Down
Date: October 18, 2012, 11:00AM EDT


In this webinar you will see how to load a type 1 and type 2 dimension with SSIS and Informatica. Learn the pros and cons of each tool and see them in action. Learn how to use the data flow transforms in SSIS to perform delta load and see the equivalent in Informatica. You will also learn some of the best practices applied in both tools.


Speaker: Kathi Kellenberger
Topic: New T-SQL Features
Date: October 23, 2012, 11:00AM EDT


The SQL Server 2012 release has something for everyone: Column Store Index, AlwaysOn Availability Groups, Power View and more. I bet you haven’t heard about all the great new T-SQL features! Attend t

4 comments:

Unknown said...

Hi,The foreign company does not establish a presence of Business setup in Qatar, instead an agent is appointed to market goods and services within Qatar. A commercial agent generally in Qatar for foreign produced goods. Thanks.......

sas online training in hyderabad said...

Thanku for sharing ..
Harpreet's Diary on Business Intelligence & Database..
SAS Institute introduced the SAS Certified Professional Program,training proper understanding of how the SAS software works. Among the five certification programs that SAS Institute has come up with, SAS training can be considered as the entry point into the big data and the data analytics industry.
SAS online training in hyderabad

Unknown said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
web design Company
web development Company
web design Company in chennai
web development Company in chennai
web design Company in India
web development Company in India`

jefrin said...

Nice to read this post
SQL DBA training in chennai