Don't forget to grant rights to the Team Foundation Server account and the Team Foundation Server Reporting Account. I'm lazy, so I added it to my local admin group on my Virtual Machine. I'll dig into what the rights actually are later. If these accounts...

A very good article on MSDN will help developers determine when to use the CLR stored procedures, functions and triggers versus traditional TSQL ones. The guidance is as follows directly from the article: Use declarative T-SQL SELECT , INSERT , UPDATE...

For all you folks who managed to talk your managers into letting you get the Team Suite MSDN Subscription, you'll be happy to know that the straight install from the DVD does "upgrade" or change the existing VS 2005 Professional installation you might...

Since I'm doing a bit of SQL Server Reporting Services development and architecture, I found this URL on MSDN that leads to standard .NET format syntax for data types. This is specifically relevant when doing financial reporting and formatting numbers...

I ran across some arcane insane java application for my masters class. I refused to install the Sun JVM, so I found this little nugget of nostalgia instead: http://www.mvps.org/marksxp/WindowsXP/java.php

I love stuff that makes my life easier. I also hate the fact that (most) everything today requires wires. So any solution to make my life easier in that regard I'm all for. Check out iGO.com. They make universal power adapters in a small form factor....

So I'm coding a quick Windows Forms app in Visual Studio 2005 and noticed that the following line resulted in a compiler error: SqlConnection myConnection = new SqlConnection ( ConfigurationSettings .AppSettings[ "connectionString" ]); The trick...

So here is another solution to the following error message: The data set "DataSetName" contains a definition for the field "FieldName". This field is missing from the returned result set from the data source. This can happen in report designer when...

In preparation for XBOX 360, here is my gamer tag! Put your gamertag here too.

Ever get this error from SQL Server Reporting Services when you consume a stored procedure and attempt to preview the report from the designer? The data set "DataSetName" contains a definition for the field "FieldName". This field is missing from the...

If you are running the IE7 beta, some sites and applications expect you to have IE 6 on your machine. In many instances, these sites are not doing a greater than version check, but looking for a specific set of IE versions. Thus, the following script...

The Approach Since there is no table of contents functionality in SQL Server 2000 Reporting Services, I had to develop a maintainable approach that worked well within the domain of Reporting Services as a technology. The Table of Contents requirement...

Yee-hah! Signing assemblies got a whole lot simpler. What's that you say? I don't have to fool around with creating the snk file myself and then editing the assembly info file to provide it? That's right. Just right click the project, go to the Signing...

I used to use this site quite frequently, but forgot about it! It's really great! http://www.connectionstrings.com/ This site will list connection strings for multiple types of data-related connections.