About Jeremiah

I'm a senior database administrator with Cass Information Systems, a SQL Server MVP, director-at-large with PASS, and I also help out with my local chapter and the Application Development virtual chapter.

You can learn more about me or contact me directly.


Google Reader
Google Profile
delicious

Links for the Week of 2009.07.31

SQL Server
Fast Running Totals solution with ordered CTE update? Who says you need a cursor to get a running total? I’ve typically done these kinds of things with expensive CROSS JOINs and/or nasty INNER JOINs. Good to know there’s a nicer way.
Extended Events Manager Update: Now A SSMS Addin SQL 2008 Extended Events are a [...]

July 31st, 2009 | Category: Code | Leave a comment

The Terror of Isolation

I work in isolation. I don’t mean physical isolation – I have coworkers and we talk and go to lunch and do all kinds of coworker things. I work in physical isolation from other practicing database professionals. My manager is a former DBA, but he hasn’t worked with SQL Server newer than SQL 2005 and [...]

July 28th, 2009 | Tags: , , , | Category: SQL, SQL Server, sqlpass, syndication | 2 comments

Links for the Week of 2009.07.24

SQL Server
Learn Microsoft BI So you want to learn all about the BI, do ya? Lots of videos. Lots and lots of videos. They’re all free.
Getting a NEWSEQUENTIALID() How do you get the ID that’s created after an insert if you’re using NEWID() or NEWSEQUENTIALID()? Pat Wright has the answer! (Hint: The answer is not [...]

July 25th, 2009 | Tags: , , , , | Category: Code, SQL, SQL Server, nonsense | 2 comments

From Tables to Objects – Follow Up

First off, I want to say thank you to the Central Ohio .NET Developers Group for giving me the opportunity to speak last night. I really enjoyed it and I was glad that I could share some of the things that I’ve learned with such a great group of people.
Everyone at CONDG was very welcoming, [...]

July 24th, 2009 | Tags: , , , , , , | Category: Code, SQL Server, syndication | Leave a comment

From Tables to Objects: Resources

Here are the slides and sample code from my recent presentation “From Tables to Objects” that I gave at the Central Ohio .NET Developer Group.
To those who did not attend, you can skip the rest of this post unless you want some NHibernate and SQL Server resources.
NHForge – this is the project home page [...]

July 23rd, 2009 | Tags: , , , , | Category: Code, Visual Studio | Leave a comment
 
  Older Entries »