Thanks for those who attended the webinar on Unit Testing with SSIS and BI xPress. In case you couldn't be there, you can see a recording of it below.
The new version can be downloaded here: http://www.pragmaticworks.com/Products/BI-xPress.aspx.
Some of the questions from the audience to point out:
Q: Daniel: Does it support older version of ssis such as 2008?
Thanks for all who attended the webinar on how to Double your Salary in 3 Years. This webinar is quite personal to me (Brian) and one that I'm passionate about helping others with. You'll be able to find the recordings tomorrow here:
Slides available in the following compressed file:
In this short video, you'll learn how to implement an SSIS framework to detect failures and achieve compliance for regulations like Sarbanes-Oxley. To download BI xPress mentioned in the video please visit the following link: http://www.pragmaticworks.com/Products/BI-xPress.aspx.
In SQL Server 2012, you now have the choice between doing a cube in MOLAP or Tabular mode. This Whiteboard Wednesday shows you the benefit and cons to each of these modes.
Navigating through the array of Microsoft visualization tools can be quite difficult. In this video, Devin Knight and Brian Knight show the pros and cons of each of the tools and the appropriate time to use each. There is of course lots of grey area in your selection.
We also refer to a decision matrix Excel spreadsheet in the video. You can find that attached here: Reporting Decision Matrix
Until next time,
Each and every Wednesday Pragmatic Works is excited to bring you Whiteboard Wednesday, a discussion on patterns, best practices or rants about our industry. In this first video, you'll see some of the top visualization mistakes that people make in building reports. At a glance those are:
These are of course a subset of many of the issues. Let us know if you can think of others in the comments section below. This topic is part of the our Master's SSRS class, given monthly.
Until next time!
This week, the new quarterly update was release of BI xPress was released. The release had over a hundred improvements in it but I wanted to highlight 3 of the neater ones. There are also a lot of down payments in this release that will show themselves in a spring release. If you already have BI xPress, the release is a free update if you’re under maintenance. These are just a small fraction of the BI xPress overall features. For more information, see the
entire product feature list here.
Free Trial Download
Every report in the monitoring console has been redeveloped in WPF, giving it better performance and interactivity. View packages running live and view errors while they occur in a visual method. You can also stack packages side-by-side to see the all run at the same time.
Update 2 – SSIS Catalog Import
The SSIS catalog import tool will enable users to import native performance and execution data from a 2012 SSIS catalog to the BI xPress auditing database. This will make it possible for users to view execution data for packages that do not have the auditing framework. It allows you to combine multiple server’s auditing information into a single view.
While BI xPress has add-ins into the Visual Studio environment, you can now also use the Pragmatic Workbench to launch all the components. You can now customize the look and feel of the workbench’s metro interface.
While we do offer in-person training around the country, we also offer live virtual instruction from our top consultants in the field. So, when does it make sense to go virtual versus in-person?
See our Upcoming Virtual Training Classes. This January, you will receive an additional $200 off any training class that you book in 2013.
There are draw-backs of course. If your co-workers can’t leave you alone if you’re in the office, it’s best to be in-person training instead of virtual but be aware of the differences in cost. Our in-person training is offered in bootcamp-style or workshop style around the country (schedule here: http://www.pragmaticworks.com/LearningCenter/Bootcamps.aspx).
When you first unbox a fresh SQL Server environment or place a new application on a SQL Server, there are a number of hurdles that you may have to watch out for. These common pitfalls usually include:
This video below features Jason Strate. He’s one of our Sr DBAs who also does assessments. If you’d like to see more about assessments in your environment, check out our offerings here.
As part of our assessment we will review:
· Database design and index usage
· Query performance
· Potential system bottlenecks
· SQL Server’s IO responsiveness
· Microsoft Best Practices for environment and system configuration
· And more!
Until next time, Brian Knight
Extended events in SQL Server allow you to trap certain events like errors or informational messages and log them so you can react to them. They’re especially critical to learn them now since they are the replacement for important tools like SQL Profiler. In this video, Jason Strate walks you through some of the cases when you’d use them.
Until next time, Brian Knight