|
|
-
|
|
All the videos for this popular conference are online or will be soon (48 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event9. All are free to watch! The one’s on my list to watch (because I’m interested in SQL Server 2012/Data Warehouse/SSAS):
Basic ......
|
|
-
|
|
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions. It applies to SQL Server ......
|
|
-
|
|
As you may know, the TechEd in the U.S. is not the only one. There have been many all over the world, and it 2011 there have been one’s in New Zealand, Australia, and next month in Russia. The Australia and New Zealand TechEd ended a couple of months ago, and all the videos from those sessio......
|
|
-
|
|
Technology Adoption Program (TAP) and Rapid Deployment Program (RDP) are ways for Microsoft to get early feedback on new products or product updates as well as give important customers a heads-up on what Microsoft is up to. Participation is by invitation only (usually by someone in Microsoft’......
|
|
-
|
|
This is my biggest gripe with SSIS: I have a data flow task, and within that I’m pulling data from multiple sources into multiple destinations, with a few performing data flow transformations. While testing, I want to disable some of the components. You can’t. You can disable any task......
|
|
-
|
|
Microsoft and HP have announced another appliance, called the Database Consolidation Appliance (see my blog about the other two appliances). In short, this appliance consolidates databases into a single, virtual environment.
In more detail:
Many customers continue to struggle with solving the pro......
|
|
-
|
|
Over the past few years I have developed a list of ways to improve performance in SSAS and in two of the tools that use it: ProClarity and PerformancePoint. Below are those performance tips along with other important items to be aware of:
1) Manually add aggregations to the cube via the Aggregatio......
|
|
-
|
|
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. Analysis Services is made up of two engines:
Formula Engine (FE) – It is single-threaded. It processes the MDX queries, determines what data is needed to answer the......
|
|
-
|
|
Some announcements and notes from SQL PASS Summit 2011, going on this week:
It was announced that the official name of the SQL Server “Denali” product is SQL Server 2012 and will be released in the first half of the year 2012. There will be a Release Candidate (RC0) that should be provided by the ......
|
|
-
|
|
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture shows the ErrorConfiguration properties for a cube:
There are numerous objects where you can specify the error configuration via the properties dialog: dimension, cub......
|
|