The Last Day To Save
If you have not registered for the 2005 PASS Summit, today is the day to do so. The conference fee goes up after today, so call your boss and get registered.
Writing CLR Stored Procedures in C# - Returning Data (Part 2)
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.
Creating Dot Net Stored Procedures in SQL Server 2005
The CLR in SQL Server 2005 is quite the topic of debate and whether it is a good thing or not. No matter which side you are on, the reality is that you will need to understand how to create, manage, and work with stored procedures based on assemblies in SQL Server 2005. New author Yelena Varshal brings us a basic article and a sample that you can use.
Many-to-Many Dimensions in Analysis Services 2005
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.
MSDN TV: Report Authoring Tips and Tricks
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.
Triggers in SQL Server 7.0 and 2000 - What's New
This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of
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.
Finding Table Space
One of the most popular questions on SQL Server 2000 deals with determining how much space the various tables in your database take up. There are a variety of reasons for this and a few ways to gather the information. Author Amit Lohia takes a look at how sp_spaceused works and how you might customize it to suit your needs.
The July SQL Server Standard - Replication
We've just sent the July issue of the SQL Server Standard to the printer and it should be shipping out to you subscribers next week. The e-version should be in your virtual briefcase and it should be at the PASS and MCP sites soon. Read the editorial and see what's in this issue.
Introduction to XQuery in SQL Server 2005
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.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers