Contents tagged with SQL Server
-
Repositories gone wild
One of the very beneficial side effects of the rise of MVC in the ASP.NET world is that people started to think a lot more about separating concerns. By association, it brought along more awareness around unit testing, and that was good too. This was also the time that ORM's started to become a little more popular. The .Net world was getting more sophisticated at various levels of skill. That was a good thing.
-
Rebuilding CoasterBuzz, Part II: Hot data objects
This is the second post, originally from my personal blog, in a series about rebuilding one of my Web sites, which has been around for 12 years. More:
-
SQL ADO.NET shortcut extensions (old school!)
As much as I love me some ORM's (I've used LINQ to SQL quite a bit, and for the MSDN/TechNet Profile and Forums we're using NHibernate more and more), there are times when it's appropriate, and in some ways more simple, to just throw up so old school ADO.NET connections, commands, readers and such. It still feels like a pain though to new up all the stuff, make sure it's closed, blah blah blah. It's pretty much the least favorite task of writing data access code. To minimize the pain, I have a set of extension methods that I like to use that drastically reduce the code you have to write. Here they are...
-
Forum search win
I checked to see how CoasterBuzz's search index was going today, and was pretty shocked to see that it now as about 15 million rows. Can't say that I've personally written anything that generated that much data on its own before.
-
Letting the kids loose on your junk
I ported the data from my reasonably large forum on CoasterBuzz over to an early test build of POP Forums v8. First off I was just relieved that the data was easy to move.
-
Paging in SQL 2005 like a ninja
I'll be honest, I really haven't looked much at SQL Server 2005 because I really didn't have any incentive to. Sure, I've been using the Express version in production and it's super sweet, but honestly I haven't bothered looking any deeper into it. I did get the programming book Microsoft put out, and even read the new stuff, but didn't think much about it.
-
Is there a way to count SQL transactions in an ASP.NET Request/Response cycle?
Is there a way to count SQL transactions in an ASP.NET Request/Response cycle? In other words, is there some simple bit of code you can wire into an HttpModule at starts and ends counting in the events of my choice?
-
Reporting on massive amounts of data in real time: Need input
Since I've been in the content business online for eight years or so, advertising is the life line that pays the bills. Not my first choice since it has been relatively unstable since the start, but it is what it is.