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...
10 בנובמבר 2009
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...
8 בנובמבר 2009
2 hours later…
In this screenshot you can see some compiler statistics. (Yes, you can use the compiler service as a pretty-printer or...
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...
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: http://dxcorecommunityplugins.googlecode.com/svn/trunk/CR_NavigationContrib
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...
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...
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...
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....
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...