Hello Dear Reader SQL Saturday 151 is just around the corner. If you haven't registerd there is still time to sign up now, click here!
We talked about Teaching being involved in the SQL Community and of course the up coming Pre-Con.
I hope you enjoy!
1.
What
got you into IT and then into SQL Server as a Career? Was the move to
work with SQL Server straight to BI or where you ever a DBA?
My
first official job in IT was as a installer/trainer for a software company that
developed applications for tractor dealerships (which eventually customized for
car dealerships as well). My mom had been one of the original employees there
as a developer and thought it would be a good opportunity for me.
She wasn't working there when I started
working there, but in later years she did rejoin the company although we worked
in completely different departments. My job was to travel out to tractor
dealerships and get their IBM System 36 installed and configured and then to
teach the personnel how to run their business using the computer.
Most
of them had been on manual systems. I did some custom reporting development for
them because, of course, canned reports in the software never answered the
questions that management really had.
When
we started moving our applications to PC-based systems, we had a database
backend and that's where I started to learn how to write SQL queries but I
didn't know anything about database management. Fast forward many years and I
was in another software company as a project manager for custom development in
the legal industry. I stumbled on Business Intelligence while I was looking for
information on the Internet to use to train up a new employee on project
management skills.
I
read about cubes and thought this had to be valuable to the types of reporting
and analysis that we were trying to incorporate into our software, and that's
when my career veered off into BI. At the time, I managed a team of Lotus Notes
and Java developers, and we extracted data from our Lotus Notes databases into
Oracle databases so that we could do more sophisticated reporting than we could
in Lotus Notes. I went straight from that in to BI - I've always been involved
in one way or another in getting data out of computers into a format that
people need for analysis.
2.
You
just moved to Alaska, why Alaska and what do you love about it?
I
moved to Alaska because my husband told me when were dating (many, many years
ago) that he would be happier living with me in a shack in Alaska than he would
in a mansion in (somewhere I forget now).
So
I wanted him to prove it to me! But more seriously, he's a country boy and was
never very happy in our city homes. To rectify that, we were looking for
property out in the country somewhere in the Western states a couple of years
ago and a long-lost childhood friend of my husband's called during that time
and described where he was living in Alaska. It had everything we were looking
for, except it wasn't as close to an airport as I required. So I said I would
put up with the travel inconvenience as long as I could get a decent Internet
connection, which we made happen, and so here we are!
Travel inconvenience is putting it mildly.
It's quite an ordeal to get in and out of here - but it's an amazing place to
be while I'm home. We're still getting set up and stocked up, but I love the
access to fresh foods from the sea and from nature - we have all the salmon and
halibut and other types of fish that we could ever want, plus wild mushrooms
(chanterelles and morels) and a variety of edible seaweeds. We'll be building a
greenhouse for year-round veggies. I go for a walk almost every morning when I'm
home - rain or shine - and walk about 3 miles with a neighbor and see more deer
(and sometimes bear and bald eagles) each day than I see people in a week. It's
a beautiful view and environment, and I'm really glad to be here!
3.
You’ve
had the opportunity to travel to many different places and teach to many
different people and audiences. What has your favorite experience been as
a teacher? What was your favorite location to travel to?
I
have lots of favorite experiences as a teacher. I really like to
experience a place through its foods and I had a list of foods to try during
the week I was there. It was my personal food scavenger hunt!
Each
day at lunch I would ask my students to help me identify what was on our lunch
menu to determine what I could cross off my list. On Thursday, I was asked if I
would join some of the students for dinner to get some of the other items on my
list. I assumed we would be going out to a restaurant, but I was invited to a
flat that one company had rented for the students they had sent to my class and
they cooked dinner for me.
Meanwhile
there was an incredible storm outside - hurricane force winds in Warsaw! But we
had such a wonderful time enjoying homemade food and they were telling me
Polish folk tales as we waited out the storm. And to cap it off, one of the
students told me she had used one of my books in a college course (which she
had neglected to tell me all week until that night!). That evening was truly a
memorable experience!
As for my favorite location, that's more
difficult question to answer because there have been so many places and so many
wonderful people that I can't single out just one!
4.
How
has the SQL Server Community, and/or being involved with it, affected your
life?
Being
involved in the SQL Server Community has given me the opportunity to meet people
from all around the world. On a personal level, my husband is on a mission to
acquire a certain breed of dog which is not commonly found in the US, so he
found breeders in other countries and suggested I go to these places and I
thought - I KNOW people in those countries who I could ask for help with the
language, etc. How nice is that?
On
a professional level, it's extremely helpful because I have a network of
like-minded people that I can connect with regularly which is so important as
an independent consultant who doesn't have an office full of co-workers. I've
been able to participate in many projects as a result of having met people
through community and I've been able to connect people that I know with clients
that need their sort of expertise.
Having
this network as a result of the SQL Server Community also helps me keep aware
of important happenings and trends in the industry, provides a sounding board
when I'm dealing with challenges, and keeps me motivated to keep learning more
and to see the same old things in new ways.
5.
Last
year you attended SQL Saturday 62 in Tampa and later you were at SQL Rally in
Orlando, this year it is back to Orlando for SQL Saturday 151. What keeps
you coming back to visit the SQL Server Community in Florida?
I
have a lot of friends I like to see in the SQL Server Community in Florida and
it's a nice place to visit most times of the year!
6.
Your
Pre-Con looks fantastic, if I was speaking to someone at an HR/Training
department who should I tell them they should send to attend?
The
Pre-Con is going to cover a lot of ground, although it is specific to the BI
features in SQL Server 2012. The people who will benefit the most will be those
who have some familiarity with earlier versions of SQL Server BI because I will
talk about the things you need to know to make the transition more easily and
I'll point out what's most important in the new features. If you're completely
new to BI, you won't have the right context.
Anyone
responsible for BI architecture, solution development, or BI support would
benefit from this Pre-Con if a SQL Server 2012 upgrade is on the horizon, or if
you're wondering why (or if) you should bother with an upgrade.
7.
Why
is BI so important to the business world? Do you have any stories about
how BI investments help change or shape a company that you worked with (that
you can tell without breaking any confidentiality agreements)?
BI
is so important because there are so many questions and there is so much data,
but it's not so easy for a business person to find the answer to their
questions. The structure of the data that is necessary for capturing
transactions just doesn't lend itself well to summarization and comparative
style queries. I don't think any of my clients would say that BI revolutionized
their business.
Instead, they would say that having BI has
freed up their time so that they can spend more time thinking about what to do
in response to what they learn from BI rather than spending all their time
trying to gather the data and piece it together to make sense of it
somehow.
8.
I’m a
DBA, why would I want to learn about BI?
I
know enough about DBAs to know that there are different types of DBAs, so I
would say it depends... I think you need to understand enough about BI to
determine which tool is right for which job and then shift the work where it
will get the best performance with the hardware and BI developer resources
available.
You
might even be an accidental BI developer, if not now, maybe soon. There is no
escape from BI! The bottom line is that the business wants data for analysis,
yesterday. The easier you make that process and the faster you can deliver, the
more of a hero you can be.
9.
Your
presenting Data Visualization in Reporting Services during the SQL Saturday 151
event, how does this tie into the pre-con?
They're
actually unrelated. My Pre-Con focuses on SQL Server 2012 whereas my Data
Visualization presentation talks about what you can and should do in Reporting
Services to tell the right story, and that's applicable regardless of what
version of Reporting Services you're using.
That
said, I will also delve a bit into spatial data visualization which is SQL
Server 2008 R2 feature along with some other items that were introduced in that
version, but the main theme of the session is about design techniques - good
and bad.
10.
If
you could give one bit of advice to someone starting out in the IT field what
would it be?
Find
your passion and run with it, as long as you can see how it solves a business
problem. Everybody likes different aspects of technology, which is good thing
else we'd all be in each other's way.
When
you find what you're passionate about, you don't mind spending extra hours
learning about it, whether you're getting up early or staying up late. You want
to eat, breathe, and live it while everyone around you thinks you're nuts! But
that passion pays off when you can use it to help others solve their problems.
The
more problems you can help people solve, the more valuable you are, and the
more you want to learn so that you can expand the range of problems you can
solve. It's a vicious cycle!
Thanks,
Brad
