Browse by Tags
All Tags »
DEV (
RSS)
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...
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...
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...
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...
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
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...
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...
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...
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...
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...
We had an interesting problem the other day. In our database (SQL Server 2008) we have a few tables with possibly many millions of records. We send some of the data from these and related tables to a third party service for processing and get status reports back. The problem was that the reports that we get back cannot easily be correlated back to the original records in our database. Let’s say we have a person table and an address table with a 1:m relationship between person and address. The tables...
I can’t decide what I think about the following implementation so I decided to throw it out here. Any thoughts are welcome. In a previous post I wrote about our wrapper around Bouncy Castle PGP encryption. Turned out it worked pretty well except one little problem. The PGP implementation on the receiving end would complain about our signature. In despair I even posted (and later answered) a question on StackOverflow. :-) The problem was that they use an old version of a PGP library that couldn’t...
After a tough last week where I spent far too much time debugging encryption keys, I needed something to relax. I haven’t tweaked my Visual Studio color settings in a while (a couple of years) so I spent a couple hours today refining them. You probably don’t want to know what I do when I’ve had a really bad week. Ok, I’ll let you know. I put on some music I like and watch Defrag. Preferably at 2 AM. I don’t know who’s idiotic idea it was to remove the graphical defrag interface from Windows, but...
On a recent project here at Renaissance , we needed to send files over FTP to some third party vendor. One of the requirements was that the files had to be encrypted using PGP (Pretty Good Privacy). After some research we decided to use Bouncy Castle . Bouncy Castle is an open source C# implementation of the OpenPGP standard. It is available in Java as well. An additional requirement was that the PGP Encrypted files needed to be signed as well. If you have no background in cryptology or PGP and this...
The time to rebuild my development machine had arrived again. I’ve been running Vista 32 bit for about a year. I was basically happy with Vista as a development machine, but something else had bothered me over the last couple of months. All the mundane crap that was clogging my system. For example, Skype, Trillian, ITunes, Hamachi, PDF readers, MS Office … The list goes on and on… I want a super lean installation of Windows 2008 Server x64, Visual Studio 2008, Sql Server 2008 x64, TortoiseSVN, VisualSVN...
More Posts
Next page »