{"id":573,"date":"2007-06-19T04:03:11","date_gmt":"2007-06-19T09:03:11","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru"},"modified":"2007-06-19T04:03:15","modified_gmt":"2007-06-19T09:03:15","slug":"ask-a-sql-guru","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru","title":{"rendered":"ask a SQL guru"},"content":{"rendered":"<p>Came across <a href=\"http:\/\/www.askasqlguru.com\/\">ask a SQL guru<\/a> today. Service is run by the Microsoft DB MVP&#8217;s. You call them (via Skype), and they answer your query, via a video cast. Its quite new, hasn&#8217;t proven itself (I mean, why not just ask a forum?), and also offers itself as a video podcast. I&#8217;m thinking it can be useful for newer folk, especially if you like step-by-step instructions.<\/p>\n<p>Going by how useful the Guru Bar at the MySQL Expo 2007 was, and how easy it is to make screencasts these days, I wonder if this would be something some <a href=\"http:\/\/dev.mysql.com\/guilds\/\">guilds<\/a> members would consider in addition to the wonderful <a href=\"http:\/\/technocation.org\/index.php?option=com_content&amp;task=category&amp;sectionid=4&amp;id=13&amp;Itemid=29\">podcast<\/a> by Sheeri?<\/p>\n<p>Technorati Tags: <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/ask%20a%20sql%20guru\" rel=\"tag\">ask a sql guru<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/sql\" rel=\"tag\">sql<\/a>, <a class=\"performancingtags\" href=\"http:\/\/technorati.com\/tag\/sql%20guru\" rel=\"tag\">sql guru<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20ask%20a%20SQL%20guru&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2007%2F06%2F19%2Fask-a-sql-guru&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"b95d62830a\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-573\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-573\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-573\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Came across ask a SQL guru today. Service is run by the Microsoft DB MVP&#8217;s. You call them (via Skype), and they answer your query, via a video cast. Its quite new, hasn&#8217;t proven itself (I mean, why not just ask a forum?), and also offers itself as a video podcast. I&#8217;m thinking it can [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20ask%20a%20SQL%20guru&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2007%2F06%2F19%2Fask-a-sql-guru&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"b95d62830a\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-573\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-573\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-573\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2007\/06\/19\/ask-a-sql-guru?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[44,23],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-9f","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2280,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/optimising-sql-applications-by-using-client-side-tools-by-mark-riddoch","url_meta":{"origin":573,"position":0},"title":"Optimising SQL applications by using client side tools by Mark Riddoch","date":"5\/2\/2012","format":false,"excerpt":"Mark Riddoch of SkySQL. This was a talk about the future in general. What people would like. Etc. Not about something that exists yet, hence the sparse notes. Trace statements are good for the \"why\". You move on to the debugger, but what is a useful SQL debugger? Profilers addresses\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":440,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/11\/02\/core-data-and-mysql-as-a-data-store","url_meta":{"origin":573,"position":1},"title":"Core Data and MySQL as a data store?","date":"2\/11\/2006","format":false,"excerpt":"I've been thinking a lot about Core Data recently. It supports SQLite out of the box, and its rather scalable and fast. Main reason being sqlite3 is included on every desktop and server of OS X that has shipped since 10.4 (Tiger). It got me thinking about using MySQL as\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1464,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/04\/22\/video-interview-with-microsofts-php-evangelist","url_meta":{"origin":573,"position":2},"title":"Video: Interview with Microsoft&#8217;s PHP Evangelist","date":"22\/4\/2009","format":false,"excerpt":"I caught up with Zach Skyles Owens, a PHP Evangelist at Microsoft. If you missed the embed, watch the video. I have some sparse notes below. I learned some new things: Microsoft spends time working with the PHP community They are porting applications to work with an SQL Server backend\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2816,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/11\/mariadb-10-0-5-storage-engines-check-the-linux-packages","url_meta":{"origin":573,"position":3},"title":"MariaDB 10.0.5 storage engines &#8211; check the Linux packages","date":"11\/11\/2013","format":false,"excerpt":"Today before Ivan's tutorial, he told me that in the 10.0.5 virtual machine images he created, he couldn't find the Cassandra storage engine. I told him it had to be installed separately, and this is true - you have to install some engines separately! When you do a yum install\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":793,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/15\/services-oriented-architecture-with-php-and-mysql","url_meta":{"origin":573,"position":4},"title":"Services Oriented Architecture with PHP and MySQL","date":"15\/4\/2008","format":false,"excerpt":"Joe Stump, Lead Architect, Digg. Slides should make its way at Joe's website soon enough. Mainly works on the backend, makes sure its scalable, can all the Digg buttons be served, et al. Application layer is loosely coupled from your data. Whole point of SOA? You can put a service\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":794,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/17\/help-my-website-has-been-hacked-now-what","url_meta":{"origin":573,"position":5},"title":"Help, my website has been hacked! Now What?","date":"17\/4\/2008","format":false,"excerpt":"Eli White from Digg presented. It was an interesting talk... He covered:You are going to get hacked...- SQL injection- XSS- CSRF (cross site request forgery)- Session HijackingSlides (PDF, ODP) have SQL injection\/XSS example, with the hole, the attack, and the prevention.Technorati Tags: mysqlconf, mysql, mysqluc08, mysqluc2008, eli white, digg, hacked,\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/573"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=573"}],"version-history":[{"count":0,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/573\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=573"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}