ORM Research

SQL Server 2005, SQL Server 2008
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

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

SCOM Solution

SCOM
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

Performance Studio

SQL Server 2008, 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

SQL Data Generator

Tools
I just received word from Rachel Hawley over at RedGate that SQL Data Generator has been released. I've been using the beta over the last few months and I've found it incredibly useful for setting up tests and playing around with my database designs, seeing how different data loads will be distributed through the indexes, etc. It's quick to use but fairly powerful and flexible and, frankly, pretty inexpensive. I strongly recommend it.
Read More

SCOM Problem

SCOM
I'm stuck. I posted this last week on the Microsoft SCOM newsgroup, but I'm not getting any responses. On the off chance that the 5 people a day who read this site might know the answer, here's the question as posted: I'm sure this is something fundamental and simple, but I'm honestly stuck. I'm attempting to capture a new Performance Counter, Plan Cache, Cache Hit Ratio, Object Plans & SQL Plans. When I lay it out to create it, I get the attached error. I'm assuming based on the "Unknown alias" and the fact that I'm in a custom management pack, something is amiss with the Management Pack. What? Any help at all would be appreciated. Date: 3/28/2008 11:29:55 AM Application: System Center Operations Manager 2007 Application Version: 6.0.6246.0 Severity:…
Read More

New SCOM Book

SCOM
I got a new SCOM book in the mail yesterday, System Center Operations Manager Unleashed. It's friggin' huge. I've just started reading through it and it looks pretty good. So far, it's much more thorough than the only other book available for SCOM, Mastering System Center Operations Manager 2007. I'm going to ready through more of it before I post a review to Amazon. I think I'll write up a review for the PASS book reviews too. Hey, if you have time on your hands, get on over there, request a book and write up your own review.
Read More

SQL Server 2008 Free Instance

SQL Server 2008
If you don't want to risk blowing up your laptop (like I did) and you're not interested in setting up and maintaining a virtual server, but you still want to test SQL Server 2008. Then, PASS (Professional Association of SQL Server Users), Dell & MaximumASP have a solution. Just go to SQL Server Beta. You can set up a private instance and it will persist between sessions.
Read More