Search results matching tags 'SQL Server 2012' and 'Conferences'

PASS Business Analytics Conference (BAC) Recap

KKline — Sun, 14 Apr 2013 14:15:00 GMT

The PASS Business Analytics Conference (PASS BAC) is PASS' first foray into an event that is dedicated to business intelligence, big data, data visualization, and business analytics. And it totally makes sense for PASS to move in this direction, over and above the flagship community work centered on database management and application development. Why? Because business analytics is all about how to apply the data being collected and managed by all of those developers and DBAs. And, at the end of the day, how we use and apply our data is really the nexus of its value. That's what matters to business. You can read the speech from the standing president, Bill Graziano (Twitter | Blog), or watch it online at the PASS website.

The day one highlight, introduced by the SQL Server team's best presenter - Amir Netz (Twitter), is the release of a new BI data visualization tool called Project “GeoFlow” for Excel. GeoFlow is a 3D visualization and storytelling tool that helps you map, explore and interact with both geographic and chronological data for visualizing data which is difficult to identify in traditional 2D tables and charts. With GeoFlow, you can plot up to a million rows of data in 3D on Bing Maps, see data changes over time and share findings through appealing screenshots and cinematic, guided video tours of the data. It's really something you have to see to understand – check out the video demo and screenshots below. You can also download and try it out firsthand today. It’s an entirely new way to experience and share insights – one you’ll probably enjoy. For more information on GeoFlow, check out the Excel team’s blog and visit the BI website.

The highlight for me, aside from connecting with so many friends and colleagues in the exhibit hall at the SQL Sentry booth, was the day 2 keynote address by Dr. Steve Levitt of Freakonomics fame. Freakonomics is both a brilliant blog and the number one business book in America. His insights are well documented in a variety of places, not just in his own channels, but also in places such as TEDtalks. I'm also really enjoying his new website, https://www.freakonomicsexperiments.com/.

Steve presented an outstanding keynote, full of funny anecdotes and insights into the world of data analytics and interpretation. A couple of his comments really resonated with me which are worth repeating. In one story, he pointed out how some of the greatest insights came from corporate data which was collected incidentally or coincidentally. The data that help provide the greatest and most valuable revelations were from data that was basically a corporate afterthought. Another revelation - he's only now starting to make much use of relational databases. He primarily uses spreadsheets, flat files, and the Stata statistical analysis tool. Another insight, which I've known and proselytized as "the Fresh Pair of Eyes" approach, is that it really helps him to gain insights in a problem by knowing as little about the problem as possible. As it turns out, if you know the industry or the challenge at the core of the problem, you make a lot of assumptions that limit your means of interpreting data. By knowing nothing or next to nothing about a particular problem, you can ask the questions that insiders never ask. Here's an example (not from the keynote though) - let's say you're an energy company CEO. You might spend a lot of time thinking about how to accommodate the expected huge increase in energy consumption due to lots of people driving electric cars. You might tell your data analysts to figure out when and how to ensure peak electrical usage is available at the times when consumers are recharging their electric vehicles. But a fresh pair of eyes would point out that electric cars, in their present form, are a huge energy boondoggle compared to hybrid and plain ol' cheap, high-mileage models like the Honda Civic. Consumers will never recoup their investment in a high-priced, all-electric car compared to a cheap, gas sipping model.

At the heart of his presentation is the fact that data is meaningless when it doesn't answer important questions! Many times, data professionals spend so much time devising elegant SQL statements and clever user-interfaces that they forget about using a fresh pair of eyes when they look at business questions. Our session, Operational Excellence for the BI Pro, focused on the trails and travails of successfully implementing and growing the footprint of a business intelligence project.

In addition, we had a fun and very informative panel discussion breakfast on Thursday of the PASS BAC. At right is a picture of Nick Harshbarger, Justin Randal, and me prior to the session. The audience was very engaged and, despite having no slides, there was a whole lot of wisdom goin' on. The panel included Chris Webb (Twitter | Blog), Craig Utley, Jen Stirrup (Twitter | Blog), Paul Turley (Blog), and Stacia Misner (Twitter | Blog). I served as the moderator and facilitator of the session. We recorded the session, with a little HD Flip camera, and although I haven't checked out the file yet, we're hopeful we can post it or at least a transcript soon.

Do you have a "fresh eyes" story? I'd love to hear it! Post a comment here!

Many thanks,

-Kevin

-Follow me on Twitter!
- Google Author

SQLintersection!

KKline — Wed, 27 Mar 2013 13:47:00 GMT

