Search results matching tags 'PASS' and 'Administration'

The Year That Was - 2012

KKline — Mon, 31 Dec 2012 19:31:00 GMT

2012 was, simply stated, a year that kicked my butt. When I wasn't struggling professionally, I was struggling personally. Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles. I apologize to those of you who are normally on my Christmas card list for not sending any this year. The wind was not in my sails. On the positive side of the ledger, I made a scary but exciting leap to SQL Sentry midyear. This was a huge shake-up after 10 years with my previous employer, but one which has been met with unbridled enthusiasm everywhere I've gone. Thank you for the handshakes, high-fives, and hugs! We're doing some really exciting things at SQL Sentry (such as SQLPerformance.com and Plan Explorer Pro) and I hope to engage with you more than ever in 2013.

Blogging Activity, Plus Leadership Skills & Professionalism

2012 marked a bit of a shift in my content creation direction. I've seen an uptick in struggles in the non-IT part of our career - communications, leadership, motivation, goal-keeping, all of those sort of things. I feel like I have some wisdom to contribute in that space. So, in addition to technical blog posts, I been putting down more of my experiences and lessons learned on the interpersonal side of the IT career path. My top ten blog posts for the year reflect some of that new direction:

Do You Have One of "the Three W’s" to Sit on a Board of Directors? -- Important tips for any IT pro considering a role in strategy and executive leadership.
Timewarp: What Is a Relational Database? -- With all the talk about NoSQL databases, let's go back to the fundamentals.
Want Another Reason to Hate iTunes? -- A throw-away article that precipitated a maelstrom of comments. Them Apple fanboys are passionate!
Why Do IT Pros Make Awful Managers? -- Not all IT pros make awful managers, but when they're awful it's often for similar reasons.
High-Availability White Papers and Resources for SQL Server -- Read the latest about AlwaysOn Availability Groups, and more.
New White Paper: SQL Server Extended Events and Notifications -- SQL Server 2012 great augments the Extended Events feature set. Find out how.
Build Your Own Microsoft Operations Management Pack -- Resources to build out your own SCOM management pack.
Help Me Update the History of SQL Server -- I started with SQL Server when it was still an OS/2 product. Jeesh! Lots of versions have come out since then.
TIE: Recorded Webcast Available: Extend SCOM to Optimize SQL Server Performance Management and The Expert's Conference (TEC) - For AD, SharePoint, Exchange, PowerShell and Other Admins -- Pointers to a webcast about extending SCOM and the TEC conference.
A Fond Farewell to Quest Software -- I learned so much in 10 years at Quest Software.

As I mentioned in the opening paragraph about blogging, I'm putting more energy into best practices for professional growth among IT pros. Along those lines of thought, I started a website called ForITPros.com with my long-time friend Joe Webb (Twitter | Blog) and, in partnership with SSWUG, developed a 2-DVD set and streaming media class called Leadership Skills for IT Professionals containing 14 hours of leadership and soft skills training specifically crafted for IT teams.

I've also been working with PASS on the Professional Development Virtual Chapter (VC), led by Mark Caldwell (Twitter). We've already got a full year of content schedule and are trying to figure out how fit in more sessions. Maybe moving to more than one webcast per month? The PASS Professional Development VC archive has lots of great content for you to review and future sessions are detailed at the PASS Professional Development VC homepage.

In-Person Activity

2012 was busy where I actually appeared in person or put in a big effort to write or create content. Here's a run-down: Articles (2), Conference Spoken (12), Customer Calls (88), Customer Visits (4), Magazine Columns (14) at SQLMag.com and DBTA.com, New Books (1) with Ross Mistry, PASS Chapter Presentations (12), Pre-cons/Full-day Seminars (4), SQL Saturdays (4), SSWUG Sessions (4), TechNet Radio Broadcasts (2), Technical Book Reviews (3), and Webcasts (10).

