Patrick Wright

2005 Presentation

I did a presentation today at the Microsoft offices here in Salt lake City. It was on administration of SQL 2005. Aaron Zupancic Presented on Dev topics for SQL 2005 and Scott Golightly presented on BI. For myself and Scott the demo gods were not smiling on us. We both had some demo’s go south very quickly. None of mine seemed to work well. Which was surprising since I tested them the night before. Just goes to show you should test them 5 minutes before you go on. I also have a firm belief that Aaron paid off the Demo gods to make sure his went well. I’m not sure where he sent the check but I need to find out for my next presentation.

Overall I think it went pretty hopefully everyone learned something about 2005. I know I got information out of it and a day that you learn something is a good day.

Pat

2005 Replication error.

This was a little strange one we got in our Dev environment today. I was changing the default for a column to not allow nulls and I got this message back from S2k5

Skipping replication schema version logging since systranschemas table is not present in database 10.

This database was previously replicated but we got rid of all replication on it way before we moved it to 2005. So I was curious to find that it was talking about replication when it showed it was not replicated? I was even more surprised since the next script I had to run was removing the primary key and adding a new one with some changes. It wouldn’t allow me to do this since it said the table was replicated. After trying sp_helppublication and various other replication sprocs and looking Mgnmt studio there was nothing that said replication was there. So one of the other dba’s here tried sp_removeDBreplication on that db and that worked and then I was able to drop it. Not really sure why or what kept this replication hanging around but it was good that he was able to do that so we could get the primary key added.

Pat

DBA Toolbox

So what is needed for a DBA Toolbox to deal with all the issues that arise for Dba’s?

This is what I’ve come up with so far. If you have more suggestions I would love to hear from others to fill out the list more. I’m not trying to make the perfect list at this point just looking for a good outline to start some discussion and find other things that might come up.

Maintenance

For Performance

Updating stat’s

Reindexing/defrag

File growth Control or monitoring

Stats monitoring,

Wait stats,

Perf counters,

For Integrity

Checkdb

Hardware level checking?

For Backup/recovery

Backup schedule/Program

Restore schedule

Disaster Mode

For Connection issues

For corruption

For down server/Suspect mode issues

Best Practices

For DB Design

For Sp programming

For Hardware Design

Pat

Summary of PASS 2006.

So my pass summit didn’t go exactly as I had hoped. On Monday afternoon I ate something that didn’t agree with me at all and spent most of Tuesday very sick from it. I made it to some of the volunteer sessions but missed out on a lot. For those of you that I’m the regional mentor for I apologize I wish I could have made it to more of it. I also missed the opening reception and the Sql Server Central party which was a big bummer.

Wednesday I started to feel better but was pretty weak and didn’t dare eat much. I was very happy to accept the 2006 PASSion award Wednesday morning before the Keynote. It was a great honor thank you to all in the membership committee that voted for me. Thank you also to Rushabh who nominated me.

Of the sessions I went to during the Summit I really liked Kalen Delaney’s Session on Metadata in 2005. This was helpful to learn where 2005 is storing some of it’s information. Andrew Kelly had an great presentation on monitoring sql server and things to look for when your monitoring. I spoke with him later for a podcast also on some suggestions he had for raid and hardware configuration. I consider Andrew one of the best on the topics for hardware and raid configurations so It was great to hear him talk about it.

Overall once again I had a great PASS Conference I think for me it’s been more and more transitioned into the networking aspect of the conference and less just about the sessions. If you attend a PASS conference, your local chapter, or a Regional Event just remember to speak up and talk to the person next to you. That’s what it’s all about making those connections will serve you very well over the next years. Hell maybe you’ll even meet new friends that you’ll actually miss because you only get to see them once a year at PASS. Then again you’ll probably meet a few that you wonder if you shouldn’t return to PASS in case they are there.

Volunteer anytime you get a chance for PASS it’s a great organization and it’s all about helping people.

In case I don’t blog again before Thursday. Happy Thanksgiving Everyone!

Pat

Getting Ready For PASS

Ok So It sucks but I’m still at work at 7:00p.m. MST. Why do Finance departments never tell IT they have plans of upgrades to there Great Plains software? Then again why do IT Departments let Finance control that? J

That’s not what this blog is about right now. It’s about getting ready for the best Conference of the year. That’s right it’s time for PASS again. This year I’ve got a very busy schedule. Not to mention I haven’t even looked at the Session schedule yet.

