Presenting M-Data Analytics at Consona Connect 2010
What is M-Data Analytics and how is it going to change the way you use data?
M-Data Analytics is a Data Warehouse. A Data Warehouse is a database that is specially designed for reporting and data analysis. M2M Data is extracted, checked, cleaned, and transformed to a format which [...]
I get a ton of questions and calls about SQL Server Maintenance issues 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 perhaps outright [...]
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 [...]
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 [...]
This is the fourth of a series of articles discussing backup and recovery for M2M businesses.
Once again, I’m giving you a very high level overview of these concepts and I am not going to cover every option available, only those which are important to companies that use M2M. If you want to dig [...]
In the last article in this series, I discussed the commonly used options for Backup options and stressed that off-site backup were critical for disaster recovery. However, I also pointed out that the size of your backups combined with how many past backups you need to retain can be cost prohibitive. In this article, I’ll [...]
I regularly receive questions about backup and recovery. A particularly troubling message I received recently prompted me to create the polls on database backup and recovery. I decided to create a short series of articles on disaster recovery for the small/medium sized businesses that typically use Made2Manage. This article is a true story [...]
I’ve been speaking with a fellow M2M Admin and helping him get up to speed. I was shocked when he admitted to me that he had no backups. He explained that they were using Raid 5, and therefore didn’t need any. If you’re in this situation, don’t feel bad. Most of us work for small [...]
Unfortunately M2M does not automatically populate the Country field on many screens when a US State is selected. This can cause problems in reporting when an executive wants sales broken down by country and many of them are grouped under Null.
Anyway, if you want to see how many addresses are missing “United States” you [...]