Archive for the ‘SQLServerPedia Syndication’ Category

Must-Have Resources – SQL Server Backup & Recovery

Thursday, December 8th, 2011

One of the things that drives me crazy as I’m getting older is that my brain is losing the capacity to differentiate version numbers.  As I speak travel around speaking with customers and at conferences, I find my self saying things like “I can’t recall if this problem was fixed in SQL Server 2000 or 2005. But you don’t have to worry about that any more.”  Or things like “That feature was added in SQL Server 2008 R2, eh, or was that version 6.5.  DOH!” followed by a loud slapping sound as I whap my palm into my forehead.

The Internet doesn’t forget either.  Recommendations that were once helpful, if not outright essential, now are neutral or even downright bad. So now, whenever I put together new presentations, I always spend a lot of time in research, reassessing my knowledge on the topic.  (That doesn’t mean that I’ll extemporaneously say it wrong, because I speak in an off-the-cuff and rapid style. But at least my notes are usually correct).

 

Case In Point

Take backup and recovery (B&R), for example.  I’ve been writing about and performing B&R for years.  I’m even part of the team that builds the most popular B&R tool in the SQL Server space.  It’s an extremely important part of what I do.  And yet, even after spending a couple days re-researching topics (yet again), I still manage to get a few of the more specific details wrong because of changes over the years in the feature set.  How so?

During an Expert’s Perspective webcast last week (and available on-demand) covering the top backup and recovery mistakes on Microsoft SQL Server, I mis-explained the details concerning how SQL Server performs a differential backup.  A very clever SC on our team who was also attending the webcast pointed out to me after the session that I’d described differentials working at an 8k page-level when, in fact, they work at the extend-level (that’s a block of eight 8k pages). #FACEPALM!

When describing the differential backup I said that a bit was flipped on each page header and SQL Server would only back up those pages. Instead, whenever a page is changed a bit is recorded on the differential change map (1bit per extent), the backup process then queries these map pages and backs up those extents that have been marked as changed.

 

The Research Reveals

The cool revelation here is not that I can admit my mistakes.  The take-away from this blog post are all the great articles I read writing my latest slide deck.  These blogs and articles were so good that I needed to spread the word.  Add these to your must read list:

Virtual Log Files must be tamed!

Backup and Recovery Myth Busting

Other Good Sources

And just in case you need a refreshing in the basics of SQL Server backup and recovery, check these out:

Information Hoarder No More!

Wednesday, November 2nd, 2011

I hate to admit it, but I’m a hoarder.  Yes, like those insane people on the A&E TV show.  Only my hoarding is all virtual.  For example, take the image above.  That’s just a tiny part of my Google Reader home page.  That’s a tiny part of my Google Reader home page AFTER reading most of the day on a recent Sunday. I still had thousands of entries to go after hours of reading.  On top of that, I subscribe to some technical e-newsletters.  I’m a member of quite a few LinkedIn discussion groups, each of which produce daily and weekly newsletters. (I only subscribe to the weekly versions).  Then there’s Twitter too.  In all, there are THOUSANDS of interesting floating through the ether which I’d been trying to collect and, occassionally, read. Bah humbug!

The Downside of an Information Hoard

You might think that, as an IT professional, hoarding information is good for you.  After all, the more you know, the more effective you are at your job, right?  Uh – no.  I’ve discovered a few downsides to keeping all of this information around.  First, I lose time on administrivia, uh, I mean administration.  I can’t think of a time when a search on Google has not produced the information that I’m interested in.  So by spending time keeping up with my blog feeds, adding new blog feeds, deleting old ones, and so on, I lose time administrating something that really doesn’t need to be administrated.

Second, there’s the time it takes to read all of these entries – many long hours to read thousands of entries per month. I’ve actually figured out a little trick to make this go a lot faster. What’s that trick? Well, previously, I used to start reading my entries and then clicking “Next Entry” each time. Even when I skipped a lot of entries, just slogging through them all was a big time drain.  Now, I simply select large swathes of entries that I’m not interested in and click “Mark as Read” without ever opening them. Works great!  I’ve also gotten a lot more aggressive about dropping bloggers and RSS feeds that offer low value.  A lot of bloggers have popped up who only recount things which are available in Books On-Line.  Why spend any time on that at all?  I’m looking for strong insight, experiences, and analysis – not simple technology facts.  (A follow on thought to this tip is that “Bloggers Should Write Meaningful Article Titles!”)

