<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Pragmatic Works Blog

Your source for SQL Server and Business Intelligence expert insight and the latest Pragmatic Works' news.

Flashback Friday – SSRS, I don’t know where to begin!

Posted Jan 30, 2015 by Tammye Michau

Getting Started With SSRS 2012

What is SSRS? It almost sounds like a song from the Beatles but it’s not. If you are new to reporting, SQL Server Reporting Services (SSRS) can look complicated. You will find in this video that it’s actually one of the easiest pieces of the BI stack to learn. SSRS 2012 has made some substantial improvements which are covered in this webinar.

Coming Soon: SQLSaturday Phoenix!

Posted Jan 29, 2015 by Liz Hamilton

SQLSaturday Phoenix will be held Saturday, February 28, 2015 at The Black Canyon Conference Center in Phoenix, Arizona. Admittance is free but there is a $10 lunch fee.

Precons will be held Friday, February 27, 2015 at the Microsoft office in Tempe, Arizona.

Seven of Pragmatic Works' consultants will be presenting at SQLSaturday Phoenix. Below is a list of their sessions and you can can receive more information about each one by clicking on the title.

February Free Training Schedule

Posted Jan 29, 2015 by Liz Hamilton


Free Training on the T's!

Join Pragmatic Works every Tuesday and Thursday at 11 a.m. EST for free Training on the T's. Our industry expert will cover a variety of topics including Power BI, SSAS, SSIS, SSRS, Hadoop, Performance Tuning and many more!

We're Coming to SQLSaturday Phoenix!

Posted Jan 28, 2015 by Adam Jorgensen

Hey everyone! I’m winging my way across the country this week but I can’t hold back my excitement  to be coming to Phoenix the week of February 22nd for SQLSaturday Phoenix! SQLSaturday Phoenix will be Saturday, February 28, 2015 at The Black Canyon Conference Center in Phoenix, AZ.

I’m coming with a number of my Pragmatic Works peers. Some like Ginger and Alan are presenting with me during our precon. I can’t wait! Our precon is all about creating your future data warehouse platform. From SQLSaturday’s site:

Introducing BI xPress Server

Posted Jan 26, 2015 by Liz Hamilton

We are exicted to announce the launch of BI xPress Server! BI xPress Server joins the DOC xPress Server in our Workbench Server line of products. Our line of server products gives your business and technical users access to your company's data, without requiring them to have a desktop installation. 

Free Training on T’s – Tabular and PowerPivot Feature Limitations

Posted Jan 23, 2015 by Tammye Michau

On Thursday we hosted the Tabular and Power Pivot Feature Limitations webinar with Brad Schacht.  He took us through the various Tabular and Multidimensional differences, as well as a work around for features that are not supported in Tabular.  This webinar is sure to assist you in making an informed decision as to which product you want to use based on your needs to get the best information in your PowerPivot.

Employee Spotlight-Brad Schacht

Posted Jan 21, 2015 by Liz Hamilton

Since Pragmatic Works has so many amazing employees we've decided to put them in the limelight. Our employees are what make Pragmatic Works successful and we wouldn't succeed without them. Each month we will be highlighting a stellar employee that often goes above and beyond the call of duty. It's a small way we can say thanks for everything they do. 

Flashback Friday-SSIS ETL for Beginners

Posted Jan 16, 2015 by Tammye Michau


I can’t connect my package…never fear Brad Schacht to the rescue!

So you want to connect your SSIS package to Excel, SQL Server, Oracle and some Flat Files but you just can’t seem to get it to work. No worries! Our superhero consultant, Brad Schacht, will help break things down and show you how to make these connections one by one. Brad will show some of his super powers in ways that will assist you with using SSIS to do a simple data dump, how to keep tables in sync, and how to do incremental loads. 

Join Us at SQLSaturday Nashville

Posted Jan 15, 2015 by Liz Hamilton

We are so excited that SQLSaturday Nashville is this weekend! The event will be held Jan 17, 2015 at Lipscomb University; One University Park Drive, Nashville, TN 37204. SQLSaturday Nashville brings together SQL Server professional and those wanting to learn about SQL server togther.

Six of Pragmatic Works' consultants will be presenting on Saturday. Below is a list of their sessions and you can can receive more information about each one by clicking on the title.

Webinar Follow-Up: Intro to Data Factory

Posted Jan 13, 2015 by Steve Hughes

This is a follow up blog post based on the Intro to Data Factory session I gave on the Training on the T’s with Pragmatic Works. Find more free training from the past and upcoming here. I did my session on January 13, 2015.

In this session, I gave a simple introduction to new Azure Data Factory using a CopyActivity pipeline between Azure Blob Storage and Azure SQL Database. Below is a diagram illustrating the factory that is created in the demo.

Webinar Follow-Up: Data Analytics & Distribution with Power BI

Posted Jan 12, 2015 by Ginger Grant

Thank you to all of the people who took the time to view my session on Data Analytics and Distribution with Power BI. I really enjoy getting the chance to decrease the confusion I hear regarding Power BI, and hope that you will find the question and answer section helpful if you are trying to learn more about the product.

Intro to Big Data Analytics Demo

Posted Jan 09, 2015 by Liz Hamilton

Back in December Pragmatic Works' BI Consultant, Alan Faulkner, did a presentation on Intro to Big Data AnalyticsIn this session he introduced the Hadoop-based services in Windows Azure and used PowerBI features to build a self-service BI Big Data solution. Now we are offering you an outline and demo to accompany his presentation.

January Free Training Schedule

Posted Jan 06, 2015 by Liz Hamilton

Every week Pragmatic Works hosts free webinars on a wide range of topics that include Power BI, Performance Tuning and many other SQL Server topics. Join our industry experts every Tuesday and Thursday (and sometimes other days) at 11 a.m. EST to expand your SQL Server knowledge!

Flashback Friday-The T-SQL Golden Egg

Posted Jan 02, 2015 by Tammye Michau


Which comes first the Chicken or the Egg?

It doesn’t really matter which comes first in this instance, it’s more about the egg. In this particular webinar Kathy Kellenberger is going to tell us how to cook our egg, in a matter of speaking. Let’s just assume that the webinar, “Get Started with T-SQL SELECT Part 1” teaches about how to take care of the chicken to get her to lay an egg.  

Subscribe to Blog Updates