Sign in
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
Analysis Services 2005
Architects Corner
Blogcasts
Business Intelligence
Code samples
Free SQL Server Tools, Utilities and Addins
High Availability
High Availability and Disaster Recovery
Oracle
Pages
Performance
Performance Top Tips
Post Event Follow Up
Replication
Reporting Services
SAP
Service Broker
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
T-SQL
Webcasts
Archive
Archives
January 2006
(4)
November 2005
(4)
October 2005
(3)
September 2005
(9)
August 2005
(14)
July 2005
(14)
June 2005
(29)
May 2005
(19)
April 2005
(18)
March 2005
(9)
February 2005
(18)
January 2005
(7)
December 2004
(18)
TechNet Blogs
>
Mat Stephen's SQL Server WebLog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Mat Stephen's SQL Server WebLog
TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning
Posted
over 8 years ago
by
Mat_Stephen
0
Comments
For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP...
Mat Stephen's SQL Server WebLog
Get SQL Server Analysis Services OLAP Online on your PDA Pocket PC
Posted
over 8 years ago
by
Mat_Stephen
0
Comments
Have you ever been asked to do OLAP on a PDA – Pocket PC. If you have this http://www.euroman.co.uk/pcktindex.html has to be the best answer. I’ve seen it demoed and it rocks – its so cool; bringing scalable OLAP server power to your PDA in a way you...
Mat Stephen's SQL Server WebLog
Feature comparison: Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
At last, here is a feature comparison between Microsoft SQL Server 2000 Reporting Services vs Business Objects Crystal Reports / Crystal Enterprise that I can actually point you to. We ' ve had our own internal one for quite sometime, but for what I believe...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server 2005 Educational Webcast Series on TechNet
Posted
over 8 years ago
by
Mat_Stephen
0
Comments
Sorry I'm a little late in alerting you to this SQL Server 2005 Educational Webcast Series on TechNet, which runs from March 21-May 18. This 10 part series will provide IT Professionals with a broad overview of the benefits of SQL Server 2005 to whet...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server 2005 fuzzy logic in matching and grouping - how does it work in SQL Server Integration Services?
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
Following on from a presentation 'First Look at SQL Server Integeration Services' to some MVPs here at TVP Reading, I am responding to the a question I was asked, 'how does SQL Server's fuzzy logic work'. I was meant to explain how the confidence and...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server 2005 Virtual Labs on MSDN
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
Are you ready to experience SQL Server 2005? Announcing the launch of the SQL Server 2005 Virtual Hands on labs. In these labs, you will get to experience many of the new features in SQL Server 2005 including CLR integration, XML support and deep business...
Mat Stephen's SQL Server WebLog
UK Technical Roadshow – a few places left so hurry if you want one
Posted
over 8 years ago
by
Mat_Stephen
0
Comments
There are three technical tracks at the 2 day roadshow this year. The second day is a ‘SQL Server 2005’ day with a number of sessions covering SQL 2k5 from three angles: ITPro (DBA), Developer and Security. On the ITPro track there will be Analysis...
Mat Stephen's SQL Server WebLog
Two new free Microsoft SQL Server Reporting Services Report Packs released for IIS and Great Plains
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
From the blog hits I received the last time I posted some info on free report packs available for SQL Server Reporting Services, I'm sure many of you will be pleased to find we've just posted two more for IIS and Great Plains. Objective: The Report...
Mat Stephen's SQL Server WebLog
The Final Word in Microsoft SQL Server 2000 Backup, Restore and recovery
Posted
over 8 years ago
by
Mat_Stephen
0
Comments
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...
Mat Stephen's SQL Server WebLog
First Microsoft-SAP Collaboration Brief from Microsoft on loading data from SAP BW into SQL Server Anlaysis Srevices
Posted
over 8 years ago
by
Mat_Stephen
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...
Mat Stephen's SQL Server WebLog
Questions arising from TechNet Webcast: Business Intelligence on the Microsoft Platform 23rd March.
Posted
over 8 years ago
by
Mat_Stephen
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...
Mat Stephen's SQL Server WebLog
Forthcoming UK Microsoft SQL Server Business Intelligence Webcasts.
Posted
over 8 years ago
by
Mat_Stephen
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...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server - Reporting Services Scripter - a free tool from sqldbatips.com
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
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...
Mat Stephen's SQL Server WebLog
Using SQL against the Unified Dimension Model in Microsoft SQL Server 2005 Analysis Services
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
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...
Mat Stephen's SQL Server WebLog
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!
Posted
over 8 years ago
by
Mat_Stephen
5
Comments
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’...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server 2005 - The Pricing, The Editions, and the Edition's Features
Posted
over 8 years ago
by
Mat_Stephen
2
Comments
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...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server Resource Kit tools - 'Free' with MSDN and TechNet
Posted
over 8 years ago
by
Mat_Stephen
1
Comments
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...
Mat Stephen's SQL Server WebLog
Office Excel Add-in for Microsoft SQL Server Analysis Services – its free, its powerful and it could save you money!
Posted
over 8 years ago
by
Mat_Stephen
4
Comments
Well I’ve been blogging for a 11 weeks or so and looking at my stats I can see the posts that attract the most attention are those that either advertise a freebie or offer a performance tip. So, blatantly pandering to my ratings, here’s another freebie...
Mat Stephen's SQL Server WebLog
Office Business Scorecards Accelerator – the ultimate marriage of business and intellgence. Another free application from Microsoft
Posted
over 8 years ago
by
Mat_Stephen
4
Comments
At first glance, particularly if you’re a jaundiced techie like me, you may think the Balanced Scorecard is a concept wholly worthy of its acronym, BS. You might find a description of its function couched in those seemingly worthless terms like vision...
Mat Stephen's SQL Server WebLog
Reporting Services : 21 Report packs released to the web for free download
Posted
over 8 years ago
by
Mat_Stephen
7
Comments
Just incase you missed this freebie: Report Packs SQL Server 2000 Report Pack for Microsoft CRM Download this set of six predefined CRM-based reports and a sample database that let you easily visualize and author managed reports to support key sales...
Mat Stephen's SQL Server WebLog
Its Sunbelieveable: Sun’s First Windows - Microsoft SQL Server SAP Benchmark and Certification
Posted
over 8 years ago
by
Mat_Stephen
Actually, I reckon it must be Sun’s first Windows - SQL Server benchmark ever, unless you know otherwise? It’s great to see Sun embracing the new Opeteron chip from AMD and coming up with a great 32 bit SAP SD 2 tier 2 proc benchmark http://www50.sap...
Mat Stephen's SQL Server WebLog
SQL Server Performance Top Tip: SQL Server User Mode Scheduler (UMS) – understanding it can explain some odd performance
Posted
over 8 years ago
by
Mat_Stephen
4
Comments
When performing batch jobs where you wish to run processes in parallel it is important to understand how the scheduler works. You can get a description of what the scheduler does by looking under the title ‘ SQL Server Task Scheduling’ in Books...
Mat Stephen's SQL Server WebLog
Migrate your legacy Oracle databases to SQL Server - Tools you need to do the conversion
Posted
over 8 years ago
by
Mat_Stephen
2
Comments
Its a question that comes up more and more as people realise they can take advantage of SQL Server's lower TCO. "Does Microsoft have any tools for converting PSQL to TSQL". No, but the link below will take you to a company that has tools to do this and...
Mat Stephen's SQL Server WebLog
Microsoft SQL Server Performance Top Tip: Degrees of Parallelism and a Degree of Uncertainty
Posted
over 8 years ago
by
Mat_Stephen
2
Comments
Max degree of parallelism is an advanced configuration option in SQL Server about which many question have been asked and much written. In this blog entry I hope to offer some insight and certainty as to what this option does and how it should be used...
Mat Stephen's SQL Server WebLog
Blogcast - Creating a simple Microsoft SQL Server Reporting Services report using the Report Wizard
Posted
over 8 years ago
by
Mat_Stephen
2
Comments
Following the trend I've created my first Blogcast - Creating a simple SQL Server Reporting Services report using the Report Wizard. It lasts about 6 minutes. It takes you through the simple steps required to create a simple report, making a little tweak...
Page 5 of 7 (160 items)
«
3
4
5
6
7