THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

  • #SQLVacation Follow-up Resources and Contest Details

    #SQLVacation, Resources

    I've gotten lots of requests for the slide decks, scripts, and the #SQLVacation contest running through July 31st. Plus, other things to follow-up on. In order to make life easier for me, I've put all of the answers in one place on my SQL Sentry blog page. Click the link to get all of the goodies. If enough people participate, I might be able to persuade my boss to let me do this next year. So c'mon and help a brother out!

     

    #SQLVacation, The Experience

    First came the in-person #SQLVacation roadtrip.

    That Kline family won't be nearly as good at this as us Griswolds!That Kline family won't be nearly as good at this as us Griswolds!

    Two weeks riding the highways from Nashville, TN to Chicago, IL to St. Louis, MO and back.

    One thousand four hundred miles in a minivan with five women (my wife and four of our daughters).

    Eight PASS user groups. Twelve presentations. 

    Over three hundred attendees. 

    Two hundred t-shirts. 

    Eight winners of a license for Plan Explorer PRO. 

    And through it all

    ...

    ONE TOILET.

    Merry Christmas! The ... uh ... bathroom was full!Merry Christmas! The ... uh ... bathroom was full!

    If you've followed along with my blog posts, please let me know what you think. I sincerely hope you found the series to be engaging, funny, and fun. I always appreciate constructive criticism that'll help me turn misses into hits, and hits into bulls-eyes. So pass word back to me or provide a comment here. 

    Many thanks,

    -Kev 

    Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare Google Author

    Originally appearing at KevinEKline.com. 

  • Professional Developement - Digging for Gold

    Andrew Carnegie, once the wealthiest man on earth, came from humble beginnings. As a young boy, he worked a number of odd jobs. His hard work, industrious nature, and persistence eventually led him to become the largest steel manufacturer in the United States.

    Once, during an interview, Carnegie was asked how he had hired 43 millionaires. At that time, being a millionaire was very uncommon. It would be similar to a person having $25 to $30 million in today's dollars. Carnegie was quick to correct the reporter. He had hired 43 people who had become millionaires while working for him.

    The reporter then asked how Carnegie had made them millionaires. He replied that developing people is like digging for gold. You sometimes have to remove a lot of unwanted dirt before you can find the first nugget of gold. But you don't go looking for the dirt, you look for the gold.

    Read the rest of this article HERE.

    Let me know what you think! Best regards,

    -Kev 

     Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare | YouTube | Google Author

     

  • DBTA - Russian Hackers Steal 1.2b Internet Credentials: Or, Why the Heck Does this Keep Happening?!

    I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics like me), pour a second cup of coffee, and browse the local paper, The Tennessean, while I have breakfast. On the morning of August 5, I had the added pleasure of spewing said coffee and oatmeal all over my morning paper when I read the headlines: Russian gang stole 1.2 billion Net passwords.

    Scanning the article, midway through the details, I saw that the hackers used good, ol’ fashioned SQL injection attacks. They target approximately 450,000 websites from small mom-and-pop shops to the very largest company websites. A bit later, I read more online from The New York Times article where the story first broke.

    Their efforts brought in 4.5 billion records in total, each one containing a user name and password, resulting 1.2 billion unique accounts. And of those unique accounts, a little data processing found that there were about 542 million unique email address, since many people use the same user name and password on multiple accounts.

    Read the rest of this article at http://www.dbta.com/Columns/SQL-Server-Drill-Down/Russian-Hackers-Steal-12b-Internet-Credentials-Or-Why-the-Heck-Does-this-Keep-Happening!-99182.aspx

  • ICYMI - Troubleshooting SQL Performance Issues, Missing Indexes, and DROP and TRUNCATE TABLE

    Troubleshooting SQL Server CPU Performance Issues
    This outstanding article from Joe Sack ( b | t ) of SQLskills.com steps you through a methodical and insightful series of DMVs and queries that can pinpoint CPU issues on your SQL Server instances.

    Don’t just blindly create those "missing" indexes!
    Our own Aaron Bertrand ( b | t ) discusses ways to get better and more balanced information used in decisions about creating new indexes than offered as suggestions by native SQL Server tools.

    The Myth that DROP and TRUNCATE TABLE are Non-Logged
    Paul Randal ( b | t ) of SQLskills.com refutes the age-old myth that TRUNCATE TABLE and DROP are not logged operations. I love the full T-SQL reproduction of the issue so that you can see the internals in action.Troubleshooting SQL Server CPU Performance Issues

    Read more SQL Sentry happenings in our monthly eNews at: http://www.sqlsentry.com/company/more-news

  • SQLVacation Postcard Day 8: Nashville, TN

    KevinEKline.com SQLVacation Nashville Postcard


    All good things must come to an end and, after logging almost 1400 miles on the road, the #SQLVacation road trip returns to its home city - Nashville, TN, the "Music City". Eight SQL Server users groups, eight matching blog posts, two hundred t-shirts, and many hundreds of attendees later, it's time to get back home.

    Only there's one last catch for this Clark Griswold of an everyman. I have one last session to deliver, Top 10 Things Every SQL Developer Needs to Know, here at the Nashville chapter of the Professional Association for SQL Server. Our regular monthly meetings occur on the last Friday of each month from 11:30 AM - 1:00 PM. We always have lunch during the first half hour followed by the scheduled session starting at noon.

    I'm gonna deliver this session. And you're going to like it. Whether you like it or not.

    In case you're new to middle Tennessee or to the concept of user group meetings, we meet at Nova Copy which is located at 15 Lindsley Avenue, Nashville, TN 37210. Y'all come on down, y'hear! (As an aside, Nashville has recently started a Business Intelligence User group.  More details can be found here: http://nashbi.sqlpass.org/).

    KevinEKline.com SQLVacation Walley World Entrance Flags from 1983

     Don't forget that #SQLVacation is more than just a speaking tour! Click on the hyperlink to read the details for the summer-long SQLVacation Contest.


    Raise your hands if you want a free license for PE PRO!

    Short shorts are required to win, Clark.

    Your participation on Twitter, Facebook and other social media gets you an entry. One in every twenty-five entries wins! Winners get courier bags, licenses to Plan Explorer Pro, and other goodies.

    Now keep in mind that Nashville is my town. I love this city. And I love this user group. The current leadership of the Nashville chapter is composed of Louis Davidson, Robert Verell, Jim Houchin, and long-time logistics boss Shelton Dickson. Louis and Robert have kindly stepped up to tell us about their experiences, their user group, and their (our) city.

    louis davidsonLouis Davidson

    • When did you begin your professional career? In around 1990, I was going to college and was offered an LAN Admin position. After a year of climbing under desks to check to see if the computer was plugged in, a programming job opened up writing/editing nearly 1000 (poorly written before and after I started) queries and stored procedures. I was hooked, but I knew I could do better... in 1992 I got my first real DB programming job and I have never looked back.
    • What’s a normal day at work like for you? It ranges from lots of meetings, trying to figure out what the users want and translate into a model/solution. The other days are spent taking that design and writing code to produce a solution. Both kinds of days have their value, I love doing design, but it is kind of awesome to see it come into a real solution. 
    • When did you come to Nashville? Around 13 years ago I moved from Virginia Beach to work with a startup. Virginia was awesome, but living in Nashville has been great with some really awesome user group co-leaders over the years (for example, a fellow named Kevin Kline was excellent to work with!) 
    • KevinEKline.com SQLVacation Ryman_AuditoriumWhen and why did you decide to help as a volunteer leader? Four or five years ago, several local MVPs resurrected the local user group, as we were all involved pretty heavily in PASS, along with a local recruiter (Shelton Dickson). The leadership has changed, but we haven't really missed a beat with new leaders stepping in. The best part of the experience is the camaraderie of the people who have been in the membership\leadership, as well as some of the stuff that I have learned in the meetings over the years.
    • What is the IT community like in Nashville? Very robust. We regularly have 40+ at our group meetings, which we usually hold on the last Friday of the month. Our biggest constituency seems to be healthcare and insurance, but I feel like there are a lot of other industries out there as well. 
    • What do you like about your Nashville? What you recommend someone do there, if they came to town on their own #sqlvacation? Music, music, music, and hot chicken. You can't go anywhere in Nashville and surrounding counties without running into live music of some sort. From huge names in our arenas, to historic medium-sized venues like the Ryman Auditorium or the Schremmerhorn Symphony Center, to small venues like the Franklin Theater, and even lots and lots of restaurants and tiny establishments. Hot Chicken is fried chicken that, KevinEKline.com SQLVacation Princes Hot Chicken Shackby itself is magnificent, but it has been painted with an oil and pepper concoction that, if you choose hot enough, can melt your face (and then you will want to do it again the next day). You know a food is worth trying when it's named after a city, and you've got to check out Nashville-style "Hot Chicken". Prince's Hot Chicken Shack, Bolton's, Hattie B's, 400 Degrees, and Chef Big Shake's are all my favorites, but there are others. It is a taste that is uniquely Nashville and it is amazing. Of course, there is great history in the area with lots of civil war historical sites, wonderful lakes, and some really great shopping around (antique and new!), so you can keep yourself busy when you aren't sitting behind a keyboard. 
    • What do you and your family enjoy doing in Nashville? See what I recommend people do here :). Hot Chicken and a concert... hands down my favorite think to do any night of the week.

    robert verellRobert Verell

    • When did you begin your professional career?  I started my IT and professional career in 2004 as an implementation specialist for a mortgage software vendor. My first dive into SQL Server was installing 2000 to work as the backend for my company's application on my work laptop that I used as a sandbox and to learn how to install the application. I had absolutely no idea what I was doing with the database engine install. 
    • What’s a normal day at work like for you? Even though I'm a DBA, I'm actually doing a lot of development currently.  I am working on my parent company Cigna's internal cloud project where they are doing database as a service for SQL Server.  It poses challenges from a security, monitoring, and space allocation standpoint.  For the Cigna subsidiary I've been with for 4 years, I'm also working on a standard automated install process so we aren't clicking next and taking 4-6 hours doing installations.  We do a lot of installs every year and the automation will hopefully free up a good bit of our time. 
    • KevinEKline.com SQLVacation Nashville ParthenonWhen did you come to Nashville? I came to Nashville in 2000 in an attempt to become a rock star with my rock band, Project Jones; I played bass and quit the band after 8 months living up here, but I enjoyed the city so much I stuck around and did everything I could to not run back home to Mississippi with my tail between my legs. I got into bartending and went to school at Middle Tennessee, where I graduated in a few years. 
    • When and why did you decide to help as a volunteer leader? I guess I have always enjoyed teaching and sharing knowledge; when I learned about the user group itself, it sounded right up my alley.  I wanted to help out in any way I could.  When I learned there was a leadership position open and that I was invited to join, I absolutely wanted to get involved at that level.  I have good mentors and fellow leaders for the user group, yourself included that certainly make getting involved exciting.  The best experience I probably had is over the last 2 weeks...I've secured a *very* good speaker for July from out of town. 
    • KevinEKline.com SQLVacation broadway-street-nashville-brian-jannsenWhat is your experience with the IT community like in Nashville? Nashville is very heavy on Microsoft technologies I've found.  Jokingly, one person called the IT in our town very "inbred".  I tend to agree with this a good bit...everyone I meet is either working for or used to work for a list of about 10 companies.  I think some folks are playing bingo on the side, trying to fill up the whole card, and not just one row if you know what I mean. I don't mean that in a bad way though!  The Nashville SQL Server User Group is very heavy on healthcare as it comprises much of IT in town. (Ed. - In fact, Nashville is trying to brand itself as the "Silicon Valley of Healthcare IT"! There are dozens of Health IT startups in the city). 
    • What do you like about Nashville? What you recommend someone do there, if they came to town on their own #sqlvacation? This is a blog post in of itself!  I enjoy the people, the cost of living, the weather, and the lack of natural threats.  If someone were to vacation here, for day stuff I'd recommend The Parthenon, The Frist, Cheekwood, and maybe a bike trip down the Natchez Trace.  For nighttime, Printer's Alley, Broadway, and a spectator sporting event are good options.  Regarding the latter, we have lots of college sports and pro sports year round.  A day trip to the Jack Daniel's distillery isn't a bad option either.KevinEKline.com SQLVacation NashvilleFunForFamilies.com Logo
    • What do you and your family enjoy doing in your city? I have a 20 month old and one on the way, so my options usually are centered around kids these days, but the zoo is very underrated here. We also are big fans of the parks around the city, and shopping in the cool springs and green hills areas always make for a good afternoon. (Ed. - full disclosure: my spouse is one of the publishers and bloggers on NashvilleFunForFamilies.com -Kev).

    You can tell that Louis and Robert both love their home city. And so do I! I hope you'll come visit us if you ever have the chance to come to Music City!

    And don't forget to get involved in the #SQLVacation Contest!

    Enjoy!

    -Kevin

    -Follow me on Twitter!

    -Google Author

  • SQLVacation Postcard Day 7: Evansville, IN

    KevinEKline.com SQLVacation Evansville postcard

    Our long #SQLVacation is nearly at an end because our stop in Evansville, IN is our last roadtrip location for the family and the penultimate (i.e., second to last) technical session of the journey. It's a bittersweet, but a joy to have the family with me while I work these long days and late nights.

    Evansville is such a beautiful place that it was name La Belle Riviere ("The Beautiful River") by the early French trappers who were the first Europeans to explore the river valley. Today, the city is the commercial and cultural hub of the "entire tri-state area!". (I can't help but say that in the voice of Dr. Doofenshmirtz from the TV show Phineas and Ferb).

    KevinEKline.com SQLVacation WallyWorld01

    KevinEKline.com SQLVacation Wally World 02

    The Evansville SQL Server users group meets monthly in the Evansville Central Library (in Browning Room B), 200 SE Martin Luther King Jr Blvd, Evansville, IN 47713. If you're planning to attend, be sure to register HERE so the organizers can get a proper headcount for the lunch. I'll be delivering two sessions at this event: SQL Server Internals & Architecture and Ten Query Tuning Techniques Every SQL Developer Should Know. You can download the slide decks from SlideShare.Net.

    The user group is led by Edward Rhoades, an enterprise DBA and all-around Renaissance Man of IT. Let's get to know a little more about Evansville, the user group, and its hardworking volunteers:

    • Evansville CMOEWhen did you begin your professional career? I began my professional career as a retail manager. After about 10 years of retail manager, I decided to go back to college to get a degree in Information Technology. After I had a job as a developer post college, I got a job as a DBA at Atlas World Group about 4 years ago. I was mentored by a great bunch of SQL DBAs there and I owe them a lot as they were my first #sqlfamily. Even though I have shifted a tad in focus from DBA to developer to IT Manager, I still am a DBA.
    • What’s a normal day at work like for you? My work life is stretched supporting a lot of different kinds of technology. One hour, I could be writing a Reporting Services report. And then the next hour I could be troubleshooting an Active Directory issue. And then I could be meeting with a customer to talk with them about their EDI requirements. This is a big difference from when I was a production DBA.  I do miss those days of getting knee deep with SQL Server internals and performance tuning. 
    • Evansville-museum-immersive-theaterWhen did you come to Evansville? I have lived here most of my life. For about 10-15 years, I was living in different areas of the country and living abroad in Scotland. But I've gravitated back Evansville. It's where family lives and since family is important to me and my wife, we like living here.
    • When and why did you decide to help as a volunteer leader? A year or so ago, the previous leader came to me and had asked if I would like to take on a leadership role. I said sure. But I didn't know at the time that my role would morph into becoming one of the co-leaders of the group. There are multiple positive experiences about being a volunteer leader. I would have to say that at the top of the list for me is that I get to collaborate with some great people who are working on some cool things here in Evansville. Both of the other co-leaders of our group are awesome to work with and we're lucky to have them.
    • Eveansville Mesker ZooWhat is the IT community like there? Our IT community is small but we've attracted some great minds to work here. We continually look for opportunities to engage people to attend one of the several user group meetings here. We have active PowerShell, .NET,  SharePoint user groups that are focused to provide their membership quality education and networking opportunities in our IT community. I love the PASS community! Last year was the first time I attended the PASS Summit and I really enjoyed meeting a lot of people who I see on twitter all of the time. I hope that everyone from our user group could get the opportunity to experience the #sqlfamily like I have. My goal with our group is for every member to feel like they are a part of the #sqlfamily We're always looking for speakers, members, and sponsors for our group.
    • Evansville LST1What do you like about Evansville? What you recommend someone do there, if they came to town on their own #sqlvacation? For historical buffs like myself, our city is rich with culture and history. We have lots of museums, like the Children's Museum of Evansville (CMOE), the Evansville Museum, the LST 325 Navy Ship, Willard Library, and the Reitz Historic Home. We also have a vast list of unique restaurants and micropubs for people to experience. Check out directory of activities at http://www.celebrateevansville.com/ for a great look at all our city has to offer. 
    • What do you and your family enjoy doing in your city? We are big fans of taking advantage of a lot of the cool things in our downtown area. We are big fans of the museums and historical places in Evansville, the cool Children’s Museum, and the Evansville Museum. We also have a 7 mile greenway space which runs along the Ohio river that is great for running, walking or biking on. We also like to see an occasional baseball game at historic Bosse Field.

    To learn more about the Evansville SQL Server Users Group, follow them on Twitter at @evvpass or check out their webpage. They usually meet every third Thursday between 11:30 and 1pm at Central Library in downtown Evansville. Edward can be reached on TwitterFacebookLinkedin, and via email at ed@edwardrhoades.com. Get involved with your local chapter of PASS! You won't regret it.

    And please let me know what you think about, well, about whatever's on your mind. Inquiring minds what to know...

    Best regards,

    -Kev

    -Follow me on Twitter!

    -Google Author


  • SQLVacation Postcard Day 6: St. Louis, MO

    KevinEKline.com St Louis postcard

    The Griswolds had an experience they'll never forget in St. Louis. And we've had ours too, but in a very good way. We'd vacationed in St. Louis two years ago and had a great time. We've seen the sights, gotten the pictures, and have the t-Shirts. I still love to see the big, iconic Gateway Arch though. In fact, I'm pretty much old news in St. Louis having spoken at their SQL Server user group several times over the years.

    KevinEKline.com SQLVacation clark griswold 01

    They've set a grueling pace for me at this meeting, asking for 3 out of my 4 roadtrip presentations along with a vendor presentation to talk about SQL Sentry's tools. Here are the details:

    St. Louis SQL Server User Group Meeting
    June 23rd 1:00 pm- 4:00 pm CST, Vendor Presentation 4:15 pm- 5:00 pm
    Lync meeting at https://join.microsoft.com/meet/ehendrix/VN8FCP1Q or join by phone +13149941870 (USA, Saint Louis) English (United States), Conference ID: 41053818
    Register to attend HERE.
    Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO  63141.  Parking is in the garage behind / next to the building. There is an entrance to the building from the 2nd floor in the garage.Agenda
    12:30    Registration - Lunch Provided - Covenant Technology Partners
    13:00    (me) Ten Query Tuning Techniques Every SQL Programmer Should Know
    14:00    (me)  Top 10 DBA Mistakes on SQL Server
    15:00    (me)  End-to-End Troubleshooting Checklist for Microsoft SQL Server
    16:00    Raffle Drawing: Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/Msft Books and more!
    16:15      Vendor Presentation - Kevin Kline,  SQL Sentry
     
    I'm not exactly sure how we'll pull this off without bathroom breaks and no time for questions, since they're all 1-hour presentations. So we'll just have to play it by ear.
     
    Now, let's hear a little bit about the St. Louis SQL Server user group and their leader, Julie Bloomquist:
    • St Louis Magic HouseWhen did you begin your professional career?  I was fortunate to get a great job offer right out of college from Chevron in San Francisco.  It was my first time living outside of St. Louis and it was a wonderful experience in a fantastic city.  I started out as a programmer was promoted to a analyst.  (Ok, I’ll date myself… We all wore suits with big shoulder pads.) I’ve always worked in IT.  I first started working with SQL Server with Version 6.5 and I was thrilled when Version 7 came out with all of its improvements.
    • What’s a normal day at work like for you? I start with reflective prayer!  “Please let all last night’s backups work.” After that I take a big sigh and read through the current work tickets to decipher how many claimed emergencies are really emergencies.  Then I check emails. If yours isn’t in the top 100, you lose. Next, I scroll through my “To Do” list and try to convince myself I can actually get something checked off. Wishful thinking. Eventually I install SQL Server on new servers and configure. Test AG failover, backups jobs and restore testing. Set up new SQL Server jobs, grant permissions and general DBA activities. I’m still in a more reactive role. Unfortunately, I’m also involved with our SQL Licensing and Microsoft negotiations. Fun stuff. Oh wait, some of my “normal” days start with a 3AM wake-up call. But we’ve all been there, haven’t we!
    • When did you come to St. Louis? I’m a native St Louisian. I did an early stint in San Francisco, then came back to the Midwest to be close to family.
    • When and why did you decide to help as a volunteer leader? I was originally a DB2 DBA and a Co-Chairman of the St. Louis DB2 User Group. When I moved over to SQL Server I looked for a local chapter and discovered it was defunct. I contacted Microsoft and they assigned a SQL technical liaison to assist me with starting up the St. Louis SQL User Group.  Microsoft offered the meeting room and, at first, the speakers. They also assisted with getting the word out about the user group. That was back in 2003 and I’m still involved as a Co-Chairman. It has been a great way to meet the SQL community in the St. Louis area. We were able to get associated with PASS and broaden our groups horizons. STLSSUG grew and we spun off the St. Louis BI User Group. Where we were once quarterly meetings there is now a meeting every month, with times varying between afternoons and evenings. By creating relationships at PASS we have been able to bring in top national speakers to our local meeting. We also assist with the St. Louis SQL Saturday. Getting members involved in the group has been very rewarding.
    • st louis 10-story slideWhat is the IT community like there? Very diverse! Our members are from large and small companies. We've got members from all industries - Healthcare, Brokerage, Retail, Manufacturing, Research, Universities, Justice Department, Consulting Firms, Rental Car, Aero Space, Legal and more. 
    • What do you like about St. Louis? We have everything from A (Anheuser-Bush) to Z (one of the best rated Zoos in the country). The majority of the venues are free and it is a great place to visit even if you are on a tight budget. We also have a top symphony, huge botanical garden, first-run musical theater, great sporting events and excellent Jazz venues.
    • What you recommend someone do there, if they came to town on their own #sqlvacation? Visit Forest Park, one of the largest city parks in the nation. Within the park you can visit the Zoo, Science Center, Art Museum, History Museum or just paddle a boat around the lake and enjoy the scenery. Don’t forget to make a trip downtown to the Gateway Arch or take in a Cardinals baseball game. If you have kids, the City Museum and the Magic House are very unique and not to be missed. Adults might enjoy the Anheuser-Busch brewery tour and free sampling. Do it twice! Foodies can enjoy “The Hill" for authentic Italian cuisine and some famous Ted Drewes frozen custard for dessert. And while we might not have Walley World, Six Flags close by!
    • St Louis ABB ToursWhat do you and your family enjoy doing? You can usually find my husband and me doting on our dog Sparky and walking through the many historic neighborhoods.We enjoy the classic architecture, landscaped lawns and many parks St. Louis has to offer. We go to St. Louis Symphony concerts and the historic Fox theater whenever possible. As an avid gardener I frequent the Missouri Botanical Garden for inspiration and enjoy caring for my many Bonsai trees at home.

    If you're in the St. Louis area be sure to come to the next user group meeting! Your career will thank you. And while you're at it, be sure to join PASS, the worldwide community of SQL Server and data management professionals of which the St. Louis group is a local chapter.

    -Kev

    -Follow me on Twitter!

    -Google Author

  • SQLVacation Postcard Day 5: Springfield, IL

    SpringfieldPostcard

    In the movie, National Lampoon's Vacation, Clark and Ellen Griswold decide to lead their family, including the kids Rusty and Audrey, on a cross-country expedition from the Chicago area to the Los Angeles amusement park Walley World, touted as "America's Favorite Family Fun Park." Ellen sensibly wants to fly, but Clark wants to bond with his family over the course of a long road trip.

    Cousin Eddie 01

    Clark: So, this is the ol' homestead.

    Eddie: Yeah, but I don't know for how long? Bank's been on me like flies on a rib roast.

    Clark: I know the feeling.

    Eddie: Enough 'bout my problems. Hell, looks like you could use a cold one.

    Clark: Now, you're talking Eddie! (Eddie drinks from an open can, passes it to Clark, then opens a fresh beer and begins to chug.)

    In my version of the vacation , we're stop in Springfield, IL (a place we've never been before) instead of the Griswold's stop in Kansas to visit Ellen's cousin Catherine and her husband Eddie. I'm just hoping nobody foists their cranky Aunt Edna or their mean dog Dinky on us. But if we do have to deal with add-on travelers, we're dropping them off at Lori Edwards (b |t) place in Tucson instead of Edna's son's Normy's home in Phoenix.

    95454-004-D2F51788

    Not only the Man who Preserved the Union, but also an evidently talented vampire hunter.

    Springfield is a lovely town, serving as the state capital and also a well-known tourist destination since it is the birth place of Abraham Lincoln. Set in lush and bucolic southern IL, it is surrounded by miles of rolling hills and verdant, well-tended farms. The kids will be enjoying some #SQLVacation time seeing the Lincoln-related tourist attractions today while I'm speaking at the local SQL Server users group of PASS, led by Patrick Brewer.

    At tonight's meeting at the lovely Island Bay Yacht Club, I'll be presenting two sessions: End-to-End Troubleshooting Checklist for Microsoft SQL Server and Top 10 DBA Mistakes. (You can download the slides now on SlideShare). Let's get to know Patrick and the Central Illinois SQL Server user group a little better!

    • When did you begin your professional career? I started in 1996 SQL Server 4.21 converting to SQL Server 6.5.  I maintained a document imaging system that had 9 servers (running Windows 3.1 and 3.11) with 18 jukeboxes for a great company, JM Family Enterprises.  Each of the Windows server were running a local version of Sybase (I’m old).
    • What’s a normal day at work like for you? Creating solutions with T-SQL, SSIS, C#, MVC, conducting meetings on Lync, troubleshooting issues with vintage systems, and trying to provide customers the best solutions possible.
    • When did you come to Springfield? I moved to Bloomington, IL 5 years ago.  I drove from Springfield (72.4 Miles) to work every day for 4 years, and finally convinced my wife to move to Bloomington, IN.
    • When and why did you decide to help as a volunteer leader? I learned about PASS from my manager when I started at Afni 9 years ago. We had always talked about starting a chapter, but no one wanted to take the reins. I’ve always enjoyed helping people learn new things. I’ve always enjoyed teaching. Becoming the chapter leader was a no brainer. I’ve had so many positive experiences in the year that our chapter has been established. Most of them are meeting people like myself that want to learn more about the products that we use to provide solutions, but also meeting the experts and finding out that they are just like myself (wanting to help people learn more).
    • What is the IT community like there? Our group covers a large area of Illinois.  We have many Colleges/ Universities, manufacturing, insurance, call centers, hospitals, and government agencies.  The largest employers in Central Illinois are State Farm and Caterpillar.  Though if you have ever sipped a cup of Coffee, the home of Bunn Automatic is in Springfield.
    • What do you like about Springfield? What you recommend someone do there, if they came to town on their own #sqlvacation? Though I moved to Bloomington 5 years ago, I still go back home to Springfield. I grew up racing sailboats and still sail 4 times a week. I start in March and will sail until the lake freezes over. The only weather I don’t like sailing in is lightning storms.  Springfield is the home to Abraham Lincoln, and as you can imagine, there are many things to do relating to Lincoln. I worked at Lincolns home for a summer, and it is like stepping back into the mid-1800’s. Even the nails on the sidewalks are designed from the era.  Other than that, there are corn fields for miles and miles.
    • What do you and your family enjoy doing in your city? Movies, Shakespeare Festival, hanging with friends. My mom volunteered at the Abraham Lincoln Presidential Library, and has been involved with many activities with the Lincoln sites.  The most popular sites are:

    Have you set your vacation plans for the summer? If so, share them with the community and on social media using the hashtag #SQLVacation! And don't forget to enter the contest for a chance at many free prizes!

    -Kev

    -Follow me on Twitter!
    -Google Author

  • SQLVacation Postcard Day 4: Downtown Chicago

    ChicagoLL

    Of the hundreds of cities that I've visited around the world, Chicago is one of my favorites. The food. The museums. The architecture. The scenery. It's all good - except for those outrageously cold winters. So I was really excited when my family agreed that they'd enjoy spending their summer vacation in the "Second City" as the midpoint for the #sqlvacation speaking tour. (Don't forget that the contest component of #sqlvacation lasts all summer long. You've got plenty of opportunity to win through July 31st).

    Clark Griswold 02


    vacation quote 01

    While I'm working, the Horde will visit Navy Pier, Art Institute of Chicago, the Bean, the Museum of Science and Industry, Shedd Aquarium, 360 Chicago, and do an Architecture River Cruise.

    the_bean_of_chicago

    One of the great things about being active in PASS and the broader SQL Server community are the interesting and inspiring local user group leaders. Chicago has a rich history of contributing to the SQL Server community. For example, Rick Bolesta from the Lyle, IL area served on the PASS board of directors for even longer than I did (13 years, iirc), acting as the board liaison for founding sponsor, CA. And I'd be remiss not to point out that PASS was founded on the concrete banks of the Chicago River under the aegis of the association management company Smith Bucklin.

    The Thursday evening session at the Chicago SQL Server User Group meeting is completely sold out. (Of course, the meetings are free. But you know what I mean). I am presenting two of my sessions there - Ten Query Tuning Techniques Every SQL Programmer Should Know and Top 10 DBA Mistakes on SQL Server. If you can't attend, why not go ahead and download the slide decks now from my page on SlideShare! Let's learn a little more about the current leadership team in Chi-town, Frank Gill and Bob Pusateri.

    Frank Gill:

    • When did you begin your professional career? I started working in IT in 1999 as a COBOL programmer.  DB2 was my first exposure to databases. I started working as a SQL Server DBA in 2007 and have been enjoying it ever since.
    • What’s a normal day at work like for you? I work for a managed services/consulting company and split my day between clients. In the course of a day, I might install SQL Server, set up availability groups, and troubleshoot performance problems.
    • lurie-garden-chicagoWhen did you come to Chicago?  I grew up in the suburbs of Chicago and moved into the city in 1993.
    • When and why did you decide to help as a volunteer leader? When Bill Lescher announced he was stepping down in June of 2012, I decided to put myself up for consideration.  I have really enjoyed the opportunity to get to know other chapter leaders and members of the SQL community.  It’s also been rewarding to be able to give back to the SQL community.
    • What is the IT community like there? The IT community is varied in Chicago.  Our user group is made up of DBAs, developers, architects, and business intelligence analysts.
    • What do you like about Chicago? What you recommend someone do there, if they came to town on their own #sqlvacation?  I am a volunteer at the Art Institute of Chicago and I highly recommend a visit there. Chicago is a great place to eat. If you get a chance to get out of downtown, they are many opportunities to sample great food: Pilsen for Mexican, Taylor Street for Italian, Argyle Street for Southeast Asian, and Albany Park for Middle Eastern.
    • What do you and your family enjoy doing in your city? We love the Art Institute and the Field Museum.  We also love exploring new neighborhoods.  I’ve lived in the city for more than 20 years and still make to parts of the city I’ve never been on a regular basis.

    Bob Pusateri:

    • BobPusateri_squareWhen did you begin your professional career? I always wanted to end up in IT (except for those times where I wanted to be a doctor...or a fireman...or an actuary...or a city manager...). I actually started working with "databases" (MS Access) in high school. I had an after-school job working for a city and the building department was totally based on paper at that time. They were trying to move everything to Excel and it was failing miserably. I thought there had to be a better way, and looked into writing something using Access or MySQL. I probably should have chosen MySQL, but over a summer I learned Access and put together an application for managing building permits, contractor licenses and a couple other day-to-day tasks. I perfected it over the next year, and then they started using it to run the department. It went live in 2003. They still use it today. I also sold it to a few other cities, some of which still use it as well. All through college I knew I wanted to be a DBA and started learning SQL Server (2000) in my spare time. Tried as hard as I could but no company would hire a DBA straight out of college (probably a smart idea!) so I took a job as a programmer and then moved to the DBA team 2 years later. 
    • What’s a normal day at work like for you? First thing I'll do in the morning is go through the server and job logs from the night before and make sure nothing went bump in the night. If something did, I'll either fix it myself or get in touch with the responsible parties. Then I'll work on outstanding tickets and answer email. Lunchtime is for reading blogs. After lunch it's usually meetings with our team's customers and work on other projects. 
    • chicago-portillosWhen did you come to Chicago? Aside from going to college downstate, I've never left. Born and raised in the Chicago area. 
    • When and why did you decide to help as a volunteer leader? I was a member of the chapter for a few years, and each year the chapter leader would mention they're looking for help. I had been thinking about it for a while, and last year decided to open my mouth and become a co-chapter leader. 
    • What is the IT community like there? I've always felt there's tremendous opportunity for IT folk in and around Chicago in pretty much every field imaginable. The financial district, especially the Chicago Board of Trade and the Chicago Board Options Exchange means you'll find pretty much every global player in financial markets has an office here. There's also a strong presence from the insurance industry, and several large academic medical centers that are always seeking top IT talent. In the last few years the startup community has really grown as well. 
    • FieldMuseumWhat do you like about Chicago? What you recommend someone do there, if they came to town on their own #sqlvacation? There's never a dull moment in Chicago (for better or for worse). Always plenty to do, no matter what time of year. If you come here and are bored, you're doing something wrong.  For those who have never been to Chicago before, my to-do list has several items. See Millennium Park and be sure to walk through The Lurie Garden, my favorite part. Check out one of the museums. If you're at all interested in architecture, there are some wonderful tours along the river. You have to eat a hot dog and a beef sandwich, so go to Portillo'sYou also need deep dish pizza. I recommend Lou Malnati's or Pizzeria Uno. They're both great, but their restaurants are quite manufactured and touristy. If you want something a little more seedy, head to Exchequer on Wabash. Segway tours are a lot of fun and a great way to cover a lot of ground quickly. If it's a rainy day, check out the Lincoln Park or Garfield Park Conservatories. I'm not much of a plant person but they really are spectacular.
    1. What do you and your family enjoy doing in Chicago? If we're going downtown, it's usually for a specific purpose. Either we'll be heading out to dinner, maybe catching a show in the theatre district, summer concerts at Millennium Park, or checking out one of the museums. They're all great, but our favorite is the Museum of Science and Industry. The Field Museum and Art Institute are also amazing. For a real treat (and I recommend this for your family if you are staying downtown and have the time) after dark, catch a cab (or take a long walk and watch out for freaky people) to the Adler Planetarium. You get the most amazing view of the skyline from there. It's great during the day too, but really awesome at night.

    On behalf of the entire SQL Server community, I want to say thank you to Frank and Bob for their volunteer spirit. Were it not for hardworking and unsung heroes like them, SQLFamily simply would not exist.

    So how about you? Are you active in your local PASS chapter? If not, consider attending your next chapter meeting. They're all posted online at the PASS Local Chapters web page.

    The #sqlvacation contest continues until July 31st and includes both a contest component and the live events. Check out all of the details at SQLSentry.com/SQLVacation.

    -Kev

    -Follow me on Twitter!
    -Google Author

  • SQLVacation Postcard Day 3: Chicago Suburbs

    SQLVacation Postcards

    I've been to Chicagoland many times over the years. Winters are tough for a Southern boy like me. But summer in Chicagoland is one of the best experiences evah! One such magical experience was when I stumbled into a Taste of Chicago event back when that wasn't a wide-spread event. Irmagird. During the 1990's, when I worked for Deloitte, I occasionally traveled to the practice office in downtown Chicago or to the tax practice in Deerfield. In the later 1990's and early 2000's (a.k.a. "the aughts"), I frequently traveled to the original offices for PASS on Michigan Avenue. Later on during the aughts through 2012, I often traveled to the Quest Software offices in Naperville. So it's with these thoughts in mind that we make the #SQLVacation drive from Indianapolis to the Chicago Suburban SQL Server user group in Downers Grove, IL.

    vacation-2

    I had those glasses. And that computer.

    One of the things I have to keep reminding myself about America's biggest cities is that they are HUGE. You can start driving in one part of Chicagoland at noon, drive a straight line without looping, and still be in greater Chicagoland hours later. And if you don't time it just right, you can add a couple hours additional time spent in stop-n-go traffic. That's frustrating enough to send Clark Griswold into an over-the-top tirade of EPIC proportions.

    My session will run from from 6:00 - 9:00 PM CST and will address the topic of End-to-End Troubleshooting Checklist for Microsoft SQL Server.  (Click the link to download the slide deck from SlideShare.net).  Oh and you need to REGISTER HERE. Officially, the event is sold out. But we'll figure something out - and possibly anger the Fire Marshall - if we have a few unregistered attendees show up.

    By all accounts, Downers Grove is an amazing place to live and work. Forbes Magazine named Downers to the Top 10 of America's Friendliest Towns. It's also rated as on of the country's most educated cities, one of America's Top 10 Best Places for a Healthy Retirement list (on account of its many parks and hospitals), and at the other end of the age spectrum, one of the best cities in America for kids. But perhaps most significant of all is that Randy "Macho Man" Savage was a proud alumnus of Downers Grove North High School. OOOH YEAH!!!

    Today, I want to give a shout out to the leaders of the Chicago Suburban SQL Server user group - Lowry Kozlowski and Andy Yun.

    Lowry Kozlowski

    • When did you begin your professional career? I began my professional IT career while going through a divorce about 17 years ago as a Y2K COBOL programmer. But our DBA left before the project was fully converted. Since I was taking SQL database courses at college at the same time, I stepped in to use Unisys ISQL command line to validate the data and it went from there. We got a SQL Server box that I managed to connect to the DMSII databases, and run Crystal Reports. I was hooked. Prior to that I worked as an optician and in accounting positions. I had wanted to be a photographer, but developed allergy to the chemicals. Hence my dual degrees, Associates in Photography and Bachelors in CS.
    • What’s a normal day at work like for you? What is normal? As a consultant, I could be at a client site doing installs and building new systems, perform assessment of existing infrastructure, in the office reviewing job failures, training junior team members on troubleshooting, or working on troubleshooting tickets for clients. 
    • When did you come to Chicagoland? I have lived in the Chicago land area my whole life, so it is great to be able to support my community. 
    • Navy-Pier-ChicagoWhen and why did you decide to help as a volunteer leader? I had considered several years ago helping the user group when Wendy Pastrick (now on the PASS Board of Directors) was going to step down. But another volunteer was more ready than I was at the time. I wasn't sure I could handle the responsibility and time commitment at the point in my life. So when Wendy ask if I would be able to work with Andy Yun to support the group. It is great to be able to help bring training and networking avenues to our group. I love getting to know the people in the group and extended community. It has been a learning experience on how to get speakers, sponsors, and even venues to have our meetings at. I really enjoy working with Andy, as he is very outgoing and we have been able to achieve a very good balance on the meeting and other responsibilities.
    • What is the IT community like there? Chicago is a great IT community, and the Downtown Chicago chapter and Suburban chapter work very closely together, as well as with the Chicago BI group. Our industries vary from consulting, to businesses to education, and a whole variety of things in between. 
    • Chicago-Art-Institute-Museum_Exhibits-at-Chicago-Art-Institute_4303What do you like about Chicagoland? What would you recommend someone do there, if they came to town on their own #sqlvacation? I love that there is so much variety of things to do in Chicago area - zoos, museums, street fests, fantastic food. If you get a chance to see it, go to Navy Pier and wander around, take a cruise on the lake front, or a take speedboat ride. The river tours are just great. Walk around Grant Park or Navy pier, Sears tower, John Hancock,I could go on and on. 
    • What do you and your family enjoy doing in Chicagoland? My family loves to go to the museums, shopping, and out to eat. (I have all girls). We enjoy walking or biking on the lakefront. Seasonal things are great too. Art fairs and street fests are just a few of the things we love to do. Since I am a Cubs fan and the girls are Sox fans, we rarely go to the ball park together. :)

    Andy Yun

    • When did you begin your professional career? Around 2000-2001.  My first job out of college was for a small internet development consulting shop.  There, I was both an app dev and a system admin. And that's where I was first exposed to SQL Server 2000.  After that, I took a job as a junior SQL Server DBA and the rest is history! 
    • When did you come to Chicagoland? Dude, I was born & raised in the Chicagoland area! (He didn't actually say "dude" -Kev).
    • When and why did you decide to help as a volunteer leader? I'd already been a member of the Chicagoland SQL Saturday organizing committee for two years and had begun speaking 3-4 months prior.  The opportunity to reboot the Chicago Suburban User Group came up as a surprise to me.  I freaked out for 30 seconds, then decided "Alright, why not!" In the past year, I've been thrilled to meet many new #SQLFamily members, in my immediate area.  I've enjoyed building a small community of UG regulars, who I look forward to seeing every month! Oh yes, for your "any extras," guess I'd just like to plug that I'm thrilled & honored to be speaking for 24 Hours of PASS later this month! My session is entitled Every Byte Counts: Why Your Data Type Choices Matter
    • What is the IT community like there? The community here in Chicagoland is massive.  And being Chicagoland, asking what industry is NOT present somewhere here would be easier to answer! 
    • chicago pizzaWhat do you like about Chicagoland? What you recommend someone do there, if they came to town on their own #sqlvacation? Food!!! There's such a diverse food scene here, with numerous ethnic groups represented, to traditional "Chicago-style" offerings (pizza, hotdogs), to cutting-edge chefs pushing the boundaries.  Whenever #SQLFamily come into town, I like to take them out to interesting places to eat. Ask the SQLSkills crew, I take their students out regularly!
    • Where can I find out more about the user group?  Contact myself or Lowry Kozlowski at chisuburbanssug@sqlpass.org or visit us on the web at http://chicagosuburban.sqlpass.org/.


    Even if you can't make it to this meeting, please get active in your local PASS chapter. To find the PASS chapter closest to you, check at the PASS Local Chapters web page. Over over 250 chapters around the world, there's likely to be one near you.

    And don't forget, the #sqlvacation includes both a contest component and the live events. Check out all of the details at SQLSentry.com/SQLVacation.

    And if you want my slides, be sure to check my page on SlideShare!
    -Kev

    -Follow me on Twitter!
    -Google Author

  • SQLVacation Postcard Day 2: Indianapolis, Indiana

    KevinEKline.com SQLVacation Indianapolis Postcard 01

    For some people, Indianapolis means one thing, and one thing only - the Indianapolis Motor Speedway (a.k.a "The Brickyard")  and the Indianapolis 500. In my case, it means several times speaking at IndyPASS, the local SQL Server User Group, over the last 10 years. I first spoke at IndyPASS with the then head of Microsoft's Business Intelligence product line, Bill Baker. Bill was a big racing fan and, fortuitously, the user group leaders were happy to accommodate his request to speak in time to see the big race.

    KevinEKline.com SQLVacation 03

    I also got the chance back in 2005-2006 to see a hilarious comedian known as Buck Foley. (Lloyd Work is a local IT guy, a programmer by day, and a Chris Farley impersonator by night). Suffice it to say that Buck is a motivational speaker who lives in a van down by the river. And he knows IT like no other comedian I've ever seen. Check him out online, especially if you can't come see him in person.

    Buck Foley 01

    While this #SQLVacation means lots of free time for "the Horde" (that's my nickname for my 7 kids), I'll still be working. Today's agenda for my wife and the four out of our seven kids on this roadtrip includes a day at Indianapolis Children's Museum, the largest in the world. My hope is that they'll get to see something really exciting, like the world's largest turnip. That's just the way Clark Griswold would want it. Perhaps they'll stop by the site of Wonder Bread where they literally invented sliced bread. (Everybody keeps trying to tell me that their invention is the best thing since Wonder Bread. But I know better!) Or they might swing by for a selfy at the Slippery Noddle Inn where bullets are still embedded in the walls from the Al Brady and John Dillinger gang shout outs. Or, best in my book, would be a visit to the Indiana Medical History Museum for a chance to gander at a room full of pickled human brains. Wow!

    The Indy event will be crowded and fun. Why? Because it's their 10th Anniversary Birthday Bash! The program starts at 5:30 PM with catering by Dick's Bodacious BBQ and entertainment. The session for this event will be Ten Query Tuning Techniques Every SQL Programmer Should Know (feel free to use the link to download the slide deck from SlideShare).

    So let’s get to know the Indianapolis even better by talking with Ray Lucas, the lead volunteer for IndyPASSTwitter and LinkedIn

    • When did you begin your professional career? I graduated from Purdue University with a Bachelors in Computer Information Technology in 1995. Back then I was learning all things database on the dreaded O word...you know Oracle. :-) I spent two summers as a college intern at Allison Engine in the early 90's, using a temp agency to snag a job as a receptionist, covering for someone out on leave. I then networked my way into a job for the remainder of the summer and the next. I have fun stories about how the oil pumps  are made for V-22 Osprey vertical takeoff airplanes. I was right at home with the engineers. Upon graduation, I started my professional career back in 1995, working with, you guessed it, Oracle. My studies at Purdue included PL/SQL, and that landed me a job supporting applications, designing databases, and writing code. From there I spent the next 7 years implementing applications, but not just database related tasks. I became the jack of all trades, generalist IT guy who got the projects that didn't fit into a specific mold. That has been the precedent for my career ever since. I spent years as an infrastructure project manager, Manager of a Business Intelligence Team, responsible for reporting strategy for a Fortune 500 company. I was the lead BI architect for a well-known Indy based high end audio company. I moved to consulting 7 years ago, and was asked to run an infrastructure migration for our managed services arm. That move has been my focus ever since, as I now am an Infrastructure Execution Lead, responsible for large scale IT infrastructure migrations, most recently full IT integrations of manufacturing plants in the Mergers and Acquisitions space. Like I said, that general IT, just give it to Ray thing paid dividends, as I think I have a decent grasp on how IT works, both from a business and technical perspective, which allows me to take on large IT projects.
    • What’s a normal day at work like for you? Calls from 7:00 am to 12:00 pm with my European clients (UK, France, Spain, Italy, Ireland). Meetings in the early afternoon with US resources and South American clients (Columbia, Puerto Rico, Brazil). Real work from 3:00-5:00 pm. Calls from 9:00 pm to 11:00 pm with my Chinese and Japanese clients. Sometimes I even get to travel to these counties. It is tiring, but the people are interesting, the work exciting, and I love it. After being out and about, not sure I can go back to a desk only job.
    • When did you come to Indy? I was born and raised in Seymour, Indiana, the small-town of John Mellencamp fame. I went to college 90 minutes north at Purdue University, studying Computer Information Technology. My summer internships in Indy helped me to establish local ties that drew me back to Indianapolis. I started my career here in 1995, and started helping with IndyPASS in 2005.
    • When and why did you decide to help as a volunteer leader? I went to the first IndyPASS Meeting as an attendee. A co-worked mentioned it and I decided that night to attend at the Microsoft Offices. The crowd was large, probably 150 or so to see Bill Baker from Microsoft. I was hooked. I knew I wanted to help in any way and offered my services the next meeting. Hearing that the group needed a place to meet, I secured the Conseco Conference Center where I worked at no cost to the group. I then became Sponsorship Director, Vice President, and now serve as President. IndyPASS has helped my career tremendously. My path to Executive Director of Managed Services and my current infrastructure role in Mergers and Acquisitions started with an IndyPASS sponsor. When I was downsized from an employer, an IndyPASS Sponsor and now a dear friend of mine, sold a job at her company with my name on the contract, insisting I work with her. She arranged for the role, the position, and the rest is history. Infrastructure projects have been my life ever since. In general, IndyPASS has furthered my career, helping me to understand how to lead, motivate and cultivate relationships. It has helped me to better understand the Indy IT community, and help connect others that might not otherwise know one another. I enjoy connecting job seekers with open positions, sponsors with potential customers, and most importantly IndyPASS attendees with opportunities to learn, grow, and develop the social networking skills so desperately needed in today’s Information Technology landscape. 
    • What is the IT community like there? IndyPASS draw folks from all over Indiana. We have regular attendees from as far north as Lafayette (90 minutes north), and as far south as Bloomington (90 minutes south). Attendees come from big companies like Caterpillar, insurance companies, small law firms, large and small consulting firms, managed services companies, software development companies, healthcare companies, and even professors from IUPUI here in downtown Indianapolis. The Indy tech community is vibrant and alive, with many start-ups rooting here in the Midwest and having great success doing so. I consider our attendees to be some of the brightest I’ve met, while still holding true to that humble Midwest way that brings them back to learn from anyone willing to speak and share their knowledge. 
    • What do you like about your city? What you recommend someone do there, if they came to town on their own #sqlvacation? Downtown Indianapolis is a fun, walkable city, with lots of monuments. Check out the Eli Lilly Museum at the base of the Soldiers and Sailors Monument on the circle before walking 300+ stairs to the top. Ever wonder why they call us the "Circle City"? The people in Indy are honest, friendly, and genuine. Catch an Indianapolis Indians baseball game. This Triple-A team is fun to watch and Victory Field is one of the best minor league parks in the country. If you are here in the winter, the Colts and Pacers both play at amazing facilities, with Bankers Life Fieldhouse voted the best sports arena in the country 12 years running. Check out the NCAA Museum. This is the home of the NCAA y'know. Check out the Indianapolis Children’s Museum, the largest of its kind in the country. Last but certainly not least, take a trip to the Indianapolis Motor Speedway, home of the Indianapolis 500. The museum only costs a few dollars and you get to see all the cars that have won the Indy 500. Then take a couple laps around the famed 2.5 mile oval. There really is nothing more exciting than a race at IMS. 
    • What do you and your family enjoy doing in your city? Sports, sports and more sports. Indianapolis 500 in the spring. Indians baseball in the summer. Brickyard 400 and MotoGP motorcycle racing in the late summer. Pacers basketball and Colts Football in the winter. Microbreweries, microbreweries and more microbreweries. Beer is the new drink of choice these days in Indianapolis.

    Ray's IndyPASS History Highlights

    • First meeting took place on June 16, 2005 with Bill Baker of Microsoft.
    • IndyPASS was started by Bret Updegraf (first President) and John Magnabosco (first VP).
    • Crowe-Chizek (now Crowe-Horwath) seeded the group with $2000, allowing us to provide free meetings and eventually have the funds to secure a 501©3 status.
    • That non-profit status has really helped to secure annual sponsors, with IndyPASS never being below at least 3 active sponsors at any one time in its 10 year history.
    • IndyPASS currently has six (6) sponsors, in industries from consulting to managed services to hardware to software to recruiting.
    • Of the 120 potential meetings, only 3 have been cancelled due to weather. We only bow to Mother Nature when we have to. Otherwise, the learning must go on.
    • The IndyPASS email subscription base sits at just under 600.
    • Monthly meetings fluctuate in attendance, but average between 40 and 50 these days.
    • The largest IndyPASS crowd was right around 200 attendees at IndyPASS Birthday Bash v2.
    • Group members also actively manage Indianapolis SQL Saturday, which last year had over 300 registrations.
    • June 16, 2015 marks v10 of IndyPASS.
    • We are proud of the first 10 years of IndyPASS and look forward to the next 10 years of IndyPASS.

    Ray's Key Insights to User Group Success

    • Great Sponsors. IndyPASS relies on great sponsors to back and promote meetings, provide food and prizes, all with no charge to attendees.
    • Generous Hosts. Meetings have been hosted at Conseco, Microsoft, LANTech Training, Perpetual Technologies, and currently Apparatus, all at no cost to IndyPASS for all 10 years.
    • Engaged Technical Base. Indy has a great base of technical folks interested in all things data and technology who keep it fresh:
      • We span the SQL Server stack (and most systems that touch or rely upon SQL Server), with topics targeting DBA’s, infrastructure,  Business Intelligence, reporting, Big Data, Parallel Data Warehousing, ETL, Hadoop connectivity, SharePoint reliance, SQL Internals, data security, data backups, SQL Programming, etc. You name it and we have probably talked about it over the years.
    • Great people!
      • Past board members: Bret Updegraff (founder), John Magnabosco (founder), Jimmy May, Dave Leininger
      • Current Board Members: Ray Lucas (President), Kyle Neier (Vice President), Scott Stephens (Treasurer, he's been here in this role since the beginning), Devin Lamb (IndyPASS Web Guru, the guy behind the emails), Aaron Cutshall (Sponsorship Director), Dexter Ploss (SWAG Director, DP finds the free giveaways better than anyone), Hope Foley (SQL Saturday Guru and Board Member), Alan Dykes (Board Member), Tom Ahler (Board Member and Ticket Guy), Ron Carrel (Board Member), Michael Goolsby (Board Member and IndyPASS Facilities, the room is ready when MG is involved)
  • SQLVacation Postcard Day 1: Louisville, Kentucky


    KevinEKline.com SQLVacation Louisville Postcard

    Along the banks of the mighty Ohio River, in sight of the shores of Indiana, lies beautiful Louisville, KY. Louisville is a city I've long felt connected to. (No, not because I drink bourbon, although that's a pretty good reason to like the place, come to think of it). It's because my brother, five years my senior, earned his graduate degrees in one of the city's fine universities and worked there as an English professor for many years. Whenever I had a spare weekend, I'd load up the family, pop a cassette into the car stereo, and make the ~3 hour trip north to the Bluegrass State to visit my brother, sister-in-law, and nephews. Good times for sure.

    KevinEKline.com SQLVacation 02

    Even after my brother relocated to Anchorage, Alaska (It's a long story, trust me), I still visited Louisville at least once a year for their annual SQL Saturday. In fact, this year was the first year I've ever missed the event. And that's only because I knew I'd be there for this event!

    It's well known that Clark Griswold is a big fan of every bit of kitschy Americana on his family vacations. Some fun things we're going to try to see for our #SQLVacation include: 95% of the world's bourbon whiskey is made in the state as are 90% of the disco balls sold in the USA. Over 100,000 mint juleps are served during the Kentucky Derby and Kentucky Oats events. The world's largest baseball bat (120 feet tall!) is the replica of Babe Ruth’s 34-inch Louisville Slugger bat weighing in at 68,000 pounds, is made of steel, stands 120 feet tall and is located at Louisville Slugger MuseumGQ magazine ranks Louisville as the 'Manliest City' because of bourbon, baseball, and horse racing.

    If you're in the area and are interested in hearing my presentation, then be there early. They've already got a "sell out" crowd. I'll be there around 11:00 AM for an 11:30 AM starting time. The topic is going to be decided there by a show of hands. It's a toss-up between (click the link below to download the slides):

    KevinEKline.com SQLVacation Dave FacklerSo let's get to know the city even better by talking with Dave Fackler, the lead for the Louisville PASS chapter (Dave's responses are in italics):

    • When did you begin your professional career? I started working as a computer programmer in the US Air Force in 1989, working primarily with Unix and mainframe systems.  I started working with SQL Server in 1998 with the release of SQL Server 7.0 and became addicted to the BI tools – and that addiction continues today J
    • What’s a normal day at work like for you? As a consultant to the Department of Veterans Affairs, I spend most of my time helping the Business Intelligence Service Line there expand, develop, and support the VA’s enterprise data warehouse environment.  As the Chief Technical Architect for that group, I help strategize on the overall architecture and design of the business intelligence infrastructure, make recommendations on tooling choices, help other teams throughout the VA who are building data mart and reporting solutions based on the data warehouse environment, etc. Given that I telework 100%, I also spend a lot of time on the phone and on Microsoft Skype calls!
    • When did you come to Louisville? I grew up outside of Louisville in a small farming community, went away to college at Vanderbilt in Nashville in 1985, served in the US Air Force until 1997, worked for a consulting firm in Atlanta until 2005, and then returned home to build a house on my Dad’s farm.  So I’ve come full circle and am VERY glad to be back in the Louisville area.
    • When and why did you decide to help as a volunteer leader? I helped to start the Atlanta SQL Server Users Group back in 2001 (and even gave the first ever presentation for the group, which can still be found here. So I was very familiar with leading a local PASS chapter when the prior leader of the Louisville group (Mala Mahadevan) needed to turn over the group to someone in late 2013.  I really enjoy leading the group, seeing SQL Server professionals in Louisville network together and learn, and meeting other chapter leaders and volunteers across the country and around the world!
    • What is the IT community like there? The IT community within Louisville is a great mix of “old and new”.  We have a lot of companies that have called Louisville home for a very long time – particularly in the healthcare, automotive, and manufacturing sectors.  SQL Server professionals in those companies are focused on maintaining their systems, developing in-house database solutions, and dealing with third-party ERP and EHR systems. On the other hand, we have several cutting-edge technology companies that are helping to “modernize” the IT community through groups like the Technology Association of Louisville Kentucky (TALK) and events like TechFest Louisville.  So Louisville is a great place to be for technologists and SQL Server professionals of all backgrounds and levels of experience.
    • What do you like about your city? What you recommend someone do there, if they came to town on their own #sqlvacation? Louisville is a great place to visit!  Of course, anyone coming can start with the classics like the Derby Museum at Churchill Downs (or even the Derby itself, if you plan your trip for early May), Slugger Museum & Factory, the Muhammad Ali Center, the Frazier History Museum, and the Kentucky Science Center (check out the KentuckyShow! which provides a “Kentucky 101” lesson narrated by Ashley Judd).  Beyond that, Louisville has a wealth of green spaces and parks along with a growing list of culinary delights (led by a group of independent restaurants known as the Louisville Originals).  And you can’t really come to Louisville and Kentucky without at least considering a trip to some of our most famous distilleries (check out the Kentucky Bourbon Trail) or at least a few of our world-famous bourbon bars (take a look at the Louisville Urban Bourbon Trail for distilleries IN the city).  And finally, for the more adventurous visitors, take a shot at the MEGA attractions at the underground MEGA Cavern.  There’s lots to do in Louisville!!
    • Where can I find out more about the user group? The email address is louisville@sqlpass.org. And our website is at http://louisville.sqlpass.org. We're also active on FacebookLinkedIn, and Twitter. Come join us!
    • How can we get in touch with you for further questions?  Easy. My email is davef@rollinghillsky.com. And you can connect with me on LinkedIn and Twitter.

    How about you, dear reader? Have you ever visited Louisville, KY as a tourist? Tell us about it using the #SQLVacation hashtag on social media! If you've entered the contest, every #SQLVacation tweet or post you put out is a raffle entry! One in every 25 entries wins, so get in there and share your #SQLVacation with the community.

    -Kev

    -Follow me on Twitter!
    -Google Author

  • Make your summer vacation a #SQLVacation

    This summer, we at SQL Sentry have decided to do a fun riff on the National Lampoon Vacation movies starring Chevy Chase. And I'm asking you to participate as you take your own vacation, whether it's a week at the beach or a "staycation" catching up on chores around the house.

    sqlvacation 01

    In my case, I’m going to load up the 5 of the 7 members of the Horde in a minivan (no dog or mother-in-law on this trip) and drive a circuit of the big cities between Nashville and Chicago, speaking at a different SQL Server user group meeting each day. Your first way to participate is to come to the user group meetings:

    • 15-Jun-2015, Louisville KY, Lunch session
    • 16-Jun-2015, Indianapolis IN, Dinner session
    • 17-Jun-2015, Chicago Suburbs IL, Dinner session
    • 18-Jun-2015, Chicago IL, Dinner session (Limited seating. Be sure to REGISTER).
    • 22-Jun-2015, Springfield IL, Dinner session
    • 23-Jun-2015, St Louis MO, Lunch session
    • 24-Jun-2015, Evansville IN, Lunch session

    • 26-Jun-2015, Nashville TN, Lunch session 

    I’ll be giving away some custom t-shirts (take a look at the design below) and getting the SQL Server family pumped up during the otherwise slower months of summer.

     Your second way to participate and to get in on some prizes is  to join in the social media fun. Just put out the word on social media (Twitter, Facebook, what have you) about your own #SQLVacation plans and activities and you'll get entered into the regular prize drawings and as well as the grand prize drawing, at the end of summer.

    I hope you’ll take part in the social media fun! You can read all of the details about the contest, rules for participation, and such at http://sqlsentry.com/sqlvacation. (Some conditions and rules apply, so be certain to read up)! If we get a lot of community participation, we'll do it again next year to a whole different set of cities!

    sqlvacation t-shirt 02


    I hope to see you in person! Best regards,

    -Kevin

    -Follow me on Twitter!
    -Google Author

  • Microsoft //Build and Office365 Events Coming to a Chicago, LA, Charlotte, Indianapolis, and Jacksonville

    The //build Tour

    If you build software using Visual Studio or code against the Microsoft stack, you don't want to miss the //build traveling road show.

    The Microsoft //build tours bring the Build conference experience to you for in-depth, usable knowledge about Windows 10 and much more. There's coding sessions and lots of new product demos. You'll also get facetime with Microsoft Technical Experts to ask those tough questions, partner showcases, and opportunities to connect with your fellow peers. Register today, it's a FREE event.

    Two dates are just around the corner:

    On Wednesday, June 10, 2015, Build Tour Chicago

    build 01, 2015-06-04_9-38-41

    On Monday, June 15, 2015, Build Tour Los Angeles

    build 02, 2015-06-04_9-39-25

    You experience...

    • Best of //build announcements and insights.
    • Windows 10 developer platform for app and web developers.
    • Coding sessions and demos across devices.
    • Q&A with Microsoft engineers.

    Attend sessions and demos, watch the keynote, and deepen your knowledge of Microsoft Universal Windows Apps, Web Apps Platform, Lighting-up new devices and capabilities and Cross-platform development.

    The Windows10/Office Tour

    In addition, the “USA Tour on Windows 10/Office/EMS” is coming to a city near you. This mini-conference is focused on Windows 10, Office 365, and productivity offerings to ensure you are on the leading edge of Microsoft software, devices, and services. Topics include: Windows 10, Next Generation Windows Devices, Internet Explorer and Project Spartan, Office 365, Delve, Sway, & Skype for Business, Windows Phone 10, Surface Hub, and the new Enterprise Mobility Suite. Register for these upcoming cities:

    • Indianapolis, IN on Thursday, June 4
    • Charlotte, NC on Tuesday, June 9
    • Jacksonville, FL on Thursday, June 11

    Let me know if you decide to attend. I'd like to hear what you thought of the event.

    -Follow me on Twitter!
    -Google Author

    -Kev

  • ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism - SQL Server Performance

    Great topics for further reading about tuning SQL Server performance:

    Exploring SQL Server 2014 SELECT INTO Parallelism

    Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO operations.

    Parameter Sniffing, Embedding, and the RECOMPILE Options

    Parameter sniffing is a term used to describe the processes by which SQL Server attempts to reuse execution plans where certain parameters might frequently change. If you’re only familiar in passing with the term, it probably has negative connotations for you.  But parameter sniffing is merely a behavior, which is neither always bad nor always good in and of itself. Read this interesting article by Paul White (b|t), and be sure to read the lively discussion that follows.

    Finding Performance Benefits with Partitioning

    Erin Stellato (b | t), of SQLSkills.com, is back with another great read. This time she’s covering performance benefits that come from partitioning and in which cases partitioning is not going to provide a performance boost.

    Enjoy,

    -Kev

    -Follow me on Twitter!

More Posts Next page »

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement