November 2005 - Posts
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
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 is that
Read More...
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 you
Read More...
In preparation for XBOX 360, here is my gamer tag! Put your gamertag here too.
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
