CodeRush Plugin – Navigate to Implementation

יום חמישי, נובמבר 12, 2009

EDIT: As of version 9.3.2 of CodeRush functionality similiar to that provided by this plugin is provided in the core product and support and builds for this plugin is discontinued... If you need assistance for earlier version of CR, just leave a comment and I'll get back to you. Instead of posting a new a post every time a new build of CodeRush (and the plugin) becomes available, I’ll start to post the binaries here by updating this post. If you are interested in the source code, you can get it here. If you want a walk-through of how the plugin...

Calling the Google Closure Javascript Compiler – Code

יום שלישי, נובמבר 10, 2009

Here’s a follow-up to the last post that contained a few screenshots showing the integration of the Google Closure Javascript compiler in Visual Studio. Since I said in the last post that I would make the source available if there was interest, I’m doing that now. The project structure is as following All of the code for accessing the compilation service is in the GoogleClosure project. Initially I didn’t have a Winform project. I split the projects for this post, realizing that some people interested in the code might not have CodeRush. The GoogleClosure project also contains the UI in a...
one comment

Integrating Google Javascript Compiler in Visual Studio

יום ראשון, נובמבר 8, 2009

Friday, Google released some of their Javascript tools. Among them the Closure Javascript compiler. Being excited that Google has released Closure (the compiler), I decided to give it a go. So late Saturday night after the party was over and the kids were sleeping, I played a little with the online UI when I saw that the compiler services are exposed through a REST web service. At that point it would be a crime to go to sleep. 2 hours later… In this screenshot you can see some compiler statistics. (Yes, you can use the compiler service as a pretty-printer or...

My Favorite SQL Server 2k8 Feature

יום חמישי, אוקטובר 22, 2009

Since I'm typing this on my new Eee 1101HA I'm going to keep it short. (I hate these mini keyboards) Keeping an eye on our production Sql Server box is an integral part of my daily routine. I would not categorize myself as a DBA as I don't do much administrative work related to our databases. I'm dealing mainly with issues that are related to development and making sure our system runs efficiently. One of those tasks is to make sure that our database is properly indexed and maintaining indexes as the database grows. Anyone who has done any significant work against...
no comments

CodeRush plugin "Navigate to Implementation" – binaries for CodeRush 9.2.4

יום ראשון, אוגוסט 30, 2009

For convenience, here are the binaries for the Navigate to Implementation CodeRush plugin. It is built against CodeRush 9.2.4. A detailed overview of the functionality of the plugin can be found here. The source code is available on Google Code:  

Importing Large Xml Files to SQL Server Using SqlBulkCopy

יום שני, יוני 15, 2009

Say you have a large Xml file that contains relatively tabular data that you want to import into SQL Server. There are several ways to go about this. Let’s look at a couple of options. Load the file into an XDocument. Extract elements from the DOM using Linq and then use ADO.Net to insert the data into the database. Load the data into a DataSet using ReadXml and save the data to the database Read through the data using an Xml reader and save each record to the database Options number 1 and 2 requires that we load the...

Multi-Threading is Hard – Who do you trust?

יום חמישי, יוני 4, 2009

Something has been bothering me for quite some time and I am frankly not entirely sure what to do. I have been working on a multi-threaded server application for over a year and feel that I have a decent grasp on multi-threading. More importantly, I have learned to respect the complexity. So what is bothering me? Over the last few months I have encountered a number of blog posts that propose some solution with code that multi-threaded. The problem – It’s Wrong! Sometimes I send an email to the author, but for the most...

A Must Read – Release It!

יום שבת, מאי 30, 2009

I just finished reading Release It by Michael Nygard. The book deals with the topic of having software in production. Over the years I've been on quite a few projects from the requirements phase through development and eventually production. (No, not all of them reached production) I can't give enough compliments about the book. The writing style is a brilliant mix of development related issues and "war" stories from Michael's own experiences. It covers both anti-patterns and patterns required for successful survival in a production environment. From the editiorial review: In Release It!, Michael T. Nygard shows you how to design andarchitect your application for...
no comments

SqlBulkCopy Bug Workaround

יום רביעי, מאי 20, 2009

We are using SqlBulkCopy to import large xml documents into a database. However, we encountered a “minor” bug in the .Net Framework related to table naming. It turns out that if you have a dot “.” in the table name, SqlBulkCopy doesn’t work. The problem has been reported and a KB article is available, but without a workaround besides renaming the table. Our problem wasn’t with the actual name of the table(s), but with the name of the schema. The schema naming convention used in that specific database is .TableName. The following code failes with the exception below....

How Many Rows in a Table?

יום חמישי, אפריל 30, 2009

Have you ever wondered how many rows your SQL Server database tables contains? A few times now I've wanted to grab a list of table names with the row count for each table. In a post about a few undocumented Stored Procedures I came across this neat script.EXEC sp_MSforeachtable 'SELECT ''?'', Count(*) as NumberOfRows FROM ?' It uses an undocumented stored procedure that iterates over all user tables in the database. The only issue I had with it, was that the output was really tedious to read. I wanted a simple tabular display showing me a list of tables with their name and number...
no comments