Third, and more importantly, information hoarding takes a big emotional toll on me.  Maybe it’s a factor of just how my brain works and is completely inapplicable to you.  But in my case, I always carry a subtle nagging feeling when I have unread entries in my various accounts.  Even when I know that these entries are optional and that it’s not necessary for me to read any of these things, I still feel like I should read them. Basically, it makes me feel like I should be working all the dang time and that makes me feel anxious.  Anxiety makes me less productive and more prone to burn-out.  And anxiety bleeds through my work hours into my home life.  It makes it hard to enjoy a movie with the kids or some gardening in the yard.  All because there’s that feeling that I haven’t gotten the hoard processed yet.

The Solution to the Information Hoard

I mentioned a couple specific techniques for thinning out the hoard in paragraph two.  To summarize, first, subscribe to only those bloggers, feeds, and newsletters which add actual understanding to your life.  Second, open and read only those entries that matter and skip the rest. Those are techniques for dealing with lots of entries to read.  But my last problem, the anxiety issue, was a little bit harder to solve.

Like a lot of internal ways of handling life’s problem, the answer is simple but not easy.  Similar life problems with simple but difficult solutions might include feelings of guilt (the solution is confession) or anger (the solution is forgiveness, either of yourself or for the other party).  So what’s the solution to anxiety? Here’s my thought process – the answer to my information hoard is about values.  What do I mean?   I value these various things because they make me better at my job.  Losing things of value causes me some anxiety.  My anxiety has its roots in the feeling that I’m letting things of values (these various blog entries) slip through my hands.  Why would you ignore things of value, or even worse, get rid of them?!?  On the other hand, if you asked me what I really and truly valued most in this world, I’d answer with “my family and loved ones”.  But again, do I actually demonstrate this priority with my time? Not nearly enough. Therefore, the answer is to properly appraise the value of my time.  When I think about it rationally, I think that this sort of reading is worth about 30 minutes per day, maybe a full 60 minutes when there’s something really important to learn or someone really significant to listen to.

That’s it.  After 30 minutes, I can walk away from any sort of reading guilt-free.  So what’s my new solution to the information hoard and the anxieties that it’s been producing?  A quick check on the writers and topics I care about the most and then “MARK ALL AS READ”.  Yes, there will be more to read tomorrow.  But now I no longer carry an ever increasing load saying to myself “Someday I’ll get to that”.  I feel better already.

Feedback Requested

What’s your strategy to dealing with your information hoard?  Are you still keeping everything you ever produced or read digitally?  Does my approach sound reasonable and workable to you?  Or am I off base?

Thanks!

-Kev

-Follow me on Twitter

 

 

Everybody Needs a Test Harness

Monday, October 31st, 2011

When you’re developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming?

I know that I did just that, for years.  It wasn’t until I was trying to performance tune some existing code that I realized I hadn’t actually taken caching of data and execution plans into account.  So all those modified stored procedures that I was so proud of might not actually be faster than the first generation of procedures because I hadn’t checked to ensure that I was testing cached programs against uncached programs (and, by extension, the data used by those programs).  That’s easy enough to fix with a test harness.  Test harness were originally an actual, physical harness used by engineers to clamp down parts of an electrical or mechanical device they were prototyping.  Ours is no different.  It locks down all of the assumptions about our code (like my early, false assumption that I didn’t need to clear the caches) and adds a metric or two for good measure – literally – so we can better measure what’s happening in that code.

Here’s what my test harness looks like:

/* Transact-SQL test harness by Kevin Kline, http://KevinEKline.com, Twitter at kekline */
/* Flush dirty pages from the buffer to the database files. */
CHECKPOINT;
/* Flush the data cache and procedure cache, respectively. For DEV environments only! */
DBCC DROPCLEANBUFFERS;
DBCC FREEPROCCACHE;
/* Enable statistics tracking for IO and timings. Remember, SET commands remain enabled during a session until disabled. */
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
-- Whatever SQL code you'd like to process goes below.
SELECT SalesOrderID
FROM Sales.SalesOrderHeader H
WHERE CustomerID = 344
GO
SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;
/* Textual Execution Plans, if desired.
SET SHOWPLAN_TEXT ON;
SET SHOWPLAN_TEXT OFF;
*/

 

I also like to include the execution plans a lot of the time.  You might wonder why I don’t save the execution plans for the GUI in SSMS?  Well, I’m a big advocate of scripting in general because I like to automate activities.  By pulling the execution plans using scripts, I can use SQLCMD to schedule a large number of query executions during the evening and have the results ready for analysis when I come back into the office in the morning.  Workin’ smarter, not harder, Baby!

So how does this test harness work for you?  Do you use other elements in yours?  If so, share your experiences here!

Thanks,

-Kevin

-Follow me on Twitter

 

Simplifying CSV Data Loads

Thursday, October 27th, 2011

Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database.  When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software.  I recently visited www.csvexpress.com to check out just how simple it could get.   In short, CSVexpress offers a repeatable and quick way to load any CSV file into SQL Server (or any other database).   For those whose data quality is not as pristine as it should be, CSVexpress also offers a wide variety of built-in functionality to repair the data issues.   These are in addition to the data transformation components available out of the box, but let’s not get ahead of ourselves.
The first thing I notice when I visit CSVexpress is that there are some video tutorials available on the main page.  I found it pretty straightforward to load a CSV file into the database without watching the tutorials beforehand.  However, by watching the tutorials I was able to learn more about some neat features and functions that I had not previously noticed.  

For my test, I grabbed a simple CSV data file containing the following data:
City,User_ID,Name,Street_Address,Status
“Dallas”,47,”Janet Fuller”,”445 Upland Pl.”,”Trial”
“Lyon”,38,”Andrew Heiniger”,”347 College Av.”,”Active”
“Dallas”,43,”Susanne Smith”,”2 Upland Pl.”,”Active”
“Berne”,22,”Bill Ott”,”250 – 20th Ave.”,”Active”
“Boston”,32,”Michael Ott”,”339 College Av.”,”Trial”
“New York”,41,”Bill King”,”546 College Av.”,”Deleted”
“Oslo”,45,”Janet May”,”396 Seventh Av.”,”Active”
As you can see from the diagram below, the import of the data to create a schema was not difficult at all:
Once the schema is configured, I can create the following simple data flow to move data from my CSV input file to my target table in SQL Server:


While there are other tools available for performing similar tasks, CSVexpress makes it very simple and intuitive.  However, as I mentioned earlier, where it starts getting really interesting is when you need to pre-process and clean-up the data prior to loading it.   Whether it involves enriching the data from external data sources or web services, or identifying and repairing bad data, CSVexpress maintains a simple interface for all of that.  
The best part – it’s all free of charge.  The version you can download from www.csvexpress.com is expressor’s free Community Edition.  expressor also offers a licensed Desktop and Standard Edition with even more advanced features, which are available for a 30-day trial.   As a matter of fact, at the end of November, expressor will be introducing Salesforce support into their commercial editions and CSVexpress will feature a 30-day trial version.  You will be able to load Salesforce just as easily as if loading to SQL Server, or download your Salesforce contact, lead, and opportunity data and transform it before generating the right CSV output file (or files) that meets your daily, weekly, and monthly Excel reporting and analysis needs.  Now that’s easy!

Troubleshooting Repeated Login Failures on SQL Server

Friday, October 21st, 2011

 I’d recently experienced a situation where I was getting repeated login failures to a SQL Server where I knew that I had the correct user name and password.  Each time, I’d get error 18456 in response.

“Login failed for user ‘<user_name>’. (Microsoft SQL Server, Error: 18456)”.


The challenge when troubleshooting this error message is that you may have a problem with SQL Server or you may have a problem with Active Directory or Kerberos, if you’re using one of those authentication technologies.

A False Trail


When times are good, and you’re able to make a connection, you can always query sys.dm_exec_connections, to see how you’re connecting, for example, using NTLM rather than Kerberos.  But that doesn’t help us when we can’t connect to the server at all.

In other situations, your problem might be caused by duplicate SPMs in Active Directory.  MVP Russell Fields documented a nice solution for ridding Active Directory of duplicate SPNs here.  Microsoft Support also mentions some troubleshooting steps forauthentication problems here.  Ok, that helps. But it’s not my solution. 


MVPs to the Rescue


Fortunately, my MVP buddies Edwin Sarmiento (blog | twitter) of Canada and Bitemo Erik Gergely (blog) of Hungaria had already discussed and solved the problem for me!

Something Erik pointed out, but hadn’t occurred to me at first, is that if you’re getting this SQL Server error message then you’ve actually reached the server and probably aren’t having a full disconnect error.  The second thing that Erik pointed out is the importance of the state element of this error message.  A lot of the time, you can simply ignore the
state element of an error message.  But not this time.  As it turns out, state is the key to solving the problem.  For example, a state of 18 indicates that the password must be changed.

Microsoft provides a pretty good description of the states of error 18456 here, but it leaves out a few things.  (You’ll get more useful info if you read all of the comments too).  But
again, Erik comes to the rescue by providing
a complete and concise list of error 18456 states here.


Microsoft Improves the Documentation


Even better for all troubleshooting situation involving state information, Microsoft has now added state descriptions for errors in Books Online, including error 18456.  When you look in your SQL Server error log, you see the state of the error and be able to make an accurate deduction about  the nature of the error!

Hope this helps,

-Kev

-Follow me on Twitter

PASS Summit 2011, Day 3 – A Tribute to Wayne Snyder

Friday, October 14th, 2011


First things first, Wayne Snyder is rolling off the board of directors for PASS this year.  We’d worked together, shoulder to shoulder along with Joe Webb (blog | @joewebb) and other outstanding members of the SQL Server community, for many years of on the PASS board of directors and I’m certain that my tenure on the board and as president of the organization would’ve been nothing but trouble had Wayne not been there, covering my blind side(s), at every turn.  Here’s my tribute to Wayne Snyder:

If you were to mention “Wayne Snyder” to me, I’d instantly start to grin and, probably, nod a little bit.  Wayne is the kind of leader who always comes to mind with overpowering and emotional warmth.  Sometimes when you visualize a memory of a person, you see them in your mind’s eye stooped over a console deep in thought or pontificating at a meeting somewhere deep in corporate America.  But when I recall Wayne, I always see an image of Wayne smiling with his arms out wide as if he’s going to wrap you in the biggest, most comforting, Southern-fried, big brother  hug you’ve had all year.  And that image is loaded with all kinds of deep positive connotations: supportive, enthusiastic, sincere offer you thoughtful conversation, honest convictions, and straight answers. 

To use an analogy, some leaders are only the “thermostat” of their organization – they set the temperature for everyone else.  But Wayne was also the “thermometer” as well – he showed what temperature at which our organization was running.  And that temperature is warm. As a PASS member, you knew within a heartbeat that it was ok to give a shout-out back to the speaker in a crowded auditorium, that there were no stupid questions, that it was ok to be the one who knew the least in the room because, in fact, he was the guy who knew the least in the room once and here he was to help you become the one who knew the most in the room! I honestly can’t count the number of people who Wayne recruited into the ranks of PASS simply by being Wayne.

Thank you, Wayne, for your many years of service to our community.  And thank you most of all for acting as the wellspring of our communities exuberant, uplifting, and just plain fun attitude of embodied in our motto of “Learn. Grow. Share”.  No one does it better than you.

Now, it goes without saying that Dr. Dewitt’s keynote is one of the singlemost anticipated sessions of the entire event.  Why?  As Dr. Dewitt mentions himself, the hallmark of his sessions are a semester of graduate school IT learning distilled into one hour of awesomeness.  There are lots of great resources discussing NoSQL on the internet (and I’ve pointed out a lot of them in the past).  But who wouldn’t rather leapfrog months of on-the-side research learning about NoSQL by enjoying Dr. Dewitt’s keynote?  Watch the streaming video at this SQLPASS link.

And if you’re here at the PASS Summit on Day 3, I hope to see you in my two sessions this afternoon:

Crash! Boom! Bang! 10 Ways to Blow Up Castle SQL Server and the Techniques that Catch Them (DBA-318)
Enterprise Database, Administration and Deployment, Regular Session (75 minutes) in 3AB

Are you a Linchpin? Career management lessons to help you become indispensible. (PD-200)
Professional Development, Regular Session (75 minutes) in 4C4

 Follow me on Twitter!

PASS Summit 2011, Day 1

Thursday, October 13th, 2011

I’ve already had a few good days in Seattle/Redmond this week, meeting with the Microsoft SQL Server program teams and with other Microsoft SQL Server MVPs.  I was as excited as a squeeling Justin Beiber fangirl waiting for his new video, wishing I could tell you all of the cool things I learned at Redmond about the future of SQL Server.  But as you’d expect, all of that cool stuff is presently NDA.  I’m sure there’ll be some cool announcements from Microsoft this week.  So be on the lookout for the good word from Microsoft.

