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

Archive for the ‘Visual Studio’ Category

Links for the Week of 2009.09.12

SQL Server
Optimizing Queries That Access Correlated datetime Columns DATE_CORRELATION_OPTIMIZATION is some good stuff. If you have an InvoiceDate column that happens to be close to the OrderDate column in a related table, and this setting is on, the compiler will generate what could be a much better optimization plan.
Difference between an index and a primary [...]

September 12th, 2009 | Tags: , , , , | Category: CSS, Code, SQL, SQL Server, Visual Studio, nonsense | One comment

Links for the Week – 2009.08.07

SQL Server
Commenting Your Code Do it, people. I don’t comment enough of my code, but it’s something I keep in the back of my mind all the time.
Fast Running Totals Solution With Ordered CTE I love Mladen’s solution to this particular problem. I usually would use a nasty self join or some kind of hideous [...]

August 7th, 2009 | Tags: , , | Category: Code, SQL, TFS, Visual Studio, nonsense | 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

Links for the Week of 2009.07.10

SQL Server
Object Naming Standards Scott Herbert put up an overview of the naming standards that he uses. Like the obnoxious lout that I am, I commented. The point is, of course, to use naming standards. Take a look at Scott’s for an example.
No SQL There’s a big hullabaloo going on about this whole “No SQL” [...]

July 10th, 2009 | Tags: , , , , | Category: Code, SQL, SQL Server, Visual Studio | One comment

Columbus Give Camp is Just Two Weeks Away

The Columbus Give Camp is only two weeks away but it’s still not too late for both charities and volunteers to sign up.

GiveCamp is a weekend-long event where software developers, designers, and database administrators donate their time to create custom software for non-profit organizations. This custom software could be a new website for the [...]

July 2nd, 2009 | Tags: , , , , , , | Category: Code, SQL, Visual Studio, sqlpass, syndication | Leave a comment
 
  Older Entries »