Sometimes when changing code I've found that the "Process Default" does not process quite enough. When I get unexplained problems, the first thing I try is to "Process All" on...

This isn't quite there but may help you to get closer. I'm new to DAX also. My idea was to add an additional filter to your calculate statement with an...

When you created the cube, did you define Team to have a dependency on Company with the key? This would make 'Team 1' for each company distinctly different even though...

The issue had nothing to do with SSRS. IE blocks cross-protocol links (http:// to file://) unless the site is on the trusted sites list. Added it to the trusted sites...

Thanks Grant. This is exactly what I was looking for.

I also loved your book "SQL Server 2012 Query Performance Tuning ".

The views option would work if we could prevent them from joining views. There might be a way to prevent that but I'm not sure how. I read an article...

Agreed about the problems with allowing non-technical users access. One of the requirements to get login permissions will be passing a SQL Query exam though. Of course, user's may cheat...

Thanks Paul. Right now I'm leaning towards replicating the most relevant tables to another database and then using the resource governer to limit resource usage. I thought about mirroring but...

If you can get the 90 logins into a table, you could write dynamic SQL to print the needed T-SQL statements. Another way is if they are in Excel, write...

Thanks. That did it.

I have two needs for this.

The first is geocoding addresses and getting the latitude, longitude. I may use Bing for this but I'm open to other ways.

The second...

Compile the console app. Then just type in your executable name and path instead of "dir c:\" for the command.

if exists(select 1 from Table1) select * from Table1;

35,000 rows vs 14,000,000. The funky column names are malconfigured time stamps. I can do this through an OPENQUERY statement inside SQL Server. Once I do that though, there's no...

I only have select permission on the AS400 so I can't create a stored procedure. It's an old system and the original developers are long gone. The current people maintaining...