The best emotion to describe how I'm feeling is 'astounded'. I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference. Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection.

Check out this list of speakers:

Aaron Bertrand, Sr. Consultant, SQL Sentry, Inc. [blog | twitter]
Andrew J. Kelly, Mentor, SolidQ [blog | twitter]
Bob Ward, Principal Architect Escalation Engineer, Microsoft [blog | twitter]
Brent Ozar, Brent Ozar Unlimited [blog | twitter]
Conor Cunningham, Principal Architect, SQL Server, Microsoft [blog]
Grant Fritchey, Product Evangelist, Red Gate Software [blog | twitter]
Jeremiah Peschka, Brent Ozar Unlimited [blog | twitter]
Joseph Sack, Principal Consultant, SQLskills.com [blog | twitter]
Kendra Little, Managing Director, Brent Ozar Unlimited [blog | twitter]
Kevin Kline, Director of Engineering Services, SQL Sentry, Inc. [blog | twitter]
Kimberly L. Tripp, President/Founder, SQLskills.com [blog | twitter]
Mat Young, Senior Director of Products, Fusion-io [blog | twitter]
Paul S. Randal, CEO / Owner, SQLskills.com [blog | twitter]
Paul White, SQL Kiwi Limited [blog | twitter]
Steve Jones, Editor, SQLServerCentral.com [blog | twitter]
Sumeet Bansal, Principal Solutions Architect, Fusion-io [blog | twitter]

Read the list of SQL Server sessions here. On top of the list of outstanding sessions to attend, I'll be giving a keynote on Tuesday afternoon. Witness:

So the only thing between the attendees and the booze in the reception hall is our keynote address?!? Oh yeah, that's going to go down real smooth, isn't it? I'll last about as long as a puny henchman between James Bond and the villain of the movie. Sumeet Bansal, from Fusion-IO, will have to survive until the credits roll. We'll be talking about high performance computing on SQL Server 2012 with an eye towards high availability, AlwaysOn, and Availability Groups.

If you're in Las Vegas, I hope to see you there! If not, you should consider coming to this excellent conference.

-Kevin

-Follow me on Twitter!

What's It Like on a SQLCruise?

KKline — Tue, 05 Feb 2013 19:25:00 GMT

I always seem to get a question or two along the lines of "What's it like on a SQLCruise?" as I present at various conferences, SQL Saturdays, and user group meetings. Since we just finished up the 2013 Miami SQLCruise, I thought it'd be a good time to recap so that you can judge for yourself if you'd ever want to do it yourself. Personally, I think that Tim Ford (Twitter | Blog), together with his wife Amy, are doing better than ever in making the cruise both a top-quality learning experience and fantastic social experience. I've heard from many attendees that they learned enough in the first day or two to make the whole trip worthwhile and, keep in mind, some of these attendees paid for the trip out of their own pocket.

Loads of pictures at http://sqlcruise.com/cruise/past-cruises/sql-cruise-caribbean-2013/.

SQLCruise Content

SQLCruise is, first and foremost, a training event. On each cruise, Tim usually pulls together four or five very well known experts in the industry who, in turn present several hours training. Each day the ship is at sea is a day spent in class. Example of the agenda is on the lower right. When the ship is in port, it's a day of activity and adventures. Tim spends quite a bit of time coordinating with the speakers so that the curriculum is both unique and well tailored to the students.

But each and every night, whether at sea or in port, is spent in 'office hours'. For many attendees, office hours are their favorite part of the learning experience. Since Tim caps registration at 15 students, that means the students get virtually unfettered access to the experts. If you've ever attended a conference, you've probably encountered that common scenario where the speakers are busy with presentations and, at the conclusion of their session, are mobbed by attendees with questions. They're lucky to get 3-4 minutes of the speaker's time. On the other hand, the students get hours and hours to talk about whatever is on their mind. And since we're on a cruise ship in the tropics, office hours usually look like the image at top right. It's both very relaxing and very educational.

Another aspect of the content on SQLCruise that makes it unique is the amount of time spent on personal and professional development. The majority of attendees are not newbies. They're mid-career professionals who are doing well and their career and want to take it to a higher level. But as we often find, our earlier years in IT are spent learning how to be really good at the technology part of our career. We like technology and, sensibly, it's the immediate problem we face in day-to-day productivity. But as the years progress and we earn a few promotions, we come to find that rising in the ranks means a lot of communication and, gasp, office politics. The speakers, in many cases, have careers the students would like to emulate. This is where SQLCruise really shines. Imagine being able to pick the brains of senior technologists and managers in a friendly and welcoming environment. How great is that? In fact, many SQLCruise attendees (I know of several from each cruise I have attended) have used the professional counseling they received on the cruise to enact an energetic new phase in their career with big pay raises, exciting new jobs, high-profile blogs, and all sorts of other really cool things like that.