Keynote

Rushabh Mehta, the PASS president, spent a few moments extolling the value of community and the achievements of the professional association.  And he’s got a lot to be proud of.  PASS has come such a long way.  One of the most telling facts about the significance of PASS, to me, is that important SQL Server announcements now happen at the PASS Summit.  There was a time, and not very long ago too, in which Microsoft made important SQL Server announcements at other Microsoft events like PDC and TechEd.  No longer!  PASS is the nexus for Microsoft’s data management users.  And it shows.

Ted Kummert, Microsoft’s top data executive, had a lot of exciting talking points about how the community has grown.  PASS now has hundreds of chapters worldwide and nearly ninety thousand members.  The event has over 4000 paying attendees this year, which means probably around 6000 total attendees including press, exhibitors, speakers, etc.  That’s big!  In fact, that’s just about the peak capacity for the Washington State Convention Center here in Seattle.  No wonder PASS will be at other locations in the future.

It’s Officially called SQL Server 2012

SQL Server “Denali” is officially rolling out as SQL Server 2012.  There are a lot of interesting new developments with SQL12 regarding the way the product is splitting into multiple types of appliances designed for specific workloads and customer needs.  Need a massive processing appliance, check! That’s PDW.  Need a hybrid solution for data housed both on premises and in the cloud?  Check.  Need processing power for BigData?  Need processing for non-relational and unstructured data?  Check.

Microsoft’s improving tools will culminate in a new release of development tools called “SQL Server Data Tools”, formerly known as Project Juneau, while the business intelligence side of the house will have a new set of tools in “Power View”, formerly known as Project Crescent.  Hadoop figured large in the keynote, as Microsoft acknowledges that many BigData problems are best served by non-relational data stores.  Denny Lee, of SQLCAT, proposed an in-house data marketplace during his demos.  My face lit up like a kid at a surprise 10-yr birthday party.  Really?!?  FOR ME?!!?  I laugh because I’d been doing that at jobs throughout my career, offering up what I used to call the “data feedstore” to managers within my team.  +! for validation of your ideas.

First Session of the Day

From there I headed out to my first presentation of the conference, which I was delivering with my pal Buck Woody (blog | twitter) of Microsoft. Our session was all about Cloud 101 – when it’s appropriate to use the cloud and where you can learn more about the specific technologies like IaaS, PaaS, and SaaS.  Many IT pros don’t know the difference and are being subjected to the “implement it!” decrees of their bosses who simply read an article on an airplane saying that the cloud is the future.  The best quote from the Twittersphere about our session?  “Elastic is fantastic”  I couldn’t have said it better!

Speaking of conference sessions, my buddy Brent Ozar (blog | twitter) pointed out this great mobile schedule planning resource:

Go to Guidebook and download the app for your iPhone, Windows Phone 7, Android, or Blackberry.  After launching it, you’ll be prompted to download a guide.  Type in PASS Summit, and we’re near the bottom of the list.

Voila! Instant mobile schedule guidebook to the PASS Summit.

The Energy is Nuts!

After delivering my session, it was off to the Exhibit Hall, where I played the role of booth jockey for Quest Software for the rest of the proceedings that day.  I noticed two things of significance.  First, the crowds were thicker and more energetic than I’ve seen in years.  Wow!  I knew attendance was our highest ever, but the crowd was near to bursting out at the seems like a 14-year old kid wearing last season’s clothes.  So either the Washington State Convention Center is no longer big enough or more planning is needed to make this venue work.  When I was in leadership for PASS, planning and properly utilizing the venue was always a logistical nightmare.  So I don’t envy the current leadership in figuring out how to make the PASS Summit scale to an even larger size.  The second thing I noticed was how focused the crowd was.  Usually, you get a lot of tire-kickers in the booth who, deep down inside, only want your vendor swag.  Yes, we had some cute swag this year (a Toad beanie baby and some cool ribbons for your badge).  But we also had huge crowds even after we ran out of swag.  And, in case you didn’t detect the important part of the previous sentence, we ran out of swag! That’s right we gave out everything on day 1 of a 3 day event.  I nearly freaked the freak out. What is going on here, folks?  Haven’t you heard that there’s a recession going on?

 

 

Here, There, and Everywhere; Speaking in Fall 2011, Part 1

Friday, September 2nd, 2011

