Search results matching tags 'Conferences' and 'Best Practices'

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:

New York City

SQL Saturday 158, August 4

The Colorado User Group Tour

Boulder PASS user group meeting, August 14

Colorado Springs PASS user group meeting, August 15 (Register here for Colorado Springs PASS user group meeting).

Denver PASS user group meeting, August 16

Comatose, August 17 (Not an actual city in CO).

Orlando

SQL Saturday Performance Tuning Pre-Con, September 28

SQL Saturday 151, September 29

Online

SSWUG 2012 Fall vConference, Oct 2-4, (Please register using code 'VCKEVIN'. I will personally hug you, virtually.)

Lincoln

SQL Saturday Performance Tuning Pre-Con, October 5

SQL Saturday 165, October 6

Cedar Rapids

East Iowa PASS user group meeting, Oct 8 TBD

Quad City PASS user group meeting, Oct 9 TBD

Nashville (Go Titans!)

SQL Saturday Leadership Skills for IT Pros Pre-Con, October 12

SQL Saturday 145, October 13

Seattle

SQL Connections, Las Vegas, Nov 1-4

PASS Summit 2012, Seattle, Nov 6-9

Let me know if you're nearby and if you're coming to any of these events. I'd enjoy seeing you personally and getting a chance to shake your hand!

Hope to see you soon,

-Kevin

-Follow me on Twitter!

-More content at http://KevinEKline.com

SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

KKline — Mon, 23 Apr 2012 13:15:00 GMT

One last reminder - If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday. Full details are here: http://sqlperftuning.eventbrite.com/. We'll be working some exercises, so bring your laptop with an instance of SQL Server 2008 (or later) running on it. It'll be fun!

I also encourage you to come on down to SQL Saturday 130 the following day - whether there's an official registration for you or not. (But don't tell 'em I said that). :^)

Come by the booth for a visit. I'll be hanging out most of the day and have some nice swag to give away.

Enjoy,

-Kev

Follow me on Twitter!

Upcoming SQLSaturday Events in Omaha and Atlanta!

KKline — Wed, 17 Aug 2011 15:47:00 GMT

I've had enough time off from traveling after my surgery to finally travel again. First on the circuit , set for August 27th, is Omaha, Nebraska and SQL Saturday #91. As a former Crimson Tide alum, I was stoked about going to the University of Nebraska, our once and future rivals on the Grid Iron. But after a moment's confusion, I remembered that the Huskers are over in Lincoln, not Omaha. (May Bear have mercy on my soul.)

Almost all of the speakers are friends. Many are Microsoft MVPs. So it'll be great to catch up with these fine folks and, I hope, get a chance to meet many attendees. I'll be doing three of my favorite presentations: SQL Server Internals & Architecture, End-to-End Troubleshooting for Microsoft SQL Server, and Top Ten Most Crucial DBA Mistakes. As I write this, I realize that I've got to get busy and post those other slide decks in the slides section of my website!

I'll also be visiting a few customers for the two days before hand, signing a few books, and otherwise trying to be productive. In the parlance of my employer, that means helping with sales.

Next month, on September 17th, I'll be speaking at the Atlanta SQL Saturday #89. I'm presenting just one session at the event itself, though I'll be hanging out at the Quest booth much of the time. If possible, I'm also going to spend as much time as I can in Bob Ward's sessions.

In addition, I'll be presenting a full day pre-conference seminar on Friday, September 16th covering all sorts of SQL Server performance tuning and optimization content. There are only a few seats left, so if you're so inclined REGISTER HERE ASAP. All attendees will be getting a big goodie bag with posters, a signed copy of one of my books, and a T-Shirt.

Atlanta is an easy 4-hour drive from Nashville. And the weather is usually great in September. So this should be a fun event in every way!

Follow me on Twitter.

-Kev

How I Prepare For Presentations, And My Speaking Schedule For This Quarter

BuckWoody — Tue, 16 Aug 2011 14:04:45 GMT

I do a little speaking here and there and I’ve been asked about the method I use to get ready for a talk. I thought I might share the method I use, although as you read through this remember that not everyone has the same style, processes and procedures they use. As long as you feel prepared when you speak and the audience learns something from you, you’re doing it right. Still and all, it can be useful to see what someone else does to tune your process even further. Whatever makes your speaking better helps us all, including me, as I sit through quite a few presentations myself.

I do several types of presentations, from working with my direct clients at Microsoft in a very targeted and interactive discussion all the way to a full semester of classes at the University of Washington that lasts for several weeks. I also speak at technical events, and in all of these the audience size an participation levels vary. Even so, I still follow roughly the same process:

Develop The Concepts
Create Animations
Develop A Slide-A-Day
Practice
Tuning And Feedback

Develop The Concepts

When I’m asked to speak on a topic, I try and boil that down to one over-riding goal, such as “The listener should know how large-scale data sets can be handled”. Then I do a work-back outline of how that would happen - introduction, terms, define the problem, explain the options, provide specifics, detail references might be one example. Then I try to make that even tighter, until I start losing fidelity in the talk.

This is where the duration of the talk and the audience makeup is most critical. The shorter the period of time I have to talk, the lower I set the goal. I’ve seen people try to cram a complex set of information in an hour, complete with demos. At the end I certainly have an exposure to the information, but I don’t know that I have retained it. I would rather the speaker focus on one specific part of that deep topic or simply provide an overview and then point me to relevant resources I can study in detail later.

The key is what the audience retains when the talk is over. If they think “wow - that speaker is really smart” that’s actually a failure. They should think “wow - I’m really smart, and now I know how to do that thing the speaker talked about”.

Each of these concepts then becomes a logical flow of mini-goals, and many times, these map to a slide or whiteboard graphic.

Create Animations

It doesn’t matter what tool you use - somehow you need to convey your information to the audience. In some cases, I can draw “word pictures” simply by talking, but technical topics often lead themselves to graphics. I’ve used whiteboards, Power Point (don’t make that face) and even Microsoft Paint with a Wacom Tablet. I try to show a start-to-finish process, or layer components to slowly cement in the listener’s mind what I want them to know.

The rule of thumb I use is to show one piece of a system at a time, to show a larger more complex whole. To show how that system interacts with another, I use animations. All of these are done as simply as possible, using the least flashy animation I can. Any technology I use should be to get the point across, not to show how many fonts and explosions I can cram onto a screen.

I find that almost every concept I developed in the previous step warrants it’s own slide or drawing. If I have too many, say more than 8 or so for a one-hour presentation, then I have too many concepts for a single presentation, or I’m making it too complex. If I have lots of lists on the screen and not many graphics, then I’m reading notes and not setting up a dialog with the audience. Creating a graphic per concept keeps me from many of these errors.

Develop A Slide-A-Day

Speaking isn’t my full-time job, so I have lots of “real” work to do. So after I’ve gotten the concepts down and turned them in to graphics, I take one slide each day when I can and work through the detail of the concept I’m talking about. If I’m using Power Point, I use the “Notes” view to put down the text I want to cover, the references I find on the web, in magazines and books, and the other speakers I credit during the presentation. I give that out electronically after the presentation, since I don’t want people focusing on my notes while I’m talking - I would much rather they listen carefully and take their own notes. Even so, sometimes there are processes or procedures that I need to show. When I don’t show it on the screen, I show it in the Notes view. If I’m using some other medium like a whiteboard, I usually blog the information and then show the link to my blog.

Practice

This is probably the most skipped step I see in new presenters. Yes, you have to sit in front of a mirror. Really. And yes, you have to say what you’re going to say, and time yourself. Really. It feel awkward, and it should. And you need to do this. Really.

I use the “Presenter View” in Power Point. It has the slides (so that you can see the next one coming), the Notes you made, and a timer. It’s a great tool even if you aren’t going to use Power Point in your talk.

But you have to practice. I try to practice my talk at least five times. Interestingly, this isn’t so I’ll say the same thing the same way every time. In fact, it’s quite the opposite. It helps me feel more confident in the information, and allows me to “wander” slightly during the talk and be more dynamic, because I know what I need to get across - I’ve practiced it.

Tuning And Feedback

If time permits, I try to deliver the talk at work or to my wife. I give the audience a feedback sheet with what I want to know, so that they will be critical without being mean. I try to do this with as many different audiences as I can. Based on what I hear back, I may adjust or tune a section to ensure that I get the information across.

So what’s on that sheet? Well, things like “How was the speed? Did it seem like I knew what I was talking about” and so on - but there’s one part that is pretty interesting. I give them a test. I make questions that I should answer during the talk, and at the end I hand out the paper and see if they get those answers. If they don’t it’s my fault. End of story. I either picked people that don’t care about the topic, or don’t listen, or who aren’t interested in helping me. All of those are my bad. If I do an effective presentation, I move the knowledge of the topic from my head to theirs. That’s success.

Speaking Schedule

If you’re interested in seeing the result of this preparation style, I ‘d love to have you join me. I enjoy meeting the folks that read this blog, so if you’re near any of these events then stop by and say hello!

