Webcast: Avoid Slow SSAS Queries: MDX Query Troubleshooting Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often […]

Webcast: Avoid Slow SSAS Queries: MDX Query Troubleshooting Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often […]

Webcast: Avoid Slow SSAS Queries: MDX Query Troubleshooting Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often […]

Featured Article(s) Troubleshooting SQL Server 2008 XML Problems In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 XML. He also tells how you can resolve these problems. Webcast: Basics of Administering Databases for The Layman – Part 3 Okay, so you’ve gotten your data into your database. Did you do […]

Webcast: Basics of Administering Databases for The Layman – Part 3 Okay, so you’ve gotten your data into your database. Did you do it right? Do you have too much data? Do you have the right data? Can you actually get the data out that you want? Now how do you get it out? This session will take you through […]

Featured Article(s) Elemental MDX: Members, and an Introduction to Member Functions, Pt. 3 Part 3: BI Architect Bill Pearson continues his Elemental MDX Series with an introduction to the ”members” concept in MDX, before exploring the .Members function. Next, he introduces member “family” functions, beginning the exploration of this general group of MDX functions with the .Parent, .Children and Ancestor() […]

Webcast Available Now: SQL Server Forensics Have you ever received a call from one of your users asking why they received an error 3 days ago? Or maybe they want to know when a particular piece of data was deleted and who did it. Troubleshooting past events is difficult in SQL Server, but not always impossible. Learn how to set […]

Featured Article(s) Elemental MDX: Members, and an Introduction to Member Functions, Pt. 2 Part 2: BI Architect Bill Pearson continues his Elemental MDX Series with an introduction to the ”members” concept in MDX, before exploring the .Members function. Next, he introduces member “family” functions, beginning the exploration of this general group of MDX functions with the .Parent, .Children and Ancestor() […]

Almost Tax Day! Just a friendly reminder for those in the US. Favorite Management Studio Tricks It’s fun to see what types of things people have come across in using Management Studio – lots of little things that can help make working with data, queries and such a bit easier. Leif: "Dragging the columns folder from Object Explorer onto a […]

Featured Script SP Source Code Generator This Stored procedure Creates stored procedures(Insert, Update & Delete) for a given table…. (read more) Big News of the Day: Visual Studio 2010 Released In Vegas at the launch event, Microsoft has released the next version of Visual Studio, with native support for .NET 3.5, 4, the ribbon interface and a lot more. For […]