{"id":390,"date":"2011-07-01T00:00:14","date_gmt":"2011-07-01T00:00:14","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=390"},"modified":"2024-01-06T16:55:51","modified_gmt":"2024-01-06T16:55:51","slug":"jul-2011-sql-server-crm-user-groups-%e2%80%93-combined-meeting-andy-novick","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=390","title":{"rendered":"Jul-2011 ~ SQL Server & CRM User Groups \u2013 Combined Meeting"},"content":{"rendered":"

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

 <\/p>\n

Presenter:<\/span> Andy Novick of Novick Software
\nTopic:<\/span> The Biggest Loser: Database Edition<\/p>\n

 <\/p>\n

Fat! That\u2019s how you\u2019d have to describe most databases these days. Gigabytes piled on megabytes until the terabytes add up and up. In one way, we think of disk space as cheap. After all you can go down to the local office supply store or on-line and buy a terabyte drive for less than $100. But can you really use justify that for a database? <\/p>\n

Not of you want to get the kind of performance, redundancy and disaster recovery that are demanded of today\u2019s applications, so you use a SAN, or a multi-drive array or solid-state storage and pretty soon you\u2019re spending some real money. Add it up: the san, the fiber network, SSD\u2019s, the disaster recovery system, the development system, the QA system, backup space and staff to manage it all. Pretty soon that $100 terabyte turns into around $75,000. Managing your data well can lead to savings in disk space as much as 75%. <\/p>\n

The Biggest Looser: Database Edition presentation shows you how to put your database on a diet using the features of SQL Server: \u2022Compression \u2022Filtered indexes \u2022Maintenance, REBUILD and REORGANIZE \u2022Index management: Do you really need all those indexes? \u2022Application Changes. Topics include \u2022How to calculate the storage required for each row? \u2022How to measure the actual storage of each row \u2022How to find hidden overhead such as Snapshot Isolation bytes \u2022How to recover extra space \u2022Why NOT to SHRINK your database files \u2022Why log files grow and how to keep them under control \u2022How to shrink log files the right way \u2022Rebuilding files to recover all the extra space <\/p>\n

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

Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server’s capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular “SQL Server Load-fest” event conduced in Waltham, MA. <\/p>\n

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

 <\/p>\n

Presenter:<\/span> Anne Stanton of FM Global
\nTopic:<\/span> Joining the Conversation in a world of Social Media<\/p>\n

 <\/p>\n

Everyone has heard about twitter, facebook and linkedin but how or why does one get started? <\/p>\n

Why do people care about this trend and what is really in it for you? This session is going to be focused not only on the social media tools and their potential integration to Dynamics CRM, but also on some of the business reasons why joining into the conversation can increase profits and reduce marketing costs. <\/p>\n

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

Anne Stanton has a combination of business and technical expertise. She started her career in the 80s as a programmer working with ancient languages like Fortran 77, Basic, Turbo Pascal and Cobol and then built out her expertise as a master of software applications. Mid stride in 2005, she summarized her mix of computer science and business experience by going back to school. She completed her MBA with a sub specialty in Accounting. Anne has spent twenty six years working with technology and is still very passionate about all that it can do to help businesses excel. <\/p>\n

Her recent focus has been working with the Microsoft Dynamics xRM platform and Microsoft Dynamics CRM software. She was awarded as the 7th Microsoft MVP for CRM and has a long running blog, (www.crmlady.com) and twitter feed (crmlady) on the subject. She has worked with Microsoft Dynamics CRM as a customer, partner practice leader and consultant starting with version 1.2 which was released in 2004. Anne is currently a Principal Business Analyst for FM Global in Johnston, RI.. <\/p>\n","protected":false},"excerpt":{"rendered":"

  Presenter: Andy Novick of Novick Software Topic: The Biggest Loser: Database Edition   Fat! That\u2019s how you\u2019d have to describe most databases these days. Gigabytes piled on megabytes until the terabytes add up and up. In one way, we think of disk space as cheap. After all you can go down to the local […]<\/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":[83,79,84,80,81,82,12],"class_list":["post-390","post","type-post","status-publish","format-standard","hentry","category-2011-events","tag-blogging","tag-database-compression","tag-facebook","tag-filtered-indexes","tag-rebuild-tables","tag-social-media","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/390","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=390"}],"version-history":[{"count":10,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions"}],"predecessor-version":[{"id":1162,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/390\/revisions\/1162"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}