Search results matching tag 'User's Group'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=User%27s+Group&orTags=0Search results matching tag 'User's Group'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Off to Richmond for SQL Saturdayhttp://sqlblog.com/blogs/louis_davidson/archive/2015/03/13/off-to-richmond-for-sql-saturday.aspxFri, 13 Mar 2015 22:12:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:58188drsql<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3><FONT face=Calibri>I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing some work for PASS leading up to speaker submissions), that my blog didn't even show up in the blogs list on sqlblog.com. My last blog was right after PASS when I had attended the Summit from my hospital bed.<o:p></o:p></FONT></FONT></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3><FONT face=Calibri>Since then, it has been quite a bumpy road. For a person who usually travels as much as I do for fun (SQL and Disney) and work, not having left the Nashville area since vacation in September has been weird. But all sorts of stuff have gotten in the way, mostly that I just haven't felt like blogging (heck, I haven't had an entry on my simple-talk blog since then either, though a few editorials were posted on sqlservercentral.com by my editor that I wrote pre-surgery).<o:p></o:p></FONT></FONT></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3 face=Calibri>But now, finally, it is time to wake the heck up. I am leaving Nashville this Sunday, heading for a week of work in Virginia Beach, not coincidentally the same week as </FONT><A href="https://www.sqlsaturday.com/381/eventhome.aspx"><FONT color=#0563c1 size=3 face=Calibri>SQL Saturday Richmond</FONT></A><FONT size=3 face=Calibri> where I will be talking about In-Memory OLTP tables and how they affect your database design.<SPAN style="mso-spacerun:yes;">&nbsp; </SPAN>It is also pretty cool that </FONT><A href="https://twitter.com/jessicammoss"><FONT color=#0563c1 size=3 face=Calibri>Jessica Moss</FONT></A><FONT size=3 face=Calibri> will be presenting down in Virginia Beach while I am in town, so a stop at the </FONT><A href="http://hrssug.thecloudlyfe.com/"><FONT color=#0563c1 size=3 face=Calibri>Hampton Roads SQL Server User Group</FONT></A><FONT size=3><FONT face=Calibri> is definitely in order for most of the people I work with.<o:p></o:p></FONT></FONT></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3 face=Calibri>Here is the abstract for my presentation (if you want Jessica’s go </FONT><A href="http://hrssug.thecloudlyfe.com/march-meeting-2015/"><FONT color=#0563c1 size=3 face=Calibri>here</FONT></A><FONT size=3><FONT face=Calibri>):</FONT></FONT></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;">&nbsp;</P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><B style="mso-bidi-font-weight:normal;"><A href="https://www.sqlsaturday.com/viewsession.aspx?sat=381&amp;sessionid=28084"><FONT color=#0563c1 size=3 face=Calibri>How In-Memory Database Objects Affect Database Design</FONT></A><FONT size=3><FONT face=Calibri> <o:p></o:p></FONT></FONT></B></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3><FONT face=Calibri>With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.<o:p></o:p></FONT></FONT></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><o:p><FONT size=3 face=Calibri>&nbsp;</FONT></o:p></P>
<P class=MsoNormal style="MARGIN:0in 0in 8pt;"><FONT size=3 face=Calibri>Does this mean I am fully back and over my funk? Good grief, I don't know. But I have submitted for 4 other SQL Saturdays over the rest of this year, and I have projects that are just waiting for me to get started. Some days I want to just lay down and not get up until it is time to go back to bed. Others I want to write a new book, travel to the ends of the earth and talk about SQL Server. The fact is, I am taking this one task at a time, and I look forward to talking about SQL Server for you at 9:45 on the 21st of March. And when that is over, I am going to Dollywood's opening weekend and let the </FONT><A href="http://www.dollywood.com/themepark/rides/Tennessee-Tornado.aspx"><FONT color=#0563c1 size=3 face=Calibri>Tennessee Tornado</FONT></A><FONT size=3 face=Calibri> spin some sense into my head. Hope I see you there (SQL Saturday or Dollywood, either way we can have some fun!)</FONT><o:p></o:p></P>Speaking on 7/25 for the Nashville SQL Server User Group: How In-Memory Database Objects Affect Database Designhttp://sqlblog.com/blogs/louis_davidson/archive/2014/07/16/speaking-on-7-25-for-the-nashville-sql-server-user-group-how-in-memory-database-objects-affect-database-design.aspxThu, 17 Jul 2014 00:47:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54551drsql<P>So I have blogged about it, and I have prepared for it, and next Friday at lunch time I will be unveiling my new presentation. The location/other details can be found here: <A href="http://nashville.sqlpass.org/Home.aspx">http://nashville.sqlpass.org/Home.aspx</A>, but the abstract is:</P>
<P><FONT size=3>How In-Memory Database Objects Affect Database Design </FONT><FONT face=Calibri,sans-serif><BR><FONT size=3>&nbsp;&nbsp;&nbsp; </FONT></FONT><FONT face=Calibri,sans-serif><BR><FONT size=3>With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will introduce the concepts of In-Memory Database objects, discussing how the design is affected by the new technology. As a basis for the presentation,&nbsp;I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.</FONT></FONT></P>
<P><FONT face=Arial>It is not exactly what I have envisioned for the presentation for the slightly distant future, but I am pretty pleased with where it is right now. I decided that since this was such a new feature, it is very likely that people would not be well enough acquainted with the subject for me to ignore the introductory aspects. So while I originally planned to dive right in, I have added a lot of introductory material to explain the features enough first to make sure that the design aspects I will cover make sense no matter your level with the in-memory features.&nbsp; I plan to use the same format with some flexibility if I do this for a <A title="SQL Saturday" href="http://www.sqlsaturday.com/" mce_href="http://www.sqlsaturday.com ">SQL Saturday</A> later this year, and certain so when I do the presentation at <A title=Devlink href="http://www.devlink.net/" mce_href="http://www.devlink.net">Devlink</A>. Luckily at Devlink I have another 15 minutes to work with, so 15 more minutes of code comparison will hopefully fit the needs of the more programming oriented attendees at Devlink.</FONT></P>
<P>Of course, I am not done blogging about a few additional aspects I have come up with, but with a week and a half to go before I present it, more writing on the presentation has been the goal. </P>
<P>&nbsp;</P>Speaking this week at Richmond SQL Server User Grouphttp://sqlblog.com/blogs/louis_davidson/archive/2014/06/08/speaking-this-week-at-richmond-sql-server-user-group.aspxSun, 08 Jun 2014 22:55:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:54133drsql<p>Thursday night, at 6:00 (or so) I will be speaking in Richmond (<a href="http://richmondsql.org/cs2007/">http://richmondsql.org/cs2007/</a>&nbsp;), talking about How to Implement a Hierarchy using SQL Server. The abstract is:</p><p><em>One of the most common structures you will come across in the real world is a hierarchy (either a single parent "tree" or a multi-parent "graph"). Many systems will implement the obvious examples, such as a corporate managerial structure or a bill of materials. It turns out that almost any many-to-many relationship can be used as a hierarchy to find the relationship of parent rows to child rows (for example, the relationship of actors to movies they’ve been in). In this session, we’ll discuss several different implementations of hierarchies that you can use to optimize your hierarchy implementations and put into practice immediately, with ready-made T-SQL examples.</em></p><p>Hierarchies are one of my favorite "fun" topics, as they are interesting for a few reasons. First, they have very common usages that most people come across, and second, they make for fairly interesting example code and performance testing. In my slides (and downloads), I will have examples where I generate several trees, including 3400, 41000, 52000, and even a 1.2 million node tree (which, using my slightly slow generator, took like 16 hours on my i7 laptop) along with 5 rows of sales data for every root node of the tree.&nbsp;It is kind of interesting to me to see how well the different tree implementations behave using each sized tree. I may even get a chance this week to toss the tree structures into in-memory tables and check their performance (but if not, it certainly will be included in what I am going to announce in the next paragraph.)</p><p>The only downside is that (not unlike most of my presentations) I have way too much material for 1 hour (or even 2). So I will be working in the upcoming future (hopefully by Devlink) to put out my directors cut video of this and several other presentations&nbsp;I have that are just too unwieldy for a non-precon sized session.&nbsp;I will officially announce this effort soon (along with a realistic schedule!), but it has been met with many life issues. I had a few weeks set aside for this task, but the weekend I sat down to record videos, I&nbsp;got sick and have had to push things back.</p><p>However, all&nbsp;of the code will be available for download, and my email address is no secret (<a href="mailto:drsql@Hotmail.com">drsql@Hotmail.com</a>) and I am always&nbsp;happy (if&nbsp;sometimes slow) to answer questions, take criticisms,&nbsp;or paypal payments at that address, so feel free to do either with the code when it is posted at <a href="http://www.drsql.org/Pages/Presentations.aspx">http://www.drsql.org/Pages/Presentations.aspx</a>&nbsp;</p><p><br></p>A wee bit exhausted… time to reenergizehttp://sqlblog.com/blogs/louis_davidson/archive/2012/12/10/a-wee-bit-exhausted-time-to-reenergize.aspxTue, 11 Dec 2012 02:26:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:46604drsql<p>I admit it. I am tired and I have not blogged nearly enough. This has been a crazy year, with <a href="http://www.drsql.org/Pages/ProSQLServerDatabaseDesign.aspx">the book I finished writing</a>, the pre-cons I have done (teaching is NOT my primary profession so I do a lot more prep than some others probably do), lots of training on Data Warehousing topics (from Ralph Kimball, Bob Becker, and Stacia Misner, to name three of the great teachers I have had), SQL Rally, SQL PASS, SQL Saturdays and I have gotten a lot more regular with my <a href="http://www.simple-talk.com/blogs/author/2155-louis-davidson/">simple-talk blog</a> as well… Add to this the fact that my daughter added a new grandchild to the family, and my mother has started to get so weak she is starting to fall down quite often (I am writing this blog entry from a spare bedroom at my mother-in-law’s house while my mom is in rehab!) and I am getting exhausted.</p> <p>Am I whining? Probably, but it is my blog! No, seriously I figure that occasionally you have to poke your head out from under the covers and write something and this is my something until after the New Year (other than posting a few already written and edited simple-talk blogs). I am on vacation from work for 2.5 weeks, and I don’t plan to do much with this laptop of mine for those two weeks unless the spirit hits me with an idea for a blog that I just have to write, but usually most of my blogs that have any technical or artistic merit take weeks to complete.&#160; On the second of January, I hope to be back at it, analyzing my <a href="http://sqlblog.com/blogs/louis_davidson/archive/2012/01/02/2012-blog-resolutions.aspx">resolutions from last year</a>, and making good on a few of them, particularly “Blog about my other (computer) love occasionally” and review some of the gadgets I have acquired as they pertain to doing my job as a writer/data architect. (Hint: My mother-in-law does not have Internet access, so some of the devices I have here are instrumental in my ability to work untethered for weeks on end.)</p> <p>So until next year, Merry Christmas, Happy Holidays, Happy New Year!&#160; I hope your holidays are restful and fun.&#160; I know part of mine will be because I intend to replicate this picture at least one or two more times next week, hopefully with a Turkey Leg in the hand that isn’t holding the camera taking the picture (all with my Windows Phone set on Battery Saver Mode, which delightfully turns off all syncing :)</p> <p><a href="http://sqlblog.com/blogs/louis_davidson/image_48E9D397.png"><img title="image" style="border-top:0px;border-right:0px;background-image:none;border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;display:inline;padding-right:0px;" border="0" alt="image" src="http://sqlblog.com/blogs/louis_davidson/image_thumb_7282C02C.png" width="407" height="254" /></a></p>PASS Nomination Committee http://sqlblog.com/blogs/louis_davidson/archive/2012/06/13/pass-nomination-committee.aspxWed, 13 Jun 2012 14:00:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:43874drsql<p><font size="3" face="Times New Roman">
<em>Edit: Well, I didn't get elected, and at this point, seeing who won (great choices in Angela, Stephanie, and Jason) and what else I have going on between now and the end of the year (presentations, grand childen being born, etc), I couldn't be more pleased with the outcome.&nbsp; Usually the phrase "maybe next year" is cold comfort to the people who were not (as the election site so elequently uses) top vote getters, but in this case, I think we can all be happy that the top vote getters will do a great job for PASS and that we have more time to do other community activities. So, see you maybe next year.</em></font></p><p><span style="font-size:11pt;">&nbsp;-------------------------------------------</span></p><p><span style="font-size:11pt;">Starting today you can vote for your choice
for who should be on the <a href="http://www.sqlpass.org/Elections/NominationCommittee.aspx"><font color="#0000ff">Nomination
Committee for SQL PASS</font></a> (or perhaps some previous day if you aren't reading
this on the 13, and if it is after noon on the 23, well, tough). There are 12
people who are up for vote with 3 slots available so this should be fun. There
are a few people I know quite well on the list, and a few I don't really know
at all. Looking at their qualifications I think one thing stands out. You
probably can't make a bad choice. One of them is myself, and this is a job I
did once in the past, and is something I feel like I am somewhat uniquely
qualified to do from 11 years of working with PASS members and board members
alike. <o:p></o:p></span></p><p><font size="3" face="Times New Roman">
</font><span style="font-size:11pt;">The job is helping to pick who will get the
chance to run for the Board of Directors for PASS by vetting the people who
apply (according to the <a href="http://www.sqlpass.org/LinkClick.aspx?fileticket=inbos5j8Rec%3d&amp;tabid=118&amp;mid=792"><font color="#0000ff">PASS
By-Laws</font></a>, Section VIII.3, assuming I am reading it right.) So, the fact is,
your choice ought to be somewhat based on how your idea of a board member
matches up with our ideas. Of course, it will be a team effort and there is
always compromise. <o:p></o:p></span></p><p><font size="3" face="Times New Roman">
</font><span style="font-size:11pt;">So let me tell you the criteria that I
personally have always hoped to find in board members. <o:p></o:p></span></p><blockquote><p><font size="3" face="Times New Roman">
</font><em><span style="font-size:11pt;">Professional level technical skills
(primarily SQL). </span></em><span style="font-size:11pt;">The
last thing we need is people who know nothing of what we do simply trying to
make a name for themselves with the concept of a professional group like ours.
We need people that understand what it is they will be representing. They don't
have to be experts by any means, just solid skills, probably demonstrated in
the community. <o:p></o:p></span></p></blockquote><blockquote><p><font size="3" face="Times New Roman">
</font><em><span style="font-size:11pt;">Strong leadership qualifications.</span></em><span style="font-size:11pt;"> Ideally, we will get
people who have led groups of people before. Not everyone who would be a great
Board Member will live near enough to a SQL user group to be involved, so this
could mean technical management, local government, and volunteer work for
charities, church leadership, or even being a team leader. A big plus is that
the person should be able to communicate well publicly to unify the community
of PASS through the good times and the times that are opposite to the good
times. <o:p></o:p></span></p></blockquote><blockquote><p><font size="3" face="Times New Roman">
</font><em><span style="font-size:11pt;">History of volunteerism.</span></em><span style="font-size:11pt;"> Possibly just with
PASS, or possibly with some other type of organism. The person ought to know
what it means to work for not a buck. <o:p></o:p></span></p></blockquote><blockquote><p><font size="3" face="Times New Roman">
</font><em><span style="font-size:11pt;">History with PASS.</span></em><span style="font-size:11pt;"> Even if for just a
reasonably short period of time, the person should know enough about PASS that
they aren't just blindly trying to join at the top. Attendance at a conference
or two would be a good bonus so they know what it is about but not everyone can
afford to attend, even if they were comp'd the entrance fee. <o:p></o:p></span></p></blockquote><blockquote><p><font size="3" face="Times New Roman">
</font><em><span style="font-size:11pt;">Ideas on what they think PASS should be like
and how they can help get it there.</span></em><span style="font-size:11pt;"> (Perhaps) obviously we all expect that
candidates aren't just campaigning because they think it sounds cool. They have
a desire to move PASS toward some better future. <o:p></o:p></span></p></blockquote><p><font size="3" face="Times New Roman">
</font><span style="font-size:11pt;">Over the years I have put my name in the hat
a several times for the board of directors, and twice was cut by the Nomination Committee, and the one time I was a candidate I lost. The funniest part of that
year's Summit for me was that I was sincerely relieved when Kevin Kline sat me
down and told be I had lost. I did not (and still do not, really) have the
strong leadership qualifications needed to be on the Board of Directors.
However, like most any longtime volunteer, I feel like I have a solid
understanding what kind of kind of person inspires me as a volunteer. (Hence
the list!) <o:p></o:p></span></p><p><font size="3" face="Times New Roman">
</font><span style="font-size:11pt;">If you look at the 5 qualities, all of them
are solidly focused on community. If you agree with my vision of what a PASS
leader should be, vote for me. I promise to make sure the candidates are up to
the high quality that you expect. If you don't agree (or perhaps just didn't find my black and white photo to your liking), vote for someone else, everyone seems quite solid as members of this committee.&nbsp;</span></p><p><span style="font-size:11pt;">If I don't
get elected...there is less work for me to do, and I will have more time to
server PASS and the SQL Community in any other way I can. </span></p>SQL Rally Relational Database Design Pre-Con Previewhttp://sqlblog.com/blogs/louis_davidson/archive/2012/04/13/sql-rally-relational-database-design-pre-con-preview.aspxSat, 14 Apr 2012 03:58:10 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42826drsql<p>On May 9, 2012, I will be presenting a <a href="http://www.sqlpass.org/sqlrally/2012/dallas/Agenda/Session.aspx?sid=2416" target="_blank">pre-con session</a> at the <a href="http://www.sqlpass.org/sqlrally/2012/dallas/" target="_blank">SQL Rally</a> in Dallas, TX on relational database design. The fact is, database design is a topic that demands more than a simple one hour session to really do it right. So in my Relational Database Design Workshop, we will have seven times the amount of time in the typical session, giving us time to cover our topics in a bit more detail, look at a lot more designs/code, and even get some time to do some design as a group. Our topics will be: </p> <ul> <li><strong>Theory </strong>- More or less the foundational principals and processes that will presumably help you understand the &quot;why&quot; behind the rest of the material. </li> <li><strong>General Data Modeling </strong>- The basic concepts behind database design, data modeling, graphically and semantically. Terminology and concepts will be covered to make sure that when I say a word, you know what I am meaning. The field of computer science is littered with confusing terminology that needs to be made clear. </li> <li><strong>Normalization</strong> - Basically the process of making your database work well with the relational engine form both a performance and data integrity point of view. </li> <li><strong>Physical Modeling </strong>- The actual process of creating a working database by choosing proper data types, protecting the data integrity, etc. We will discuss the steps, as well as take a look at a model that is implemented. </li> <li><strong>Implementation Patterns</strong>- For the most part, the primary pattern that we use in a relational database is normalization. Database, tables and columns are rather easily mapped to requirements, and using normalization, we usually will arrive at a solution.However, there are certain types of solutions that crop up in common implementations. Examples include uniqueness, hierarchies, files, user-specified schema, data driven design, and more. </li> <li><strong>Other Miscellaneous Advice</strong> - Time permitting, I have a set of slides that cover some basic performance/security/implementation related material. </li> </ul> <p>A lot of the material/examples/demos come from my 2012 book (<a href="http://www.drsql.org/Pages/ProSQLServerDatabaseDesign.aspx" target="_blank">SQL Server 2012 Relational Database Design and Implementation</a>) that will be shipping just before the Rally, so I am making arrangements to get copies of the book for most if not all of the attendees. So the day will introduce the material to you in a rapid format, and then you can take the material home and read it again (and my email is always available for further questions on the material as well.) </p>PASS First Timer Advice–Make it worth it!http://sqlblog.com/blogs/louis_davidson/archive/2011/08/26/pass-first-timer-advice-make-it-worth-it.aspxFri, 26 Aug 2011 19:45:41 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:38081drsql<p>I have seen a lot of other people giving advice about what to do on your first trip to the SQL PASS Conference and I want to give you my two cents worth as well. Many people will be pushing the social aspects of the conference and that is excellent advice which I too will emphasize, but in my mind there is one main thing you need to do:</p> <p><strong>Make it worth it.</strong></p> <p>Someone has shelled out a pretty large sum of money to get you there, and they want to see some return on investment in order for you or your coworkers to do it again. There are far too many choices out there for training, and PASS is a great bet to really learn a breadth of information in a short amount of time. Add to that a pre-con or two and you can get some deep insight to in the short period of time.&#160; One thing that I love about it is that there are so many sessions that even after 10 years I can get some extremely deep information from super geniuses Conor Cunningham and Bob Ward (and not of the Wile E Coyote variety!) as well as some very deep information from a host of others, all on topics that I am already quite good at and still learn a very valuable thing or two (and sometimes even more). Then I can pick up get beginner and intermediate topics on stuff that I am just interested in. </p> <p>If you have problems you need solved, write them down and bring them with you. Bring your laptop with demonstrations of your problem. I know I love to help out people with design problems if they have enough information to make it easy to see what they are trying to do. The SQLCat team (<a title="http://sqlcat.com/" href="http://sqlcat.com/">http://sqlcat.com/</a>) usually has a great presence and will talk to you about problems, and there are labs to try out features that you might not usually have access to. Add to that the lounge with a bunch of current and future MVPs hanging out willing to give you some time talking about SQL Server related topics. Just don’t come to most technical sessions and expect to ask a question that takes 10 minutes of explaining and get your solution while everyone else waits… </p> <p>So take it somewhat seriously and learn something to take back to your company and show that the investment was worth it.&#160; And try not to quit and change jobs the week after the Summit, if you can. Nothing kills a training budget like people getting the feeling that they are paying their employees to go to a job fair for a week.</p> <p>Now, as long as you can make the investment pay off for whomever has paid for you to come to the Summit (even if it is you!), now have fun. There are tons of opportunities to have fun at the Summit. On the opening night we have a Quiz Bowl game where we quiz some of the smartest (goofiest) people in the SQL community on various&#160; insane topics.&#160; There is a PASS Party one night, a dinner you can <a href="http://www.sqlandy.com/index.php/2011/08/networking-dinner-at-the-pass-summit-2011/?utm_source=feedburner&amp;utm_medium=twitter&amp;utm_campaign=Feed%3A+Sqlandy+%28SQLAndy%29" target="_blank">sign up to attend</a> on Monday and if you keep your ears open, plenty of other happenings around the Summit. Right around the conference center there is a theater, numerous restaurants, an excellent arcade, so there are plenty of places around to hang out with your new PASS friends you might make. And if you take one of the shuttles to your hotel with other people, you will probably meet a few people heading to the conference right after you get off of the plane (if you don’t bump into someone on the plane!) One of the best things about attending a large conference like this is that you can meet a lot of people you probably read/watch on the Internet and find out that they are just people (albeit people who spend a good amount of free time punishing various keyboard devices a little extra).</p> <p>I said I would mention it, and social networking is a very useful tool, especially at conferences. My suggestion is to (at least a few weeks prior to the Summit,) sign up for twitter, get a twitter client and follow @sqlpass at a minimum (feel free to follow @drsql too!) Also use your twitter client (or if you refuse, a browser) to periodically watch a search of sqlpass: <a title="http://twitter.com/#!/search/sqlpass" href="http://twitter.com/#!/search/sqlpass">http://twitter.com/#!/search/sqlpass</a>. All of the twitter types will be telling everything that is going on, so if you go to a session and don’t like it, you can find out another that is good. If you want to find a group of people out one night to hang with, there is always something going on. A handy tool I have started using on my Windows Phone 7 is an app called Spout (there is an iPhone and Android version too) that lets you watch a twitter stream, twitter search, facebook account, google reader, and several others in cool looking rotating display. I used it at Devlink last week and it was cool watching what everyone was saying about stuff based on a twitter search of “devlink”. And the best part of using twitter? The friends you make at the conference go home with you and become close friends over time, sometimes even those you never even physically meet.</p> <p>In the end, you can either go to the conference, attend some sessions and go home, or…end up with a head full of knowledge, some real new friends, a host of virtual friends, and a community that you can lean on when you have needs (of course, they will lean back too.) And if you really like this conference stuff, there are lots of user groups and one day little PASS conferences all over the <strike>country</strike> world these days called <a target="_blank">SQL Saturday</a> that you can go to and see some of the same people and lots of new faces.&#160; Who knows, you might even find yourself compelled to speak at next year’s event!</p>SQLPASS Submissionshttp://sqlblog.com/blogs/louis_davidson/archive/2011/05/06/sqlpass-submissions.aspxSat, 07 May 2011 01:20:14 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:35521drsql<p>So I am a bit hesitant to post this because the past few times I have posted about something I have submitted they have failed to occur.&#160; But hey, I might as well. If I don’t I might get all 5 sessions I submitted and have to do them.. and that would be super tiring.</p> <p>So I put in 5, including a 1/2 day session and a pre-con and if I could choose only one, it would be the pre-con. Before you start thinking I am stating the obvious, I have done one pre-con by myself at the Orlando SQL Saturday last year and it was great to have enough time to actually do the topic of relational database design, including time to actually get the people in the session to create designs on their own. The 1/2 day session is intriguing. I am thinking that a 1/2 day would still give us time to do some database designs, though not likely on the whiteboard in teams. In either case, if I get to do either of these, I figure I would bring my <a href="http://www.wacom.com/en/Products/Cintiq.aspx" target="_blank">Wacom Cintiq 12x</a> monitor to interact onscreen…</p> <p>So, the sessions I submitted are, starting with the regular sessions:</p> <p><strong>Database Design Fundamentals</strong> – A session I have done quite a few times over the years, including quite a few SQL Saturdays recently with major changes to the normalization bits based on newer, friendlier example code.</p> <p><strong>Characteristics of a Great Relational Database</strong> – A new session that I have only done once for the AppDev virtual chapter. It is a basically a list of seven characteristics that make a database great, rather than just functional.</p> <p><strong>Database Structures for Programmers</strong> – A session that I am writing for Devlink this year (and probably the Nashville SQL Server User Group in July) that is probably encroaching on a few of my idol’s sessions who talk about structures.&#160; My goal in suggesting it was to branch out a bit and start talking a bit more about non-relational stuff. A great lacking I think is sessions about the physical structures, particularly at the level I tend to give talks at (which is to talk about complex subjects in less than complex manners.)&#160; A lot of developers don’t want to get so deep it gets confusing, but they do need to know about how the physical implementation of SQL Server can be manipulated for your benefit.</p> <p><strong>Database Design Patterns In Practice</strong> (1/2 day) – In this session, my goal will be to cover constraints, triggers, etc and how you can put them together to make interesting objects in your design. It will be highly interactive, more or less consisting of an overview of data protection/implementation objects, then a set of scenarios that we will implement together.</p> <p><strong>Database Design Workshop</strong> (pre-con) – This session will cover database design from the basics to actually putting it into practice. It is a bit like drinking from a firehose, but it very practical in nature as we will be looking at stuff that any person who has to do database design will do regularly.</p> <p>So there you have it. If I get even one of them I will be happy to do it. Speaking at PASS may be the most stressful of all of the speaking I do since the competition is strong, there are lots of tracks,and I have regularly been in the final slot of the conference where I probably would have been too tired to attend a session myself. If you want to get a solid idea of why this gets to me, watch for my <a href="http://www.sqlpeople.net/blogs.aspx" target="_blank">SQL People</a> entry comes up sometime this month. </p>Allen White to speak at our Nashville SQL Server User’s group April 24http://sqlblog.com/blogs/louis_davidson/archive/2009/04/17/allen-white-to-speak-at-our-nashville-sql-server-user-s-group-april-24.aspxSat, 18 Apr 2009 01:18:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13342drsql<P>I am scheduled to be the opening act, with a short 5-10 minute tip/trick session entitled “Tips – Taking Care of ‘Future You’”, and then the illustrious Allen White will take over and give a presentation on the new administration features of SQL Server 2008.&nbsp; Frankly I am glad that he is going after me, because I know he is going to be quite a bit better than me :) (This being based on what I have heard and the fact the he is a professional trainer and I am just a rank amateur!)&nbsp; </P>
<P>If you don’t know Allen, his bio is:</P>
<P><EM>Allen is a SQL Server Trainer for Scalability Experts, a leading provider of scalable solutions, training and services based on Microsoft SQL Server. He's spent over 30 years in IT, including operations, development, telecommunications, network admin and database design and administration. He's been using SQL Server since 1992 and is certified MCITP:Database Administrator, MCITP: Database Developer and MCT.&nbsp; Allen has been awarded Microsoft’s MVP Award for his work in the SQL Server community for the last two years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog at </EM><A href="http://sqlblog.com/blogs/allen_white/default.aspx"><EM>http://sqlblog.com/blogs/allen_white/default.aspx</EM></A><EM>.</EM></P>
<P>He is a great guy, and I am looking forward to getting an opportunity to hear him speak.&nbsp; He is coming to see us because he happened to be in town for the weekend to run the <A href="http://www.cmmarathon.com/home.html" target=_blank>Country Music Marathon</A>. I was going to run it, but then I realized I was going to be in Atlanta for <A href="http://www.sqlsaturday.com/" target=_blank>SQL Saturday</A>. (Okay, to be honest if you know me you would be fairly certain that I won’t even be walking 26 miles anytime soon.)</P>
<P>If you want to come out and see Allen too, we will be at Nova Copy, 15 Lindsley Ave. Nashville 37210. RSVP to Shelton Dickson (<A href="mailto:shelton@dicksonresources.com">shelton@dicksonresources.com</A>) as soon as you can if you are coming so we will know how much pizza to order.</P>
<DIV class=wlWriterHeaderFooter style="PADDING-RIGHT:0px;PADDING-LEFT:0px;PADDING-BOTTOM:0px;MARGIN:0px;PADDING-TOP:0px;">
<P><A></A></P></DIV>