Archive for the ‘Uncategorized’ Category

Over the last few weeks I have been working on a new presentation titled The Utility Database.  I can’t remember the last time that I have been this excited about a presentation.  This presentation includes information on how to use a utility database to keep a history of your server. I will help you answer questions like the average run time of your stored procedures.  We will talk about consolidating your checklists into one report so you have one reference point for each of your daily activities.

Next week on Wednesday Aug. 17th I will be presenting this session in Colorado Springs at the Colorado Springs SQL Server User Group and then the next night I will be delivering the session in Denver at the Denver SQL Server Users Group.  If you have a chance to stop by that would be great.  I will be looking for feedback to make the presentation better.    

The Colorado Springs SQL Server User Group is going to meet Wed. night, and I think it’s going to be a great session. This meeting we are going to have 5 speakers giving 5 different sessions. Each of these sessions are considered lighting sessions so there should be text on the slides and it should be a quick hit for each subject. I will be speaking on the Growing Pains that I see in a database when I go into shops that are currently seeing a growth spurt. So come on down, have some fun with the group. You can find more information here


One would think that I might read the complete directions before I get all crazy and start posting things, In this case well, not so much. I think I was so excited about the last T-SQL Tuesday and was ready to do another one that I saw the question and was ready to post away. So I posed a week early, and I then deleted the post, and I will repost this on the correct day. So maybe I should really change my answer this week to… Read The $%^@! Manual Chris.




From Steve Jones about this topic:

I was giving a presentation recently and someone in the audience started to ask about why I recommended against a certain technique. Without getting into it, this person kept saying that she had to implement things her way since the “business” said they needed it done that way. However a little digging showed that the business didn’t really understand the technology. They were asking for a result, and she took them literally in how she implemented a process. A classic impedance mismatch.

I think we’ve all had situations that are similar. The business, the client, the customer, is asking for something, but they don’t know how to ask those of us building the technology. Or they don’t understand the implications of asking for something like “absolutely zero data loss” to be implemented.

The official topic this month is:

What issues have you had in interacting with the business to get your job done.


The sad part here is I don’t know where to start or where to stop.  If many of the companies that I have worked for knew what they wanted I am sure that the road would be much easier to travel.  The best example that I can give is when a Delphi programmer was assigned to a director position but kept on developing.  He then in turn hired his first DBA, and in the interview made the obvious mistake of saying he wanted a complete lock down of the database.  His exact words were, “I want a Soup Nazi, like on Seinfeld, but I want that in our database. I want a Database Nazi”.  Yet it took years before we could even start to make any changes to the security.  I had some of the developers actually get up and walk out when they were not allowed to make changes to the production database schema.  Now this may have even been somewhat acceptable, if it were a small company that could make changes at the drop of a hat.

But no…

This is a public company.  One that is still traded to this day, and to top it off that director still works there and still has access to production to make changes in the database at will.  Last I heard he was promoted to Data Architect because of his in-depth knowledge.  The operations team says he needs to develop elsewhere yet he is determined to have access and work in production.  He wants the access without the responsibility.

SQL Road Trip

Posted: September 26, 2010 in Uncategorized

Saturday September 25th I attended and helped organize a SQL Saturday in Denver, I have to say that I was really impressed with the way that the Denver User Group jumped in and made that event a huge success. I believe we had over 160 attendees and it appeared that most people were learning and networking just like any other SQL Event. This was my first official “SQL Saturday”, but I am sure there are many more to come. As a matter of fact next Saturday I will be on the road to Kansas City to attend and speak at SQL Saturday # 53, and this is where the plan started to develop….

Marc Beacom, Andrew Dykstra, Jason Horner and I are all going to take my camper and make a drive out to KC. Marc and I are planning on speaking and Andrew and Jason are attending. I think I am going to have to blog each day of the trip along with photos to share. We plan on leaving around 6:00 AM on Thursday to make sure that we have enough time to get there. When we get there we hope that Steve Jones stops by for a few beverages.

New Look

Posted: September 8, 2010 in Uncategorized

Well there is a new look to the blog, if your new please tell me what you like and well what you don’t. I do know that I am not the best person at spelling or grammar. There is a new page on the blog that you can find in the upper corner, this will show you all the SQL Events that I am aware of. If there is an even that I don’t know about please let me know. I would be more than happy to add it..

Good Week

Posted: July 19, 2010 in Uncategorized

I always forget when the user group meeting is sneaking up on me, and then at the last minute something reminds me, sometimes it really is the last minute (OK they had to call me once from the meeting). Over the past month we have had MVP’s Ben Holting, Glenn Berry, Kalen Delany and even I spoke that the local group. Just this year alone we have had over 25% of the year as MVP Speakers. Well this month is just as big. We welcome Kevin Cox from the SQL Cat team. If you don’t know who he is I recommend you come, have you ever wondered how the big SQL Server shops do it? How does Microsoft recommend the way they do it? This has got to be the session for you. There is more information on the User Group page, the event starts just before 6 to network, I hope to see you there.


