22Apr 2008 by Grant Fritchey No Comments

LINQ and (by extension) ORM Discussion

Object Relational Mapping
Steve Jones' editorial today was questioning the use of LINQ. His focus was on the security aspects. The discussion went past that. This is a bit of circular reference since I posted over there and linked back to my ORM Concerns post below. There are a lot of interesting points being made. Some of it, from a DBA stand-point, is quite repetitive although I'd prefer to think of it as reinforcing. Steve's editorial is worth a read and the discussion is excellent.
Read More
21Apr 2008 by Grant Fritchey No Comments

SCOM Error

Tools
We've been getting a lot of alerts saying "Performance Module could not find a performance counter." It's been making me nuts. I finally did a search on the web and found an entry over on the Operations Manager Product Team blog. It's a known issues with SP1. I'm posting this, not because I'm complaining. I'm not. SP1 solved several issues that I had and I'm very happy to have installed it. Unfortunately, it introduced problems. Just not as many as it solved.
Read More
21Apr 2008 by Grant Fritchey 2 Comments

SQL Server 2005 SP3

SQL Server
I've said it before and I'll say it again, Microsoft Connect really works. There has been a campaign going throughout the SQL Server community to get a new service pack out for SQL Server 2005. Microsoft had, at the very least, suggested that they were not going to release any more service packs for 2005. That's all changed now. I saw the announcement in Kalen Delaney's editorial from SQL Sever Magazine UPDATE. That's worth a read all on it's own. And consider this, 704 votes made this happen. That's 704 people who took the time & trouble to click their mouse a few times. If that's all it takes to influence Redmond, then you should all be over there using Connect as often as possible to get the fixes, changes or…
Read More
17Apr 2008 by Grant Fritchey 4 Comments

ORM Concerns

Object Relational Mapping
Object Relational Mapping (ORM) software is a great idea. You can't deny that the mismatch between objects and relational data has to be dealt with. Instead of all the time, money and effort being spent here, why not get a tool that does most of the work for you? But... One direction that this can lead is towards dumb databases. After all, if putting a piece of software between the object & the db makes things easier, how much easier if the db and the object look exactly the same. Ta-da! Even less code to write & maintain. Unfortunately, TANSTAAFL (There Ain't No Such Thing As A Free Lunch) still applies. What you save in initial coding you will pay for in reporting, data cleanup, integrity issues, data integration issues...…
Read More
11Apr 2008 by Grant Fritchey 5 Comments

nHibernate Database Benefits and Costs?

Object Relational Mapping, SQL Server
I posted this question over at SQL Server Central, just like my last post, I'm also posting it here. I need some help. I've been trying to research this and I can't find good, hard facts. Any help would be deeply appreciated. It looks like we might be facing a large project shifting over to using ORM methods through nHibernate. I'm trying to get a read from the database community on what exactly I should expect in terms of issues, challenges and headaches during the development process. I'm also interested in any long term maintenance issues, troubleshooting problems, etc. If your developers implemented ORM all the way down to storing object data on the database in a non-normalized/object oriented fashion, how did that affect you? Did it muck up reporting?…
Read More
09Apr 2008 by Grant Fritchey 2 Comments

ORM Research

SQL Server
I posted this over at SQL Server Central, but I thought I'd repeat the question here: I really need some help on this one. One of our development teams is looking into ORM as a way to get code out the door faster. I've been doing a bunch of research on the topic (I'll post the links below) and I've found some interesting discussions over the pluses & minuses of the methdology. There are lots of positive examples of how well it works from all the vendors of various ORM products. I can't find any concrete examples of failed projects or long term maintenance nightmares or anything else like that. Even if ORM is the greatest thing since the flush toilet, there must be failures out there. Does anyone have…
Read More
04Apr 2008 by Grant Fritchey 3 Comments

Sequel or Ess Cue Ell

Misc
It's Friday, why not a goofy post. What kind of DBA are you? Do you pronounce the bit at the beginning of SQL Server 2008 as a word, sequel, or as three letters, ess cue ell? I'm a sequel kind of guy myself for most everyday conversation. I do occasionally break it down when I need really specific clarity, but those events are rare. Anyone else?  And after you answer it here, go over to SSC and answer the question there too.
Read More
02Apr 2008 by Grant Fritchey No Comments

SCOM Solution

Tools
I had posted a problem I was having with SCOM below. I got a good answer to the problem in the Microsoft discussion group. It was a silly little thing. The "SQL" alias inside the object needed a reference placed within the Management Pack definition. I've still go so much to learn about this tool.
Read More
01Apr 2008 by Grant Fritchey 1 Comment

Performance Studio

Tools
I just found out about some new functionality coming out in SQL Server 2008 called Performance Studio. It's actually largely a framework around which you can build performance monitoring routines for an entire enterprise. This sounds terrific. I'm going to dig into a bit and make it my presentation for the Heroes {Community} Launch event at SNESSUG next week. Here's a Technet webcast on the topic. Here's a very nice blog entry over at SQLTeam (I suppose I should ad them to my blog roll) discussing the function of the Data Collector, the foundation for this new framework. Performance Studio only works with 2008 systems though, so that's something to take into account. Although I see an interview with Brad McGehee that says it's not enterprise ready. Another something to take…
Read More