So here’s the perspective from someone who volunteered way too much. J

Sunday and Monday are going to be time with my wife. J I can’t wait to see some of the city with just her. J

Tuesday is all day Sessions for volunteer’s I don’t even know how I’m going to make it to all of them since I belong to 3 committee’s and they are all having meetings at the same time! Tuesday evening is the opening party and the Sqlservercentral party. Which I’ll probably make some sort of appearance at. After that probably a late night at the bar with some friends!

Wednesday Doing a presentation for Red-Gate at there booth at 11:45 Stop by if you want to hear about Execution plans. Lunch with the mountain men! (You guys rock). Later in the day some Chapter committee information which I’m really looking forward to. Then late that night the Volunteer party. This alone is a good reason to volunteer for PASS last year it rocked and I had a lot of fun. Even if I did leave on the early bus. J

Thursday Some good Breakfast sessions for Mvp’s and of course Steve Ballmer’s keynote which I don’t want to miss. Then more pass meetings throughout the day. I hope to get a few sessions in there also. I hope to hit the PSS Service center also for some of there presentations and the hands on labs. Hopefully I’ll have time for this today or Friday. The night will be wrapped up with an MVP party going on.

Friday Nothing scheduled yet besides sessions. Finally a full day to take in the classes and see what is being presented. Since I haven’t looked at the session schedule yet I guess I don’t know what I’m going to yet but I plan on mapping some things out tomorrow so maybe I’ll update the blog then.

Oh and I’ll be doing interviews and podcasts throughout the conference. Look for the really big guy in the Fedora! Stop by and I’ll interview you. J

Last year I promised that I would post messages from PASS and sessions. I hold no promises this year since I plan to spend most of my nights interviewing or drinking with friends. J

Hope to see you there!

PASS Summit Session book

Well since I told myself I would blog more I better start doing it.

Someone posted a great link to the PASS book in PDF format on the PASS site. This is the one they hand out when you get there so if you want to look through it more before hand in digital format or print some of it here’s a link that will take you there.

http://www.sqlpass.org/client_files/content/PASS_OnsiteProgFINAL.pdf

pat

Blogging Again

I’m making a commitment to blog more frequently in the future!

Ok so I finally finished putting together the First Utah Code Camp. It was a lot of fun the day off. It was a lot of stress building up to it. Well worth the effort in my mind though because most everyone had a lot of good things to say. Since that’s over with now I have to focus on the next major hurdle. PASS!

That’s right PASS is just a few short weeks away and even though I’m not presenting PASS takes up much of my time. I belong to quite a few committees’ and help out with different things so I’ll be very busy this year at pass. I’ve also agreed to do a 10 minute presentation at the Red-Gate booth at 11:45 on Wednesday in the exhibit hall. It will be on Execution plans and what to look for. Real quick and simple just trying to give some good information out there. Stop by if you’re in the area!

After PASS its right back into getting ready for the next Code Camp. Which I’m working on securing the next location for. Most likely Neumont University again. Hopefully with more sponsors this time and lot’s more people!

Pat

Utah Code Camp

Utah Code Camp

October 21^st 2006

Neumont University

Salt Lake City, UT

The local .NET Users Group and SQL Server Users Group is conducting a “Code Camp” for local software programmers next month at Neumont University. The code camp follows the Code camp manifesto that it is for the community by the community and always free. We are looking forward to excellent sessions on lots of different topics.

The Saturday, October 21^st event is scheduled from 8:00 AM to 5:00 PM. The conference is free please register at www.msutahevents.com . We will have sessions for both Developers and DBA’s.

We will have a Sponsors area with lots of giveaways!

If you would like to speak or are interested in speaking Please email me at pat_wright@sqlpass.org . Or visit www.msutahevents.com for more information.

pat

Events coming up

I should really blog things in here besides just events coming up!

Just an fyi for anyone in the SLC area. We are putting on a SQL PASS Code camp on May 31^st 2006. It will be from 8-5:00 at the Ms offices. It is free and open to all. We are limiting registration to only 60 though so register quickly! The registration site is listed below. Hope to see you all there. I am still also taking speakers and sponsors if anyone is interested. Thanks!

http://utpasscodecamp.mollyguard.com

Pat

Lookup Tables Constrained

