19Feb 2010 by Grant Fritchey 11 Comments

So You Want to Write a Book?

Misc
What the heck is wrong with you? Still interested? Fine. I'll tell you my take on this whole business. I'm only an expert on this if you take the adage that the expert is the guy that's a page head of you in reading a book. To date I have published two full books and three chapters in a third. I can easily think of enough people who all have more experience than that with book writing that I'd have to take off both shoes to count them all. Is anyone still reading? Cool. So you have the desire to write a book? Let me pop your first bubble. You will make very little money. This bears repeating. You will make very little money. If you were to figure out your hourly…
Read More
15Feb 2010 by Grant Fritchey 4 Comments

nHibernate Database, First Look

nHibernate
I'm getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I'd share my initial impressions. I'll be capturing trace events from the database over the next couple of weeks, so I'll be following up on the behavior of nHibernate within this database as well. The first thing I saw & thought was, "Foreign key constraints. Thank the gods." That really is good news. I was frankly concerned that they might go with the "let the code handle it" approach. There are quite a few null columns. I'm also seeing tons & tons of nvarchar(255) which must the default string size. Lots of bit fields too. They also used bigint in a lot of places too. None of this is definitively good or bad,…
Read More
01Feb 2010 by Grant Fritchey 4 Comments

SQL Saturday #34 Wrap-up

PASS
Whew! It's over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed out our online registrations at 500, an accomplishment by itself. During registration on the day of the event, we  shut down registration and just started waving people through the door at 300. Our best guess at the total attendance was 340 (not the 375 I tweeted during the delirium of the day). There were a couple of minor glitches and one major one. The major glitch was not enough vegetarian food. We just ran out. Everyone else seemed to get a meal. We had just a few, read that 3 or 4, sandwhiches at the end of the day. I want to personally thank Adam Machanic for all the…
Read More
27Jan 2010 by Grant Fritchey 8 Comments

SQL Saturday #34

PASS
The event is this Saturday. Take a look at our sponsors, speakers and the program. It's going to be a great opportunity to learn about SQL Server and things around SQL Server. If you're in the New England area, please register and take advantage of this excellent event. 450 of your peers are already pledging to show up. This is going to be a good time for networking too.
Read More
25Jan 2010 by Grant Fritchey 3 Comments

A Call to Arms

SQL Server, T-SQL
Phil Factor's most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer's spiffy new outfit... well, it's not exactly there. That's why he looks so nekkid. But seriously, the very idea of naming objects inside of the database with Hungarian-style notation really should end. Phil's right. There's absolutely no reason why you should name a unique index ixuTableName when UniqueTableName or TableNameUnique would do the job just as well and not be nearly as obscure. I confess to using this type of naming convention all the time, but I'm realizing that I don't need it and it's largely just habit. There are possible exceptions, for instance you want to group all lookup tables in your database so you name them lkTableName, but…
Read More
21Jan 2010 by Grant Fritchey 2 Comments

PowerShell Script for Creating Indexes

PowerShell, SQL Server, T-SQL
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know this is problematic on multiple levels and I'm working on that too). Rather than sitting around typing this up, I decided to use PowerShell to do the work for me. I'm still very much learning how to do things in PowerShell so this took me almost as long as it would have to type them up, but now I know more than I did. Having gone through the pain of trying to find a good example on the web that did exactly what I wanted (they're out there, just hard to find), I decided I'd add this one in so the next person had at least one more source of…
Read More
18Jan 2010 by Grant Fritchey 3 Comments

What three events brought you here?

Misc
Another one of the DBA bloggers games of tag is occurring. I've been asked by Tom LaRock to answer Paul Randal's question; What three events brought you here. Well, mom was a cheerleader and dad was a football player, so... Oh, wait. I guess I misunderstood the question. He means what three events lead me to becoming a data geek. Well, that's completely different. Luckily, no (further) cheerleaders will be harmed in making this (part of the) story. Geek When I was 16 years old and Jimmy Carter was President, Radio Shack was still considered to be the place for aspiring geek wannabe's. It just so happened that I hit $500 in my bank account about the same time they started pushing this radical thing called a "personal computer." I…
Read More
18Jan 2010 by Grant Fritchey 6 Comments

Database Design Process

Misc, Tools
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked four questions about how each of us do our work: What process do you follow? How important are the business requirements? What tool do you use to create the design, do you need it to diagram, do you even care about diagrams? What's your biggest pain-point about designing? Funny enough, I haven't done a full on database design in over a year. My company just finished about 6 years of very hard-core engineering work, designing and building or redesigning and building, the majority of our data input and collection systems. Then, I was doing lots of design work. Now, we're either largely in maintenance mode for most of those systems, or the…
Read More
13Jan 2010 by Grant Fritchey No Comments

SQL Server Standard Volume 7 Issue 1

Misc
Kathi Kellenberger's fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more articles in the hopper. Keep an eye out for them. We're providing you with the best writers giving us some of their best stuff. Go and check it out. If you're not a member of SQL PASS, it's free to join, and you'll get access to this article, lots more like it, as well as other stuff.
Read More