August 2011 - Posts

• More things I learned today: EXEC AS USER on dynamic SQL

  I really liked the addition of the WITH EXECUTE AS clause when defining stored procedures and functions, to change the execution context, just for the duration of the stored procedure or function. For example: CREATE PROC SomeSchema.SomeProc WITH EXECUTE Read More... Posted Saturday, August 13, 2011 7:14 PM by Greg Low | 1 Comments

• Things I learned today: Calling a scalar UDF with EXEC

  One thing I love about T-SQL is that every day I seem to find another way to use it that wasn't immediately obvious to me. I was reading the SQL Server Denali documentation and noticed that in the definition of the EXEC command that it said you could Read More... Posted Saturday, August 13, 2011 6:52 PM by Greg Low | 2 Comments

• Setting default values for slicers in PowerPivot

  I've been doing some work with PowerPivot and SharePoint/Excel Services this week. I wanted the user interface to have slicers for: Year Month Day But I wanted the slicer to be preselected for the current month. There is no property on the slicers to Read More... Posted Thursday, August 11, 2011 2:56 PM by Greg Low | 3 Comments