Wednesday, December 31, 2008

DM Companion – Data mining in cloud city

If you would like a better understanding of the Data Mining Experience from the web, DM Companion looks like a good learning tool.

Of course, there’s always this tool too:
http://sqlserverdatamining.com/cloud

DM Companion

Monday, December 29, 2008

DataPort Web | Sql bulk insert and paramaters

 

Sometimes transferring data quickly and safely can be a major task. In the following example I’ll show you how you can do a parameterized insert and how to use the sql transaction. This will speed up your insert tremendously.

DataPort Web | Sql bulk insert and paramaters

Data Dude - VSTS Database GDR VPC

 

You can download the VPC from the following location:

Data Dude

Sunday, December 21, 2008

Metadata Toolkit - Windows Live

The BI Metadata Toolkit

Overview

This white paper covers several interesting and unique methods for managing metadata in SQL Server Integration Services, Analysis Services and Reporting Services using built-in features including data lineage, business and technical metadata and impact analysis.

http://www.microsoft.com/downloads/details.aspx?FamilyID=182bd330-0189-450c-a2fe-df5c132d9da9&displaylang=en

Metadata Toolkit - Windows Live

Saturday, December 20, 2008

Download details: SQL Server 2005 SP3

 

Microsoft SQL Server 2005 Service Pack 3

Brief Description

Download Service Pack 3 for Microsoft SQL Server 2005.

Download details: SQL Server 2005 SP3

Tuesday, December 09, 2008

Andrew Fryer's Blog – creating a “time of day” dimension

Highlighting some of the pluses of SQL 2008

Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled. Storing time in SQL server 2005 was a bit of a cludge typically involving picking an arbitrary date (like 1/1/1900) and then tacking the time on to the end of that.  Now there’s a separate time data type so it’s easy to store the right data and create the time dimension using a script like this:

declare @time time = '00:00'
declare @timekey int = 0
declare @timegrain int =15

if not exists
    (select  * from sys.tables where name = 'dimTimeofday')
create table dimTimeofday( timekey int, TimeofDay time)
while @timekey < 1440 begin   
    insert into dimTimeofday(timekey,Timeofday) values (@timekey, @time)
    set @time = dateadd(minute,@timegrain,@time)
    set @timekey += @timegrain
end

For more on the new time data type check books on line here.

Andrew Fryer's Blog

Monday, December 08, 2008

SQL Server Matrix Workbench

Excel inside SQL Server?  It’s possible…

/*In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-based operations' */

SQL Server Matrix Workbench

Thursday, December 04, 2008

Saturday, November 29, 2008

Report Viewer Redistributable 2008 from 9/9/2008 still does not read 2008 reports??? - TechNet Forums

SQL 2008 launched a few months ago... and left Reporting Services developers in the dust.

Good things will come to those that wait.

The current target date for a control that can read the 2008 RDL schema is currently the first calendar quarter of 2009.  These dates can and are subject to change.

Report Viewer Redistributable 2008 from 9/9/2008 still does not read 2008 reports??? - TechNet Forums

Friday, November 28, 2008

"So, a booth babe and a geek walk in to a bar..." and they get certified.

Notes from a former certification blogger.

I really recommend that you subscribe to Born to Learn.

Ask Ken why it's called Born to Learn, while you're over there.

The first stop for MCP, certification, or exam help continues to be your regional helpdesk: http://www.microsoft.com/learning/support/worldsites.mspx, as you know. The MCP newsletter is still the best, official way to get news about the program and exams: Subscription info. And don't forget the other great bloggers in Microsoft learning--if you get stuck somewhere, check in with one of these people or teams:

While I'm at it, I thought I'd answer some of your other, recent questions, too, in a little Q&A.

"So, a booth babe and a geek walk in to a bar..."

Seven Steps to Certification Success : Training and Certification : Learning : Microsoft Forums

Where to start when dealing with certifications

Before writing this article, I posed a question to many certified individuals. The question I asked was, “What was the hardest part of your certification journey?” You would expect to hear that the hardest part was the exam(s) themselves. However, many people responded that the most difficult challenge was that they simply did not know how or where to start. They would describe how they heard of a certification, bought a book and started studying. There was no research performed, no plan established, and no evaluation afterword to debrief and learn from the experience.

Seven Steps to Certification Success : Training and Certification : Learning : Microsoft Forums

Thursday, November 27, 2008

JAM Software - SpaceObServer - The Hard Disk Space Manager with Database Storage

 

SpaceObServer - The Complete Disk Usage Management Solution

V3.3.2

SpaceObServer is a powerful and flexible hard disk space manager for Windows. It scans local and network drives using a background service and stores their structure, sizes and properties in an SQL database. In an Explorer-like user interface the collected data can be viewed and browsed in hierarchical or tabular views, 3D bar, pie, line charts and tree maps. Using the archived data you are able to track the development of the space usage from past to present, and forecast future size usage. A flexible file search, with predefined searches for very big, old or obsolete files allows filtering and listing files directly from the database. A duplicate file search is also included.

JAM Software - SpaceObServer - The Hard Disk Space Manager with Database Storage

Wednesday, November 26, 2008

Friday, November 21, 2008

TFS & Virtual Machines

 

What to do if you need to roll back \ undo your virtualized client

Use the Force -  To get the server and workspace versions in sync again perform a get using the force option. 

OR

If you are using Hyper-V a better solution is to put your workspace on a drive that is offline to the host OS (Windows 2008) but known to the Hyper-V machine.  You have to disassociate this offline drive from the Hyper-V machine before you do the rollback and re-attach afterwards.  This keeps the rollback from affecting the workspace drive, leaving your workspace files the same. 

Ed Hintz (MSFT)

Download SQL-RD Subscription Free Trial - Schedule SQL Server Reporting Services reports in daily, weekly, monthly etc. A single report in an e-mail, or a batch of...

 

SQL-RD saves time and money by allowing you to schedule and manage MS SQL Reporting Services Reports on numerous servers from a single application. It exports your RS reports to multiple printers, FTP, Secure FTP, email, folders, FAX and SMS. Choose to output to doc, xls, rtf, wk*, dbf, htm, mhtm, pdf and more. Use standard frequencies like daily, weekly, mothly, or set up your own custom calendars and exception calendars. Dynamic schedules provide an unmatched feature for linking and automating reports, data and destinations. It integrates seamlessly with Outlook and Exchange Server. Use Event-Based schedules (triggers) to fully automate your business processes whether they are report-related or not. SQL-RD features a feature-rich intuitive user interface, Folder Housekeeping, Clustering, PDF, PGP, Excel and Zip security, and an NT (Windows) service scheduler. It is fully compatible with SSRS 2000 and SSRS 2005.

Download SQL-RD Subscription Free Trial - Schedule SQL Server Reporting Services reports in daily, weekly, monthly etc. A single report in an e-mail, or a batch of...

Monday, November 17, 2008

Kimberly L. Tripp | Transaction Log VLFs - too many or too few?

 

To have a more ideally sized VLF, consider creating the transaction log in 8GB chunks (8GB, then extend it to 16GB, then extend it to 24GB and so forth) so that the number (and size) of your VLFs is more reasonable (in this case 512MB).

Kimberly L. Tripp | Transaction Log VLFs - too many or too few?

Wednesday, November 12, 2008

Useful Query #1 - find overlapping SQL Agent jobs

 

In SQL 2008 (or using 3rd party tools) you can run this command against multiple servers to determine which SQL Agent jobs overlap.  Perfect for finding contentious jobs...

use msdb
go

with cte  (name, server, run_date,run_time,run_duration,enddate,startdatetime,enddatetime,retries_attempted) as (
select --j.name, h.step_id, h.step_name, h.sql_message_id, h.sql_severity, h.message, run_status,
j.name,server, run_date, run_time, run_duration, run_time + run_duration enddate,

dateadd(hh, run_time / 10000,
            dateadd(mi, (run_time % 10000)/100,
            dateadd(ss, run_time %100,
            cast(cast(run_date as char(8)) as datetime)))) startdatetime,
            dateadd(ss,run_duration,dateadd(hh, run_time / 10000,
            dateadd(mi, (run_time % 10000)/100,
            dateadd(ss, run_time %100,
            cast(cast(run_date as char(8)) as datetime))))) enddatetime,

retries_attempted
from sysjobs j
inner join sysjobhistory h on h.job_id = j.job_id and h.step_id = 1
where run_date > convert(varchar(10),dateadd(d,-1,getdate()),112)
--and run_status <> 1
)
select cte.server, cte.name, cte.startdatetime, cte1.enddatetime, cte.run_duration, cte1.server, cte1.name, cte1.startdatetime, cte1.enddatetime, cte1.run_duration
from cte
cross join cte cte1
where (cte.name <> cte1.name)

and (cte.startdatetime between cte1.startdatetime and cte1.enddatetime
    or cte.enddatetime between cte1.startdatetime and cte1.enddatetime)
    and cte.run_duration > 300

Thursday, November 06, 2008

Carpe Datum - Activity Monitor

Other than hiding Activity Monitor from us in SQL 2008 (it's on the toolbar now) it has some great new features that make the role of a DBA almost obsolete.

Well, not quite, but it does make things much easier.

Install SQL 2008 and you can even run things like Policy Based Management and Activity Monitor (Super 2008 Ed'n) against SQL 2005 & 2000 instances.

My favourite trick is to show query plan on an active query, show missing indexes, then implement.  Instant performance improvements... and here's another way to track performance (or just snoop).

The new Activity Monitor has another trick up its sleeve: If you open it and then expand the first band of information just below the four graphs, you'll see a list of processes that you can order, sort and filter. If you right-click any process, you'll see an option to "open in Profiler". Click that, and you'll open Profiler with a default trace right on that SPID. Very useful to quickly identify the actions of a connection.

Carpe Datum

Legalizing the crack that is Excel spreadmarts – Chris Webb on Project Gemini

There’s nothing wrong with Excel.  Actually, there’s tons of stuff wrong with Excel.  Here is one example of a Spreadmart gone bad.

Excel error leaves Barclays with more Lehman assets than it bargained for

The law firm representing Barclays filed the motion (download PDF) on Friday in U.S. Bankruptcy Court for the Southern District of New York, seeking to exclude 179 Lehman contracts that it said were mistakenly included in the asset purchase agreement. The firm — Cleary Gottlieb Steen & Hamilton LLP — said in the motion that one of its first-year law associates had unknowingly added the contracts when reformatting a spreadsheet in Excel.

Cut-Paste Wealth Destruction! :)

Actually, many of the problems with Excel aren’t really with the product, it’s how it’s used.  “When the only tool you have is a hammer, everything looks like a nail.”  Ditto when the only tools you are comfortable with for dealing with numbers are Excel and Calc.exe, and it takes 2 weeks (or more) for the same report to be built using a “reporting tool” by the IT team…

Chris has some great points that I wholeheartedly agree with.  In the past, I have been responsible for promoting the view of a “single source of total knowledge” or a “one view” of the organization.  Excel doesn’t fit into this picture as a storage mechanism, but it can be the UI, analysis, modeling, and calculation engine that is supported by a central repository stored in the SQL Server cloud (or wherever you may decide to store your data).  Not knowing the details on Project Gemini, I hope that it continues with this theme of server-based storage and client-based analysis, and doesn’t go the way of Coleco Gemini.  I hope that there are options for clients who don’t adopt the latest technologies.  

Spreadsheets have long been one of the most popular ways for corporate users to store and analyze data. But over the past few years, they have played an increasing role in data breaches because workers are apt to store them unsecured on laptops. In addition, hackers have actively tried to exploit vulnerabilities in Excel.

Since I’m a DBA at heart, I’m not comfortable seeing thousands of silos of varying degrees of accurate information multiplying and dividing around a company. With a DBA mindset, it is all about control, security, maintainability, and performance of your data. 

This kind of desktop, DIY BI is in a way similar to illegal drugs: there are always some people that want it, a certain number of them are always going to do it even though they know they shouldn't, so you've got two choices - either legalise it and then hope to control it, as with Gemini, or throw all your efforts into outlawing it.

Chris Webb's BI Blog: Last thoughts on Gemini for the moment

Project Gemini – Microsoft’s Brilliant Trojan Horse

The concept of transferring some of the calculations and aggregations to the client does make sense.  My laptop is more powerful than many of the 5 year old servers in use at some of the client sites I work in.  It would be great to be able to quickly build models without delving into Business Intelligence Studio, SSIS, SSRS & SMS, or asking a developer.  There’s not much faster than memory on a PC, so in-memory processing sounds great to me.  I just hope there’s a way to push out a lockdown mechanism, for when that laptop and its information disappears from the company.

I hope they include a connector to perform calcs inside the GPU too

I like what I see so far with some of the “value-adds” coming out of MS Downloads for Excel like the data mining tools, though in the wrong hands (or even worse, the right hands) the information could be very misleading and lead to disastrous results.  From a marketing and adoption perspective, does it make sense to sell the idea of distributing mass amounts of data down to a client PC?  I’m still waiting on a good forms-based interface to input data from Excel directly into a data repository.  Sort of an InfoPath merged with Excel, without the need to install InfoPath, and with the “always-on” save features from One Note.  Sure, web forms and web services.  What about just Excel to Sql?

Without proper governance and understanding of the technology, publishing to Sharepoint can still lead us to Enterprise Spreadmart solutions and IT maintenance nightmares. 

In my opinion, rather than sheets of 20 million rows of raw data crunched and stored in a spreadsheet on a laptop, file share, or document store, there should be sheets (or something else?) of results available with the data being stored, crunched, and transformed in a central, secure, redundant place (“THE CLOUD?”). I hope that this is the approach Project Gemini will provide.  Magic?

One truth, shared by many, common to one. 

Metadata, semantic web technologies and, yes, Gemini again

Gemini IS Analysis Services

Gemini is Inevitability

Wednesday, November 05, 2008

SPSFAQ – Scalability and the fact that Sharepoint isn’t a database.

Some people seem to think that Microsoft Business Intelligence is Sharepoint.  Sharepoint is one piece to the puzzle, and it can scale, but there are some inherent limits that need to be avoided.  Eli has a few.

The 2,000 rule: because stored procedure calls to SQL Server slow down as you reach 2,000 items, have less than that in a view on a List. Less than 200 ideally to have optimum performance.

SPSFAQ

Speaking of scalability & Microsoft applications… Windows 3.1 is dead.  Long live Windows 3.11.

Microsoft has officially retired Windows 3.1

news.bbc.co.uk — "An application has expectedly quit. Windows 3.x has come to the closing moments of its long life. On 1 November Microsoft stopped issuing licences for the software that made its debut in May 1990 in the US. The various versions of Windows 3.x (including 3.11) released in the early 1990s, were the first of Microsoft's graphical user interfaces .."

http://digg.com/microsoft/Microsoft_has_officially_retired_Windows_3_1

PSS SQL Server Engineers : SQL Server Support in a Hardware Virtualization Environment

 

SQL Server Support in a Hardware Virtualization Environment

There is no doubt that virtualization is a hot and popular topic (the number of questions over email I get daily are a testament to that). Therefore, I think it is important for our customers to understand the support policies from Microsoft regarding SQL Server running in a hardware virtualization environment.

We have just published the following KB article that outlines this policy:

http://support.microsoft.com/?id=956893

PSS SQL Server Engineers : SQL Server Support in a Hardware Virtualization Environment

BeI - Microsoft Business Intelligence

 

Day after day we are working with Cube Browser but when the project or cube designer has closed we lost our query, sometime it takes a long time to reorder again all our dimensions.

This add-in is giving us the ability to save personal views and run it as a new request.

I develop it for SSAS 2005 & 2008 (SSAS 2008 Pre CTP6 with VS 2008).

Download Add-in For SSAS 2005

Download Add-in For SSAS 2008

BeI - Microsoft Business Intelligence

BeI - Microsoft Business Intelligence – Using WMI & Reporting Services

 

Reporting Services Querying with WQL

Hi Everyone,

From time to time we need to "ask" our Operation system questions such as:

1.       How are you today?

2.       How was your night?

3.       Do you need anything?

4.       Did somebody do something to you?  Who?

Well, the best way to do it is querying the system with WMI queries by WQL language.

Few days ago my customer needed to decide what the best way is.

So, how we can do it? , the following solutions are some examples of ways to do it

BeI - Microsoft Business Intelligence

Sunday, October 26, 2008

SSIS Junkie : T-SQL: Generate a list of dates

 

The following bit of code uses a common table expression (CTE) to generate a contiguous list of dates in SQL Server.

with mycte as

(

select cast('20080101' as datetime) DateValue

union all

select DateValue + 1

from mycte

where DateValue + 1 < '20080731'

)

select convert(char(8),DateValue,112) DateValue

from mycte

OPTION (MAXRECURSION 0)

SSIS Junkie : T-SQL: Generate a list of dates

Wednesday, October 22, 2008

SQL Server Forums - Deleting Large Number of Rows

SQL 2008 breaking “feature”


I was looking at the ROWCOUNT documentation and BOL states:
Using SET ROWCOUNT will not affect DELETE, INSERT, and UPDATE statements in the next release of SQL Server. Avoid using SET ROWCOUNT together with DELETE, INSERT, and UPDATE statements in new development work, and plan to modify applications that currently use it. Also, for DELETE, INSERT, and UPDATE statements that currently use SET ROWCOUNT, we recommend that you rewrite them to use the TOP syntax.
Something to keep in mind if your scripts will be run against sql 2008

SQL Server Forums - Deleting Large Number of Rows

Sunday, October 19, 2008

How to open a website in Visual Studio 2005 from the command line - BradleyB's WebLog

 

How to open a website in Visual Studio 2005 from the command line

I’ve seen several queries asking how to launch Visual Studio 2005 opening a specific folder as a website from the command line. Unfortunately Visual Studio 2005 does not support this by default but you can enable the scenario by writing a macro.

To do this, create a new macro either in an existing module or in a new module. For this example I’m going to add a module call Website to the MyMacros project.

If you’re new to macros in Visual Studio 2005, select menu Tools/Macros/Macros IDE, then select the MyMacros project and add a module.

Before you can use the new Website extensibility objects within VS you’ll need to add a reference to VsWebSite.Interop.dll.

Once added you can add the following code:

Public Module Website

Sub OpenWebsite(Optional ByVal path As String = "")

If (String.Compare(path, String.Empty) = 0) Then

MsgBox("Must supply a folder path to the OpenWebsite macro", MsgBoxStyle.OkOnly)

Else

Dim webPkg As VsWebSite.VSWebPackage

webPkg = DTE.GetObject("WebPackage")

webPkg.OpenWebSite(path, VsWebSite.OpenWebsiteOptions.OpenWebsiteOption_None, False)

End If

End Sub

End Module

After this code is added you’ll be able to run the macro. You can test it out in the command window.

From the Command Window in VS:

>Macros.MyMacros.Website.OpenWebsite C:\MyProjects\MyCompany\CompanySite

From the Command Line:

devenv /command "Macros.MyMacros.Website.OpenWebsite C:\MyProjects\MyCompany\CompanySite"

After its working you can register a shell command enabling an “Open as Visual Studio Website” command on any folder in windows explorer.

To do this copy the following into a OpenWebsite.reg file and run it.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\OpenVSWeb]

@="Open as Visual Studio Website"

[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\OpenVSWeb\command]

@="devenv.exe /command \\\"Macros.MyMacros.Website.OpenWebsite %1\\\""

Now you should be able to right click on a folder in Windows Explorer and select “Open as Website”.

How to open a website in Visual Studio 2005 from the command line - BradleyB's WebLog

Querying and Reporting on Report Execution Log Data

SELECT 'http://localhost/reportserver?'+cast(c.path as nvarchar(max))+'&'+cast([Parameters] as nvarchar(max))
FROM [ReportServer].[dbo].[ExecutionLog] e
INNER JOIN catalog c on c.itemid = e.reportid
WHERE ….

This lets you query the execution log and generate a list of URLs to run reports in Reporting Services.

Querying and Reporting on Report Execution Log Data

Tuesday, October 14, 2008

Andrew Clancy's Blog : NHibernate Query Generator in Action

 

NHibernate querying is great – it gives us the ability to query objects directly without the need to know anything about the underlying relational schema. It has a couple of major flaws though: 1. property names are accessed via strings, so we don’t know until runtime whether they exist, or are mapped 2. it’s ugly and cumbersome – frankly probably one of the major barriers I’ve had to ORM until now.

Ayende’s NHibernate Query Generator fixes both of these things. Mapped properties are accessed via properties as nature intended, and querying is a lot easier to read and write. Not quite as neat as Linq-to-NHibernate will be, but so much better than native NHibernate querying that I wonder why it wasn’t included in the trunk.

Andrew Clancy's Blog : NHibernate Query Generator in Action

MS BI Conference: Monday Keynote - Mike Diehl's WebLog

Waiting on 2010…

Timeframes: the next major release of SQL will be 24-36 months from release of SQL 2008, but in the meantime, there are a number of releases coming: Madison and Gemini will be coming in the first half of 2010, and CTP's will be available sometime early next year. There are some incremental releases of Analysis Services, Integration Services and Reporting Services coming - the next gen of Reporting Services in particular will become available in a Feature Pack "real soon now".

MS BI Conference: Monday Keynote - Mike Diehl's WebLog

Tuesday, October 07, 2008

The Programmer's Weblog: Inserting Blob into Microsoft Sql Database

 

It took me a while to figure a good way to insert Blob information into a Microsoft Sql database. One of the things you need to do is to insert an empty Blob, and I wasn't finding that on the internet. In Oracle you will use an empty_blob() function. So, I managed to get my code to work and decided to post it here so people can find an easy example. If you need more information, let me know.

The Programmer's Weblog: Inserting Blob into Microsoft Sql Database

Using Grouping Sets in SQL Server 2008 | Servers and Storage | TechRepublic.com

Cube-like functionality in SQL 2008.

Today I took a look at the usefulness of the new GROUPING SETS clause in SQL Server 2008. The results of the GROUPING SETS clause can be achived in other ways, but it takes more programming work to do so. Next time I will take a look at SQL Server 2008 enhancements to the CUBE and ROLLUP; two constructs that can produce similar results to the GROUPING SETS clause, but in a different manner.

Using Grouping Sets in SQL Server 2008 | Servers and Storage | TechRepublic.com

Monday, October 06, 2008

Cumulative update package 1 for SQL Server 2008

Some important fixes here.

FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order

FIX: The result for the Sum or Count function returns an empty value when you query a SQL Server 2008 Analysis Services cube

FIX: In SQL Server 2008 or in SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session

FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008

Plus plenty of Reporting Services updates.

Cumulative update package 1 for SQL Server 2008

Thursday, October 02, 2008

Hey Scripting Guy! How Can I Write to Excel Without Using Excel?

The scripting guy answers this question.

How Can I Write to Excel Without Using Excel?

Hey, Scripting Guy! Question

Hey, Scripting Guy! I need to be able to write information to an Excel file. I do not want to install Microsoft Office Excel on my server, but the spreadsheet format is a nice way to store information. I can then give it to my pointy-headed boss, and he can create pivot tables, charts, or whatever exactly it is he does all day. Basically, I think if I give him lots of data, he will leave me alone and let me do my job. Can you help?

Hey Scripting Guy! How Can I Write to Excel Without Using Excel?

How Can I Read from Excel Without Using Excel?

Hey, Scripting Guy! Question

Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on my server (which I understand is unsupported anyway)?

 

http://www.microsoft.com/technet/scriptcenter/resources/qanda/sept08/hey0911.mspx

Nick MacKechnie : Microsoft Announces SQL Server 2008 Experience

 

Microsoft Announces SQL Server 2008 Experience

On Monday, Sept. 29, Microsoft is launching the SQL Server 2008 Experience online at http://www.SQLServerExperience.com. With more than 500 short videos in 11 different languages, the SQL Server 2008 Experience is a Web site that helps Microsoft’s global customers and partners learn more about SQL Server 2008, Microsoft’s recently released data management and business intelligence platform. SQL Server 2008 provides a trusted, productive and intelligent data platform for business-critical applications. The launch of the SQL Server 2008 Experience kicks off a worldwide readiness outreach that will reach over 350,000 customers, partners and community members through in-person events over the next year.

Visitors to the SQL Server 2008 Experience can expect the following:

• Brief interviews with the SQL Server Engineering team, providing a behind-the-scenes view of the many technologies in SQL Server 2008

• Guidance on a wide range of topics such as business intelligence, compliance, upgrades and application development, including videos from customers showing how SQL Server 2008 is helping them be more successful. Customers that will be featured include Xerox Corp., Baltika Breweries and DriveCam Inc.

• Great deals on SQL Server 2008 books, courses and exams offered by Microsoft Learning

When: Sept. 29, 2008, at 8 a.m. (US Pacific Time)

Where: Online at http://www.SQLServerExperience.com

Nick MacKechnie : Microsoft Announces SQL Server 2008 Experience

Jamie's Junk : Time Series Reporting Stored Procedure - part 3 of 3

 

Time Series Reporting Stored Procedure - part 3 of 3

This post continues part 2 of the series.  In this part of the series I will demonstrate how to create a report using the stored procedure and also how to call the stored procedure from Excel using the Data Mining Addins for Office 2007.

In creating a report, the first thing I did was to use BI Dev Studio to create a new Report Server Wizard Project.  I then, of course, gave the wizard a connection string to my Analysis Services database that contains my Time Series model.

Jamie's Junk : Time Series Reporting Stored Procedure - part 3 of 3

Wednesday, October 01, 2008

Web Development Helper

 

Web Development Helper

Web Development Helper plugs into Internet Explorer and provides tools for Ajax and Web development.

Web Development Helper

PSS SQL Server Engineers : How to fix your SQL Server 2008 Setup before you run setup...

 

How to fix your SQL Server 2008 Setup before you run setup...

Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place? This would include a new installation, upgrade, or a install of a new instance or feature.

In this blog post, I'll give you details on how this works and point you to resources for known setup fixes that might affect you.

PSS SQL Server Engineers : How to fix your SQL Server 2008 Setup before you run setup...

XML Workshop XXII - A TSQL RSS Library - SQL Server Central

 

In the last few sessions of XML Workshop we had been looking at ways of generating RSS/ATOM Feeds. You can find the previous sessions here. We have seen how to generate RSS and ATOM feeds in SQL Server 2005 as well as 2000. In the previous sessions, we have seen how to generate RSS and ATOM feeds using FOR XML PATH as well as FOR XML EXPLICIT. If you are working with SQL Server 2005 (and above), you can take advantage of FOR XML PATH and if you are still in SQL Server 2000, you can use FOR XML EXPLICIT.

..

So the focus of this sessions will be writing a function that accepts two XML parameters containing channel and item information and generates an RSS 2.0 feed. We will be able to call the function as in the given example.

XML Workshop XXII - A TSQL RSS Library - SQL Server Central

Thursday, September 25, 2008

iT-Workplace - Home of Intelligencia

 

