SQL Server Security – Only about a day left to register! Our SQL Server Security virtual workshop is happening Friday – so you only have a day or so to get registered and save your spot! I’ll be teaching the workshop and we’ll be covering the different aspects of SQL Server security, including injection and what you need to be […]

Featured Script admin db – meaningful Agent job notification If you want to konw the real failure message when a job fails and you want to maintain a history of job failures (and succes… (read more) Interested in Learning About SQL Server Security? Check out our upcoming virtual workshop! In the workshop, we’ll be going through things to know, SQL […]

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() […]