Archive for the ‘Uncategorized’ Category

 

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

Description:

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 kevincox@microsoft.com

   

Location:

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.