26 Jan
2012

SqlBulkCopy for Generic List<T> (useful for Entity Framework & NHibernate)

A common complaint of the Entity Framework is slow insert times for larger datasets. Last night I was trying to insert a catalog of 15k products and it was taking a very long time (I gave up after 5 minutes). I recalled this post a while back from Mikael Eliasson demonstrating SqlBulkCopy using .NET. I […]

Read More
2 Jul
2010

Using TransactionScope with SQLite

Category:UncategorizedTag: :

Earlier this week I ran into a little quirk with SQLite. Take a look at the following code snippet: using(var transaction = new TransactionScope(TransactionScopeOption.Required)) { using(var connection1 = new SQLiteConnection(_connectionString)) { connection1.Open(); … // Do stuff with the open connection } // Closes the connection (so we think …) using(var connection2 = new SQLiteConnection(_connectionString)) { […]

Read More
25 Jan
2010

Calls to ReportExecutionService.Render() Hang

Given: One Windows Service, written in C#, using SQL Reporting Services via the SSRS web services.  MyApp.Service waits for work requests to come in, and when it finds them it uses SSRS to generate some PDFs (among a bunch of other stuff).  The Windows Service code is in one project, “myapp.service,” and the code that […]

Read More
28 Nov
2009

Database Change Management with Tarantino

Seeing as how I have not graced these pages with my presence in quite some time. I figured I better get something going. A little while back my team started working with some outside contractors and our make shift way of keeping changes in sync and under control was simply not cutting the mustard. Why […]

Read More
24 Jun
2009

Repost: Watch out for SQL Server Parameter Sniffing

I posted on this about a year ago.  I am reposting this as a Public Service Announcement (otherwise known as a PSA). Do you have a stored procedure where the amount of data returned can vary wildly depending on what parameters are passed in?  Does performance change dramatically depending on how much data is being […]

Read More
4 Jan
2009

SQL Window Clause

Category:UncategorizedTag: :

Hi it’s Jason again. I enjoyed writing my last post on SQL pivot so much that today I thought that I would explore another rarely used feature of this ubiquitous query language – the window clause. As before I am using SQL Anywhere 10 but the same technique will work with several modern databases such […]

Read More
31 Dec
2008

Three Times the Fun

Category:General PostTag: , :

Jason again. Over the past week, while most people have been enjoying some hard earned time off, I’ve been working…a lot. Joining me in my efforts have been fellow Elegant Coder Chris and Priyesh. The nature of the projects that we undertake here can make it difficult to apply some key development principles. A particularly […]

Read More