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
The last thing you want to do is truncate and load your data when your synchronizing two tables. In this video Bradley Schacht and Brian Knight white board some of the common patterns and approaches to incremental loads in SQL Server.
Now that you see the outline, get the full details in the below On the Board video. If your company blocks YouTube, you can also access the video through a corporate-friendly method here: http://permalink.fliqz.com/aspx/permalink.aspx?at=6294476941e6498f8bdaa9ef7130d0cc&a=e4af6c7e40c243b29b2cf4546fe57056
Upcoming SSIS Masters Workshops:
We’re adding a few new workshops every month to our learning center section on the site here. Don’t want to travel? No problem, we also offer many more classes online like MDX, DBA, SharePoint and others.
Let us know which method you prefer to do in the comments section.
Thanks so much for the people all that came to the data cleansing session we did at PASS. We covered data cleansing using Data Quality Services (DQS), Master Data Services (MDS), scripting and deduplication with Fuzzy Grouping. The code downloads are now available for the project we used here:
Other free webinars that might interest you are:
Thanks again, John Welch, Chris Price, Brian Knight
We've all made configuration mistakes when installing a new SQL Server. Most people just install SQL Server and forget to go back and optimize the configuration. In this white board session, Jason Strate walks you through common configuration mistakes in SQL Server.Some of the big areas to consider are:
What are other mistakes you can think of? Use the comments to let us know what we missed!
Find out more about about the assessments that Jason mentioned in this video here: http://www.pragmaticworks.com/Services/PerformanceAndInfrastructure/Consulting-Services.
Until next time, Brian Knight