SQL Server with Mr. Denny


September 21, 2010  11:00 AM

Last weeks slide decks

Denny Cherry Denny Cherry Profile: Denny Cherry

Last week was a very busy week for me presentation wise.  So instead of putting out 4 blog posts, one for each event I waited and put everything in a single deck.

On Wednesday at the San Gabriel Valley .NET users group I talked about SQL Server Indexing.

On Thursday morning during the 24 Hours of PASS I talked about Storage as a preview of my PASS Summit pre-con.

On Thursday afternoon at the SoCal .NET Architecture User Group about SQL Server Basics.

On Saturday at SQL Saturday 55 I talked about Execution Plans and SQL Service Broker.

Thanks to everyone that came to my sessions through out the week.  For those that had questions at the 24 Hours of PASS session I’ll be posting them shortly.

Denny

September 20, 2010  11:00 AM

Get yourself a discount for SSWUG Virtual Conference

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve been given a handy discount code for those looking to go to the SSWUG Virtual Conference which is coming up in October (from the 20th to the 22nd), 2010.  The code to enter is F10VCDCherry.  You can enter the code on the registration page for the conference.  This code will get you a $30 discount on what ever the lowest cost that you can get.  That includes early registration, alumni discount, etc.

Denny


September 15, 2010  11:00 AM

Talking to the SoCal .NET Architecture User Group about SQL Server Basics

Denny Cherry Denny Cherry Profile: Denny Cherry

Later this week on September 16, 2010 I’ll be going and visiting the SoCal .NET Architecture User Group in Santa Ana, CA.  In this presentation we’ll be going back to the basics of SQL Server and focusing on the basic T/SQL DML statements, and object creation as without a good foundation to build that application on there won’t be a successful deployment in the long term.

The next SoCal IASA chapter meeting will be Thursday September 16, 2010 at Rancho Santiago Community College District, 2323 N. Broadway, Santa Ana. Meeting starts at 7:00 pm, pizza and networking 6:30 pm. Meeting cost is $5 to help us cover the cost of food and beverages. RSVP by emailing to mike.vincent@mvasoftware.com if you plan to attend.

In addition to the presentation, I’ll be bringing along a copy of Windows 7 Ultimate to give away to one lucky winner courtesy of Stephen Rose the Senior Community Manager for Windows 7.

I look forward to seeing you there.

Denny


September 14, 2010  11:00 AM

Where can you find me speaking for the rest of the year?

Denny Cherry Denny Cherry Profile: Denny Cherry

I’ve got a bunch of sessions planned from now to the rest of the year.  Here’s the list of all the events large and small.

September
15th – San Gabriel Valley .NET Users Group
16th – 24 Hours of PASS
16th – SoCal .NET Architecture User Group
18th – SQL Saturday 55
23rd – Virtualization VC

October
5th – Performance VC
20th – SSWUG Virtual Conference
23rd – SQL Saturday 54

November
1st-4th – SQL Connections
8th – PASS Pre-Conn
9th-11th – PASS

Hopefully I’ll see you at one or more of these great events.  I’ve got info on all these events on my Facebook Page as well.

Denny


September 13, 2010  11:00 AM

Get Certified for up to 20% less than normal, and be protected by Second shot.

Denny Cherry Denny Cherry Profile: Denny Cherry

Prometric and Microsoft are offering a way to get Microsoft Certification vouchers for up to 20% off when you agree to purchase multiple vouchers.  Go to the site, select the link for the number of vouchers you want to buy, and the site will email you a voucher code which gives you the discount.

Exams and retakes must be taken before June 30, 2011.

So go get yourself some certifications.

Denny


September 9, 2010  11:00 AM

I’ll be talking about SQL Clusteres to some .NET developers

Denny Cherry Denny Cherry Profile: Denny Cherry

Later this month (September 15th to be specific) I’ll be speaking at the San Gabriel Valley .NET Users Group.  They’ve requested that I come in and talk about SQL Server Clustering, which I just happen to have a slide deck about.

If you happen to be in the area feel free to come on over.  The group meets over at 605 E Huntington Dr, Monrovia, CA 91016.

As usual I’ll be at a near by Starbucks before the meeting starts.  I’ll tweet my location thanks to 4Square when I get there.

Denny

UPDATE: Turns out that I’ll actually be speaking about indexes today instead.


September 7, 2010  11:00 AM

I’m looking for your auditing check lists.

Denny Cherry Denny Cherry Profile: Denny Cherry

As many people may already know I’m working on a SQL Server security book which is due out Q1 of next year.  One thing which I’m including in the book are check lists that people can follow to help them pass the various audits which we as IT professionals now have to pass.  If you’ve got a checklist that you use at work, that you are able to share I would really appreciate it if you could send those over to me.  The reason that I’m putting out this call is that every auditor looks for different information, so I’m trying to put together a sort of master list of items to look at.

I’m going to collect the various checklists and combine them into a sort of master check for each type of external audit.  I’m sure that there are more audits than what I’m listing here, so if you know of a type of audit that you’ve had to deal with feel free to send them over as well.  I know of PCI, SOX (Sarbanes–Oxley), and HIPAA audits.

If you don’t have a checklist but you have an audit you’d like to share (please be sure not to get yourself fired for sending it to me) I can take that and turn them into a checklist.  If you send an audit I’ll be sure to not publish any confidential information about your company.

Anything that you can find and send between now and the end of September 2010 would be great as that will give me a couple of weeks to put everything together for my editor.  Anything you can send please send to mrdenny AT mrdenny DOT com.

Thanks,

Denny


September 6, 2010  11:00 AM

I’ll be the September 23rd presentor for the Virtualization Virtual Chapter

Denny Cherry Denny Cherry Profile: Denny Cherry

On September 23rd I’ll be presenting for the SQL PASS Virtualization Virtual Chapter.  I’ll be doing part of the pre-con that I’ll be doing at the PASS Summit.  So in addition to getting some great info (at least I think its great info) you’ll get a nice teaser for what you’ll be able to see at the pre-con in November.

Denny


September 3, 2010  11:00 AM

So where will those SQL PASS parties be?

Denny Cherry Denny Cherry Profile: Denny Cherry

So if you caught my blog post yesterday, I talked about finding some of the after parties to get some “social networking” done.  Because the overall Microsoft MVP community is totally awesome Joseph Guadagno (Blog | Twitter), the MVP who put together mvpsummitevents.com and techedevents.info has put together passsummitevents.info for we SQL Server peps.

The site has a flikr feed as well, so any pictures which are uploaded to flikr.com with the tag SQLPass10 will automatically be shown on the site.  (All you photo walk people be sure to tag everything when you upload them.)

I’ve got The Tap House entered in there for each night since people will always land there.  We’ll get Bush Garden entered in as well.  Events have to be approved before they show up so SPAM doesn’t end up there.

Many thanks for Joseph for setting this up for us, it’ll be a huge help getting people together and getting people to meet new people.

So if you are going to go to an official event, or a tweet up, or a drink up, or a bar fight get it posted in there so that we can spread the word about the party.  Vendors, if you are going to throw something there’s a sign-up link that you can put in when the event is submitted so have at it.

Denny


September 2, 2010  11:00 AM

So you want to go to a conference, but you are afraid that you don’t know anyone there.

Denny Cherry Denny Cherry Profile: Denny Cherry

Odds are that you know someone at the conference, its just a matter of finding them.  Of every conference that I’ve attended I can’t think of a single conference where I haven’t found someone that I know from somewhere that I’ve worked.

Some of these conferences can be quite large, shows like TechEd or PDC can easily have over 10,000 attendees, so finding friends may be hard to find.

Now some IT Professionals find it hard to make friends and meet new people at conferences (shocking I know, people who tend to be introverts have problems making friends).  If you find yourself being one of these people I have a few tricks that can help you find friends and make sure that you have a good time at the conference.

In the morning

Skip the hotel breakfast.  Every conference that I’ve gone to provides you with breakfast.  Yes I’m well aware that the hotel breakfast it better than the conference breakfast, but the other attendees are at the conference breakfast.  When you have gotten your crappy conference breakfast, not all of them suck but most seem to. I half think that its so that people have something to talk about over breakfast.  So after you’ve gotten your breakfast from the buffet, its time to find somewhere to sit.  Any table which is empty isn’t suitable for you to sit at either, there must be something wrong with the table that’s why no one else is there.  Find a table that’s got a few people sitting at it, preferably that are already chatting.

When you get to the table, don’t just plop down and start eating.  This won’t get you into the conversation, a quick “Hey is this seat taken?” will get you a moment of face time, and probably a quick “help yourself” or something similar.  As you eat, follow the conversation and interject something useful if you can.  When the conversation lags a little bit, if you the people at the table haven’t become your best friends yet its time to speak up.  I’ve got a couple of questions here to get you started.

“Hey I’m {Your Name}, where are you folks from?”

“I’m planning on catching {Some Session you plan to attend}, what are you looking forward to seeing?”

These should at least get the conversation started.  When talking with people at the conference, keep in mind these people do the same thing for a living that you do so you’ve got something in common right there to talk about.

Lunch Time

Again, you’ll want to head to the conference food hall as this is where almost all the conference attendees are going to be.  The same questions to start the conversation from above apply here.

If this is a day which doesn’t have a planned event that night, I’ve got another important question for you to ask.

“Did you folks have any plans for tonight?”

If they say yes, and it doesn’t sound like a private event ask it anyone can come.  The worst that they’ll say is that it’s a private event.  Odds are you’ll get a yeah sure, it’s at {Some Bar} there are going to be a bunch of us there.

Dinner Time

Now the trick with dinner is that most conference don’t provide dinner, that’s usually up to you.  The best way to find people to have dinner with is to put away your wallet and talk to the vendors.  Someone is going to be throwing a party of some sort, you just need to find it.  These official parties usually don’t last all that late, but they will be full of people to talk to and they will have free food and a couple of free drinks.

The people that you have met at the vendor party will hopefully lead you to the next section.

The after party

There is pretty much always going to be something going on after the official parties.  You can call it a night at any time from dinner, until what ever time the local bars close.

When it comes to SQL PASS the default place to go after the official parties are done is the Tap House on 6th Street in Seattle.  They’ve got a good menu of beers and other drinks, a couple of pool tables and lots of tables.

It has started to become a little more common for the official and even the unofficial parties to be listed on a website somewhere.  For the MVP Summit this year someone put together the mvpsummitevents.com website.  For TechEd they put together the techedevents.info website.  When the SQL PASS summit comes around this year, I’m not sure if they will have a website for us or not.  Hopefully PASS will have a sign board or something by the PASS HQ booth where people can post official and unofficial parties that are open to everyone.

If you still aren’t sure how to find a party, look for the speakers.  They’ll have some sort of different badge on, or a flag hanging from their badge.  They should pretty much all know a lot of people, as they’ve probably been coming to the conference for years and they will either know where the after parties will be, because they will be there themselves or they will know who you need to talk to to find out where the parties are.

When you get to your next conference, work on having a good time. You won’t be disappointed if you do.

Denny


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: