Post New Web Links

SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

Posted By: Posted Date: August 21, 2010 Points: 0 Category :ASP.Net

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004

View Complete Post

More Related Resource Links

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Data Points: Designing Reports with SQL Server Reporting Services 2005

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

SQL Server 2005 Analysis Services - Performance of Excel Pivot Tables

Hi, I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk. The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has only one processor (there are 8...) at 100%... Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes... Thanks in advance Hugo

SQL Server 2005 Analysis Services Step by Step Companion CD

Hi everyone,

I'm also reading this book, and do not have the companion cd. If someone could e-mail it to me at: sibasishdasgupta@gmail.com i would really appreciate it. Thanks in advance.

Where to find code samples for "SQL Server 2005 Analysis Services Step by Step" book?

Hi,

I am reading SQL Server Analysis Services from "SQL Server 2005 Analysis Services Step by Step" book and I want to download the code samples for the same. Please tell me how I can do that?

Thanks in advance,
Sumit

Web Services ASMX Data to SQL 2005 Server

I'm using Visual Studio 2010. Project .NET 2.0 ASMX web service to SQL 2005. In the VS development server the data goes into the SQL Server correct but the page displays a blank http 500 page. When I load it to the local IIS webserver the data does not go and it still displays the blank http 500 page.

Here's my code

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace PassportWS

{
    /// <summary>
    /// Summary description for CourseEnquiry
    /// </summary>
    [WebService(Namespace = "urn:portal.com:passportService")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]

public class PassportService : System.Web.Services.WebService
{

[WebMethod]
public int PassportMethod(string PassNumber, string PassType, DateT

SQL Server 2005: Regular Expressions Make Pattern Matching And Data Extraction Easier

Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.

David Banister

MSDN Magazine February 2007

Data Points: SQL Server 2005 XML Support, Exception Handling, and More

SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.

John Papa

MSDN Magazine May 2006

SQL Server 2005: Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities

SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.

Jay Nathan

MSDN Magazine September 2005


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All