Welcome to TechNet Blogs Sign in | Join | Help

March 2005 - Posts

The Final Word in Microsoft SQL Server 2000 Backup, Restore and recovery

I am pleased to be able to point you to the last word in SQL Server 2000 Backup and Restore methods. At last all the answers in one place! SQL Server 2000 Backup and Restore Published: March 1, 2005 Author: Pankaj Agarwal Published: February, 2005 Summary:

First Microsoft-SAP Collaboration Brief from Microsoft on loading data from SAP BW into SQL Server Anlaysis Srevices

It's a great pleasure to announce the first Microsoft Collaboration Brief on an official SAP site, written by Microsoft’s own Hermann Däubler.

 

Loading data from SAP BW into Microsoft Analysis Services using Open Hub Service.  (You can cacnel any request for a certificate)

 

Summary

The following paper should help to get a quick start on how to load data from SAP BW into an external Microsoft Analysis Services MOLAP cube using the BW Open Hub Service. Unlike using SAP .NET Connector to access one of the BW APIs it’s not necessary to write any code. Open Hub Service is the officially recommended way to unload data from SAP BW into external data targets.  Whenever you extract data from the mySAP BI environment into 3rd-party target systems your SAP BW Enterprise Data Warehouse functions as an ‘Open Hub Platform’.

Posted by Mat_Stephen | 0 Comments

Questions arising from TechNet Webcast: Business Intelligence on the Microsoft Platform 23rd March.

Thanks to all of you who tuned in to this webcast last week.  Sorry this post is a little late, no sooner had I finished the webcast than the sore throat I had turned into a full blown cold and layed me out for the next couple of days.

 

The archive for the webcasst can be found here: http://www.placeware.com/cc/emea/view?id=118756214&pw=K2GX9N

 

Here are some of the questions and answers arising that may be of wider interest:

What is the URL for the Analysis Services Excel download?

http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en


What are the new SQL Server 2005 DM algorithms?

Time Series, Sequence Clustering, Association, Naive Bayes and Neural Net.


Where can I get the SQL Server BI Accelerator from?

The BI Accelerator can be downloaded from http://www.microsoft.com/sql/ssabi/ As Mat says there are 2 models available in the download but others are available. Manufacturing and Financial templates can be downloaded from http://www.microsoft.com/sql/ssabi/techinfo/datamodels.asp


Asked: will writeback in SQL 2005 be better that current? And if so, how much better and where can I find out more?

I believe it will perform better.  To find out more detail have a look at the sql 2005 webcasts at www.microsoft.com/sql


Is there an additional add-in to view olap cubes via Excel97?

There are 3rd party tools but nothing available for 97 directly from MSFT


I hope you can join us for the next two BI webcasts mentioned in my last post

Forthcoming UK Microsoft SQL Server Business Intelligence Webcasts.

I shall be presenting this first webcast myself and hosting the other two – hope you can join in. 23 March, 10am: TechNet Webcast: Business Intelligence on the Microsoft Platform This webcast is will provide IT Professionals with a complete technical

Microsoft SQL Server - Reporting Services Scripter - a free tool from sqldbatips.com

I’m grateful to Andy Steer of Contemporary, one of our Gold BI Partners here in the UK , for pointing me to this useful free utility from.sqldbatips.com Overview: Reporting Services Scripter is a .NET Windows Forms application that enables scripting of

Using SQL against the Unified Dimension Model in Microsoft SQL Server 2005 Analysis Services

Following Deepak's question, asked in his comment on my previous UDM post , I quizzed our internal Yukon alias and received the following useful info regarding using SQL against a UDM; thanks to Akshai Mirchandani. AS2005 supports a limited set of SQL

Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!

There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’

Microsoft SQL Server 2005 - The Pricing, The Editions, and the Edition's Features

All ye! All ye! The pricing, the editions and the features available in the editions of SQL 2005 have all been decided, announced and published. Naturally I meet scepticism that suggests SQL Server 2005 has slipped and slipped again, and that perhaps
Posted by Mat_Stephen | 2 Comments
Filed under: ,

Microsoft SQL Server Resource Kit tools - 'Free' with MSDN and TechNet

Okay so these tools aren ' t totally free but I didn ' t really have anywhere else to categorise them. Anyway I ' m sure I ' ve seen advertisements that boast "you can get a ‘free’ toy with every packet of some breakfast cereal". Well these tools are
 
Page view tracker