{"id":657,"date":"2005-11-05T16:53:00","date_gmt":"2005-11-05T16:53:00","guid":{"rendered":"\/blogs\/kimberly\/post\/MSDN-Webcast-Series-Wrap-up-Resources.aspx"},"modified":"2013-01-11T23:12:44","modified_gmt":"2013-01-12T07:12:44","slug":"msdn-webcast-series-wrap-up-resources","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-series-wrap-up-resources\/","title":{"rendered":"MSDN Webcast Series Wrap-up Resources"},"content":{"rendered":"<p>\nHey there everyone! I know I still owe you a few Q&amp;A entries (for sessions 7, 8 and 9) but I wanted to get this blog entry out there so that you can play a bit with some of the resources. This series was targeted at developers but really helps to &quot;bridge the gap&quot; between development and administration by always remembering the impacts of what you implement (and techniques to help you to see if you do). More specifically, everything you do and\/or design, has the potential for a negative impact to something else &#8211; there&#39;s no free lunch, eh?\n<\/p>\n<p>\nSo, this series focused more on Scalability but always remembered the impact to availability and\/or reliability. This last session brought together the three primary areas to remember while developing a scalable and reliable architecture:\n<\/p>\n<ol>\n<li><strong>Know your data <\/strong>\n<ul>\n<li>Design for Performance &#8211; Sessions 1, 2, 3, 6, and 8<\/li>\n<\/ul>\n<\/li>\n<li><strong>Know your users <\/strong>\n<ul>\n<li>Indexing for Performance &#8211; Sessions 4, 5 and 9 <\/li>\n<li>Optimizing Procedural Code &#8211; Session 7 <\/li>\n<li>Controlling Mixed Workloads and Concurrency &#8211; Session 6<\/li>\n<\/ul>\n<\/li>\n<li><strong>Users lie<\/strong>\n<ul>\n<li>Profile &#8211; to make sure that you&#39;re tuning what&#39;s really happening as opposed to what you think was going to happen! &#8211; Session 9<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\nThis last session had some great questions and as a result, a few new resources were used. Here are a few of the things we talked about:\n<\/p>\n<p>\n<strong>Event Notifications and DDL Triggers<\/strong>\n<\/p>\n<ul>\n<li>Designing Event Notifications (<a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/udb9\/html\/17a8ebe8-82c2-4cfe-a0d0-09ae2902efa1.htm\">BOL hyperlink if SQL Server 2005 installed<\/a>)<span>\n<ul>\n<li><span>DDL Event Groups for Use with Event Notifications<\/span> (<a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/udb9\/html\/43a218ba-1c9b-43cb-bd5b-4f5957d30970.htm\">BOL hyperlink if SQL Server 2005 installed<\/a>) <\/li>\n<li><span>Trace Events for Use with Event Notifications<\/span> (<a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/udb9\/html\/ca397315-eabc-41b8-b1f6-25be181a6f5f.htm\">BOL hyperlink if SQL Server 2005 installed<\/a>)<\/li>\n<\/ul>\n<p>\t<\/span><\/li>\n<li><span>Designing DDL Triggers (<a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/udb9\/html\/ca518b24-6451-445c-952d-101fccef87fa.htm\">BOL hyperlink if SQL Server 2005 installed<\/a>)<\/span>\n<ul>\n<li><span><span>Event Groups for Use with DDL Triggers<\/span> (<a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/udb9\/html\/fb2a7bd0-2347-488c-bb75-734098050c7c.htm\">BOL hyperlink if SQL Server 2005 installed<\/a>)<\/span><\/li>\n<\/ul>\n<\/li>\n<li>Especially useful function if using DDL Triggers or Event Notifications &#8211; EVENTDATA() &#8211; see <a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/03a80e63-6f37-4b49-bf13-dc35cfe46c44.htm\">BOL<\/a><\/li>\n<\/ul>\n<p>\n<strong>DMVs<\/strong>\n<\/p>\n<ul>\n<li>Favorites &#8211; <a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/d294dd8e-82d5-4628-aa2d-e57702230613.htm\">dm_db_index_physical_stats<\/a>, <a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/eb7b58b8-3508-4114-97c2-d877bcb12964.htm\">dm_exec_query_stats<\/a>, <a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/e26f0867-9be3-4b2e-969e-7f2840230770.htm\">dm_exec_query_plan<\/a>, <a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/d06a001f-0f72-4679-bc2f-66fff7958b86.htm\">dm_db_index_usage_stats<\/a> <\/li>\n<li>In general &#8211; GREAT that these are &quot;views&quot; so that you can query them directly and push their results DIRECTLY into a temp table, even with SELECT INTO <\/li>\n<li>How can you find them: <font color=\"#0000ff\">SELECT<font color=\"#000000\"> <font color=\"#808080\">*<font color=\"#000000\"> <font color=\"#0000ff\">FROM<font color=\"#000000\"> <font color=\"#008000\">sys.system_objects <font color=\"#0000ff\">WHERE<font color=\"#000000\"> <font color=\"#0000ff\">name<font color=\"#000000\"> <font color=\"#808080\">LIKE<font color=\"#000000\"> <font color=\"#ff0000\">&#39;dm[_]%&#39; <\/li>\n<li><font color=\"#ff0000\"><font color=\"#000000\">How can you find out how to use them &#8211; start in the BOL:\n<ul>\n<li><font color=\"#ff0000\"><font color=\"#000000\"><span><a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/35a6161d-7f43-4e00-bcd3-3091f2015e90.htm\">System Views (Transact-SQL)<\/a><\/span> <\/li>\n<li><font color=\"#ff0000\"><span><font color=\"#000000\"><a href=\"ms-help:\/\/MS.SQLCC.v9\/MS.SQLSVR.v9.en\/tsqlref9\/html\/cf893ecb-0bf6-4cbf-ac00-8a1099e405b1.htm\">Dynamic Management Views and Functions<\/a><\/span><\/li>\n<\/ul>\n<p>\t<font color=\"#000000\"><span><\/p>\n<li>Use my DMObjects.sql script to better learn their input types and output columns: <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/dmobjects.sql\">DMObjects.sql (8.37 KB)<\/a><\/li>\n<p><\/span><\/li>\n<\/ul>\n<p style=\"background: white; margin: 0in 0in 0pt\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><strong>Webcast links for the entire series!<\/strong><\/span>\n<\/p>\n<blockquote dir=\"ltr\" style=\"margin-right: 0px\">\n<p>\n\t<span style=\"font-size: 11pt; color: black\">Part 1: <strong>Creating a Recoverable Database<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 1, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<br \/>\n\t<\/span><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog Entry for Part 1, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-1-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><\/span><span style=\"font-size: 11pt; color: black\">Part 2: <strong>Creating a Reliable and Automated Backup Strategy<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 2, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<br \/>\n\t<\/span><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog Entry for Part 2, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-2-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><\/span><span style=\"font-size: 11pt; color: black\">Part 3: <strong>Designing Tables that Scale, Best Practices in Data Types and Initial Table Structures<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 3, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<br \/>\n\t<\/span><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog Entry for Part 3, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-3-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Part 4: <strong>SQL Server Indexing Best Practices<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 4, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<br \/>\n\t<\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog Entries for Part 4<br \/>\n\t<\/span><span style=\"font-size: 11pt; color: black\">Resource links blog entry, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-for-resources-indexing-best-practices-part-4-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">.<br \/>\n\tQ&amp;A blog entry, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-4-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\">Part 5: <strong>SQL Server Index Defrag Best Practices<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 5, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><strong><span style=\"color: dimgray; text-decoration: none; text-underline: none\">here<\/span><\/strong><\/a>.<br \/>\n\t<\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog <\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">entry, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-5-of-10\/\"><strong><span style=\"color: dimgray; text-decoration: none; text-underline: none\">here<\/span><\/strong><\/a>.<\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Part 6: <strong>Mixed Workloads, Secondary Databases, Locking and Isolation<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 6, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<br \/>\n\t<\/span><span style=\"font-size: 11pt; color: black\">For the SQLskills Blog Entry for Part 6, click <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/msdn-webcast-qa-a-primer-to-proper-sql-server-development-part-6-of-10\/\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span><\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><span style=\"font-size: 11pt; color: black\">Part 7: <strong>Understanding Plan Caching and Optimizing Procedure Performance<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 7, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">.<\/span><\/span><\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Part 8: <strong>Data Loading and Aging Strategies &#8211; Table and Index Partitioning<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 8, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><span style=\"color: dimgray; text-decoration: none; text-underline: none\"><strong>here<\/strong><\/span><\/a>.<\/span><\/span><\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><span style=\"font-size: 11pt; color: black\">Part 9: <strong>Profiling for Better Performance<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 9, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><strong><span style=\"color: dimgray; text-decoration: none; text-underline: none\">here<\/span><\/strong><\/a>.<\/span><\/span><\/span><\/span><\/span>\n\t<\/p>\n<p>\n\t<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Part 10: <strong>Session Summary &#8211; Common Roadblocks to Scalability<br \/>\n\t<\/strong><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">For the MSDN Download for Part 10, click <a href=\"https:\/\/msevents.microsoft.com\/cui\/Error.aspx?culture=en-US&amp;ErrorMsgID=ErrorMessage.EventDoesNotExist&amp;EventID=\"><strong><span style=\"color: dimgray; text-decoration: none; text-underline: none\">here<\/span><\/strong><\/a>.<br \/>\n\t<\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Transcript can be found <a href=\"https:\/\/www.sqlskills.com\/blogs\/kimberly\/content\/binary\/20051104-msdnwebcastpart10-transcript.doc\">here<\/a>.<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span>\n\t<\/p>\n<\/blockquote>\n<p><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">So, the series comes to an end (<em>even though I still have more work to do<\/em>). I have to say that it was a lot of fun and I enjoyed everyone&#39;s questions. And \/start shameless plug here\/ starting in March, SQLskills will begin a 10-12 part series on TechNet. The series will include sessions from&nbsp;my colleague <a href=\"http:\/\/www.SQLskills.com\/blogs\/bobb\/\">Bob Beauchemin<\/a> as well as me.&nbsp;This will definitely be more Operations and DBA focused but for all of you developers &#8211; it may help you better understand the system, High Availability and a myriad of New Features in SQL Server 2005.<\/span><\/span><\/span> <\/span><\/span><\/span><\/span><\/span><\/span><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/p>\n<p style=\"background: white; margin: 0in 0in 0pt\" dir=\"ltr\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span>\n<\/p>\n<p style=\"background: white; margin: 0in 0in 0pt\" dir=\"ltr\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">I hope to see <strong>you <\/strong>there &#8211; or at least your DBA&#8230; ;-) <\/span><\/span><\/span>\n<\/p>\n<p style=\"background: white; margin: 0in 0in 0pt\" dir=\"ltr\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><\/span><\/span><\/span>\n<\/p>\n<p style=\"background: white; margin: 0in 0in 0pt\" dir=\"ltr\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Thanks again everyone,<\/span><\/span><\/span>\n<\/p>\n<p style=\"background: white; margin: 0in 0in 0pt\" dir=\"ltr\" class=\"MsoNormal\">\n<span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\"><span style=\"font-size: 11pt; color: black\">Kimberly<\/span><\/span><\/span>\n<\/p>\n<p><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hey there everyone! I know I still owe you a few Q&amp;A entries (for sessions 7, 8 and 9) but I wanted to get this blog entry out there so that you can play a bit with some of the resources. This series was targeted at developers but really helps to &quot;bridge the gap&quot; between [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,27,36,47,49,50,51,58,65,78],"tags":[],"class_list":["post-657","post","type-post","status-publish","format-standard","hentry","category-design","category-events","category-indexes","category-msdn-webcasts","category-opinions","category-optimizing-procedural-code","category-partitioning","category-resources","category-sql-server-2005","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/657","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=657"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/657\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=657"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=657"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=657"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}