Tag Archives: 70-451

70-451–MCITP–Designing an XML Strategy–Design a Strategy to Transform XML into Relational Data

Requirements Design a strategy to transform XML into relational data.This objective may include but is not limited to: .nodes, .value, .query, XQuery and XPath My Take In this section we will investigate how we query the XML data to retrieve … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Design an XML Strategy–Design a Query Strategy by using FOR XML

Requirements Design a query strategy by using FOR XML.This objective may include but is not limited to: views, FOR XML PATH and EXPLICIT, FOR XML…TYPE My Take This section appears to be concerned with how it is that we will … Continue reading

Posted in SQL | Tagged , , | 3 Comments

70-451–MCITP–Design an XML Strategy–Design a Strategy to Query and Modify XML Data

Requirements Design a strategy to query and modify XML data.This objective may include but is not limited to: when to use appropriate XPath and XQuery expressions, .query vs. .value, XML indexes for performance, typed vs. untyped, .exist, .modify My Take … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451–MCITP–Designing an XML Strategy – Design XML Storage

Requirements Design XML storage.This objective may include but is not limited to: determining when to use XML for storage, untyped vs. typed (XML schema collection) My Take It seems to me that this section wants us to look into why … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Designing a Transaction and Concurrency Strategy–Design for Concurrency

Requirements Design for concurrency.This objective may include but is not limited to: hints, transaction isolation level, effect of database option READ_COMMITTED_SNAPSHOT, rowversion and timestamp datatypes My Take In my opinion the whole “Designing a Transaction and Concurrency Strategy” is a … Continue reading

Posted in SQL | Tagged , , , | 4 Comments

70-451–MCITP–Designing a Transaction and Concurrency Strategy–Design for Implicit and Explicit Transactions

Requirements Design for implicit and explicit transactions. This objective may include but is not limited to: nested transactions, savepoints, TRY/CATCH My Take I think that the main point here is more on what implicit and explicit transactions are than the … Continue reading

Posted in SQL | Tagged , | 2 Comments

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

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

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