In 2013, I expect to travel a bit less. But I also expect to do many more webcasts. Let me know if you have some ideas about what you'd like to learn! One business trip that I refuse to give up, though, is SQLCruise. (Register!) I know it sounds like the worst possible way to learn. I mean who'd want to learn on a cruise ship in the Caribbean?!? (I hope you could detect the sarcasm dripping from those two sentences.) But here are two favorite aspects of of SQLCruise that are totally ferreals - 1) You simultaneously can relax and focus on learning. You are disconnected from the mainland. You don't have to worry about the mobile phone going off. 2) You get extended ours in a intimate setting with the top talent in the SQL Server world. It's always a pleasure to attend a conference session from the best in the industry. But you'll get hours of time to talk with these veterans of the industry about your specific problems and situations. It just doesn't get better than that.

Social Media

It's hard to believe that only a year ago, 2011, was my first year on Twitter. By years end, here's where my stats had moved: 5,507 tweets (up from 3,452 tweets), 661 following (up from 531), and 3,720 followers (up from 2,656) . I didn't check my social media numbers last year, so I've got no point of comparison. But I'm currently sitting at 2,327 LinkedIn connections and 1,157 Facebook friends. One of my standing policies on Facebook is that I don't "friend" someone who I haven't personally met. That doesn't help detangle the hopeless mess I've created by having only one identify on Facebook, both personal and public. So, on the one hand, I owe all of my longtime friends a big apology for all of the SQL talk and, on the other hand, a big apology to all of my professional friends for not posting enough news and advice while dilute my status updates with personal minutia. Oh well - it is what it is.

My blogging activity for 2012 was the lowest it's been in many years, down to 44 entries, down from 77 in 2011 and well into the hundreds in 2010. My answer to that sort of doldrums for 2013 is to get sloppy! And by that, I mean less of a perfectionist and more of a content machine that just cranks it out! Most of you, as my readers, have been very forgiving of a misplaced verb, a missing punctuation, or -heck- a totally malformed sentence that makes no sense at all. So I'm going to try much harder to churn through the 700+ nascent blog posts in my notes folder and get those ideas out there!

I hope to see you following me on Twitter soon! Thanks,

-Kevin

Let's Talk Licensing and Virtualization for SQL Server

KKline — Thu, 13 Dec 2012 19:23:00 GMT

I have two new articles up on Database Trends & Applications magazine. I'd love to get your thoughts and feedback!

Welcome to the Weird, Wild World of SQL Server Licensing

Not long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first and easiest path was to buy your SQL Server license with your hardware. Want to buy a HP Proliant DL380 for a SQL Server application? Why not get your SQL Server Enterprise Edition license with it at the same time? Just pay the hardware vendor for the whole stack, from the bare metal all the way through to the Microsoft OS and SQL Server....

DBTA E-Edition - December 2012 Issue

Virtualization Conquers the Database

I was privileged to deliver a session entitled Managing SQL Server in a Virtual World at the PASS Summit 2012, the largest annual conference for Microsoft SQL Server. It was a packed house, literally at standing-room-only capacity. I delivered the session with my friend David Klee and we were swarmed by attendees after the session wrapped up. With almost 600 people in the room, we conducted one of those informal polls that speakers like to do along the lines of "Raise your hands if …" and the informal findings were very telling. Probably around 90% of the attendees used VMware and SQL Server in some capacity and at least 60% used it in production environments. Another important fact was that only 10% of the attendees were actually able to get information on the performance of the actual VMs themselves. Most had to get all of their information and support from the VM / System administration staff....

DBTA E-Edition - November E-Edition Issue

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/.

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

Is There Such a Thing as Easy ETL?

KKline — Thu, 30 Jun 2011 04:57:00 GMT

