Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2000 » Business Intelligence   (RSS)
Monday, November 28, 2005 5:47 PM

Feature Pack for Microsoft SQL Server 2005 - November 2005

Overview The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: Latest versions of redistributable components for SQL Server 2005 Latest versions of add-on providers for SQL Server
Posted by Mat_Stephen | 3 Comments
Tuesday, September 20, 2005 12:59 AM

OLAP, Darwin and Evolution

Edited 21st Sept 05 to include picture of herbarium sheet. In my article 'Business Intelligence (BI): The way it is without the blah blah' , I mention that I was aware of some exiting research using the SQL Server OLAP engine, the results of which where
Posted by Mat_Stephen | 0 Comments
Friday, August 19, 2005 11:24 AM

Reporting Services: Calling an aspx page from a report and passing a parameter

Sudhi recently asked me how to call an aspx page from a report and pass a parameter held in a textbox, or other control. My solution is: Drag a textbox control on to the report and enter the value "2005/07/28/408325" (without the the quotes) in to it.
Posted by Mat_Stephen | 0 Comments
Tuesday, August 16, 2005 11:49 AM

SQL Server Reporting Services Report Packs - looking for suggestions

when I was over in the US recently, I attended a 'Bill Baker and team unplugged' session, (Bill is the GM for SQL Server Business Intelligence). Reporting Services Report packs came up as a topic for discussion. The team asked the audience if the Report
Posted by Mat_Stephen | 7 Comments
Thursday, August 04, 2005 3:08 AM

Letter from America 3 - Mischievous reports and feeding the 5000

After all my messing around yesterday, I've decided to create this post in pocket word. I attended a securty session yesterday and was reminded of an issue that can send DBAs scuttling from the room when they learn of it's presence, the 'trojan report'.
Posted by Mat_Stephen | 0 Comments
Monday, August 01, 2005 10:58 PM

Letter from America 1

I'm in Seattle this week at Microsoft's first TechReady conference. What's more I'm totally mobile; I didn't bring my laptop. Instead I'm relying on my iPaq with built in wireless and bluetooth.1 To help me type I'm trialing a software keyboard I downloaded
Posted by Mat_Stephen | 2 Comments
Friday, July 29, 2005 3:15 PM

Get Ready for SQL Server 2005 with Free Microsoft E-Learning Courses.

More and more people are asking me about SQL 2005 training courses and certification. I believe the exams will be ready in Q1 next year. In the meantme, how about access to the training courses absolutely free until 1st November @ https://www.microsoftelearning.com/sqlserver200
Posted by Mat_Stephen | 1 Comments
Thursday, July 21, 2005 2:38 PM

Serialising an ADOMD.net CellSet object

I'm grateful to T.K. Anand for this useful code snippet which is useful if you're writing a web services client that consumes OLAP data. The following Adomd.net code can be used for saving and loading cellsets… Save: XmlReader xmlReader = command.ExecuteXmlReader();
Posted by Mat_Stephen | 0 Comments
Wednesday, July 20, 2005 2:26 PM

SQL Server 2000 Analysis Services Cube Security

If you were given an opportunity to create a “cubed” solution for 50,000 different users, would you create one cube with 50,000 roles? Would you create 50,000 cubes – one for each customer? What would you do? This is what Mosha Pasumansky and Dave Wickert
Posted by Mat_Stephen | 0 Comments
Monday, July 18, 2005 11:16 AM

How Do You Deploy SQL Server Reporting Services?

A colleague of mine in the States, Rob Caron, is very keen to learn how our customers are deploying Reporting Services; specifically with respect to IIS. When we launched Reporting Services (RS) it was all too easy to say it was a ‘free’ addition to the
Posted by Mat_Stephen | 0 Comments
Thursday, July 14, 2005 9:35 PM

Reporting Services: Two New (Free) Report Packs Released for Sharepoint and Axapta

Good news for the chap I met on the 'Ask the Experts' desk at TechEd, who was contemplating jumping through all sorts of hurdles to create reports form Sharepoint data. I couldn't really get my head round the (Sharepoint) problems he foresaw, but I was
Posted by Mat_Stephen | 0 Comments
Monday, July 04, 2005 2:19 PM

TechEd Amsterdam: If you want to come and say hello, here's my schedule - and a cautionary note regarding Jay Walking here in Amsterdam

If you'd like to meet with me to discuss any issues arising from my blog posts, anything SQL, or just to say hello, I will be at the Ask the Experts Info desk, here at TechEd at 11:30 - 2pm. Tuesday. And I'll also be at the Ask the Experts stand at 2-5pm
Posted by Mat_Stephen | 6 Comments
Tuesday, June 28, 2005 1:40 PM

SQL Server Reporting Services: Custom colour in charts

A frequently asked question is, 'how does one customise the colours in a chart?' Below is a link to a blog post from Brian Welcker, which is actually a post on how to overcome the encumberence of the chart legend when it takes up too much space on a chart.
Posted by Mat_Stephen | 0 Comments
Wednesday, June 22, 2005 5:28 PM

Querying and Reporting on Report Execution Log Data

Well I didn't realise, or maybe I just plain forgot, that these reports and the necessary support infrastrucuture come with Reporting Services under the extras folder on the CD - all useful stuff for report heads. Longest Running Reports Most Executed
Posted by Mat_Stephen | 0 Comments
Tuesday, June 14, 2005 10:21 AM

Reporting Services: How to stop IE striping out leading spaces in report data values

Reporting Services: How to stop IE striping out leading spaces in report data values: My thanks to Russell Christopher and Mike Schetterer who recently discussed the problem that IE will strip out leading spaces from data in a report. The solution: you
Posted by Mat_Stephen | 1 Comments
More Posts Next page »
 
Page view tracker