09/23-24/2011 - Orlando, Florida

SQL Saturday 85 - http://www.sqlsaturday.com/85/eventhome.aspx

I have two presentations at this event:

SQL Server Performance Tuning Using Application Path Analysis

There are a lot of resources, products and features you can use to tune the performance of your SQL Server system. Many assume you’re familiar with 400-level concepts, others don’t consider the whole stack of the client, the network, the operating system, platform and the database server. Buck Woody, Microsoft’s real-world DBA, will explain a simple, repeatable process you can follow to tune your entire application – from the client to the server. All of the tools we’ll cover are included with Windows and SQL Server:

In this pre-conference session you’ll cover not only the process, but also review a real-world evaluation. You’ll take home a system and a spreadsheet you can use to monitor and tune your applications, in a simple, easy-to-understand session.

The Saturday event is:

Cloud Computing De-mystified

The cloud! Move everything to the cloud! No, wait, the cloud is awful! Don’t move anything to the cloud! Wait – what’s “the cloud”? Buck Woody, Microsoft’s “Real World DBA” will show you how to figure out where your data should live, based on actual decision points. You’ll learn about Windows and SQL Azure, and when it makes sense to put data locally or remotely.

10/08/2011 - Portland, Oregon

SQL Saturday 92 - http://www.sqlsaturday.com/92/eventhome.aspx

Hybrid Database Systems

With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work.

10/11-14/2011 - Seattle, Washington

Professional Association for SQL Server (PASS) Conference - http://www.sqlpass.org/Events/PASSSummit.aspx

Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications

Despite all the hype, it’s rare for a business to actually “move” an application directly to the cloud. The cost, risk and effort aren’t usually worth the benefit of what you gain. Security considerations, performance, and control are just a few of the reasons that many applications need to stay in your datacenter. But there are times when including a function from the cloud makes a ton of business sense, either to extend part of your internal applications to remote workers, customers or partners, or to act as a HA/DR solution.

In this session, Buck Woody (Microsoft Senior Technology Specialist on Distributed Computing) will talk about how you can embrace Cloud on Your Terms through SQL Server Code Name "Denali" and Windows and SQL Azure architectures, and the considerations for creating a hybrid architecture across on-premise databases and cloud technologies. You’ll learn:

How to create a decision matrix for which elements can be extended to the cloud

A Windows and SQL Azure technology overview, code name Juneau, and DAC Fx

Component options for hybrid solutions, including:

SharePoint

Biztalk

.NET applications

Non-Microsoft languages and technologies

Other RDBMS’s

You’ll receive references, whitepapers and other resources you can use to evaluate your own architectures to see how you can use a secure, high-performance system that expands and contracts as needed.

10/11/2011 - 12/14/2011 - Seattle, Washington

University of Washington - http://faculty.washington.edu/woodyg/

SQL Server Essentials

This course will introduce the student to Microsoft’s SQL Server database management system. Topics included are relational database concepts for production database applications, SQL programming, and SQL Server tools. This course will introduce advanced topics -- at an overview level -- that will be presented in more detail in subsequent courses. The course involves instruction, course studies, and a project that will be completed from requirements to delivery.

During the course you will design a relational database structure from a set of business requirements, developing a graphical Entity Relationship Diagram (ERD), writing Transact-SQL code for the creation of all database tables, views, stored procedures, security, indexes and maintenance scripts for a sample system. Your final project will be the entire system creation, delivered as a series of scripts, along with the ERD and pertinent conceptual documents in a SQL Server Management Studio (SSMS) Solution.

Funny Things You'll Hear at the "Leadership for IT Professionals" at the 2011 SQLRally

KKline — Mon, 18 Apr 2011 23:14:00 GMT

The 2011 PASS SQLRally is just about one month away and it's high time I highlighted some of the important things you'll be hearing about in my precon seminar Leadership and Team Management Skills for the IT Professional. Just to set the context, many of us IT people got to our lofty career positions because of our keen use of technology. It takes a lot of smarts to get where we've gotten, but they are a very specific set of smarts that can't always be used in every business setting. And, since so many of us have topped out in our potential salary as long as we stay in the trenches and the only do technology work, a lot of us are starting to eye those middle manager positions so that we can continue to see our career grow. The only problem is that all of those skills that enabled us to become top tier technologists don't transfer into the management arena. I'll be teaching a wide variety of soft skills and specific management checklists to help you survive those early transitional days. And if you're not a manager? You'll still want to attend because the wide variety of communication skills we'll cover will help you stay on top of many other real life situations, from leading the local Girl Scout troop to taking a role on the local PTA organization. You can read the full and pedantic session description at the link I provided up above. But here's a list of Five Funny Things You'll Hear in the Precon:

"Here's where we get out the whips and chains..."
"In this section, we're going to learn how to manage our managers..."
"And then I was, like, OMG. And she was, like, LOL. And her cousin was, like, ROFL. But then I was, like, meh..."
"Darth Vader would be proud..."
"The beatings will continue until morale improves!"

And one bonus:

"That's what she said..."

Did I put these in context, heck no! But it's a fun session, with some practice labs and LOTS of content to help you make that transition from full time technologist to part- or even full-time leader! I hope to see you there. -Kevin Twitter at kekline

See You in St Louis, and then London, Amsterdam, Copenhagen, Stockholm, and York, UK

KKline — Tue, 07 Sep 2010 20:55:00 GMT

Good grief, there's a lot of travel in my future. <sigh ... deep breath> It'll be exhausting and it'll be hard to lose so much time with the family. But if I'm able to avoid travel mishaps, it'll be fun.

Meet Me In St. Louis

I'll be speaking in St. Louis, MO on Tuesday, September 14th for their mid-day meeting. The details, as I have them, are:

Tuesday, September 14, 2010 1-4pm

Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO 63141

http://www.microsoft.com/about/companyinformation/usaoffices/northcentral/stlouis.mspx

Parking is in the garage behind / next to the building. There is an entrance to the building from the 2nd floor in the garage.

Additional details and instructions on how to log in

Speaker: Kevin Kline, Quest Software Topic: SQL Server Internals and Architecture

Speaker: Kevin Kline, Quest Software Topic: SQL Statement Tuning with Query Optimizer Strategies

I'll be giving away free t-shirts, posters, an eBook or three, and backrubs (super-models, only).

SQL Bits, On the Cheap

I’ve tweeted previously about the SQL Bits conference in York on September 30th – October 2nd, but this is my first blog post about it. Now is the time to settle your plans to attend. And while you're settling those plans, take advantage of Quest Software's 20% discount on the Thursday and Friday sessions requiring payment. Just be sure to use the code QST20 when you register. The Saturday is free for everyone. Note - I said FREE. So if you're struggling to convince your boss of the value of the time off and cost required to attend these events, then at least plan to attend Saturday. But as you can see here, the prices are quite low compared to most other conferences of similar quality. I firmly believe the standard for speakers and content at SQLBits is second to none in the UK. I'll be a wallflower in comparison to other friends of mine also speaking at the event, such as Brent Ozar, a MCM SQL Server and former colleague now working with SQLSkills, Buck Woody, the well-known "Real World DBA" and senior technical specialist from Microsoft, as well as many other SQL Server MVPs, authors, and speakers, such as the event organizer, Simon Sabin, and Quest Software SQL Server expert and editor-in-chief of SQLServerPedia, Iain Kick. Some sessions I'm looking forward to include:

Monitoring and Tuning Parallel Query Execution - Part II – R Meyyappan
Where the bl**dy h*** are you? (Spatial Data Visualisation) - Rob Farley (all the way from Adelaide, Australia)
Introduction to Performance Analysis and Tuning – Simon Sabin
Oracle for SQL Server DBAs – Gavin Payne
Lies, Damned Lies And Statistics. Making The Most Out of SQL Server Statistics - Maciej Pilecki
Extreme scaling with SQL Azure – Martin Schmidt
Automating SSIS - Andre Kamman

Attendance will definitely enhance your skills and ability to do your job. The added bonus is that York is a lovely place to visit with a beautiful and storied cathedral, so I highly recommend the event for all SQL Server professionals. Prior to SQLBits, I'll be presenting in London, Amsterdam, Copenhagen, and Stockholm. I hope you can attend an event closer to you if you cannot make it to York!

And Just to Make Sure I'm Thoroughly Frozen...

While I usually have a policy against visiting places cold enough to die between the front door and the mailbox, I'll be stopping in at SQL Saturday 58 in Minnesota for a SQL Saturday taking place on Friday (not a typo), October 29th, the day after my birthday. I'll be 21 years old and, since I'm now of legal drinking age, you should by me a drink. The event organizer, as well as my friend and fellow MVP, Jason Strate, just has to be different by holding the event on a Friday, eh? Track the event on twitter using the hash tag #sqlsat58. Read all the details here and register asap!

Once finished in Minnesota, I'll barely get a breather in before heading right back out for the big PASS 2010 Summit in Seattle from Nov 8 -11. Hope to see you at one of these events soon!

Best regards,

-Kevin

Twitter @kekline