You'll have to suffer through excursions like Trunk Bay on St. John's in the US Virgin Islands.

SQLCruise Experience

Now that I've told you about the grueling educational side of SQLCruise, did I mention that we do all of this ON A CRUISE SHIP IN THE CARIBBEAN?!? The cruise ships are, if you will, an enormous Vegas hotel on the water. There are casinos, a constant parade of entertainment, live music, comedy, pools and water slides, discos and dancing, live game shows - the works. Ask Neil Hambly (Twitter | Blog) about the dancing!

Several of the sponsors also help to put on really fun contests and activities, some of which produce some really funny antics. There are fun scavenger hunts and other team relays which, if you can get over your inhibitions, are a ton of fun. Another aspect that makes the SQLCruise a unique experience is the fact that most attendees bring at least one other person, if not their entire family. That means that there are plenty of people for your significant other to hang out with while you're in class. Kids have built-in playmates, over and above the kids' activities that the cruise line keeps running around the clock. Lots of folks, including me, have also brought along a parent or several parents. They all have a great time and, in many cases, look forward to meeting their new friends again on a future cruise. Would it surprise you if I mentioned that most of the parents are not the type to start emailing each other as soon as they get off the ship?

Perhaps the most enjoyable aspect of SQLCruise for many attendees is that you're on a cruise ship in the Caribbean hundreds of miles from bandwidth. That means very limited connectivity. Although I've witnessed a student or two have to miss a class to put out some sort of fire back at the office, this is a really rare occurrence. In fact, it's much less common than what I've seen at the big conferences because you're so disconnected from all fast forms of bandwidth. Yes, there is an expensive sort of satellite connectivity on the ship. But your boss would have to be pretty desperate to keep you on the front lines while on one of these trips. Now I don't know about you, but my training events are always more enjoyable when I don't have the cares of the office weighing on my mind.

SQLCruise Instructor Allen White (Twitter | Blog) teaches about PowerShell for the SQL Server professional at right. Notice his casual but totally appropriate attire. Shorts, sandals, and comfy shirts are the norm even in class.

SQLCruise Cost

SQLCruise costs less than $200/day for the training. That compares to more than $300-400/day training costs of most commercial training centers who use the Microsoft Official Curriculum (MOC). On the other hand, there's the cost of the cruise itself. But again, the cruise is all-inclusive for lodging and meals (but not alcohol). So, for me at least, the cost of cruise itself was actually a little cheaper than a standard, nice American hotel chain like a Hilton, Marriott, or Sheraton.

Another, less tangible benefit of the expense of the SQLCruise is that the instructors are never unable to answer your questions, compared to many training centers whose trainers have never actually had a career built around the topic they're teaching. It's a huge difference.

Finally, if you're weighing the idea of paying for a trip like this out of your own pocket, consider that training expense are tax deductible. In my experience, probably a third of attendees cover their own costs. In a few cases, employers cover the training and the attendee covers their travel expenses. And for the rest, their employers cover the cost. Check out the FAQ and other resources on the website for tips on convincing your boss that this is the right training for you. As an aside, SQL Sentry gave away a full registration to the event - winner Mickey Stuewe is in the center of the picture at right. Congrats Mickey!

It's a great event and a great way to spend a week. I hope to see you at a future SQLCruise!

-Kev

-Follow me on Twitter

PASS Summit 2012, Slide Decks

KKline — Mon, 12 Nov 2012 17:02:00 GMT

Ok, I have to admit the painful truth. I'm reliably slow to the finish line. This year, I got my slides into PASS HQ by the skin of my teeth, the weekend before the event was to begin. Although I could say with a straight face "I uploaded my slides!". I have to be honest that I wasn't surprised when many of my attendees said that they weren't available for download by the time my session started. OTOH, I also have to say that I really do prefer for attendees to focus on the presentation while it's being presented and that they should grab the slides afterwards. But that's just my personal preference.

Having said all of that, I'm going to post my three session slide decks here so that you can grab them in case PASS has to take a while longer to get them posted. If you don't mind, the PASS program committee has introduced a new electronic feedback system. PLEASE PROVIDE FEEDBACK!

(Click on the session title to download the zip file of the slide deck).

PASS TV - Gaining Executive Support

