21Oct 2009 by Grant Fritchey No Comments

Birds Of a Feather Lunch

PASS
The PASS Summit agenda is shaping up and it's already looking to be much busier than last year. The latest is the Birds of a Feather lunch. It's lunch with an MVP. At least 50 different MVP's will be hosting a table each. At each table a topic of discussion will be hosted by the MVP present. It should be a lot fun. It'll be a great way to meet people and share war stories, tips, approaches, what ever. The list of topics and the MVP's leading are available here at Mike Walsh's blog. I'll be hosting a table on Team Development. I crack jokes about beating up developers, but really I see them as partners and teammates. We're all working towards a common goal, delivering the product, whatever it…
Read More
15Oct 2009 by Grant Fritchey No Comments

SQL Server Standard Update

Misc
The first article should be out within a week or so (knock wood). I hav a winner for the contest to help us pick the artwork for the cover. Leo Pasta. Congrats. Get in touch with me at: grantedd -at- gmail.com so that I can send you your prize.
Read More
14Oct 2009 by Grant Fritchey 1 Comment

SNESSUG October Meeting

PASS
The Southern New England SQL Server Users Group's October meeting was a bit sparsely attended with 7 attendees. The sponsor for the night was ApexSQL. The presenation was by AJ Dharmapuri who spoke on using DMV's. Barbara Sampson, SNESSUG Treasurer, did a demo of ApexSQL's SQLEdit. It's a pretty powerful TSQL coding and scripting tool. There's a lot of functionality that worked in a very snappy way during the demo and looked great. I may need to spend some time with their products to see if we can put them to work. As part of the sponsorship, we gave away a license for the Apex SQL Univeral Studio. Quite a prize. I was very excited to see AJ's presentation for a few reasons. First, because he presented on DMV's, based…
Read More
14Oct 2009 by Grant Fritchey No Comments

SQL Server Central Guest Editorial

Misc
My second guest editorial is up at SQL Server Central. These are fun to do (especially the video) even though they're a shocking amount of work considering their size. My hat's off to Steve for churning these out day after day. The man does earn his keep. Anyway, go on over and let me know if you have a favorite character from history that might make a good DBA.
Read More
13Oct 2009 by Grant Fritchey No Comments

Operations Manager Feedback

Tools
If you're involved with maintaining Microsoft Operations Manager, you probably have a few things you'd like to tell the developers, such as, couldn't you get some sort of override manager/explorer built into the system? Well, they've built a new feedback mechanism through the updated Connect interface. Get on over there and make your voice heard. Yeah, I wasn't really tracking it either until I saw this post from the OM development team's blog.
Read More
13Oct 2009 by Grant Fritchey 5 Comments

Table Variables Are Only in Memory: Fact or Myth

SQL Server, T-SQL
I keep seeing these concepts that have long been disproven, posted again and again on newsgroups as if they were valid information. The latest? Table variables are better because they're only in memory where as temporary tables write to the disk through tempdb. This one is abjectly wrong. I'm not even going to hedge with "it depends." From a macro point of view, there are only a few differences between temporary tables and table variables, statistics being the biggest. Temporary tables have 'em and table variables don't. Other than that, both will reside completely in memory or will swap out to the disk through tempdb, depending on their size. Some of the minor differences, and why you might want to use table variables over temporary tables, table variables won't cause a statement recompile while temporary tables will, table…
Read More
10Oct 2009 by Grant Fritchey No Comments

Another Book

Uncategorized
Well, part of one anyway. I wrote three chapters of Rob Walter's new book, Beginning SQL Server 2008 Administration. I think I've mentioned it before. Well, my copies showed up in the mail. Nothing like holding that book in your hands as proof that you've done it. When everything is electronic and we stop printing dead tree books... I don't think it's going to be nearly as satisfying to finish a book. Please, look it over. I think it's going to be a good resource for people just getting started as DBA's.
Read More
10Oct 2009 by Grant Fritchey No Comments

3 Weeks to the PASS Summit

PASS
The PASS Summit is only three weeks away and I'm getting awfully excited. It's not too late to register. Heck, you can register at the door, but you'll pay full price. If you want to save a little, use this registration code, FRP3D, and tell them you know me. They'll hook you up & you'll save $200.  If you're involved with designing, building, developing, developing against, supporting or maintaining SQL Server databases or manage any of those who do any of the above, this is where you should be for the first week of November. You're going to get great information from presentations by top experts within the SQL Server community. Speaking of community, this is one to take part in. You're going to be able to network, talk to, confer, converse…
Read More
08Oct 2009 by Grant Fritchey 2 Comments

SNESSUG September Meeting

Misc
We had a good night with 13 people attending. I ran unopposed for president of SNESSUG for my second, and final, term. We were graced with the prescence of Jeff Moden, MVP and on of the top posters over at SQL Server Central. He was just visiting. He's a great guy and I was very happy for the chance to meet him in person. Jeff is going to be at the PASS Summit this year, so you too can have a chance to meet him. The presentation was on SSAS and SSRS by Sunil Kadimdiwan. He did a full introduction of cubes from Excel to Analysis Services, all with the purpose of showing how to generate good reports using Reporting Services. Attendees were very interested in some of the security settings…
Read More
08Oct 2009 by Grant Fritchey No Comments

PASS Log Reader Awards

PASS
Brent Ozar, Andy Warren and Jeremiah Peschka have put together a blogger award called the PASS Log Reader Award. I took a couple of posts that I did in the last year and entered. No, I'm not going to say which ones and I don't expect to win because I just picked 'em up, as is, no edits and submitted. I didn't browse all my posts, I didn't rank them, rate them, or do anything else. I just picked two that seemed to describe something and describe it reasonably well. The way I look at it, win or lose, this is supporting PASS, so it's worth taking part. Plus, I like a little competition. The award will be presented at the Summit (which is only three weeks away!).
Read More