|
||||||
|
|
Not My Job Experienced M2M Administrators may have noticed something consipicously absent from my article on maintenance plans. I either skipped it intentionally to make a point or forgot because I have the attention span of a gnat, I’ll let you speculate the reason amongst yourselves. As of now, all versions of Made2Manage since 3.X [...] I get a ton of questions and calls about SQL Server Maintenance questions and problems from Administrators who just want their server to work and be protected. They’re not interested in the intricate structure of a transaction log, how to use wait stats, etc. While many database administrators who read this article will disagree or [...] Last night I received a call from a independent M2M Consultant who needed help with a transaction log that was growing too large. One of the reasons I have this blog is to find others with skills which complement mine. I like to think of us as a group of rebel soldiers with various roles [...] M2M Calendar I’ve eluded to a super secret (if I told you, I’d have to kill you) project that I’ve been working on a few times recently. This poll is a part of it. I’d really like to know how many of you folks are using the M2M Production Calendar (CALNDR) to track workdays, weekdays, [...] I’ve been volunteering with my local user group for awhile, and have been preaching community on this blog. One of the best ways to get involved, and learn for that matter, is to participate in SQL Saturdays. On The Wait List Recently we decided to host a second SQL Saturday Event later this year. It [...] The Problem Yesterday I demonstrated how to use T-sql to update the Customer Table (SLCDPM) to avoid hours of manual labor. I mentioned that you should always make a backup of the table before running an update statement in case you’ve made an error. One of my readers, Kim, astutely asked me how to use [...] One of the primary values a good DBA brings a company is in automating tedious, time-consuming tasks. In my last article, I discussed the problems when adding a sales person to M2M. M2M’s standard procedure is to create a new sales person and manually re-assign every customer (over 700 of them) to the new sales [...] Recently we had a salesperson leave our company and they were subequently replaced. I was asked to add the new salesperson and to transfer all of the outgoing person’s accounts to the new guy. So, I fired up the Salesperson (SLPN) screen and added the new salesperson. This was an internal promotion so I used the [...] In the past two weeks, I’ve had two separate people ask me the same question. They want to know how to decrypt the Utuser.dbf file so they can retrieve their user list from M2M. While I won’t show you how to break M2M encryption, I will give you two simple ways to get your user [...]
Dennis and I last year. “They found this growth in my jaw… referred me to an oral surgeon… Sensei, it’s cancer,” Dennis said to me. I was shocked and devastated. This one-two punch was followed by a long pause and then, “They’re going to remove a lot of my lower jaw next week…” People who [...] |
|||||
|
Copyright © 2010 Made2Mentor - All Rights Reserved |
||||||
Popular Articles