E.T.L. That's Extract - Transform - Load. That doesn't sound like a lot of work when all you need to get loaded is a simple Access database or an Excel spreadsheet. In a situation like that, the process is so simple, all you really need to focus on is the L in ETL. There's not a whole lot of E.T. to process, despite how wonderful that movie is. [pun intended] But as soon as your data loading process involves some difficult or sophisticated cleansing or transformations, it gets really, really hard. The other cross-thread that had really caught my interest lately is the USA federal governments Open Data Initiative. I think it's remarkable that President Obama is the first president to appoint a federal CIO. (Shouldn't that have happened in the past?) In addition, President Obama instructed the entire executive branch to open up their data (where security isn't at risk) and make it readily available to the public. And the US government collects mountains of interesting and valuable data for its own uses, but figuring out how or who to share it with was always an afterthought. While I was a contractor for NASA, for example, I worked on some incredibly interesting projects which yielded amazing and commercially valuable information. It was all public domain. But unless you knew it was there, you couldn't get to it. Making use of all of that data always intrigued me. Now, with ODI, it's all being put on the internet at an ever-increasing rate at Data.gov. However, all of this data, while open and available, is not standardized. Some data sets might be a CSV file, while others might be something like a spreadsheet. That means you'll need to extract, transform, and load that data if you want to synthesize more valuable data sets. For those reasons, I've been researching tools to help make this process easier. (I also wanted to research SSIS and ETL tools for my Tool Time column in SQL Server Magazine.) Now, I've been following expressor software for quite some time and really like their unique approach. (I actually ran into the expressor software team at a PASS Summit one or two years ago and asked for a demo of their software. And I really liked what I saw.) Rather than the workflow approach used by SSIS, expressor software uses a data mapping approach combined with reusable business rules. Their mapping approach is fundamentally different from the traditional point-to-point, source-to-target mappings paradigm. Basically, you can define a semantic type representative of your business data, create a business rule(s) to apply to the data, and then implement a "canonical" mapping which connects data sources and targets to that same semantic type. And it's free!

Abstraction is Awesome

What's cool about that? Don't forget that "semantic" means "meaning". So a semantic type is an abstraction of the meaning of the data. The net result is that expressor shields your data integration application, with its associated business and transformation rules, from changes that might occur to underlying target or source files with different field names and data type representations have to be processed. For example, let’s assume that you need to process invoices from different vendors in slightly different formats. If you use a traditional ETL tool like SSIS, any changes in the source and/or target formats will require you to modify your data mappings and transformation rules, because the mappings are tied directly to the metadata structure of the invoice file format(s). expressor, on the other hand, lets you define a common “invoice” semantic type, build all your downstream data processing off that type and map one or multiple invoice file schemas to the type. This approach greatly simplifies the mapping process and provides for more flexible data integration applications that can be more easily adapted to changes in the source and target data sources.

Benefits Abound

Since the semantic types in expressor are captured as reusable artifacts, you can also reuse them again in new data flows within your project(s). You can even share them across your entire organization. As I tinkered with the expressor Studio tool, I hit on a few other benefits with this approach:

Handles data type conversions automatically without having to write data transformation rules for these conversions
Builds new semantic types from existing types and reuses types in existing and new applications
Creates multiple, reusable business rules against a single type and applies them repeatedly as needed
Easily implements data quality rules and constraints

In an Ideal World...

In an ideal world, I'd figure out some brilliant way to make money from bringing together all kinds of that government data that I used to work with. Other folks are doing it at the Windows Azure Data Market. But in the meanwhile, I'm also looking forward to tinkering with this data to build better demos. Along the way, I'm going to use the expressor Studio desktop ETL tool (Did I mention that it's free!) as well as tell you about my experiences as I try to build out some Data.gov data sets. Those of you who know me, know that I look a good discussion and cooperative, constructive team work. So I encourage your feedback and suggestions, as I work through these data integration challenges and share my experiences. I'm looking forward to sharing with you my insights on what the expressor data integration software can do with this challenge and what some of its features and capabilities are. In upcoming releases, I'll let you know what I find intriguing and worth mentioning. Check out their website, www.expressor-software.com, to learn more about their company and products. Enjoy, -Kev Follow me on Twitter More content on KevinEKline.com

NOSQL- A Quick Overview

KKline — Fri, 03 Jun 2011 03:55:00 GMT

Several attendees at the SQLRally were asking about NoSQL ("Not Only SQL") and its benefits. This article gives a quick overview: HERE.

Also, two good resources have come out from my friend Guy Harrison. This piece on Cassandra, one of the most popular NoSQL databases, was published a while back in Database Trends and Applications Magazine. I also really liked these entries from Guy at TechRepublic and TechTarget. Guy also had the good fortune of having one of his articles published on GigaOm and then picked up in the New York Times Technology section.

The article, titled “Real World NoSQL: HBase at Trend Micro,” is the first in a five-part series Guy wrote, spotlighting NoSQL (non-relational) database deployments at five different companies. The other good learning experience for me was hearing about GigaOm for the first time. GigaOm, now on my reading list, is considered an influential and prestigious publication in the NoSQL realm.

Let me know what you think. Enjoy!

-Kev

~~~

Twitter at kekline

Back in Atlanta! Wed, Feb 9 2011

KKline — Mon, 07 Feb 2011 17:04:00 GMT

I always enjoy spending time with my friends from Atlanta, as well as meeting folks and making new friends. If you live in the Atlanta area, I hope you'll join me on the evening of Wednesday, February 9th, 2011. Details are at the Atlanta SQL Server user group website.

It's common knowledge that I have a terrible memory for many things. However, one of the few things that my memory is usually really good at is remember names & faces (and remembering stories, but that is another story as well).

It's only in the last couple years that I've gotten to know Atlanta-area folks like Aaron Nelson (blog | twitter), at left. Aaron likes to tease me because the first time or two we talked after our initial introduction, I kept getting his name wrong. That's uncharacteristic of me. But, hey, I was distracted because Aaron had brought his 12 year old daughter along and I kept wishing that I'd brought mine!

Aaron has really good content on SQL Server and PowerShell on his blog and in his presentations. Don't miss out!

Another person in the Atlanta area I've enjoyed getting to know better is Stuart Ainsworth (blog | twitter). Stuart has really stepped up to the plate these last couple years as a leader and a volunteer. I'm really impressed with his efforts, especially because they're in very important but rather invisible and thankless tasks. One example is his work in succession governance for PASS. Stuart, I salute you and thank you for your efforts. I hope to see y'all there! And if I don't, y'all come up and visit us in Nashville some time.

Cheers,

-Kev

Twitter at kekline

Education and Career Resources from Microsoft and the Community

KKline — Fri, 28 Jan 2011 13:49:00 GMT

Sometimes I'm timely in getting the news out on useful resources. And, other times, I'm a bit slower on the draw. As I told my friends back at New Year's Day, "As an official member of the Procrastinators Club, welcome to 2008!" On the other hand, it's always good to remind folks of great resources that are still available and on the shelf. Why? Well, the Internet hits us with such a deluge of constantly new material, that we often forget about the old(ish) stuff that's still really useful.

Darth Doofus, Emporer Palpatine, and Darth Goofus

Quest vConference for SQL Server

One of the most popular teaching sessions I ever engaged in was the Quest vConferences for SQL Server in 2010, with my good friends Buck Woody (blog | twitter) and Brent Ozar (blog | twitter).

These are evergreen favorites for their strong technical content and, perhaps, an outpouring of Brent's faux chest hair in the latter part of the training events. Go to this URL for the code samples, download the slides, and to rate the presentation: http://questkb.com/live and or http://www.vconferenceonline.com/shows/spring10/quest/conference/ondemand.asp. You can also get the full events shipped for free anywhere in North America on a single DVD.

24 Hours of PASS Celebrates Women in Technology

Kalen Delaney, author and expert, and one of the initiators of WiT within PASS