The last quarter of the year is usually my busiest due to the fantastic PASS Summit and SQLBits events.  The fall looks a little different … BECAUSE IT WILL BE EVEN BUSIER!  Here’s a rundown of where I’ll be this fall through mid-October:

 

BASTA! SQLCON.NET

September 26 to 29; Mainz, Germany

This big developer and admin conference runs from September 26 to 29 in Mainz, Germany.  I’ll be delivering at least one session and hobnobbing with Quest customers, friends, and in a very weird twist, my oldest daughter Emily, who will be in the Rhineland at the exact same time on a graduation present I’d been planning for her since graduation in June.

SQLBits – Query Across the Mercy

September 29 to October 1; Liverpool, United Kingdom

One of my favorite conferences of the year! The organizers are great. The speakers are great! The attendees are great!! The venues are great!!! The lunches are … um … adequate.  I’m doing all an new session on SQL Injection attack, this time with LOTS of demos kindly written by an attendee at one of my sessions in Cologne.  He like the session so much, he decided to build demos to go along with it.  (Thanks again, Volker!)

And if you’ve attended before, you know how much fun our now traditional IT Horror Stories and IT Bingo Trivia sessions are.  Make plans to attend these standing-room only sessions, before the fire marshal kicks us all out of the room for overfilling it.

 

The PASS Summit

Seriously.  This is the one.  If you can attend only one SQL Server training and community event in a given year, this is the one.  Over 150 sessions and pre-conference seminars.  Most everyone who is on the list of “who’s who” in the world of SQL Server and Microsoft-related data management and development will be in attendance.  And a large number of the Microsoft R&D team that builds, documents, and supports SQL Server will also be there.

Plus, more details to come on these events: Netherlands SQL Saturday, Belgium SQL Server Days, and SQLRally Nordic.

 

I hope to see you there in person!

-Kevin

-Follow me on Twitter!

Women in Technology: A Quick Observation and a Quick Straw Poll

Monday, August 29th, 2011

A bit of background:  Those aren’t grand daughters of the Clampetts in the picture at right.  Those are my three daughters and three stepdaughters, all of whom I want to inherit the world – as little or as much as they want to take hold of.  (I already talked a bit about this in a post on my personal, family blog.  Be warned, it’s all boring family photos and such).  Enabling them to have all of the choices and opportunities that are open to my son is a big motivating factor in my life.  So many years ago, when several PASS volunteers wanted to start doing more to build a community of support for women in technology, I was an ardent supporter.  And as president of PASS, I was able to do a tiny bit to help move WIT forward.  Now, as I travel around speaking at various other conferences and events, I always try to sit in on the Women in Technology (WIT) sessions when I can.

A while back at a SQL Saturday in Indianapolis, I was enjoying the WIT panel discussion listening to the panelists discuss their  upbringing and how they became a success in the field of technology.  Their stories were, in some ways, similar.  They were smart.  They weren’t scared of math.  They had an important mentor who supported them and encouraged them that they could accomplish any goal.  They endured struggles such as financial hardship that, while difficult to overcome, also refined their desire to become successful in their careers.  Some of the women who had to deal with men of the previous generation even had to overcome blatant chauvinism.

But then another similarity among the panelists, just a hunch really, struck me.  I had to ask, to confirm my idea. “How many of you were a bit of loner or at least weren’t heavily influenced by your friends’ opinions before your professional career?  Because with my own daughters, it’s their friends who they want to please.  And they’d punt right away if their friends teased them about being good at math, or choosing a technical career, or anything else I can think of for that matter.”

It was pretty much unanimous.  All of the panelists were loners or had a very small social circle during their formative years.  Now perhaps I’m speaking from an inaccurate assumption, but most of my daughters are tight with their friends.  And friends mean a lot to them, perhaps more than any other aspect of their social lives (like their family).  So if their friends tell them that being interested in technology will “geekify” them, then they’d drop it like a hot potato.

So I wanted to put this question out to my female friends in the IT world.  Were you in a big circle of friends during your developing years?  What importance did you place on their opinions?  Did they give you any flack for going in to IT or doing well in technology related classes?

It seems like the days of overt chauvinism are behind us here in the US.  But I wonder if we need to start earlier with our daughters among their own peer groups to support them for a future in technology.

Thoughts?

Thanks,

-Kev

-Follow me on Twitter

Upcoming SQLSaturday Events in Omaha and Atlanta!

Wednesday, August 17th, 2011

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