|
||||||
|
|
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 [...] 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 [...] 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 [...]
Hoping to find an everlasting Gob Stopper. Last year I pined away reading all of the tweets from last year’s PASS. It was cute, but I meant what I said. I made a promise to myself that I would go to PASS 2010. Well, last night I pulled the trigger and purchased my ticket to go [...] Some DBAs would cringe at what I’m about to tell you, but I often use T-SQL to format my data prior to presenting it in a report. Many experts feel that data formatting should always be done in the presentation layer. There are a couple of reasons why I do this. I re-use as much code [...]
Devin Knight, Wes Brown, and yours truly. It’s 8:30am on SQL Saturday, and I feel like I’ve taken a two by four to the head. I’m standing outside the front of the building leading the registration team at the front tables, squinting in the sun, sweating profusely, and wondering why I feel so good about [...] I took the plunge this year and started volunteering for the North Texas SQL Server User Group. Originally I started attending because I wanted to learn more about SQL Server, but it didn’t take long before I realized that there was so much more to be gained from being there. Why should you volunteer with [...] |
|||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles