SQL Server with Mr. Denny


October 4, 2010  11:00 AM

Speaking at Microsoft User Group in Irvine, CA

Denny Cherry Denny Cherry Profile: Denny Cherry

Workbridge Associates is starting a new Microsoft Users Group which will be meeting at their offices in Irvine, CA on October 19th, 2010.  I’ve been asked to be the speaker at the first meeting, and since I’ve got sucker written on my forehead I’ve accepted.

As this is a new User Group, I’m breaking out a new slide deck and presentation for the meeting.  I’ll be talking about data encryption, the ways to encrypt data at the various levels of the application, the pros and the cons of all the techniques.  This deck is actually inspired by a chapter from my upcoming book on SQL Server security which I’ll be talking about a little as well.

Workbridge Associates will be providing pizza, and there is the possibility that cold frosty beverages will be provided (don’t quote me on that, management can always get in the way of that).  There is a small parking fee for the lot, but I’m not sure if the lot will be open to the public or not for free at night, so bring a few bucks for parking just in case.  Everyone is invited, and since they are a recruiting company they will be inviting a lot of hiring managers, so it may be a great way to run across that new position you’ve been looking for.

The meeting will start at 6:30pm at 4675 Macarthur Court Suite 960 Newport Beach, CA 92660 (they say that their address is Newport Beach, but I’m pretty sure they are in Irvine, it right across from John Wayne Airport).

Hopefully I’ll see you there.

Denny

September 30, 2010  11:00 AM

VMware 4.1 VMware Tools upgrade fails

Denny Cherry Denny Cherry Profile: Denny Cherry

Just after upgrading our hosts from VMware 4.0 to 4.1 I ran across a little problem.  None of the guest machines could get the VMware tools upgraded automatically.  I had to log into each machine and upgrade the tools (ok I only did 2 or 3 manually).  It turns out that if the VMware tools had been upgraded on the guests before they would have c:\windows\temp\VMwareToolsUpgrader.exe and this file needs to be deleted before the upgrader will run automatically.

So I didn’t really want to log into 80 machines to delete this file manually, so I came up with a quick batch file to delete this file on every machine in the company.

for /F %%a in (cp.txt) do attrib -r %%a\c$\windows\temp\VMwareToolsUpgrader.exe
for /F %%a in (cp.txt) do del %%a\c$\windows\temp\VMwareToolsUpgrader.exe

Export the list of computers being hosted by VMware and save them as cp.txt.

This batch file removes the read only attribute from the file, then deletes the file. That’s right the file is read only so you can’t just delete it.

Just take the code above, stick it in a batch file and run it from a domain account that has rights to every server.

Denny


September 27, 2010  11:00 AM

Slide Deck from my PASS Virtualization VC

Denny Cherry Denny Cherry Profile: Denny Cherry

Last week I gave a presentation to the PASS Virtualization VC on how to decide if virtualization is a good choice for your SQL Server.

Denny


September 23, 2010  11:00 AM

Speaking at the Performance Virtual Chapter in October

Denny Cherry Denny Cherry Profile: Denny Cherry

So on October 5th at noon eastern (9am Pacific) I’ll be giving a presentation on getting better performance from your storage solution to the SQL PASS Performance Virtual Chapter.  The Live Meeting info isn’t up on the site yet, but I’ll send something out when I get than info as well.  Until then, save the date.

Like the session that I’m doing in September for the Virtualization VC this will be a bit of a teaser for the pre-con that I’ll be doing up at the summit in November.  I’ll see you on the 5th.

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.


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: