Monthly Archives: July 2010

70-451 – MCITP – Designing Programming Objects – Stored Procedures

Requirements Design T-SQL stored procedures.This objective may include but is not limited to: execution context (EXECUTE AS), table-valued parameters, determining appropriate way to return data, WITH RECOMPILE/OPTION (RECOMPILE), error handling, TRY/CATCH My Take This section will be dealing with how … Continue reading

Posted in SQL | Tagged , , | 5 Comments

SQL Saturday #49 Orlando FL 16 October 2010

I’ll be speaking at SQL Saturday #49 in Orlando, another great event being directed by Jack Corbett (@unclebiguns) and Andy Warren (@sqlandy).  This will be my third year in a row speaking at the Orlando event, and the fourth event … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

70-451 – Designing Database Tables – Data Integrity

Requirements Design data integrity. This objective may include but is not limited to: primary key, foreign key, check constraint, default constraint, NULL/NOT NULL, unique constraint, DML triggers My Take This section appears to be all about how it is that … Continue reading

Posted in SQL | Tagged , , | 3 Comments

70 – 451 – Designing Database Tables – Design Tables

Requirements Design tables.  This objective may include but is not limited to: table width, sizing data types, IN_ROW_DATA (BLOBs), overflow data, sparse columns, computed columns, persisted computed columns My Take These requirements seem to be aimed at brining the various … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451 – Designing Database Tables – New Data Types

Requirements Identify the appropriate usage of new data types. This objective may include but is not limited to: geography, geometry, hierarchyid, date, time, datetime2, datetimeoffset, varbinary (max) filestream My Take We will need to know what the new data types … Continue reading

Posted in SQL | Tagged , , | 3 Comments

70-451 – Designing a Database Solution – Full Text Search

Requirements Design a Full-Text Search strategy.This objective may include but is not limited to: CONTAINS, CONTAINSTABLE, FREETEXT, FREETEXTTABLE My Take Perhaps I’m wrong, but this requirement sure seems to me that we are only concerned about the Querying of the … Continue reading

Posted in SQL | Tagged , , | 3 Comments

70-451 – Designing a Database Solution – Service Broker

Requirement Design a solution by using Service Broker.This objective may include but is not limited to: designing services, contracts, activation, routes, message types, queues, remote service binding, priorities My Take From the set of requirements it seems like we will … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451 – Designing a Database Solution – Application Security

Requirements Design an application strategy to support security.This objective may include but is not limited to: application roles, schema ownership, execution context, Windows vs. SQL authentication, permissions and database roles My Take We need to understand the implications of how … Continue reading

Posted in SQL | Tagged , , | 2 Comments

70-451 Designing a Database Solution – Entity Framework

Requirement Design a data model by using the Entity Framework. This objective may include but is not limited to: defining and maintaining mapping (query vs. stored proc), defining a data model, entity SQL My Take Understand the basics of the … Continue reading

Posted in SQL | Tagged , | 2 Comments