20 posts from: Business Intelligence on SQL Server
Business Intelligence with SQL Server 2005: Transform Data into Decisions
(Indexed 2007-01-18):
Just came across a set of PerformancePoint webcasts on http://thesource.ofallevil.com/events/series/sqlserverbi.mspx. Check out: TechNet Webcast: Performance Management 101 with PerformancePoint Server 2007 (Level 200)Thursday, January 18, 20071:00 P.M.2:00 P.M. Pacific TimeJoin us and learn how Office PerformancePoint Server 2007 enables businesses to deliver performance management capabilities broadly by providing an application that is easy to use and less costly to deploy than traditional so...(truncated)...
Round up for 2006
(Indexed 2007-01-15):
Happy New Year! I am sorry I have not blogged in awhile. Its largely due to a house we are building in Auckland. Building a house is very similar to building a data warehouse, best left to the experts.[Image]What a year 2006 it has been. I have to say Business Intelligence on SQL server has definitely seen some big changes this year. After the release of SQL Server 2005, big things had to happen to top the release and what a year it has been.Service Pack 1 Was not long in coming after the Novemb...(truncated)...
How to obtain the latest service pack for SQL Server 2005
(Indexed 2006-11-09):
Microsoft have just release SQL Server 2005 Service Pack 2 CTP. Check out: How to obtain the latest service pack for SQL Server 2005
MCITP: Business Intelligence Developer
(Indexed 2006-09-30):
Microsoft has just released an update to the Microsoft Certified IT Professional (MCITP) with the creation of Business Intelligence Developer credential. It looks like you only need to sit two exams to become a Business Intelligence Developer.This qualification is a step up from the Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI).The training material is available but the exams are not available until early 2007. It might b...(truncated)...
Tips, Tricks, and Advice from the SQL Server Query Optimization Team
(Indexed 2006-09-16):
A colleague of mine has just introduced me to one of the best blogs I have seen in along while. The Tips, Tricks, and Advice is brought to you by the SQL Server Query Optimization Team.Here are some of my favourite posts on the performance features of SQL 2005 Query Optimizer. Check out the following:Why should I create an index?I Smell a Parameter!Fun for the day - Automated Auto-Indexing!
SQL Server 2005 Skill Assessments
(Indexed 2006-09-12):
Microsoft has released a series of free skill tests that are well worth trying. There are tests covering most Microsoft products. There are two categories that I have given a go.Introduction to SQL Server 2005 (DBA, Developer, BI): SQL 2005 Introduction to SQL Server 2000 Reporting Services: RS 2000
This Months Book Recommendation: Microsoft Data Warehouse Toolkit
(Indexed 2006-09-03):
After TechEd I realised that in my slide deck I did not recommend The Microsoft Data Warehouse ToolKit by Joy Mundy and Warren Thornthwaite as required reading before starting a BI project.If you are new to BI or new to the SQL Server 2005 BI platform this book is a great starting point. This book covers an end to end BI solution on the SQL server 2005 platform. The book covers a Reference Architecture for implementing a Microsoft BI Solution.The book also includes a case study using the Adventu...(truncated)...
New Zealand TechEd Is Finally Here!
(Indexed 2006-08-09):
TechEd 06 has been a sold out event for a number of weeks now. It sold out in record time. For those you that are not aware, Microsoft NZ TechEd is the largest annual IT conference in New Zealand with over 2000 delegates attending.This year I am presenting again. I am lucky enough to have one very comprehensive session on Business Intelligence.BIN213 - Delivering an End to End Business Intelligence Solution on Monday 21st Aug 2:00:00 p.m. to 3:15:00 p.m.My session is going to cover a detailed ov...(truncated)...
SQL Server Versions
(Indexed 2006-08-02):
I have lost count the number of times I go searching for the patch level or version number in SQL.This was something I did all the time with SQL 2000. It all started when SP 2 came out. We started to get issues with dts packages that were developed on SP1 and then run SP2. The problem was the package format changed between versions. Hence the question what version I am really running?Why have I brought this up you may ask? Because now that we have SP1 for SQL Server 2005 and the rollup hotfix. W...(truncated)...
New Microsoft SQL Server 2005 Business Intelligence Example
(Indexed 2006-07-24):
I have just come across a new set of sample databases for SQL Server 2005. Some of the examples are based on Project Real Business Intelligence best practices project. Based on a real world implementation of SQL Server 2005 by Microsoft.Check out: SQL Server 2005 Samples and Sample Databases (July 2006)
Installation of SQL Server Service Pack 1 by Windows Update???
(Indexed 2006-07-20):
The other day something happened to my laptop that took me completely by surprise. Windows Update decided SQL2005 SP1 was a critical patch. And proceeded to download and install SP1.Although this isnt an issue for me at then moment as I was going to install the Service Pack. I was taken a back with Windows Update installing it in the first place.Like most DB pros I prefer to manage the database patch level on my own. I can see this kind of service pack roll out causing problems for IT Administr...(truncated)...
SQL Management Studio Short Cuts
(Indexed 2006-06-01):
I have been working with SQL Management Studio (SMS) a fair bit lately. Like most developers I always look for the standard short cuts that I used on Query Analyser. Below are a few of my favourites.Commenting I use these short cuts all the time to comment large sections of code. The comment style I prefer the most is dash form which I prefer too the slash style. -- Dash Comment /* Slash Comment */To comment in SQL management studio you must now do Ctrl+K, Ctrl+C instead of Ctrl+Shift+C in Query...(truncated)...
Report Builder and the UDM
(Indexed 2005-12-06):
This month is definitely Report Front end development month. After presenting at our cabana session at SQL Server 2005 launch I have been getting busy with Report Builder and Reporting Services 2005. The project I am working on is a small scale reporting solution. The UDMAt first I had a good look at using Analysis Services as my main repository for storing all my business logic and handling querying against the source system. This has its advantages; it reduces the load against the source syste...(truncated)...
My Top 10 SQL 2005 Features for RTM
(Indexed 2005-10-23):
Hello All,This post is all about the top ten features I am looking forward to in SQL Server 2005. You may be surprised its not just SSIS nor is it just about reporting services.1. SQL 2005 RDBMS: There have been some huge improvements in the core database engine. The two major areas of improvement that bring this area as number one are: Query Performance and Disaster Recovery. These two features I will use on every project. Listed below is functionality in detail that made up the number one rank...(truncated)...
Introduction to the Unified Dimensional Model (UDM)
(Indexed 2005-09-07):
I was talking to a colleague about Analysis Services and how awesome the Unified Dimensional Model (UDM) is. I then realized I have not blogged in ages about anything useful. So I have pulled together some of my thoughts about the UDM. I was really introduced to the UDM on the Yukon Ascend program last year in Sydney. At the time I was still trying to find out what the UDM was in Analysis Services 2005 (AS2005). The simple answer is The UDM is a Cube in AS2005. Ok that may be glossing over the U...(truncated)...
TechEd 2005 Sessions Schedule
(Indexed 2005-07-30):
Hello All,My Sessions have now been confirmed. Both sessions are on the last day of TechEd (Day 4: Wednesday 31st August)I am presenting the following sessions,9.00am - 10.15am Session 12Project REAL and Tips for Migrating from SQL Server 2000 Analysis Services to SQL Server 20053.45pm - 5.00pm Session 16Ad Hoc Reporting with Report Builder: Extending the Capabilities of SQL Server 2005 Reporting ServicesCheck out the link below for the TechEd sessions schedulehttp://www.microsoft.com/nz/events/...(truncated)...
TechEd 2005 Auckland New Zealand
(Indexed 2005-06-10):
Just a quick post to let you all know, that I am presenting two sessions on the next version of SQL Server 2005.I will be covering the advanced features of Report builder New in SQL Server 2005. Also I will be covering migration tips from Project REAL for migration of Analysis Services 2000 OLAP cubes to AS 2005.Once I have a confirmed schedule I will publish my session times.Myles
SQL Server 2005 - Formally Known as Yukon
(Indexed 2005-06-09):
Ok its been along wait; in fact its been a very long wait. To be truthful when I joined the Yukon Beta 1 program in the UK, I knew Yukon was special. SQL Server 2005 is jammed packed with new features with a large number around Business Intelligence.SQL Server 2005 is the first major release of the SQL server product line since SQL server 2000. Microsoft has reviewed the editions of SQL Server to provide cost effective solutions. Have a look at the following new editions for SQL Server 2005.SQL ...(truncated)...
Getting Started with DTS 2000
(Indexed 2005-06-06):
Hello All,I thought it would be a good idea to list some useful sites for first time users of Microsoft SQL server 2000 DTS.Check out the following links. These will help you get started usingDTS as an ETL development platform.DTS TutorialsThe link below is a great overview of DTS designerhttp://www.sqldts.com/default.aspx?278DTS white papersDTS Programming Techniques Used in Microsoft SQL Server Accelerator forBusiness Intelligencehttp://msdn.microsoft.com/library/default.asp?ur...(truncated).....(truncated)...
Hello World
(Indexed 2005-06-05):
[Image]Hello All Welcome to my small part of the web. I have started this blog to share my thoughts on Business Intelligence and its applications using Microsoft Technologies primarily SQL server, and of course anything else that interest me. But first a bit about me..... I have been working in the field of Business Intelligence for the last seven years. During that time I have worked in New Zealand, Australia and the United Kingdom. My focus has been delivering BI solutions using SQL Server 200...(truncated)...