|
||||||
|
|
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 [...] Calendar Tables are only useful if they reflect how your company evaluates its data. Therefore, any company using non-standard financial fiscal years and periods will require customization with their Calendar or Date Table. In this post, I’ll provide an example of how to do so using the M2M ERP System Database. For those who don’t [...] 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 [...] Note: This is the last in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. I can haz assimilation? We are Borg – Bringing it all together. Now that we understand the basics of Dimension and [...] Note: This is the fourth in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. So, we’ve covered dimension tables and how they give your data meaning. That begs the question, how do we actually [...] Note: This is the second in a series of five “lessons” which I created for SQL University on the topics of Dimensional Modeling and Data Warehousing. Click here to read the rest of the series. Creating a data warehouse is a daunting process. It’s not something you just whip out in a weekend. So, let’s [...] In this seventh article of the T-SQL Basics Series, we will be covering both the basics as well as some specific issues with SQL Joins. If you’ll recall our last lesson, we wrote a sales query for Master Po. He then requested that we add customer information to the report. Note, after receiving e-mails from [...] All of the queries we’ve looked at so far will return all of the records in a table. This isn’t very efficient. The Where clause filters records out of your result set that you do not want. For example, suppose we’re only interested in Sales Order Master records for “Acme Rockets Inc.” The following select [...] In the previous post I mentioned the use of views to simplify querying your database in general and PowerPivot in particular. What are Database Views? Views are virtual tables, which you can create with a SQL statement. Some of the advantages of using views are: Simplified Data Access – The view hides the data structure from [...] In my free time, I’ve been working on the permission problem I wrote about a few weeks ago. I’ve managed to get the permissions to output correctly and created a system to report from them in Integration and Reporting Services (more on that in a later article). I’d like your input on it before it’s [...] |
|
||||
|
Copyright © 2012 Made2Mentor - All Rights Reserved |
||||||
Popular Articles