|
||||||
|
|
Last week I saw a discussion on the LinkedIn Made2Manage Group about the Pros and Cons of using SSRS vs. VFP Reporting, and it amazes me that people are still arguing about it. So, I thought I’d reaffirm a stance that I’ve had for many years, which is VFP Reporting Must Die. I’ve [...] Users typically love SQL Server Reporting Services Reports (SSRS), especially if they’re accustomed to more primitive tools such as Visual FoxPro. However, One of the biggest complaints I hear about SSRS is that users want to be able to launch it directly from their ERP, accounting, and other systems. A conventional way to do this [...] “Melodical Murray is a human musical instrument; he makes music by blowing his…blank” – Match Game In the previous article I discussed the issues when working with Null-able fields in Joins and Where clauses. This article will deal with the problems of blank values. What About Blanks? Many systems forego the use of Null-able fields, but [...] This topic has been done to death in many places, but I still get frequent questions about Null field issues in T-SQL. My purpose in this article is not to debate the definition of Null. Smarter men than I have already done so. SQL Server Books Online indicates “A value of NULL indicates that the [...] Pick Me Mr. Kotter! SQL Rally is a brand new event for this year. It’s kind of a hybrid between the PASS Summit and a SQL Saturday. It’s fairly low cost and being held May 11-13 in Orlando, Florida. Anyway, the reason for this post is completely self serving. I really want to present at [...] Ryan, Vic, and yours truly. SQL Saturday #56 BI Edition went off without a hitch last Saturday. Those who read this blog, probably remember the awesome experience I had at my first SQL Saturday. Once again, everything went wonderfully. Our event was scaled back this time which translated into fewer hassles. Microsoft and Artis [...] 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 [...] 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 [...] 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 [...] The ethics of business intelligence is a touchy subject that many people don’t want to talk about. However, more attention in the past several years has been given to this subject mostly due to ethics scandals at huge companies such as Enron, Tyco, and WorldCom. The Sarbanes-Oxley Act came about because of such [...] |
|
||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles