14 free SQL Server, BI and PDW online trainings from Pragmatic Works

 

Improving Query Performance 4/1/2014, 11:00am EST The 'out of the box' SQL Server installation and configuration is generally useless in an enterprise of any size and will lead to unbelievably poor query performance. In this hour we will discuss the basics of SQL Server deployment and configuration, the tools at your disposal to optimize query execution, and some tricks to make your queries perform at their best...all from the 'magic wand' approach where we start with 'most optimal' then adjust as necessary to suit the circumstances. Expect to learn a little bit of everything...from SQL Server deployment and configuration to indexing and statistics to stored procedures and functions to query design to database architecture.   Register Here

SSIS Deployment and Configuration 4/3/2014, 11:00am EST Microsoft gave SSIS a complete makeover with SQL Server 2012. Many of these changes are cosmetic in nature and don’t really affect the way you work with SSIS. Deployment and configuration are the exceptions. Attend this session to learn what you need to know to take advantage of the new Project Deployment model, the best thing about SSIS 2012!   Register Here

 

Introduction to Extended Events in SQL Server 2012 4/8/2014, 11:00am EST As a lone DBA in the scary new world of SQL Server Extended Events, you may be wary of the multiple threats of the deprecated profiler feature, Event Tracing for Windows and the Events themselves. In this session, come and learn how to map your way through these threats using the Extended Events User Interface and Admin Console. In addition, I will be detailing what “events” are and how they relate to YOUR SQL Server. Register Here

Introduction to Microsoft Parallel Data Warehouse 4/10/2014, 11:00am EST Microsoft's Parallel Data Warehouse platform has seen a huge increase in popularity over the last couple of year but remains a mystery to most of the SQL Server community. Parallel Data Warehouse (PDW) is a Microsoft answer to massively parallel processing (MPP) competition. You don't need hundreds of terabytes of data to be a good use case for PDW. In this session you will receive an overview of what PDW is and discuss real world use cases, some large data sets and some small. We will talk about how PDW can offer improvements over the SQL Servers you have in your environment today and where it really fits in the grand scheme of your organization. This session wouldn't be any fun if it was all marketing material and slides, so Brad will be sure to make the examples real by giving you a live look at queries running on an actual PDW; no tricks just a real world comparison between PDW and the SQL Server your used to seeing day in and day out.   Register Here

 

Quick Start to PowerPivot 4/14/2014, 11:00am EST In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office and SQL Server will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.   Register Here

Bringing Power BI Q&A 4/15/2014, 11:00am EST Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of Q&A from the Power BI site.   Register Here

 

Interactive Reporting with Power View 4/16/2014, 11:00am EST Power View provides users with the ability to create interactive visualizations inside SharePoint and Excel 2013. It provides users with an easy to use drag and drop interface to quickly and easily create tables, charts, scatter plots and maps. Power View is the go to self-service reporting tool in the Microsoft ecosystem that is full featured enough to provide in depth data exploration and easy enough that a sales person can use it! This session will guide you through the process of creating a Power View report that will leverage all the requirements to get you up and running as well as core functionality including slicers, filtering, animated scatter plots, tiles, cards, maps and cross-filtering data in different objects.   Register Here

Creating Power Map Reporting Solutions 4/17/2014, 11:00am EST Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of creating Power Map tours.   Register Here

 

How to use Power Query as your Self-Service BI ETL Tool4/18/2014, 11:00am EST Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of creating Power Map tours.   Register Here

Why the Cloud is your Best Strategic Opportunity 4/21/2014, 11:00am EST Today’s businesses are experiencing exciting growth. This renewed growth requires the need for improved strategies to scale and grow while remaining flexible and agile. Gartner and Forrester are backing this up with their push to evaluate the cloud market as a top strategic priority for today’s modern business. Join Tim Moolic and Adam Jorgensen COO and President of Pragmatic Works as they bring their decades of experience to discuss why and how the modern business re-platforms at a fraction of the effort and cost by using the cloud for data, applications, and analytics. This session will include specific customer cases and high level customer architectures along with a C-Level guide to the state of the cloud and it’s benefits for your organization.   Register Here

 

Getting Started with Windows Azure and SQL Databases 4/22/2014, 11:00am EST The Microsoft Windows Azure platform provides service-based offerings for your data needs. These include services from file storage to SQL databases that are scalable to your specific needs. Regardless of the size of your data platform, Windows Azure has options that fit to your business needs. In this session, we'll discuss the Windows Azure platform and discuss how the SQL Database and other services enhance and extend your data platform. By session end, you'll understand how Windows Azure is able to fit into your environment and be ready to start using Windows Azure.   Register Here

Accelerate your Development Life Cycle with Azure 4/23/2014, 11:00am EST Today's business environments change quickly. Companies want to take advantage of new opportunities as soon as they arise, with ever-tightening deadlines for their IT groups to support these new initiatives and deliver value. It's critical that as IT and data professionals, we look for ways to deliver faster, while still providing quality solutions. During this session, we'll look at how you can use Azure as part of your data related projects to accelerate the time to value for the business, with less up-front time and dollar investment.   Register Here

 

BI Scale on Demand - Implementing BI in the Cloud 4/24/2014, 11:00am EST In this session you will learn how to gallery images for running Business Intelligence in Windows Azure Virtual Machines. How to use SQL Server Analysis Services and Reporting Services in your own Azure BI environment is covered and deployment to Azure. Register Here

Leveraging Cloud for the Modern SQL Developer 4/25/2014, 11:00am EST In the past, developing a database was a simple affair where you built and deployed the database for a server down the hall in your datacenter, or in some cases to a server under someone's desk. While those good ole days were a much more simple time, they were quite limiting in how a database could be deployed and there were much fewer options for ensuring stability and performance. Today, SQL Developers have many more options for deployment including the services provided through Windows Azure. In this session, we'll dive into what you need to know to start developing databases with Windows Azure and discuss the value that cloud delivery can provide to your database development.   Register Here