Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • Steve Schneider
  • Page 2

Author: Steve Schneider

Tabular logging of Users is not like Multidimensional!

April 13, 2014 Steve Schneider

A few days ago, I wanted to start tracking on who was using my Tabular solutions. (If you wandered into this post… I’m talking about Microsoft’s SQL server Analysis Services.) With Multidimensional you have a table, that given the right…

Read more

SSAS 2012Leave a Comment on Tabular logging of Users is not like Multidimensional!

SSRS Data Source Lister

August 24, 2013 Steve Schneider

Hello, Sometimes, you’re in the middle of doing something, and you need an answer.  You google it and find such a great solution, you want to keep it handy for … whenever!  Here is such a post.  As the title…

Read more

SQL 2005, SQL 2008, SSRSLeave a Comment on SSRS Data Source Lister

Reading an SSAS cube thru SQL using MDX

July 23, 2013 Steve Schneider

Do you need the ability to read a cube, but you want to read it thru SQL?  And, why would you do this?  Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t…

Read more

SQL Administration, SSASMDX, SQL, SSAS, SSRSLeave a Comment on Reading an SSAS cube thru SQL using MDX

SSAS not logging?

July 17, 2013 Steve Schneider

So you’ve followed all the advice and set up logging so that you can know who is using your cubes.  Things are good.  One day you wake up and see that your logs no longer are logging.  You open your cube…

Read more

SQL 2008, SSAS, SSRSSSAS, SSAS LoggingLeave a Comment on SSAS not logging?

Who’s been using your Cube?

April 16, 2013 Steve Schneider

To keep track of how many people are actually using the results of your hard work… You have two considerations: 1. Turn on Logging on your Analysis Services Cube 2. Actually query that log…

SQL 2008, SSASCube, Monitoring, SSASLeave a Comment on Who’s been using your Cube?

Sql Saturday Jacksonville, April 27 2013

March 1, 2013 Steve Schneider

Hey, everyone!  There’s a great event here in Jacksonville, Florida.  It’s coming in April.  It is like a mini Tech-ed.  Free Food.  Great Technical presentations. Lots of networking.  Fellowship.  Swag.  After hours party.  What could be better than that? I…

Read more

CareerLeave a Comment on Sql Saturday Jacksonville, April 27 2013

ASSP.dll…super great functionality

February 28, 2013 Steve Schneider

There is a “DLL” that you are going to want to install on your SSAS servers… it is called “ASSP.DLL”…and you can get it from Code plex.  To quote CodePlex: The Analysis Services Stored Procedure project is a set of…

Read more

SSASAnalysis Services, MDX, SSASLeave a Comment on ASSP.dll…super great functionality

Tools to help you when developing SSAS cubes

February 27, 2013 Steve Schneider

There are a number of available tools that are free

SSASLeave a Comment on Tools to help you when developing SSAS cubes

SSRS subscriptions not working

January 28, 2013 Steve Schneider

The problem: SSRS Subscription is not sending out emails. Where to find a typical error-log: C:\SQLServer\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

SSRSLeave a Comment on SSRS subscriptions not working

SSAS File organization

January 26, 2013 Steve Schneider

A few miscellaneous notes today on the location of various file when working with Analysis Services.

SSASLeave a Comment on SSAS File organization

Posts navigation

Previous 1 2 3 … 6 Next
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes