Integrating Reporting Services Using SOAP

Want to programmatically access your Sql Server Reporting Services Server? (SSRS) Turns out there’s an app for that! Or more precisely, a SOAP web service.
The Reporting Services SOAP API provides several Web service endpoints for developing custom reporting solutions. The endpoints currently fall into two categories: management and execution. The management functionality is exposed through [...]

Read Full Post »

SQL Server Reporting Services Hits its Stride – CODE Magazine

I’ve used SSRS multiple times in the past and know of at least one instance where I’ll be using it again in the future so I was quite pleased to stumble upon Paul Litwin’s recent article regarding the current state of SSRS.
We’ve all heard that version 3 of a Microsoft product is when that product [...]

Read Full Post »

Sql Documentation

The topic of a recent discussion, Doc-To-Help appears to be a documentation authoring tool. It does NOT appear to be a documentation generating tool. For documentation of .NET assemblies Doc-To-Help will take the output of Microsoft’s Sandcastle and add formatting, TOC’s, etc. As a quick reminder… “Sandcastle produces accurate, MSDN style, comprehensive documentation by reflecting [...]

Read Full Post »

Enthusiasts Convene To Say No To SQL

Given the amount of time it seems I spend working on data access related code I’d be very interested in what solutions the community is coming up with as an alternative.
Enthusiasts Convene To Say No To SQL, Hash Out New DB Breed
via Slashdot Technology Story | Enthusiasts Convene To Say No To SQL, Hash Out [...]

Read Full Post »

Sequential GUID’s – 50% Performance Difference?

While listening to another .NET Rocks podcast this morning I caught mention of Sequential GUID’s, a feature introduced in Sql Server 2005. Given the use of GUID’s as primary keys I thought this a useful piece of information.
What are the performance improvement of Sequential Guid over standard Guid? – Stack Overflow.

Read Full Post »

Visual Studio Team System 2008 Database Edition

Like most applications, a database plays a critical role in what I’m working on. Fortunately, two higher-end versions of Visual Studio are supposed to provide a Microsoft security blanket for developing a database, managing and tracking changes to a database, and deploying those changes. (Among other things)
http://www.vitalygorn.com/blog/post/2008/01/Handling-Database-easily-with-Visual-Studio-2008.aspx
Unfortunately, Microsoft left the security blanket for getting these [...]

Read Full Post »

VSTS: DB Best Practices : Right sizing the master.dbschema file for better design time performance

A reference to the master.dbschema (or similar, see below!) is necessary for database projects in Visual Studio that reference system objects. Here’s how to add those objects without slowing everything down.
In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system [...]

Read Full Post »

Configuring the Windows Firewall to Allow SQL Server Access

I spent an embarrassingly long period of time trouble-shooting my Sql Server install only to find the problem was the Windows Firewall.
Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked.
To access an instance of the SQL [...]

Read Full Post »

How to identify your SQL Server version and edition

This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition if you are using Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
via How to identify your SQL Server version and edition.

Read Full Post »

xSQL Profiler – Free Sql Server Profiler

One of my biggest complaints about the Express versions of Sql Server is that Sql Profiler is specifically excluded, a full Sql Server license is required instead. I managed to do without Sql Profiler just fine until I was working on some Entity Framework code and wanted the see the sql getting generated. It certainly [...]

Read Full Post »