Additional Articles

SQL Server Performance Monitor

by Additional Articles

Database Journal

Performance Tuning

You can monitor the system performance by using the Performance monitor console and its related counters in Windows 2000. These counters allow you to view or save information about the overall performance of your server. When you install Microsoft SQL Server, additional Performance monitor objects and counters are automatically installed. While you must have administrative access to your SQL Server to use these objects, SQL Server admins should find them invaluable in monitoring and tuning the database server. Furthermore, the Performance monitor can be used either locally or remotely, which allows admins greater control in monitoring SQL Server.

2005-07-01

3,715 reads

Discuss

Writing CLR Stored Procedures in C# - Returning Data (Part 2)

by Additional Articles

SQLTeam.com

.Net

In Part 1 I covered a simple stored procedure that printed the current date. In this article I'll cover writing a stored procedure to return a recordset back to the client. In the process we'll learn a little bit more about .NET and C# including the SqlConnection, SqlCommand and SqlDataReader classes.

2005-06-29

3,601 reads

Discuss

Many-to-Many Dimensions in Analysis Services 2005

by Additional Articles

MSDN Communities

Analysis Services (SSAS)

See an example of using the Many-to-Many dimension in SQL Server 2005 Analysis Services to analyze sales data, and get ideas for other uses such as treating medical conditions, software testing, and more.

2005-06-28

2,289 reads

Discuss

MSDN TV: Report Authoring Tips and Tricks

by Additional Articles

MSDN Communities

Development

Getting started with SQL Server 2005 Reporting Services or the new report controls in Visual Studio 2005? Brian Welcker demonstrates some tips and tricks that you can use to add interactive features to your own reports.

2005-06-27

2,173 reads

Discuss

MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of

by Additional Articles

Database Journal

Development

An important consideration, when designing a Business Intelligence system within any environment, is a consideration for "where to put the intelligence" among the various "layers" within the system. I have stated many times in the past, in both articles and presentations, that "multi-layered reporting solutions require multi-layered architects," and nowhere is this truer than within the design and implementation of the Microsoft integrated business intelligence solution. This article provides an excellent example of such considerations: the option for placing a needed calculation at either the Analysis Services level (within the cube structure) or the Reporting Services level.

2005-06-24

2,539 reads

Discuss

Introduction to XQuery in SQL Server 2005

by Additional Articles

MSDN Communities

Basics

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.

2005-06-23

2,686 reads

Discuss

Shredding a Recordset

by Additional Articles

SQLIS.com

Integration Services (SSIS)

Shredding a recordset in this instance means that we are going to show you how to take a recordset produced in your SSIS package, loop over the rows in that recordset, break apart the columns and do something with them. This is really useful when you want to preform an action on a row of data for every row of data just like we are going to do here. Sure we could use an ExecuteSQL task to get the recordset as well but that does limit our choices of source data whereas doing it in the pipeline does not. Something useful we hope.

2005-06-21

2,103 reads

Discuss

Reproduced with kind permission from the blog of Ashvini Sharma (MSFT)

by Additional Articles

SQLDTS.com

Integration Services (SSIS)

InfoPath forms can be saved to XML, these XML Files can later be used in SSIS XMLSource adapter to pull out the data in tables and columns. However, there are some common problems you may meet in these scenarios. This article describes how to work around these potential problems. The issues mentioned in this article is not only specific to InfoPath files, it can also be referenced in other similar situations as well.

2005-06-20

1,328 reads

Discuss

MODELS, MODELS EVERYWHERE, NOR ANY TIME TO THINK

by Additional Articles

dbdebunk.com

Advanced

Even a cursory inspection of data management practice reveals that the majority of practitioners-–be they novices, or experienced, users or vendors--operate in a “cookbook”, product-specific mode, without really knowing and understanding the fundamental concepts and principles underlying their field, e.g. what data means, what data model, database, DBMS, data independence really are, and so on.

2005-06-17

2,510 reads