Intelligencia Query delivers add-in functionality for Visual Studio that transforms the task of creating OLAP reports with Microsoft SQL Server Reporting Services. State-of-the-art query tools are combined with a custom data extension that understands how OLAP reporting should work. With Intelligencia Query you get:

  • Queries are built the way that your report is to be displayed. There are no restrictions on where each dimension can be displayed or how many dimensions can appear on an axis.
  • Only the data required to fulfil your report is returned making IQ faster and more efficient than the default Reporting Services data extension.
  • Performance is further enhanced by providing techniques for building drilldown reports that only return drilled data as it is required.
  • The flexibility of the query builder dramtically reduces the need to "hand-crank" Mdx leading to better maintainability and reduced skill requirements.
  • Table and Matrix report items are supported allowing all types of reports to be created without having to resort to SQL queries via the Analysis Services ODBO interface.
  • Intelligencia Query support SAP BW and Congons TM1 in addition to all versions of SQL Server Analysis Services.    

iT-Workplace - Home of Intelligencia

Dynamic MDX in Reporting Services | The Frog-Blog

 

This post explains how you can build a dynamic MDX query in Reportins Services, customised to the users requirements. This can often bring some quite major performance benefits.

Dynamic MDX in Reporting Services | The Frog-Blog

Monday, September 22, 2008

SQL Server Policy-Based Management in SQL 2000/2005

 

Using PBM Against SQL2K and SQL2K5

We get this question a lot: can I use PBM against a SQL2K & SQL2K5 instances. The quick answer is yes but in a limited fashion. PBM is ultimately based on SMO (SQL Server Management Objects) and SMO supports SQL2K, SQL2K5, and SQL2K8. PBM relies on some changes to the DB engine which are not available in versions below SQL2K8, therefore, not all PBM functionality  is available in SQL2K and SQL2K5.

SQL Server Policy-Based Management

SQL Server Data Mining in the Cloud | SQLServerPedia

Analyzing Perfmon data with the SQL 2008 data mining tools.

In our particular example, we can see that Category 8 is the highest TempDB load.  Innnnteresting - earlier, I’d discarded categories over 5 because they represented a low amount of time, but it looks like we’ll have to go back and revisit category 8. Category 8 was Friday mornings from midnight to 4am, so we might have something going on then.

SQL Server Data Mining in the Cloud | SQLServerPedia

Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008

 

Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008

Using FILESTREAM to Store BLOBs in the NTFS File System in SQL Server 2008

Thursday, September 18, 2008

The Data Miner: September 2008

 

Here's a recap of what's new for Data Mining in SQL Server 2008:

  • The Microsoft_Time_Series algorithm has been enhanced to include ARIMA in addition to the existing ARTxp method, and a blending algorithm is now used to deliver more accurate and stable predictions, both short and long term, from a hybrid model. In addition, a new prediction mode allows you to add new data to time series models. (See below for a neat app that will let you explore these features.)

  • Built-in support for holdout has been added. You can easily partition your data into training and test sets that are stored in the mining structure and are available to query after processing.

  • You can now build mining models on filtered subsets of a mining structure's data (e.g. just male customers), which means that you no longer have to create multiple mining structures and re-read the source data for such variations over a dataset.

  • Drillthrough functionality has been extended to make all mining structure columns available, not just columns included in the model. This allows you to build more compact models without sacrificing the ability to producing actionable output reports like targeted mailing lists.

  • The much-requested cross-validation feature has been added, allowing users to quickly validate their modeling approach by automatically building temporary models and evaluating accuracy measures across K folds. The feature is available through a new cross-validation tab under Accuracy Charts in Business Intelligence Development Studio, in addition to being accessible programmatically via a stored procedure call.

The Data Miner: September 2008

Wednesday, September 17, 2008

Business Intelligence LAB - Home

 

