Monthly Archives: December 2010

2010–Goals Review

I suppose that there is a reason that I have never posted goals in a public place before last year.  It seems like there is a lot of pressure to follow through and complete those goals.  Well, there would be … Continue reading

Posted in General Ramblings | Tagged | Leave a comment

70-451– MCITP– Designing a Transaction and Concurrency Strategy–Design The Locking Granularity Level

Requirements Design the locking granularity level.This objective may include but is not limited to: locking hints, memory consumption My Take During transactions it is important to understand the effects that the isolation level will have and the effects of this … Continue reading

Posted in SQL | Tagged , , , | 1 Comment

70-451–MCITP–Designing Programming Objects–Evaluating Special Programming Constructs

Requirements Evaluate special programming constructs.This objective may include but is not limited to: dynamic vs. prepared SQL (CREATE PROCEDURE… WITH EXECUTE AS) procedure, protecting against SQL injection My Take For this requirement we will be interested in looking at the … Continue reading

Posted in SQL | Tagged , | 1 Comment

SQL Saturday #62–Tampa 15 January 2010

I just received word that I’ll be speaking at SQL Saturday #62 in Tampa Florida on 15 January 2010.  I still don’t know exactly what topic I’ll be speaking on because the organizers have done something different… They asked for … Continue reading

Posted in General Ramblings | Tagged , | Leave a comment

70-451–MCITP–Designing Program Objects–Designing CLR Stored Procedures, Aggregates and Types

Requirements Design CLR stored procedures, aggregates, and types.This objective may include but is not limited to: assembly PERMISSION_SET, CLR vs. T-SQL, ordered vs. non-ordered, executing static methods on user-defined types, multi-parameter aggregations My Take For this bullet point it seems … Continue reading

Posted in SQL | Tagged , , , | 1 Comment

Fake New Posts on Feed

For anyone who might be watching this space through the feed, I’m sorry if you got hit with a bunch of “new” posts.  I was updating some of the tags for my old posts and didn’t realize that they would … Continue reading

Posted in Uncategorized | Leave a comment

70-451 – MCITP – Designing Programming Objects – Design Common Language Runtime (CLR) table-valued and scalar functions

Requirements Design Common Language Runtime (CLR) table-valued and scalar functions.This objective may include but is not limited to: assembly PERMISSION_SET, CLR vs. T-SQL, ordered vs. non-ordered My Take For this bullet point it seems like we should be looking at … Continue reading

Posted in SQL | Tagged , , | 2 Comments