It's always a big thrill for me when a successful initiative launched by PASS goes viral. One such example is the 24Hours of PASS. (See last year's webcasts at http://www.sqlpass.org/24hours/2010/). I now see other industry trade groups and technology user groups launching their own 24 Hours type webcast marathons. Kudos - PASS folks thought of it first! (I'd give proper credit, if I could only remember who thought of it. Rick Heiges (blog | twitter), I think).

This year, 24 Hours of PASS is gearing up for an exceptional lineup of SQL Server and BI experts in 24 one-hour technical webcasts. This free training event takes place over two 12-hour days March 15-16, with each day beginning at 12:00 GMT (UTC). Click here to get registered: http://www.sqlpass.org/24hours/Spring2011/. And in celebration of Women in Technology, PASS is hosting an all female line-up of speakers.

This is another area in which PASS has prompted many emulators. My memory of the details grow dim, since this was almost ten years ago, but I believe it was then PASS director Kalen Delaney (blog | twitter) and Microsoft liaison to the board Jacqueline Borges who put forward the idea of hosting a special Women in Technology luncheon. Since that time, WiT has gone on to be one of the best parts about the big PASS Summit and something widely emulated by other professional and trade associations.

Microsoft Thrive - Career Planning Insights

I was honored to be a featured speaker on the Microsoft Thrive website about this time last year. What's Thrive? It's a website put together by Microsoft that helps you plan out your career. It has certification and learning resources, career paths, and traditional learning patterns and practices. In other words, it tells you what you need to know to qualify for various kinds of it jobs and then gives you links to dive deeper. Check it out!

http://www.microsoft.com/click/thrive/

Enjoy!

-Kev

Twitter at kekline

It's the Atlanta Attendance Contest!

KKline — Mon, 12 Jul 2010 15:02:00 GMT

I'm speaking tonight on Top 10 Mistakes DBAs Make at the Atlanta SQL Server User Group meeting in Alpharetta, GA. You can find all of the details here.

The Best Dang Design Book for SQL Server Professionals - EVER!

I thought I'd liven things up a bit with a little contest. The rules are simple:

A. If you don't follow me on Twitter, then follow me by clicking here.

B. If you already follow me on Twitter, then tweet the details for tonight's event.

C. Every new follower or current follower who retweeted the details and then attends the event tonight will get a free ebook for Professional SQL Server 2008 Design and Implementation by my buddy and fellow Nashvillian Louis Davidson (blog | twitter).

As the fine print usually says, "Must be present to win". But just to liven things up a little bit extra, I'll pull several names from the hat of all the folks who were NOT present but followed or retweeted the event details between now and 6:30 PM EST tonight.

Thanks and good luck!

-Kev

Search results matching tags 'PASS' and 'Administration'

The Year That Was - 2012

Blogging Activity, Plus Leadership Skills & Professionalism

In-Person Activity

Social Media

Let's Talk Licensing and Virtualization for SQL Server

Welcome to the Weird, Wild World of SQL Server Licensing

Virtualization Conquers the Database

PASS Summit 2012, Slide Decks

PASS TV - Gaining Executive Support

Winning Influence in IT Teams

Managing SQL Server in a Virtual World

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

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

New York City

The Colorado User Group Tour

Orlando

Online

Lincoln

Cedar Rapids

Nashville (Go Titans!)

Seattle

Is There Such a Thing as Easy ETL?

Abstraction is Awesome

Benefits Abound

In an Ideal World...

NOSQL- A Quick Overview

Back in Atlanta! Wed, Feb 9 2011

Education and Career Resources from Microsoft and the Community

Darth Doofus, Emporer Palpatine, and Darth Goofus Quest vConference for SQL Server

24 Hours of PASS Celebrates Women in Technology

Microsoft Thrive - Career Planning Insights

It's the Atlanta Attendance Contest!

Darth Doofus, Emporer Palpatine, and Darth Goofus

Quest vConference for SQL Server