Start Date:

Wednesday, July 21, 2010 

End Date:

Wednesday, July 21, 2010

Recurring Event:

One time event


What are the largest projects on SQL Server? How do they scale? How do they accomplish HA/DR? Kevin will talk about these topics at the next SQL Server Users Group meeting.


Presenter(s): Kevin Cox, Microsoft / SQL Customer Advisory Team (SQL CAT)

Kevin Cox has worked in the database field for over 30 years as DBA, author, lecturer, consultant and now Principal Program Manager on the SQL Server Customer Advisory Team. He has been fortunate to work on some of the largest database projects in the world and has become an expert in both scale up and scale out databases. He has authored a book on SQL Server and many articles for SQL Server, DBMS magazines and even the old HP3000 magazine. He has a strong application development and architecture background and was previously certified to teach Powerbuilder and Visual Basic. Kevin spent several years as a Data Center Manager during the days of large mainframes honing his mission critical skills. Kevin has an MBA degree from the University of Denver and a BS Degree from Arizona State University.  Kevin can be reached at



Ruth Holley Library


Well it has been a few years from the last time I spoke at PASS. But this year I submitted a few abstracts and was excited to learn last week that I will be presenting there in Seattle this year in November. PASS is an exciting event with a lot of get together’ s that surround it. I can’t wait to get back in the saddle and see old friends and make new ones. I have talked to a couple of other people and it sounds like it will be another good year.

I have also started working on an article series for SSWUG that will look at a number of common mistakes; we will define why they are mistakes and what the options are. I believe this is going to be a series of nine articles. The first two that I am working on is avoiding over simplified permissions by adding everyone to DBO and why people should use stored procedures.

On the SQL Perspectives blog we will be jumping into Section 3 Database Administration of the SQL Server Deep Dives book. The first chapter in this section is all about what it means to be a DBA by Brad McGehee.


In a discussion last week I had the chance to learn something new. I was moving some SQL Server accounts from one server to another. During this process I was going the long roundabout way to do this. Cynthia from the User group shared with me the sp_help_revlogin stored procedure. After doing some looking around I have found that there looks to be a couple different version of this so that it will work correctly with the system tables and or views.

The way these procedures work is to copy accounts and the passwords in an encrypted state from Point a to Point b, To include the default database. The KB articles these links point to will also give you added information about moving the logins.

If you use SQL Server 2005 as a source the procedure can be found here.

If you use SQL server 7.0 or 2000 the source procedure can be found here.

After you create the stored procedure in the master database, execute the proc and a create script will be created that you can copy from one location to another.

In My Tools Database

Posted: June 17, 2010 in Uncategorized

I have mentioned time and time again to people… when you want to learn more about SQL Server it’s time to create your own database, and now use that database to track all sort of things, like the history of your database growth, or what about the history of your jobs long term? Even the number of times your procs have been executed can be tracked in your database world, this database will help you be a better DBA. What a better way to learn then using your databases that you understand. If you don’t understand them, you will when you’re done.

With the DMV’s containing all the information about your server that most of us ask for this experience will not only provide you with awesome information but creating this on your own will help you develop your skills. So where do you start? First keep your info in there and by reading all the DMV’s that you can and use them to fill the tables. When your done it is time to add the tools that can help in you so many more places, this is where Denis Gobo chapter comes helpful in the SQL Server Deep Dives Book. Use the code, use the hints that he gives you.

The two different types of data can exist in different databases, but the thought is the same.

Thanks for the chapter Denis.

This Week’s Update

Posted: June 11, 2010 in Uncategorized

Sometimes you sit in a session and there is just so little information you will get out of the session, does that mean the session is bad? Not at all, it means that it just was not right for you. Well this week I had the opportunity to host Kalen Delaney (sponsored by Dell), in Denver for a session on SQL Server Plan Caching and Recompilation, and I can tell you that this is one of the most useful session I have had the opportunity to see in years. The information that she passed along was amazing and if it did not directly impact you are the systems you are working on it will for sure help you get an additional grasp on so many topics. For example we talked about the DMV’s to a point and how to free your proc cache. Kalen mentioned that she has a more in depth session on the same topic coming on SSWUG as a workshop. I don’t think I will miss that one. As soon as I hear the date, I will be sure to post it for ya.

UPDATE  The workshop for Kalen’s event can be found here.

So with that event over I have to look at the horizon. SQL Saturday is coming to Denver in September. I am really looking forward to that event, I am looking for speakers now, if you want to submit a session, that can be done here:

The Philadelphia SQL Server User Group, is also hosting a free on-line workshop on June 14th, along with a SQL Saturday on March 13th. The online event looks like it has some great information with the topic “Talk with SQL Server functions”