Project Description
Business Intelligence LAB is a Microsoft Business Intelligence Framework that is developped based on real life needs.
This repository hosts a set of development done upon SQL Server Business Intelligence Stack.
This covers :
- Data Access
- Sample Cube
- Sample OLAP Viewer
- XMLA
- SSIS custom component
Those component comes from my experience and my needs. Some were published on French .net community (http://www.techheadbrothers.com/) under :
http://www.techheadbrothers.com/Auteurs.aspx/renaud-harduin

Last edited May 18 at 11:21 AM by rhmBILAB, version 2

Business Intelligence LAB - Home

Tuesday, September 16, 2008

Andrew Kennedy's Blog : Units of Measure in F#: Part One, Introducing Units

Why doesn’t the US use the metric system?  That year, Congress went on summer vacation before the bill was supposed to be passed….

Measure conversion has caused numerous (and disastrous problems).  Think of litres to gallons conversion in an airplane, and really quickly you see how someone could run out of gas if they aren’t using the correct units of measure.

MS is trying to fix this with typed unit recognition in programming languages.

As recently announced in the September 2008 F# CTP (Community Technical Preview), the F# programming language now has full support for static checking and inference of units-of-measure. In this series of articles I'll gently introduce the feature. (If you're not familiar with F#, look here.) We've already been testing out the units-of-measure feature inside Microsoft and I'm amazed at the diversity of applications that are turning up. Of course, there are the obvious applications to scientific computing, and games (which are all about physics, after all), but we're seeing applications in machine learning, finance, search (think click rates, etc) and others.

Andrew Kennedy's Blog : Units of Measure in F#: Part One, Introducing Units

Data Mining in the Cloud

Mine your Data, Any Place, Any Time

The SQL Server Data Mining team is working to extend the power and ease of use of SQL Server Data Mining to the Cloud. Our goal is provide services that allow you to build rich, predictive applications without worrying about server infrastructure, and showcase these services with cool applications that give you a glimpse of what’s possible. We bring you a technology preview of our work below. Enjoy!

Current Projects

Table Analysis Tools for the Cloud

Build powerful predictive reports on your data with just a few clicks!
- No data mining expertise required
- No server installation required
- All you need is your Internet connection

http://www.sqlserverdatamining.com/cloud/

Monday, September 15, 2008

Is Excel a Complete BI Solution? | The Intelligent Enterprise Blog

The answer should be no in my opinion…  for large amounts of data Excel is not the right tool by itself, and usually BI is all about analyzing large amounts of data.  

However, the comfort of using Excel to analyze numbers isn’t something that’s going away any time soon.

What makes it a BI tool?

• Excel can be (and is often) used for operational reporting, by connecting to databases, and also for analysis and dashboards using pivot tables and charts (plus the power of VBA — Visual Basic for Applications).
• Excel does not necessarily have to be embedded in other applications.
• Excel certainly has sufficient market presence, well exceeding the stipulation above.
• Excel comfortably crosses $40 million in revenues, even when constrained for reporting and analysis usage. (Microsoft Office accounts for some $10 billion annual revenue, give or take a couple.)

Is Excel a Complete BI Solution? | The Intelligent Enterprise Blog

Searching Google for Sheet1 filetype:xls shows us there is a long way to go before getting rid of Excel.

Results 1 - 10 of about 2,000,000 for sheet1 filetype:xls. (0.28 seconds)

Sparks from the Anvil – Connection String from Analysis Services

 

SSAS Stored Procedures - connecting to the transactional data source

There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query.  This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database and dynamic dimension security is implemented by a stored proc. Here the SSAS stored procedure has to query the transactional database in order to get the user's authorisation. Clearly the SSAS database has a data source and it uses this connection to process the cube. So how do we get the connection string?

Well the short code snippet below provides the solution. The code simply connects back to the current database using AMO and obtains the connection string from the data source object. It then removes the redundant "Provider=SQLNCLI.1;" before returning a valid SQL connection string that can be used by SqlConnection().

Sparks from the Anvil

Jason Morales' Microsoft BI Update : The Business Intelligence Update - September 2008

 

The Business Intelligence Update - September 2008

HOT TOPICS

Register NOW for the 2nd Annual Microsoft BI Conference - click here!

25% Discount Promotion - Microsoft Office SharePoint ECAL / PerformancePoint Server CAL

*** extended through September 30, 2008

Assessment Tool for Business Intelligence

- compare your infrastructure against industry best practices and the latest IT research

Online Demo: Geospatial Business Intelligence

-  by integrating Virtual Earth and PerformancePoint

-  Blog: More on Virtual Earth & PPS

Business intelligence basics: case studies and job advice

Five keys to hiring (good) business intelligence professionals

Leveraging business and marketing skills for a business intelligence (BI) career

UPCOMING EVENTS

How does it all stack up?

6 part Seminar Series, sponsored by Inetium & Microsoft

Sept 18

Omaha, NE

Click here to register

Dashboard in a Day - sponsored by Quilogy

Sept 16 - Omaha, NE

Sept 18 - Chicago, IL

Click here to learn more and register

The Next Generation of Business Intelligence

Executive Roundtable Breakfast Series, sponsored by Neudesic & Microsoft

Sept 18 - Denver, CO

Sept 30 - Las Vegas, NV

Microsoft BI Conference

Oct 6-8 - Seattle, WA

www.microsoftbiconference.com

Managing Performance with PerformancePoint

Planning, Financial Reporting, Monitoring and Analytics for Dynamics GP 10

Oct 8 - Mountain View, CA

Click here to register

PASS Community Summit 2008

Nov 18-21 - Seattle, WA

Click here to learn more

Find Events & Webcasts

UPCOMING WEBCASTS

* all times listed below are for Pacific time zone

Microsoft Business Intelligence for Retail - sponsored by Solver

Sept 11, 11am

Click here to register

Using Your SharePoint Portal to Communicate Business Intelligence presented by Quilogy

Sept 11, 1 pm

Click here to register

Achieving Business Intelligence Across the Enterprise presented by Thorogood

Sept 18, 9am - Realize Fast & Effective Planning, Budgeting & Forecasting

Click here to register

NEWS LINKS & PRESS RELEASES

SQL Server 2008: First Impressions

BIScorecard Rates Eight Leading Products

An Effective Business Intelligence Strategy is the Key to Business Success

Next-generation BI at Hand, Forrester Reports

Gartner lists Microsoft India as leading vendor of BI

Information Agility

Who doesn't want to be agile?

The Business Intelligence Model of Conflicting Interests

Is Excel a Complete BI Solution?

Pervasive business intelligence: Are organizations really ready?

Seven Steps to Successful BI Competency Centers

Business Intelligence: Distilling Raw Data into Useful Information

The Business Intelligence Education Problem

Full Circle: Decision Intelligence (DSS 2.0)

Contact Me if you'd like to receive monthly emails of Jason Morales' Microsoft BI Update

Jason Morales' Microsoft BI Update : The Business Intelligence Update - September 2008

Gregg Stark on SQL Server

 

Remove Extra Spaces when Pasting from Outlook to Sql Server Management Studio

I seem to have this problem that when I paste sql code from my email into Sql Server Management Studio that it doubles all the line breaks and I have to go and remove them all.  Most of the time this isn't a big deal because the Sql is only a couple lines.  However if you get a ton of Sql emailed to you it can be quite annoying.  I finally found a way to quickly get rid of them.  Simply bring up the find and replace window and change the find to use Regular Expressions.  Then do a find on \n\n and replace that with \n. 

Gregg Stark on SQL Server

SQL Server 2008 Extended Events Manager - Home

 

Project Description
SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a C# .NET winforms application that aims to simplify creating and viewing metadata for Extended Events Sessions in SQL 2008.
This project was initially published on the MSDN Code Gallery:
http://code.msdn.microsoft.com/ExtendedEventManager/

SQL Server 2008 Extended Events Manager - Home

New Zealand IE8 Taskforce : Introducing the IE8 Developer Tools JScript Profiler

 

The recently released Beta 2 of Internet Explorer 8 contains a lot of improvements which are aimed at making developing web applications on Internet Explorer 8 easier and more productive. One of these improvements is the JScript Profiler in Developer Tools, which provides critical JScript related performance data to a web developer that helps identify and fix performance related issues. We believe the Profiler is going to be a very helpful tool to fine tune the performance of the scripts in a web application. It is lightweight, easy-to-use and provides the following features:

  • Provides performance data for JScript functions in two views:
    • Functions View – a flat listing of all the functions
    • Call Tree view – a hierarchical listing of the functions based on the call flow
  • Supports exporting the data to a file
  • Provides an inferred name for anonymous functions
  • Profiles built-in JScript functions
  • Supports multiple profile reports
  • Supports profiling across page navigation and refreshes

This post gives an overview of the Profiler and highlights some of its features. We hope you will try it out and give us your feedback.

New Zealand IE8 Taskforce : Introducing the IE8 Developer Tools JScript Profiler

Host and compile C# in Excel Services

Who says you can’t write C# Code in Excel?

clip_image002

Probably not what you were expecting…

I wrote a quick console application while testing Excel Services which uses the code provided by Robbe Morris to compile a .NET application on the fly, using source code stored as text format in an Excel spreadsheet and published to Excel Services.

So now you can write C# code in Excel and compile without Visual Studio, and host in a central location. 

Please comment if you can think of a good (or bad) application for this.  I can think of a few.

  • How about allowing the business to write custom code snippets? 
  • Storing business logic & data tiers in a spreadsheet? 
  • Complex calculations that require the power of C# or external libraries to run?

Or maybe just something to add to the list of stupid Excel tricks.

Here is the code to go with this solution.  (Limited to under 50 lines stored in the text).

using System; 
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml;
using System.Web.Services.Protocols;
using System.Security.Principal;
using SourceCodeManager;
using System.Reflection;
using System.Diagnostics;

namespace HelloWorldConsoleApp
{
class Program
{
private const string Workbook = @"http://bi-vpc/Reports/ReportsLibrary/CodeSnippet.xlsx";
static void Main(string[] args)
{
es.ExcelService s = new es.ExcelService();
s.SoapVersion = SoapProtocolVersion.Soap12;
string sessionId = null;

try
{
s.Credentials = System.Net.CredentialCache.DefaultCredentials;
es.Status[] status;
Console.WriteLine("Opening");
sessionId = s.OpenWorkbook(Workbook, String.Empty, String.Empty, out status);
Console.WriteLine("Session ID: {0}", sessionId);
Debug.WriteLine(WindowsIdentity.GetCurrent().Name.ToString());
Debug.WriteLine(Workbook);
Debug.WriteLine(sessionId);
object cellVal;
StringBuilder sb = new StringBuilder();

for (int i = 1; i < 50; i++)
{
cellVal = s.GetCellA1(sessionId, "Sheet1", "A" + i.ToString(), true, out status);
Debug.WriteLine(cellVal);
sb.Append(cellVal);
}

Debug.Write(sb.ToString());
Console.Write(sb.ToString());
string returnMsg = CompileCode(sb.ToString()); // The magic happens here
Debug.WriteLine(returnMsg);
Console.WriteLine(returnMsg);

}
catch (SoapException ex)
{
Debug.WriteLine("Error: {0} ", ex.SubCode.Code.Name);
Console.WriteLine("Error: {0} ", ex.SubCode.Code.Name);

}
catch (Exception ex)
{
Debug.WriteLine("Unknown Error: " + ex.ToString());
Console.WriteLine("Unknown Error: {0}", ex);
}
finally
{
if (!String.IsNullOrEmpty(sessionId))
s.CloseWorkbook(sessionId);
s = null;
}

}
protected static string CompileCode(string sourceText)
{
SourceCodeManager.Runtime runtime = new SourceCodeManager.Runtime();
SourceCodeManager.CodeContainer codeContainer = null;
string methodName = "Validate";
object[] parameters = null;

try
{

// Simulate pulling code from disk or from database.

codeContainer = new SourceCodeManager.CodeContainer();
codeContainer.ClassName = "MyClassName";
codeContainer.NameSpace = "MyNameSpace";
codeContainer.UniqueKey = "robbe";
codeContainer.SourceCode = sourceText;

// Compare this code with that which is set in
// our static List<CodeContainer> by the UniqueKey.
// If not found, compile and add.
// If found but source code is different, delete, compile, and add.
// If found and source code is the same, grab reference to
// previously compiled assembly.

SourceCodeManager.Registration.Update(codeContainer);

// Let's create some sample parameters to pass into
// our dynamically compiled class/method.

parameters = new object[2];

List<int> parameter1 = new List<int>();

parameter1.Add(5);
parameter1.Add(10);

List<int> parameter2 = new List<int>();

parameter2.Add(50);
parameter2.Add(100);

parameters[0] = parameter1;
parameters[1] = parameter2;

// Execute the desired method and pass in our parameters.
// Our Execute method will always return an object. So,
// we need to know its actual desired return type ahead
// of time if we want to convert it to the property Type.

bool returnValue = (bool)runtime.Execute(codeContainer,
methodName,
parameters);

return "Method result: " + returnValue.ToString();

}
catch (Exception err)
{

return err.ToString();
}
finally {

runtime = null;

}
}
}
}

USE AT YOUR OWN RISK!



ASP.NET 2.0 - Safely Compile And Execute Source Code Dynamically By Robbe Morris

Friday, September 12, 2008

How to install the Microsoft Loopback adapter in Windows XP & Get Virtual PC VPC Network working

 

The 4 steps to setting up a network and VPC.

  1. Add the MS Loopback Adapter to your physical machine, with a static IP Address (this is actually harder to do than it sounds; it took me about half an hour to find how to install it).
  2. Configure all my virtual machines with 3 network cards: One tied to the wireless card, one tied to the ethernet card, and one tied to the loopback adapter.
  3. Configure the first two cards with DHCP, and the last one with a static IP different from the host machine's one.
  4. Add entries in the host files of all machines using the static ip addresses to enable quick name resolution.

Thanks Tomas

How to install the Microsoft Loopback adapter in Windows XP

Collation, DateTime, SParse Column and XML : Using SQL Server 2008 Semi-Structured features for Performance Tuning and Application Design (1)

Taking advantage of sparse columns and data compression in SQL 2008.

The above result shows that Page Compression has the best compression rate which is 16% of the original size, and the size of sparse column table is 31%, while row compression is 36%. Data Compression has a nice stored procedure sp_estimate_data_compression_savings which can estiamte the space saving by sampling data into tempdb, and compress the sampled data. The result is listed in “Estimated Saving” column in the table. I will also discuss the changing time later in this blog.

Collation, DateTime, SParse Column and XML : Using SQL Server 2008 Semi-Structured features for Performance Tuning and Application Design (1)

Description of Typical Services Registry Keys Under Hkey_Local_Machine

After installing SQL2008 as a named instance, you can stop/start from a command line using NET STOP MSSQL$SQL2008 and NET START MSSQL$SQL2008.

Unfortunately mine failed with this error when I tried to start.

The SQL Server (SQL2008) service terminated with service-specific error 1455 (0x5AF).

Then I got this error.  The dreaded sysfader.

Application popup: SysFader: iexplore.exe - Application Error : The instruction at "0x30037c61" referenced memory at "0x00000000". The memory could not be "read".

Click on OK to terminate the program
Click on CANCEL to debug the program

Will try a reboot and see what happens.

I put together a quick C# utility that lists all services on a machine and provides searching capabilities called ListService.

From a command line:  ListService.exe %1

Where %1 is the service name you are searching for. Leave blank to show all services under the registry key SYSTEM\CurrentControlSet\Services

It’s called ListServiceSetup.msi and requires .NET 2.0 Framework and Windows Installer 3.1.

It’s only(!) 32k and you can delete the .config file.  Should be around 2k with the 10 lines of code in it… but that’s .NET for you.  The installation package is a whopping 342k.

You can download from here:

ListService 0.0.0.1 beta installer

http://www.wavesmash.com/download/utils/

Description of Typical Services Registry Keys Under Hkey_Local_Machine

Thursday, September 11, 2008

Jamie's Junk : KDD 2008 and Incredibly Awesome SQL 2008 Data Mining Demos

Data mining hits the cloud.

Currently the technology demonstration allows you to access the Table Analysis Tools for Excel 2007 by connecting to our hosted data mining service, meaning you can use the Table Analysis Tools anywhere at anytime without connectivity to your local IT infrastructure.  Additionally there is a web interface that allows you to upload a limited amount of data and play with the tools without even having Excel!  Currently only a few of the tools are implemented in the web interface.  If for any reason you haven't had a chance to grab those amazing Table Analysis Tools and see what SQL Server Data Mining can do for you - run, don't walk, over to http://www.sqlserverdatamining.com/cloud/ and try them out right now!

Jamie's Junk : KDD 2008 and Incredibly Awesome SQL 2008 Data Mining Demos

SQL Server 2008 Overview, data platform, store data | Microsoft

My step-by-step screen shot installation of SQL 2008.  Not a best-practice installation by any means.

Mount the ISO using Microsoft Virtual CDROM.

Run Setup

  • Installs .net 3.5 sp1
  • Installs patch for windows xp
  • Reboots

Run System Checker

Install Upgrade Advisor

Install single instance.

image

Next screen is product key (not shown here)

image

image

image

image

---------------------------

Rule Check Result

---------------------------

Rule "Windows Firewall" generated a warning.

The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature.

---------------------------

OK

---------------------------

clip_image001

clip_image001[4]

clip_image001[6]

clip_image001[8]

clip_image001[10]

clip_image001[12]

clip_image001[14]

Next screen you select Windows or Mixed mode and add admins to SQL (Removed from here)

clip_image001[18]

clip_image001[20]

Next screen you add admins to Analysis Services (removed from here)

clip_image001[24]

clip_image001[26]

clip_image001[28]

---------------------------

Rule Check Result

---------------------------

Rule "Previous releases of Microsoft Visual Studio 2008" failed.

A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.

---------------------------

OK

---------------------------

clip_image001[30]

clip_image001[32]

And wait.  And wait.  And wait. And wait.  About 1 hour later.

clip_image001[34]

 

And wait

clip_image001[36]

The following notes apply to this release of SQL Server only.

Microsoft Update

For information about how to use Microsoft Update to identify updates for SQL Server 2008, see the Microsoft Update Web site <http://go.microsoft.com/fwlink/?LinkId=108409> at http://go.microsoft.com/fwlink/?LinkId=108409.

Reporting Services

The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.

To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

Documentation and Samples

To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 Books Online <http://go.microsoft.com/fwlink/?LinkId=114089> at http://go.microsoft.com/fwlink/?LinkId=114089.

By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008, see the CodePlex Web site <http://go.microsoft.com/fwlink/?LinkId=87843> at http://go.microsoft.com/fwlink/?LinkId=87843. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview <http://go.microsoft.com/fwlink/?LinkId=110391> on the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=110391.

For more information about late-breaking changes in this release of SQL Server, see the latest readme file <http://go.microsoft.com/fwlink/?LinkId=100093> at http://go.microsoft.com/fwlink/?LinkId=100093.

For information about SQL Server 2008 Surface Area Configuration, see the following SQL Server 2008 documentation topics:

In SQL Server 2008 Books Online: “Understanding Surface Area Configuration.”

In SQL Server 2008 Setup Help: “Minimize SQL Server 2008 Surface Area.”

In SQL Server 2008 Books Online on MSDN: Understanding Surface Area Configuration <http://go.microsoft.com/fwlink/?LinkId=106282>         at http://go.microsoft.com/fwlink/?LinkId=106282.

SQL Server 2008 Overview, data platform, store data | Microsoft

Wednesday, September 10, 2008

SQL Server 2008 Extended Events Manager - Home

 

SQL 2008 Extended Events are a powerful new way of troubleshooting problems with SQL Server. One short coming is that there is no UI support for this new feature. The Extended Events Manager is a C# .NET winforms application that aims to simplify creating and viewing metadata for Extended Events Sessions in SQL 2008.

Planned Functionality:
  • View Extended Events Metadata for all Available Objects
  • View Event Sessions on a Server
  • Start/Stop Events Sessions
  • Create new Event Sessions
  • Alter existing Event Sessions
  • Drop Event Session
  • Script all operations
  • View information stored in targets for active Event Sessions
Release Notes

This project was placed on CodePlex at the following address per the rules of the SQL 2008 Heros contest:
http://www.codeplex.com/ExtendedEventManager/
all builds of the project, source code, and documentation have been placed there with Issue Tracking enabled,
as well as discussions enabled. If you would like to download the project, report a bug, or request a feature
be added, please visit the above link.

SQL Server 2008 Extended Events Manager - Home

Monday, September 08, 2008

Glenn Berry's SQL Server Performance: Sample T-SQL Scripts for Backup/Restore and Index and Statistics Maintenance

What every DBA should know.

Here are some sample T-SQL scripts for backing up and restoring databases and transaction logs (using AdventureWorks on the C: drive, which would not be a good idea in reality). They also show how to detach and attach a database, and how to do some basic index and statistics maintenance.  This was originally for the MCIS-4423 class that I teach at Denver University.

Glenn Berry's SQL Server Performance: Sample T-SQL Scripts for Backup/Restore and Index and Statistics Maintenance

Re: Hyperlink not working - MSDN Forums – Tip

For the jump to Url functionality in a report…

 

Instead of "localhost/application/page.aspx?id=" + Fields!ID.Value

Use "localhost/application/page.aspx&id=" + Fields!ID.Value

Use a & instead of the + sign just in front of your field value. I can't explain why but that's how I got it to work...

Re: Hyperlink not working - MSDN Forums

Wednesday, August 27, 2008

RDA Blogs - Business Intelligence and SQL Server: Virtual PC Tips - Using SYSPREP

 

Virtual PC Tips - Using SYSPREP

Virtual PC is useful for creating development and test environments where a number of server products are required. Take for instance setting up a development environment for a BI engagement. You may need SQL Server 2005, Reporting Services, Analysis Services, MOSS and possibly even Performance Point. If your development environment consists of a single laptop, Virtual PC is something you want to check out. As an aside you can get decent performance when running 2-3 Virtual PCs with 4 GB of RAM.
Microsoft has a tool called SYSPREP which you can use to clone an existing VHD file that you've prepared. This allows you to create a Virtual PC image that you can make a copy of and use. SYSPREP can take care of generating a computer name and a unique SID so that you won't "collide" with existing Virtual PC images.
I'll provide an example of using SYSPREP with a Windows 2003 Server Virtual PC Image. Open the Deploy.cab file on the Windows 2003 Server CD from the Support\Tools folder (just double click in Windows Explorer). Extract the contents to a folder (e.g. C:\DEPLOY; highlight the files in Deploy.cab, right click, then select Extract). When you are running a Virtual PC image, you can click the CD menu option, select Capture ISO Image, and point to your Windows 2003 Server .iso image file; then use Windows Explorer to access the Deploy.cab file.
Run Setupmgr.EXE (from the folder where you copied the Deploy.cab contents) to create an "answer" file; you'll proceed through a series of dialogs that record your answers to certain configuration questions to be answered when you launch a VPC that you created by copying a sysprepped VHD file. The dialogs are pretty self-explanatory; make sure to select Sysprep Setup on the Type of Setup screen.
After running Setupmgr.EXE your Virutal PC will shutdown. At this point delete the .VMC file and save the .VHD file. You will no longer launch the Virtual PC image; when you want a new Virtual PC you create a new virtual machine and use a copy of the .VHD file. The first time you launch a new Virtual PC image, SYSPREP will do it's magic and you'll have a working VPC image.

RDA Blogs - Business Intelligence and SQL Server: Virtual PC Tips - Using SYSPREP