|
I’ve been attending the North Texas SQL Server User Group meetings for some time and have met a lot of great SQL people in my area. Last night was especially good however, as Brian Knight of Pragmatic Works gave the presentation “Introduction to SQL Server Analysis Services.”
I’ve been studying SSAS, as well […]
Encyclopedia Brown is a character in a series of mini-mystery books written by Donald J. Sobol. I read most of these books in my formative years. The main character, Encyclopedia, is a young wiz kid who solves mysteries in his home town of Idaville. The stories typically have a factual […]
I know that the title of this article may sound ridiculous, but hear me out. My current employer purchases higher-end servers than most companies of the same size. Our IT Lead believes in overbuilding servers so that there is room for future expansion. “So where is the problem?” is probably the question […]
As I have time I will share the SQL queries derived from the more popular Made2Manage reports. After you have the SQL query, you can display it with any program you want such as Crystal Reports, ODBC Spreadsheets, or SQL Server Reporting Services.
Use the queries with caution and make sure that you always test […]
One of my users came to me with a problem last week, and it’s fairly common. They run a M2M Report that has the data they want, but when they export it, some of the data is missing.
This can happen for a couple of reasons. Tables can be added to a report layout […]
Yes, I know I eluded to this in an article several months ago, but I’m hoping one of my readers is already using this in production. I’m going to be testing this extensively for the next week to determine whether we can migrate to it.
So, are any of you using Version 5.6 […]
In an earlier article, I challenged my readers to come up with the widest variety of solutions to a problem I posed, and discuss what I thought was the best solution. I apologize that it took me so long to get back to this, but I have been ridiculously busy lately. Anyway, on […]
Your accounting manager comes to you with a problem. Being the stellar M2M Professional that you are, you immediately don your cape and tights. What? You don’t wear tights? Umm.. me neither… really…
Anyway, she explains to you that the terms, which are dictated by accounting, are being changed by […]
While I fully understand why different programming languages use different syntax, wouldn’t it be nice if they could at least agree on a comment structure?
I can’t tell you how many times I’ve typed something like this into the VBA studio:
— Make sure to declare the recordset
Code Here
/*
Comments here
*/
And of course it fails because […]
Any sufficiently advanced technology is indistinguishable from magic. – Arthur Clark
One of the factors which draws me to programming, and especially database programming, is that most people cannot understand it. To most people, computers, networks, and the internet etc quite simply work by magic. They know how to turn it on, and […]
Page 10 of 12« First«...89101112»
|
|
Recent Comments