Technical Weblog of Eric Charran
A Journal of My Technical Achievements and Challenges
When to use SQL Server Service Broker
Use SQL Server Service Broker for asynchronous transactional messaging from applications where...
Author: Eric Charran Date: 01/11/2006
At least one of your changes was not applied successfully to the wireless configuration
This error was throwing every time I tried to change a property in my wireless configuration in...
Author: Eric Charran Date: 01/11/2006
SQL Server 2005 WMI Provider Error
I recently resolved an error with the SQL Server 2005 Configuration Manager. Occasionally, during...
Author: Eric Charran Date: 01/03/2006
Internet Explorer Developer Toolbar
If you are a developer of any kind, and develop internet applications, I would highly recommend this...
Author: Eric Charran Date: 01/02/2006
Visual Studio and SQL Server 2005 Beta and CTP Uninstall Tool
Of course, by now everyone is running Visual Studio 2005, riiight? [8-|] For those folks that are...
Author: Eric Charran Date: 12/21/2005
SQL Server 2000 Reporting Services Parameter Gotcha
Here is a situation I recently ran across. We created a report which executed a stored procedure....
Author: Eric Charran Date: 12/21/2005
Clear Cache Tool
How many times have you reported a problem with website or web applicaiton and the level 1 support...
Author: Eric Charran Date: 12/21/2005
SQL Server 2005 System Table Map
The official SQL Server 2005 table map can be found below in .pdf format....
Author: Eric Charran Date: 12/21/2005
Installing Team Foundation Serer Beta 3 Part 3
I've now officially got my Team Foundation Server six guns strapped on. I've been attempting to...
Author: Eric Charran Date: 12/01/2005
Installing Team Foundation Serer Beta 3 Part 2
Still attempting the install on a fresh Virtual PC. The last time I tried the install, I attempted...
Author: Eric Charran Date: 12/01/2005
Installing Team Foundation Serer Beta 3
Don't forget to grant rights to the Team Foundation Server account and the Team Foundation Server...
Author: Eric Charran Date: 11/29/2005
Best Practices for CLR Assemblies vs. TSQL
A very good article on MSDN will help developers determine when to use the CLR stored procedures,...
Author: Eric Charran Date: 11/29/2005
Upgrading from VS 2005 Professional to VS 2005 Team System
For all you folks who managed to talk your managers into letting you get the Team Suite MSDN...
Author: Eric Charran Date: 11/28/2005
Standard Numeric Format Strings Output
Since I'm doing a bit of SQL Server Reporting Services development and architecture, I found this...
Author: Eric Charran Date: 11/28/2005
Microsoft Java Virtual Machine Lives
I ran across some arcane insane java application for my masters class. I refused to install the Sun...
Author: Eric Charran Date: 11/22/2005
New Convenience Alert
I love stuff that makes my life easier. I also hate the fact that (most) everything today requires...
Author: Eric Charran Date: 11/22/2005
ConfigurationManager Class Errors
So I'm coding a quick Windows Forms app in Visual Studio 2005 and noticed that the following line...
Author: Eric Charran Date: 11/21/2005
SQL Server Reporting Services Field Error Part 2
So here is another solution to the following error message: The data set "DataSetName" contains a...
Author: Eric Charran Date: 11/21/2005
My XBOX 360 GamerTag
In preparation for XBOX 360, here is my gamer tag! Put your gamertag here too.
Author: Eric Charran Date: 11/18/2005
SQL Server Reporting Services Field Error
Ever get this error from SQL Server Reporting Services when you consume a stored procedure and...
Author: Eric Charran Date: 11/16/2005
How to Make IE7 Beta Look Like IE 6
If you are running the IE7 beta, some sites and applications expect you to have IE 6 on your...
Author: Eric Charran Date: 11/14/2005
SQL Server Reporting Services Table of Contents
The Approach Since there is no table of contents functionality in SQL Server 2000 Reporting...
Author: Eric Charran Date: 11/07/2005
Sign Assemblies Like a Champ in VS.NET 2005
Yee-hah! Signing assemblies got a whole lot simpler. What's that you say? I don't have to fool...
Author: Eric Charran Date: 11/04/2005
Connection String Heaven
I used to use this site quite frequently, but forgot about it! It's really great!...
Author: Eric Charran Date: 11/04/2005
Upgrade to the RTM Bits for SQL Server 2005
Like Silk. I had an instance of the full imprint of SQL Server 2000 SP4 (Database Engine, Analysis...
Author: Eric Charran Date: 10/28/2005
SQL Server 2000 Clustering Gotchas
Part 2 on AWE Memory If AWE is enabled, SQL Server cannot use the paging file If AWE is enabled, SQL...
Author: Eric Charran Date: 10/27/2005
SQL Server 2000 Clustering Gotchas
Yes, I know that SQL Server 2005 is on the horizon. However, there are still many companies that are...
Author: Eric Charran Date: 10/27/2005
SQL Server Data Import Best Practices
The following link goes to an MSDN article which outlines some of the do's and don'ts surrounding...
Author: Eric Charran Date: 10/26/2005
Using Try Catch in SQL Server 2005
The try catch structure in SQL Server 2005 is one of the best additions to the TSQL language. This...
Author: Eric Charran Date: 10/26/2005
Renaming A SQL Server 2005 Server
For all of you who remember the agony (well, not really agony, but extra steps) involved when...
Author: Eric Charran Date: 10/26/2005
Factory Design Pattern
Usually, I wait a bit before consuming and championing a design an architecture principle to see how...
Author: Eric Charran Date: 10/25/2005
Inaugural Blog Entry - My Name Up In Lights!
Wow. I never thought I'd see the day I'd have my own MSDN Blog. I recently joined Microsoft as a...
Author: Eric Charran Date: 10/25/2005