This brief session is all about convincing your boss to do something you want - telecommute, make a big purchase of hardware or software, bring in a consultant, and so forth. See the PASS TV schedule for other sessions.

Winning Influence in IT Teams

Abstract: Ever wanted to convince the boss to try something new, but didn't know where to start? Ever tried to lead your peers toward an innovative, fresh idea only to fail to achieve your goals? This session teaches you the eight techniques of influencing IT professionals and the means of communicating your ideas upward to management and out to teammates so that you can innovate and achieve change in your organization. You'll learn the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority. You'll also learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them. And you'll discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.

Evaluate Session

Managing SQL Server in a Virtual World

This session rocked the house! We had standing room only probably at 20 to 30 minutes before start time. Our attendance was over 500, but we probably could've filled the biggest 700+ person room. A special thanks to my friend David Klee (blog | twitter) for tag-teaming with my like mega-nerd luchadors.

Abstract: Why are so many organizations implementing VMware, and what does it mean for SQL Server DBAs? In this deep-dive session, you'll see that when configured and managed properly, SQL Server can run just as well in a virtual environment as a physical one. We'll review the benefits VMware provides, including hardware abstraction, easier failover, and simpler capacity planning. We'll also explore key tips to help administer a SQL Server instance running inside a virtual machine. You'll learn the differences in general administration, disaster recovery, and high availability on VMs; get a better understanding of activity and performance trends on VMs; and learn how to ensure effective capacity planning and optimal performance on VMs. If you’ve ever had a virtual deployment go bad, or if you’re struggling to manage the performance of virtualized SQL Servers, be sure to catch this session.

Evaluate Session

Conquer Your Fear of Virtualization with a Free Day of Training at PASS!

KKline — Thu, 18 Oct 2012 16:50:00 GMT

Click this link to register: http://www.houseofbrick.com/education/sqlserverbootcamp/Registration.

Presented by my buddy, David Klee at House of Brick, one of the nations top VMWare consultancies specializing in Oracle and SQL Server deployments.

David has a great write-up of this boot camp at http://www.davidklee.net/2012/10/01/virtualizing-your-business-critical-sql-servers-free-boot-camp-by-house-of-brick/.

Secure Your Spot at the Nashville SQL Saturday!

KKline — Mon, 27 Aug 2012 14:50:00 GMT

PASS SQL Saturdays are free 1-day training events for IT professionals interested in Microsoft SQL Server, providing a variety of high-quality technical sessions, all happen through the efforts of local volunteers. The leadership team of the local chapter of PASS here in Nashville (Facebook | LinkedIn) have worked hard to make this year's SQL Saturday a day of great training and networking.

The local NashSQL leadership team includes yours truly (blog | twitter), Joe Webb (Twitter | Blog), Louis "Dr SQL" Davidson (Twitter | Blog), Christina Leo (blog | twitter), and Shelton Dickson (website). We also get a lot of operational help from Matt LeBlank (LinkedIn | Twitter).

We think you'll find it's a great way to spend a Saturday!

Register for the free community day with 5 concurrent tracks of hour-hour technical sessions running all day long: www.sqlsaturday.com/145/eventhome.aspx

Also, we are very pleased to announce the SQLSaturday #145 Pre-con event on Friday, October 12th. We have four paid sessions available from established industry experts. Session details are provided in the links below.

Please be aware that each Pre-con is priced at a staggeringly cheap $129.95 + $8.14 processing fee.

Registrations made by August 31, 2012, will receive an EARLY BIRD REGISTRATION rate of an $99.95 + 6.49 processing fee!!!

Don't miss out on this fantastic offer! Register now: SQL Satuday #145 PreCons

A continental breakfast will be served and tea and coffee will be available throughout the day. Lunch will be provided.

Come See Me. I'll Probably Be Just Down the Street Soon!

KKline — Tue, 31 Jul 2012 15:02:00 GMT

Even though I've recently changed jobs, I'll still be speaking at a lot of SQL events across the country and internationally. There are still a few trips that I've yet to finalize, in particular with the fine folks in Houston, run by my friend Nancy Hidy (blog | twitter), and my friends in San Francisco and Silicon Valley, run by my friend Mark Ginnebaugh (blog | twitter). Also, do to some missed deadlines, it looks like I won't be speaking at the Nordic SQL Rally this fall. My bad! On the other hand, you can see when checking my roster, that I hardly have time to catch my breath with this travel schedule.

I'll also be doing several on-line events with the PASS Professional Development Virtual Chapter, run by Mark Caldwell (blog | twitter), through out the year.

Here's what's on the docket up through the start of the holiday season: