Hello Dear Reader! I'm coming to you live from the wonderful SQL Rally in Dallas Texas. I have two sessions today, and the Slide Deck's and Demo's are live on the Resource Page. Feel free to download them and see if you'd like to come join me, or download them and follow along!
"So Balls," you say "What are you presenting on?"
Glad you asked Dear Reader, and away we go!
TRANSPARENT DATA ENCRYPTION INSIDE AND OUT IN SQL 2012
The great thing about this session is even though we are using SQL 2012 99.999% of this is the same as SQL 2008 & 2008 R2. So come and learn about TDE and leave with scripts that will help you deploy this if you are interested. I hope you'll stop by at 10:15 am I'm in room 302/303
Here's the Abstract:
Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL Server 2008, we were able to add Transparent Data Encryption to that list. Find out what it does and doesn't do, how it effects read-only filegroups, performance, and compression (backup and row/page), what the X.509 encryption standard is and why you should be careful of what you store and where, and other advanced features and management tips.
SQL INTERNALS, RECOVERY MODELS, AND BACKUPS! OH MY!
This is a fun session that is all about learning. We have demo's and we have fun, but a lot of getting better and advancing your career in SQL Server is knowing the concepts. We won't be Deep Diving but we will touch on ACID, B-Tree's, Transaction Isolation Levels, Transaction Log Internals, Recovery Models, and Backups. I hope you'll come join me at 4:00 in room 302/303.
Here's the Abstract
The more you know about SQL Server, the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000-foot view, we know what databases, tables, and columns are. But what makes up those databases, tables, and columns? What are records, pages, extents, and allocation units? What are Full, Simple, and Bulk-Logged recovery models? What are the differences between Full, Transaction Log, Differential, and Filegroup backups? What is a piecemeal restore? This is an introduction to these concepts using SQL Server 2012. In this session, you will learn about the internal structure, recovery models, and backups and be better prepared for future learning and managing SQL Server.
WRAP IT UP
I hope you enjoy your day out here there is A LOT of SQL Learning to be had!
Thanks,
Brad
Thursday, May 10, 2012
Wednesday, May 9, 2012
Thank You to the People That Get Us There
http://www.flickr.com/photos/saygoodie/4548042971/ |
Hello Dear Reader starting today out in Dallas Texas at the
Dallas Convention Center is the Second Annual SQL Rally. This year Sri Sridharan (@SQLRocks | Blog) and
a cast of many other volunteers, click hear to read about these great volunteers, have been hard at work to put together this great event. There are SQL MVP’s, MCM’s, the Microsoft CSS
Team, and even your friendly neighborhood SQL DBA’s such as myself.
While we take a couple days to cram in as much SQL Learning
and SQL Networking as we can I wanted to take a minute to say Thank You. Chances are you have someone that you will be
Thanking as well. If we take a minute to
ask the volunteers, the comities, and different SQL Community Leaders they
would have someone to Thank as well. So
as we start our SQL Rally let’s start it off on the right foot by saying Thanks
to the people that allow us to participate in events like these.
“So Balls,” you
say, “who are you saying Thank You to?”
The most important person in the world Dear Reader, the person
that gets me there so I can participate in events like these.
THE PEOPLE THAT GET YOU THERE
http://www.flickr.com/photos/shutterbri/5168715471/ |
When you travel you leave your home behind. I know not an earth shattering conclusion,
but when you leave your home who is there taking care of it?
When the kids were little they didn’t want to go to sleep at
night because they didn’t want to miss anything. They wanted to stay up and play, or stay up
and watch TV. I used to tell them that
while they slept the whole world stopped, and it wouldn’t start again until
they woke. I wanted them to be at ease about falling asleep. They worried what they were missing, and I
didn’t want them to worry.
As adults we know that is not true. When we sleep we know another part of the
world is up and active. In the IT world
we count on this. We expect the system
that we put in place to be used while we are not looking. The whole profit model of the internet and “Buy
Now” buttons work on that philosophy, things keep running 24 hours a day.
Life is like that too.
When you are not home, who keeps the show running? Do you have someone that you can depend
on? Someone that says to you, “Don’t
worry go, I can handle this”, someone that you have absolute faith in. Do you have someone that keeps you from
worrying?
THANK YOU TO MY WIFE
http://www.flickr.com/photos/21644167@N04/4335299130/ |
1st and foremost I need to say a big Thank You to
my wife. We have 4 kids. She has given me a beautiful family, worked
like crazy to support my career and my crazy hours, and she does an amazing job
making our house a home. Did I mention
we have 4 kids?
I’ve recently taken a new job and I’ve been traveling quite
a bit. When you do not travel for work,
then events like SQL Saturday’s, SQL Rally, SQL Connections, and the PASS
Summit seem like just a couple of events a year. Just a couple times to go away. You say things like, “This will make me
better at what I do, and besides it’s not like it is forever, it’s just a week
or a weekend”. But those things start to
add up. And when you pile on traveling
for work as well, it stacks up even higher.
So when I’m gone I’m not able to help if a kiddo wakes up at
2 am tossing his or her cookies all over the bed. If there is a noise in the middle of the
night, I’m not there to go looking, and it means one parent is stretched
thin. While I’m speaking I can’t kiss a
scraped knee or check out a flat bicycle tire.
There are a million little thing and big things that my wife
does during the day, she has a full schedule between family, work, and school. When you take one parent out of the picture,
then that day takes on a whole new level of busy. Make sure the boys have lunch money, let the
dog out, make sure the baby’s lunch is made, let the dog back in, get the baby
off to day care, let the dog out, pay
the bills, clean the house, let the dog back in, do laundry, and don’t forget
to let the dog out. And that doesn’t
even include things she needs to do for herself.
The fact that she can make it look so effortless, is a testament
to just how awesome she is. So before I
head off, I need to say Thank You. I’m
very grateful, and I want to say that without you to support me I wouldn’t get
to go participate in these great events that I write about, it just wouldn’t be
possible. You’ve taken such good care of
me that I cannot Thank You enough. Thank
You, Thank You, Thank You.
DON’T FORGET TO SAY THANK YOU
http://www.flickr.com/photos/avardwoolaver/7137096221/ |
Hopefully I’ll see you when I’m are out in Dallas, but
before you get there stop and think about who it is that is making your trip
possible.
Chances are I’m not alone in this. You probably have someone in your life that
makes it possible for you to do the things that you do. Someone that while you’re away, notices more
than anyone else. Someone who is happy for you when you get opportunities, helps
cover for you when you need it, and offers you the support you need to get the
job done. Someone that when you get
excited you want to run to and share the news about <insert good news of
your choice/>.
Someone that while you’re away, notices more than anyone
else. Make sure to say Thank You.
Thanks and I'll see you out there,
Brad
Tuesday, May 8, 2012
T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics
Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this
month. It has been a while since I
participated and this month sounded really interesting. So time to dust off the keyboard and get back
in! So Chris What are we writing on?
For this month’s t-sql Tuesday question I
wanted to highlight the need for Ethics in our industry. Don’t consumers
and business owners have to trust someone at some time with their data?
This month, take time to participate by talking about DBA ethics. I
really hope to see someone address topics such as:
· Should we have an ethics statement?
· Have ethics issues impacted you? What did you do about it?
· Security Audits: how do you police what you and others are doing
in the database?
· Does a Code of Ethics mean anything to anyone? How do we as a
community enforce a Code of Ethics?
· What do you believe our Code of Ethics should say if we the SQL
Server Community have one?
I think this is a good topic, and should produce a lot of
interesting reading. But Dear Reader
allow me to begin with a bit of a Rant.
ETHICS ARE
DEAD! LONG LIVE ETHICS
Screw Business Ethics.
“Balls,” you say, “SCREW ETHICS?!?!?”
I understand your outrage Dear Reader, allow me to explain.
I think Ethics may be an over-used
word. We all want something deep
reaching and soul searching that will put us on the same level. That will guide us to say this is right and
this is wrong, but Ethics has begun to mean “A corporations way of covering it’s
@$$ in the event of a lawsuit by telling employee’s don’t do these stupid
obvious things so when you do this (or something else like it) we are covered because
we have a sheet of paper that says we are ethical”.
Ethics are supposed to be convictions, things that you hold
so true that if something goes counter to them, they should sway your
argument. Ethics should go to the core
of our beliefs. Being Ethical should be
a deeply individualistic kind of thing, not a group thing. They should define YOU, they should help YOU
through troubled times, and only in times of great crisis do YOU question
them.
Instead Ethics are just another tool of doing business and advertising. Buy from this car company because we didn’t
take money in the Government bail-out look at how we didn’t partake of a
politically unpopular decision our Ethics.
Our Bank has been around for 130 years because we got lucky and didn’t
jump when all the others did of our Ethics.
We are focused on our customers because it is really popular right
now, and we are fighting tooth and nail not to lose market share of our
Ethics.
Ahhh Ethics. Ethics,
Ethics, Ethics. Ethics are important
there is no denying that. I like ethics,
as a father with a whole bunch of kids I hope I’m bringing them up to be
ethical and to live good lives in the future.
As a U.S. Citizen that has held positions in working with our Government
that required a high level of Security Clearance I think they are essential in
our work force. As a private citizen I’ve
also watched corporations use shotgun Ethics training to lighten their
liability from law suits, watch as high ranking government leaders committed
all kinds of unspeakable acts, and watch as religious leaders did the same or
worse.
Ethics should be a deep part of you. Ethics should be important to you, but they
should not be something that a business can identify on a sheet of paper. There are people out there that probably have
the same ethics I do, but have a personality that would grate on my nerves. We might not work well on a team together,
even though we may vote in the same block.
Using a sheet of paper to pair me up with these folks would probably be
bad. To be honest, I would like to see companies drop the
pretend focus on Ethics.
And as much as I would love to say that everyone involved
with PASS and myself shares the same Ethics we probably do not, and I wouldn’t
want to force mine on others. I would
hope that we are not so simple that a piece of paper would capture all of our Ethics
either. We probably have some core
beliefs we share, but there is nothing about our job that Ethics would instill,
that simply following the RULES wouldn’t put in place as well.
It is not a great leap of faith to think that destroying
data, hurting your company’s ability to do business, or risking national
security is against the rules. When I
see IT individuals that burn the barn down on the way out of town I think
WHY? Why!
I’m pretty sure they signed the Ethics form
for their company. I guess that piece of
paper didn’t stop them. Most were with
their companies for years. Striking out
and getting revenge in IT is no different from doing so in real life. If somebody makes a car accident happen
because they were driving like a fool, and I get out of my car and decide to
get revenge I’m probably going to jail.
There are rules against this, AHEM *assault* AHEM, just like there are
Rules against malicious hacking, data theft, and Identity Theft.
So forgive me for the rant, but I don't like buzz words that should mean something.
I like Rules. Rules are simple; people can have philosophical
battles on Ethics. What is right what is
wrong, what is perspective, blah blah blah.
Rules you can follow, like them or dislike them you know what they
are. “Don’t jump on the bed”-Don’t like
it, but I make the kids follow it…on occasion.
“Eat your dinner before dessert” – Didn’t used to be a fan of this but
13 years and 4 kids later you don’t get dessert unless you eat your dinner. Football
has rules, Baseball has rules, Heck DODGEBALL has rules.
And let us not forget Businesses are all run by Individuals. Let the Individuals be ethical, and the business with follow, and we start by following the rules.
What we should be looking for are people that use the same
Rules to govern themselves with that we use for us. Personalities may still conflict, but as a
Rule I believe in rewarding hard work and respecting intelligence. We might not have Christmas at the family
Casa together, but if we believe in the same things we can work together just
fine.
And while I would love to say that there should be a common
DBA or Data Personnel form of Ethics, (complete with a pledge, secret decoder
ring, and Top Secret membership into our club of sorts), I would much rather
have a couple rules to follow. And I’m
pretty sure anybody breaking these isn’t in the club, and gets their decoder
ring taken away.
1. DON’T STEAL, COPY,
OR PLAGURIZE
Blog after blog has been stolen, and the SQL people that you
would have to face are legion. You want
to see a ravenous Twitter feeding, watch for the next time some IDIOT, steals a
blog post, and then attempts to defend it. You'll hear me say it again and again, the SQL Community as vast as it seems is a small one. Blog posts take time and effort, and it is a terrible way to get your name known.
2. GIVE CREDIT WHERE
CREDIT IS DUE
If you read a post and get an idea from it, make sure to
give the credit where it is due. The good
folks over at SQLSkills.com are
constantly doing things that I love.
Jonathan Kehayias (@SQLPoolBoy|Blog), Joe Sack (@JosephSack|Blog), Glenn Berry (@GlennalanBerry | Blog), Paul Randal (@PaulRandal|Blog), and Kimberly Tripp (@KimberlyLTripp|Blog), in the last month I’ve
used great scripts from every single one of them. When I do I send people to their site.
I post links to the MCM videos, MCM
Videos You Should Be Watching These, I get ideas I work up a demo I put a
link in the header of the script, as well as the name of the blog post, and I
cite the author. I appreciate what they
do, and I use it to learn. And I would
never, ever want credit that doesn’t belong to me. And besides see Rule 1.
3. DON’T BE A
JACK@$$ RUDE
I have met so many people in the SQL Community that are just
really nice people. They make time for
phone calls, they reply to emails promptly, and I’ve never met one that isn’t
incredibly polite. The SQL Community is
not a large one. There are several
hundred people that you see over and over again. And you will be amazed how polite each and
every one of them are.
Maybe it is my background in sports, but being humble is something
I need to work on. My wife has been
working on me for years. I get too
prideful at times, I like to compete and I like to win. Everyone has their moment good and bad. If you’re like me just do your best, and it
will shine through.
4. DON’T LIE
This will do nothing but hurt you and your credibility. Remember small community, eventually we all
come in contact with one another.
Everybody starts out somewhere. You do not need to impress anyone. You need to be yourself. You don’t have a certification in SQL 2003,
you don’t have a MCITP in PHP, and none of us are perfect.
I’ve locked out the production SQL Server Service account
before…during the middle of the day, as
a Jr DBA I ran a profiler trace from the GUI against production (if you don’t
know why this is bad, google SQL
Server Side Traces and start using them), and I once crashed a cluster that….ask
me and I’ll tell you in person. The
point is we’ve all done things wrong. A
lot of them taught us things that defined our careers as DBA’s. The scratches are war wounds, and if you
haven’t screwed up don’t feel like you have to invent a story to fit in. Just remember rule #3, because one day you
will screw up.
5. HELP WHEN YOU CAN
Every rule so far has been a DON’T, I wanted one that was a
DO! One of the great things about the SQL Community is that we love to help, we
love to share knowledge, and we love to learn.
Depending on how long you’ve been in the game or how much you’ve been
participating you will help and contribute somewhere and in some way. You could be a community evangelist, you
could be a forum moderator, you could just be the member that posts occasionally
when they have time, you could be a SQL Saturday volunteer, or a conference
attendee. What you do matters, and it is
what makes us a #SQLCommunity.
WRAP IT UP
Thank You for stopping by Dear Reader and putting up with my
rant on Ethics. The ones that have the
most substance are the ones that you already thought were important. Now let’s all follow the Rules and get on
with the community!
Thanks Again,
Brad
Subscribe to:
Posts (Atom)