Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2009

Maintaining Security and Performance Using Stored Procedures Part II – Signing

Well, it has been a couple of weeks since my last blog post and over a month since Maintaining Security and Performance Using Stored Procedures Part I – Using EXECUTE AS was posted, although I did spend time working on the originally unplanned follow up to that post when I…

Read more

0 comments, 690 reads

Posted in Wise Man or Wise Guy on 30 November 2009

PASS Summit 2009 – Wrap-up – What’s the Value?

I’ve already written four posts (1, 2, 3, 4) that discussed what I did at the Summit, including what I learned, now I want to discuss my thoughts on the event.

This being my first PASS Summit, I really wasn’t sure what to expect.  I… Read more

0 comments, 192 reads

Posted in Wise Man or Wise Guy on 9 November 2009

PASS Summit Day 3 – Brain on Overload

After the first 2 official days of the Summit the brain is already on overload and then the second part of the keynote by Dr. Dewitt and 45 minutes of Itzik Ben-Gan’s tips and tricks totally fried my brain.

I arrived and sat with Bob Hovious with the plan to… Read more

0 comments, 188 reads

Posted in Wise Man or Wise Guy on 7 November 2009

PASS Summit Day 2 – What More Can I Learn

I actually slept in on Wednesday until 6am.  This was a change from being wide awake at 4am.  I made my way over to the convention center and was roped into invited to an informal meeting of bloggers with Andy Warren (@sqlandy) and a member of the PASS marketing team. … Read more

0 comments, 243 reads

Posted in Wise Man or Wise Guy on 5 November 2009

Let the Learning Begin

Finally time for the sessions to begin after a day and a half in Seattle being overwhelmed by the people that I’ve had the opportunity to meet.

I started the day meeting with Mike Walsh (@mike_walsh) and Joe Webb (@joewebb) in the Sheraton living area (lobby)… Read more

0 comments, 212 reads

Posted in Wise Man or Wise Guy on 5 November 2009

My First PASS Experiences

Getting to Seattle

I started my travels to the PASS Summit at about 9:30 am (EST) on Sunday and arrived at the Sheraton in Seattle at about 6:30 pm (PST) Sunday.  It was an uneventful trip on Southwest from Orlando to Albuquerque, then on to Seattle.  On the second leg… Read more

0 comments, 229 reads

Posted in Wise Man or Wise Guy on 3 November 2009

Follow Up to Maintaining Security and Performance Using Stored Procedures Part I – Using Execute As

This is a follow up to Maintaining Security and Performance using Stored Procedures Part I – Using EXECUTE AS because of a comment on that post on the SQLServerCentral syndicated feed by Ken Lee.  He commented:

Like the technique, not the example. ISNULL() is a function, it forces the where…

Read more

0 comments, 182 reads

Posted in Wise Man or Wise Guy on 2 November 2009