{"id":398,"date":"2011-08-01T00:00:37","date_gmt":"2011-08-01T00:00:37","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=398"},"modified":"2024-01-06T17:04:52","modified_gmt":"2024-01-06T17:04:52","slug":"aug-2011-double-feature-john-miner-grant-fritchey","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=398","title":{"rendered":"Aug-2011 ~ Double Feature ~ John Miner & Grant Fritchey"},"content":{"rendered":"

\"\"<\/a><\/p>\n

 <\/p>\n

Presenter:<\/span> John Miner of Sensata Technologies
\nTopic:<\/span> Working with bit patterns<\/p>\n

 <\/p>\n

In today\u2019s manufacturing environment, production lines are automated with robotics and sensors. Many of these low end microprocessors and\/or integrated circuits are designed for specific tasks such as temperature and pressure control. <\/p>\n

This presentation will review how to store the memory buffer in a table and use a view to interpret the results. <\/p>\n

The following topics will be presented with examples. <\/p>\n

1. Using the VARBINARY data type to store the bit pattern.
\n2. Storing a version number just in-case the decode changes.
\n3. Breaking the pattern into registers and nibbles.
\n4. Left shifting of the bits.
\n5. Right shifting of the bits.
\n6. Combining bits from two registers.
\n7. Putting it all together with a view. <\/p>\n

Managing your data well can lead to savings in disk space as much as 75%. <\/p>\n

Biography:<\/span><\/p>\n

John Miner (www.craftydba.com) has twenty years of data processing and proven project management experience, specializing in the banking, health care, and government areas. His architecture expertise encompasses all phases of the project life cycle, including design, development, implementation, and maintenance. His credentials include a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA). <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Presenter:<\/span> Grant Fritchey of Red Gate
\nTopic:<\/span> Seven Different Solutions for Bad Parameter Sniffing<\/p>\n

 <\/p>\n

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. <\/p>\n

In this session we\u2019ll gain an understanding of what exactly parameter sniffing is and why it\u2019s usually so helpful. Then, we\u2019ll explore how parameter sniffing can go wrong and I\u2019ll show you seven different ways you can deal with it when it does. <\/p>\n

You\u2019ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment. Everyone has heard about twitter, facebook and linkedin but how or why does one get started? <\/p>\n

Biography:<\/span><\/p>\n

Grant Fritchey has twenty+ years experience in IT. That time was spent in technical support, development and database administration. He works for Red Gate Software as a Product Evangelist and writes articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. He has published two books, \u201cUnderstanding SQL Server Execution Plans\u201d and \u201cSQL Server 2008 Query Performance Tuning Distilled.\u201d He is one of the founding officers of the Southern New England SQL Server Users Group and its current president and works on part-time, short-term, off-site consulting contracts. <\/p>\n","protected":false},"excerpt":{"rendered":"

  Presenter: John Miner of Sensata Technologies Topic: Working with bit patterns   In today\u2019s manufacturing environment, production lines are automated with robotics and sensors. Many of these low end microprocessors and\/or integrated circuits are designed for specific tasks such as temperature and pressure control. This presentation will review how to store the memory buffer […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[187],"tags":[85,6,86,88,12,87],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-2011-events","tag-bit-patterns","tag-dba","tag-mathematics","tag-parameter-sniffing","tag-sql-server","tag-varbinary"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=398"}],"version-history":[{"count":6,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":1161,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions\/1161"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}