{"id":633,"date":"2006-06-02T20:53:09","date_gmt":"2006-06-02T20:53:09","guid":{"rendered":"\/blogs\/kimberly\/post\/DBAs-definitely-should-NOT-read-this-blog-entry.aspx"},"modified":"2013-01-02T07:07:59","modified_gmt":"2013-01-02T15:07:59","slug":"dbas-definitely-should-not-read-this-blog-entry","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/dbas-definitely-should-not-read-this-blog-entry\/","title":{"rendered":"DBAs definitely should NOT read this blog entry&#8230;"},"content":{"rendered":"<p><P>Ha&#8230; did that get your attention? Well, what I really hope to do is make everyone aware of what&#8217;s made the Developer Community rounds this week. On Wednesday, Microsoft announced &#8220;Data Dude&#8221; (aka the Visual Studio sku for Database Developers). This was an announcement that may be glanced over by many DBAs thinking it&#8217;s just another tool for developers&#8230;what can it offer me? And, well, that&#8217;s where I think there are some VERY cool things to point out. I&#8217;ve been following Data Dude for a couple of months now (ah&#8230; a little birdy told me :) and at first I wasn&#8217;t sure how much it would impact me. However, after starting to get a better feel for their future directions, I&#8217;ve realized that even though I&#8217;m not their initial and\/or direct target audience that I&#8217;ll definitely find some great uses for their product. In fact, in getting ready for their announcement and in chatting with a few press folks, I wrote up a small amount of text. Some of this was quoted in the <a href=\"http:\/\/www.eweek.com\/c\/a\/Mobile-and-Wireless\/HP-TouchPad-Needs-68-Weeks-for-Additional-Shipments-142584\/\" class=\"broken_link\">eWeek article<\/a> here but there&#8217;s a few more things that I really think you&#8217;ll (yes, even DBAs) be interested in. This is the second half of the content that was quoted:<\/P><br \/>\n<BLOCKQUOTE dir=ltr style=\"MARGIN-RIGHT: 0px\"><br \/>\n<P><EM><FONT color=#000080>For Administration and Operations, I especially like their direction with regard to unit testing and sample data generation. I work with a myriad of customers who do not let development\/operations perform testing\/tuning on real production data (even a copy) due to data sensitivity requirements\/policies. As a result, performance testing can be horribly flawed. With the ability to generate large sample volumes of statistically &#8220;real&#8221; data, real-world tuning will be possible without compromising data sensitivity. This is the area that I&#8217;m most interested in initially but <\/FONT><FONT color=#000080>refactoring and schema comparisons are very interesting as well. One of my favorite sayings is &#8220;The sooner you start to code, the longer the program will take.&#8221; (Roy Carlson) as schema changes can be challenging at best and often things can be missed (data types, columns names, etc.). Often the changes are made on alternative systems and then they need to be integrated in &#8211; often through comparing schemas and with hand-created alteration scripts. With the ability to have intelligent refactoring, application and database logic can be fixed through a straightforward and flexible interface. This will help to minimize later errors or even harder to recognize performance problems caused by implicit conversions.<\/FONT><\/EM><\/P><br \/>\n<DIV><FONT color=#000080><EM>So, in the end, I&#8217;m not their primary target but I think I&#8217;ll probably get really into it and try to consider a variety of ways to leverage it for Operations\/Administrations teams for &#8220;after the fact&#8221; tuning cases. However, I do think teams will be even more productive if they adopt it earlier in their production lifecycle.<\/EM><\/FONT><\/DIV><\/BLOCKQUOTE><br \/>\n<DIV dir=ltr><FONT color=#000000>Now, if you&#8217;re even slightly interested. You can get a lot more information about Data Dude already. Here&#8217;s a beginning list:<\/FONT><\/DIV><br \/>\n<UL dir=ltr><br \/>\n<LI><br \/>\n<DIV><FONT color=#000080><FONT color=#000000>Microsoft Press Release:<\/FONT>&nbsp;<a href=\"http:\/\/www.microsoft.com\/en-us\/news\/press\/2006\/may06\/05-31VSDatabasePR.aspx\">Microsoft Enhances Collaboration for Database Professionals With New Addition to Visual Studio Product Line<\/a><\/FONT><\/DIV><br \/>\n<LI><br \/>\n<DIV>eChannelLine: <a href=\"http:\/\/www.echannelline.com\/usa\/brief.cfm?item=13359\" class=\"broken_link\">Microsoft adds database edition to developer tools<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>eWeek: <a href=\"http:\/\/www.eweek.com\/c\/a\/Mobile-and-Wireless\/HP-TouchPad-Needs-68-Weeks-for-Additional-Shipments-142584\/\" class=\"broken_link\">Microsoft Announces Team Development Tool for Databases<\/a>&nbsp; <\/DIV><br \/>\n<LI><br \/>\n<DIV>SpotlightingNews: <A href=\"http:\/\/www.spotlightingnews.com\/article.php?news=2346\">Microsoft Visual Studio TE To Cover Database Development<\/A><\/DIV><br \/>\n<LI><br \/>\n<DIV>Techtree India: <a href=\"http:\/\/archive.techtree.com\/techtree\/jsp\/article.jsp?article_id=73608&amp;cat_id=580\" class=\"broken_link\">Microsoft Expands Visual Studio \u201805<\/a>&nbsp;<\/DIV><br \/>\n<LI><br \/>\n<DIV>vnunet.com: <a href=\"http:\/\/www.vnunet.com\/vnunet\/news\/2157304\/microsoft-intros-visual-studio\" class=\"broken_link\">Microsoft unveils Visual Studio Team Edition for Database Pros<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>BetaNews: <a href=\"http:\/\/betanews.com\/2006\/05\/31\/visual-studio-gets-database-edition\/\" class=\"broken_link\">Visual Studio Gets Database Edition<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>ComputerWorld: <a href=\"http:\/\/www.computerworld.com\/action\/article.do?command=viewArticleBasic&amp;articleId=9000834\" class=\"broken_link\">Microsoft rolls out new tool for database developers<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>CRN: <a href=\"http:\/\/www.crn.com\/news\/channel-programs\/188700227\/microsoft-adds-database-developer-software-to-visual-studio-tools.htm\">Microsoft Adds Database Developer Software To Visual Studio Tools<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>Redmond Magazine: <a href=\"http:\/\/redmondmag.com\/articles\/2006\/05\/31\/microsoft-to-release-visual-studio-for-database-developers.aspx\" class=\"broken_link\">Microsoft To Release Visual Studio for Database Developers<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>TechTarget: <a href=\"http:\/\/searchwindevelopment.techtarget.com\/news\/1191448\/Visual-Studio-Team-System-adds-database-personality\" class=\"broken_link\">Visual Studio Team System adds database personality<\/a> <\/DIV><br \/>\n<LI><br \/>\n<DIV>CNET: <a href=\"http:\/\/news.cnet.com\/Microsofts-Visual-Studio-courts-database-pros\/2100-1012_3-6078425.html?tag=nefd.top\">Microsoft&#8217;s Visual Studio courts database pros<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>ComputerWire: <a href=\"https:\/\/www.datamonitor.com\/kc\/news_and_deals\/login\/?refURL=%2Fkc%2Fnews%5Fand%5Fdeals%2FmyTools%2Findex%2Easp%3F\">New Microsoft tools aim to unite developers and DBAs<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>InfoWorld: <a href=\"http:\/\/www.infoworld.com\/d\/developer-world\/microsoft-alm-platform-extended-bridge-gap-656\" class=\"broken_link\">Microsoft ALM platform extended to bridge gap<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>Internetnews.com: <a href=\"http:\/\/www.internetnews.com\/dev-news\/article.php\/3609971\" class=\"broken_link\">Visual Studio Adds Database Developer Support<\/a><\/DIV><br \/>\n<LI><br \/>\n<DIV>WebProNews: <a href=\"https:\/\/www.webpronews.com\/microsoft-great-plains-integrations-tips-for-developers-2004-09\" class=\"broken_link\">Visual Studio Has Database Developer Client<\/a><\/DIV><\/LI><\/UL><br \/>\n<P>And, if you&#8217;re going to be at <a href=\"http:\/\/northamerica.msteched.com\/\" class=\"broken_link\">Microsoft TechEd 2006 &#8211; in Boston<\/a> in a couple of weeks, there&#8217;s a LOT more information coming. In fact, my pre-conference workshop co-presenter <a href=\"http:\/\/www.mcwtech.com\/CS\/blogs\/brianr\/default.aspx\" class=\"broken_link\">Brian Randell<\/a> has authored some Hands-on Labs for Data Dude and those will be available in the HOL area. He&#8217;s&nbsp;on <A href=\"http:\/\/www.dotnetrocks.com\">DotNetRocks<\/A> this week (to be released on DNR&#8217;s site next Tuesday) and he&#8217;s chatted with them in the past about Virtual Server\/Virtual PC (for hours&#8230;now you know how I feel ;). Honestly though, we use VPC\/VS a lot in our HOLs and Brian is REALLY knowledgeable about how to optimize them, compact drives, etc. Anyway, here&#8217;s the <A href=\"http:\/\/www.dotnetrocks.com\/default.aspx?showID=115\">link to his last show on DNR<\/A> and here&#8217;s <a href=\"http:\/\/www.mcwtech.com\/CS\/blogs\/brianr\/archive\/2006\/05\/31\/167.aspx\" class=\"broken_link\">Brian&#8217;s blog entry on Data Dude<\/a>. And, just as a small hint&#8230; you should consider making a Sched+ for the &#8220;Live from TechEd&#8221; show from DNR. All I have to say is that it might have some great guests on it (maybe even related to Data Dude, hint, hint)!<\/P><br \/>\n<P>Now, the last thing that&#8217;s the most exciting for me to announce is that there are some new bloggers as a result of the Data Dude annoucement. FINALLY, one of my best friends &#8211; <a href=\"http:\/\/blogs.msdn.com\/b\/gertd\/\" class=\"broken_link\">Gert Drapers<\/a> &#8211; has started blogging (don&#8217;t forget his already awesome content site: <A href=\"http:\/\/www.SQLDev.Net\">http:\/\/www.SQLDev.Net<\/A>). If you&#8217;re at all interested in geeky database development stuff, <a href=\"http:\/\/blogs.msdn.com\/b\/gertd\/rss.aspx\" class=\"broken_link\">subscribe now<\/a>! And &#8211; many of his team members are great friends too (<a href=\"http:\/\/blogs.msdn.com\/b\/rwaymi\/\" class=\"broken_link\">Richard<\/a> and <a href=\"http:\/\/blogs.msdn.com\/b\/mattnunn\/\" class=\"broken_link\">Matt<\/a>!) and I&#8217;m very excited to see them blogging as well (<EM>it&#8217;s just that I&#8217;ve been begging Gert to do it for the past couple of years<\/EM> ;)). Anyway, it will be great fun watching this team grow and watching this product evolve. <\/P><br \/>\n<P>Here are the Data Dude team blogs:<\/P><br \/>\n<UL><br \/>\n<LI><a id=\"bp___v___BlogSideBar1___lcl___Categories__ctl0_Links__ctl1_Link\" href=\"http:\/\/blogs.msdn.com\/b\/gertd\/\" class=\"broken_link\">Gert Drapers&#8217; Blog<\/a><br \/>\n<LI><a id=\"bp___v___BlogSideBar1___lcl___Categories__ctl0_Links__ctl2_Link\" href=\"http:\/\/blogs.msdn.com\/b\/camerons\/\" class=\"broken_link\">Cameron Skinner&#8217;s Blog<\/a><br \/>\n<LI><a id=\"bp___v___BlogSideBar1___lcl___Categories__ctl0_Links__ctl3_Link\" href=\"http:\/\/blogs.msdn.com\/b\/rwaymi\/\" class=\"broken_link\">Richard Waymire&#8217;s Blog<\/a><br \/>\n<LI><a id=\"bp___v___BlogSideBar1___lcl___Categories__ctl0_Links__ctl4_Link\" href=\"http:\/\/blogs.msdn.com\/b\/thomas_murphys_agile_db_blog\/\" class=\"broken_link\">Thomas Murphy&#8217;s Blog<\/a><br \/>\n<LI><a id=\"bp___v___BlogSideBar1___lcl___Categories__ctl0_Links__ctl5_Link\" href=\"https:\/\/login.live.com\/login.srf?wa=wsignin1.0&amp;rpsnv=11&amp;ct=1357121420&amp;rver=6.0.5286.0&amp;wp=MBI&amp;wreply=http:%2F%2Fblogs.msdn.com%2Fb%2Ftsdatabl%2F&amp;lc=1033&amp;id=271611\">Database Professional&#8217;s Team Blog<\/a><\/LI><\/UL><br \/>\n<P>Here&#8217;s the official <a href=\"http:\/\/msdn.microsoft.com\/en-us\/vstudio\/default.aspx\">Visual Studio Team Edition for Database Professionals site<\/a>.<\/P><br \/>\n<P>The times are changing&#8230;&#8230;&#8230;&#8230;. for the better!<BR>kt<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ha&#8230; did that get your attention? Well, what I really hope to do is make everyone aware of what&#8217;s made the Developer Community rounds this week. On Wednesday, Microsoft announced &#8220;Data Dude&#8221; (aka the Visual Studio sku for Database Developers). This was an announcement that may be glanced over by many DBAs thinking it&#8217;s just [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,65,78],"tags":[],"class_list":["post-633","post","type-post","status-publish","format-standard","hentry","category-resources","category-sql-server-2005","category-tips"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/633","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=633"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/633\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}