Ok I'm a DBA I don't make any mistake i'm not a developer. But I've been faced with an issue that span's both and I'm trying to help a developer figure out the best way. So if anyone has any suggestions let me know!

What were looking for is the best way to constrain drop down boxes based on there previous entries. So on a form we have 4 drop down boxes. Something like different types of service and different products within those services. We only want the products for that service not all products. So after choosing the service what's the best way to constrain the product list? There is an entry in the products table but it will be quite a few joins and i don't really want to do that everytime someone is pushing the drop down button. I thought of a table that holds pretty much all of it but i can't think of one way to still get it all in a decent speed. How about a stored proc that passes one variable then 2 then 3 and so forth and so on? That might be an option also. I haven't found a ton on the web so if anyone has suggestions let me know. Thanks

pat

SQL Server 2005 Overview - Back by Popular Demand

This was stolen from Aaron's Blog!. I am to lazy to re-type this myself! :)

Last week we had overwhelming success with our SQL Server 2005 Overview event, that people have been banging down the doors for more. By popular demand, therefore, we are pleased to invite you to a follow-up event. If you were unable to attend the first session for one reason or another and would like to attend this one, please check it out! We had a great time doing it and it was a lot of fun.

Three separate seminars are presented: SQL Server Development Platform, Business Intelligence, and Infrastructure. The event is to be held on March 9th from 9:00 AM to 5:00 PM at the Microsoft offices in the International Center.

Date / Location:

March 29th, 2006, 9:00 AM - 5:00 PM
Microsoft Corporation
123 Wright Brothers Drive, Suite 100
Salt Lake City, Utah 84116
(801) 257-6400
http://www.microsoft.com/mscorp/info/usaoffices/rockymtn/saltlakecity.mspx

Registration:

Register today at http://www.microsofttraining.com/devonsites
Class / Invitation ID: 304560

2005 SP1 CTP

http://www.microsoft.com/sql/ctp_sp1.mspx

If your playing with 2005 or thinking about it. Better go get the CTP of sp1. Of course this isn't suggested for production systems it is only a CTP. Good place to go and report bugs also is at the product feedback center.

Happy testing!

Pat

2005 Presentation

So I did an overview 2005 presentation yesterday at the Salt lake city MS offices. The slides will be posted to www.msutahevents.com. It was fun and overall I had a good time seems like most people are really interested in 2005. I was reading through the reviews and it looks like I didn’t do to bad. J I apologize to some of you who wanted more in depth on the migration and installation aspects. We were going more for an overview so I didn’t go to far in depth on that topic. Perhaps a follow up in the UG for SLC would be good.

Oh one thing I did learn from yesterday is that you can Disable a DDL trigger instead of fulling dropping it. Here’s an example from BOL

CREATE TRIGGER safety

ON DATABASE

FOR DROP_TABLE, ALTER_TABLE

PRINT 'You must disable Trigger "safety" to drop or alter tables!'

ROLLBACK;

DISABLE TRIGGER safety ON DATABASE

On a side note if you want an interesting article on something not even released yet. Check out Computerworld!

http://www.computerworld.com/softwaretopics/software/story/0,10801,109567,00.html

Thanks to Kent Tegels for finding this.

Pat

I3 Software and Performance Tuning

Has anyone out there worked with Veritas/Symantec and the I3 product? We are looking to put it in to use here and while I like the SQL Server side to it the rest of it for our environment is all looking at the performance tuning aspect for the website. Our guys here are hoping more for an Exception handling issues like what Avicode can provide. But I like the performance monitoring capabilities of I3 for the DB.

Just curious if anyone has opinions out there. It’s got a pretty hefty price tag on it also.

Any other suggestions?

Pat

SQL Cmd Issues

The script below should give you the servername for each server you connected to. But what if the second one is offline? Or perhaps you don’t have login permission to it? Then it should ignore the error and go to the third one right? No it doesn’t. For some reason on error ignore seems to do just about nothing. I’ve tried it in lots of different methods in this script and I can’t get it to ignore and keep going. Anyone else run into this?

:connect sqllaunchvpc
select srvname from master..sysservers where srvid = 0
GO

:connect sqllaunchvpc\sqldev01
:ON ERROR ignore
select srvname from master..sysservers where srvid = 0
GO

:connect sqllaunchvpc\sqldev02
:ON ERROR ignore
select srvname from master..sysservers where srvid = 0
GO

Pat