(Scott Hayes) Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab.
Other News
The Case of the Missing Logical File
(Michael Sansoterra) I created a logical file that combines multiple tables into a single result set (similar to a SQL UNION.) However, when Microsoft Excel’s Query Wizard presents a list of available tables and views to query, this logical file does not show up in the list. What is the problem?
Conditional Filters in ASP.NET MVC 3
(Phil Haack) Say you want to apply an action filter to very action except one. How would you go about it? For example, suppose you want to apply an authorization filter to every action except the action that lets the user login. Seems like a pretty good idea, right?
Migrate to ASP.NET MVC 3 by leveraging your ASP.NET Web Forms skills
(Rachel Appel) Whenever a new technology or product comes onto the developer scene, people want to know how to best leverage their existing skills to work with it, and nobody wants to have to abandon existing knowledge. Making the move from Web Forms to MVC is no different. Despite the fact that Web
Performance Tips: Speed up Data Access
(Peter Vogel) I once cut the average response time for an application from more than four seconds to less than two. In another case, I reduced the runtime of a batch application from seven hours to 45 minutes. In a third case, I eliminated a problem that caused an application to run slower and slowe
IBM Cognos Proven Practices: IBM Cognos BI – Using Dimensional Functions to Determine Current Period
(Jon Appelbergh) A technique using dimensional functions to determine the current period for a multidimensional data source, OLAP or Dimensionally Modeled Relational (DMR), where the current period has not been defined in the data source itself.
Creating SQL Cubes
(Shinuraj) An OLAP (OnLine Analytical Processing) cube is a data structure that allows fast analysis of data. It can also be defined as the capability of manipulating and analyzing data from multiple perspectives. The arrangement of data into cubes overcomes some limitations of relational databases.
Change Setting for Recently Used Files in SSMS
(Jugal Shah) I noticed in SSMS that there is the ability to show recently used files. Is there a way to configure this to show more or less recently used files?
Business Rules and ETL
Business Rules and ETL As has been mentioned by others, a growing architecture is to put more business rules in a Business Layer, rather than simply relying on the database alone. A number of system requirements are driving this technique: The growth of NoSQL The growth of distributed SQL The growth of not always connected applications performing data synchronization Support […]
Where Do Business Rules Belong? Reader consensus Says In the Database
SelecTViews With Stephen Wynkoop Ryan Adams joins the show today, also information about disaster recovery and planning. Additional information on recent news, the SQL Server tip of the day and much more. [Watch the Show] Where Do Business Rules Belong? Reader consensus Says In the Database Thanks to all of you for your input on this subject. Many have written […]