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

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

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

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

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

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

SQL Pivot

Category:UncategorizedTag: :2 Comments on SQL Pivot

This is Jason who is continuing to masquerade as a guest. I’m going to let you into a dirty little secret…I’ve written a lot of SQL during my career. This admission almost sounds like heresay in these days of DDD, BDD etc. but it’s still an incredibly useful skill to have. Anyway a lot of […]

Read More