Browse by Tags

• .NET
• Analysis Services
• ASSP
• best practices
• CodePlex
• DAL
• Data Architecture
• habits
• intellisense
• output
• return
• select
• T-SQL

• Bad habits to kick : using SELECT or RETURN instead of OUTPUT

  In my last post in this series , I covered the use of "bad" characters in entity names, such as spaces or dashes. In this post I will talk about using RETURN and OUTPUT inappropriately. Jamie Thomson touched on part of this pet peeve in response to one...( Read More... Posted Saturday, October 10, 2009 6:01 AM from Aaron Bertrand | (Comments Off) Filed under: best practices, select, stored procedures, habits, output, return

• SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure

  A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog Read More... Posted Thursday, July 02, 2009 7:42 AM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, .NET, ASSP, CodePlex, stored procedures

• SSAS: Executing Arbitrary SQL queries

  I had a question a little while ago via my blog about possibly using a rowset action to execute a SQL query against a specified table. Although a rowset action will allow you to enter a SQL query, such a query is still executed against the current cube Read More... Posted Thursday, June 18, 2009 11:20 PM from Darren Gosbell [MVP] - Random Procrastination | (Comments Off) Filed under: Analysis Services, .NET, ASSP, stored procedures

• Why use Stored Procedures?

  There are as many opinions for and against using stored procedures as there are database-related roles. I believe the position that is most qualified to speak to stored procedures is the data architect’s role. Data architecture is the role that studies Read More... Posted Sunday, May 10, 2009 2:57 AM from Paul Nielsen | (Comments Off) Filed under: Data Architecture, stored procedures, DAL

• My stored procedure "best practices" checklist

  When developing stored procedures, there seems to be a lot of emphasis on "get it done fast." Which means type all lower case, pay little attention to formatting, and sometimes throw best practices out the window. Personally, I would rather front-load Read More... Posted Friday, October 31, 2008 7:40 AM from Aaron Bertrand | (Comments Off) Filed under: T-SQL, best practices, intellisense, stored procedures