magnify
formats

SQL Saturday tip: Manually printing your SpeedPASS

Published on November 12, 2013 by in SQL Saturday

Manually print your SpeedPASSMost of the time when you sign up for a SQL Saturday, the event organizers will send out an email containing a link to your SpeedPASS. This is a pre-generated PDF that has your tickets and name tag. Just click on the link in the email and print it out.

If you register late or miss the email (sometimes it ends up in your spam folder), you can manually print your SpeedPASS:

– Login to the SQL Saturday site with your PASS login. Then click “View Profile” on the right.

– Scroll down to the bottom and locate the event you want. Then click the printer on the right.

 

 

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

SQL Saturday Kalamazoo Recap

Published on November 4, 2013 by in SQL Saturday

I recently attended SQL Saturday #256 in Kalamazoo, MI.  I got the opportunity to go at the last minute due to some plans being reshuffled; so I eagerly signed up.  Oddly, this is my 2nd SQL Saturday event this year at which I did not speak. It gives you a different perspective on the day’s events. I definitely recommend trying it sometime, fellow speakers.

First off, I sat in Aaron Bertrand’s session on T-SQL: Bad Habits and Best Practices. I’ve been wanting to see this one for a while now and finally caught up with Aaron.  Next I attended Stacia Misner’s A Big Data Primer. Not very technical but a good perspective on the Big Data movement and where we may be headed. Afterward, I listened to Tamera Clark offer up good advice on SSRS Formatting Tips and Tricks.

After an excellent taco bar lunch, I sat in and listened to my friend Hope Foley speak on Server Side Performance Tuning. Lots of good advice and tips as well. Next up, Tim Ford on the Periodic Table of DMV’s: Collecting Baselines. Tim did an excellent job and I will be definitely be taking a look at his demo scripts. Finally, Karen Lopez and Joey D’Antoni presented on You wouldn’t let HR manage your databases for a great look at managing your career, recruiting, consulting, and insider tips.

I’d like to thank Josh Fennessy and his team of volunteers who did a really good job of organizing the event. Their experience clearly showed through.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
1 Comment  comments 
formats

The Information Security Summit

Published on November 4, 2013 by in Events

I recently attended the 11th annual Information Security Summit held at LaCentre in Westlake. I know some of the organizers and have volunteered for the past couple of years. This event has been quietly gaining steam for many years, this year surpassing 550 attendees and 30 sponsors over two days.

Although security is not my background, I continue to find it useful to cross pollinate and meet other professionals in other IT communities. This year was no different and I met lots of interesting and smart people.

The conference was well organized and went off without any major mishaps. One thing I did notice though is that the ISS appears to have outgrown the LaCentre location. It will be interesting to see what the organizers do for a venue next year.

All in all, it was a good event. If you have any colleagues working in Security or GRC, let them know about the best kept secret in NE Ohio IT.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

SQL Saturday 256 Kalamazoo

Published on October 31, 2013 by in SQL Saturday

As a result of some last minute schedule changes, I will be attending SQL Saturday 256 in Kalamazoo, MI this weekend. This is my 2nd SQL Saturday this year where I don’t have speaking responsibilities. Attending can be fun enough though and I look forward to seeing my friends and #sqlfamily soon.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Akron AITP

Published on March 23, 2013 by in Presenting, Speaking

I’m honored to be speaking at the Akron AITP user group on Tuesday March 26th. I’ll be presenting on LinkedIn for IT Professionals. The Akron AITP (Association of Information Technology Professionals)  is celebrating their 60th anniversary this year. Wow. Most IT organizations are mere infants in comparison. I have presented at the group before and look forward to seeing some friends and familiar faces there.

Many people I run into need help in understanding the value in LinkedIn. My presentation aims to help IT Pros get the most out of LinkedIn as a professional social networking platform. Hope to see you there!

 Akron AITP Home

EventBrite Registration

 

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

SQL Saturday 204 Detroit Download Links

Published on March 17, 2013 by in SQL Saturday

For those who attended my sessions at the SQL Saturday event here are the links to download the slide decks:

Just click on the orange download button

Upgrade Roadmap : Let’s Delve into SQL Server 2012

Download

LinkedIn for SQL Server Professionals

Download

Feel free to contact me if you have questions or comments. Thanks!

 

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

SQL Saturday 204 Detroit Recap

Just a few notes from the SQL Saturday #204 event, in no particular order.

Speaker Dinner, this went well. I got there a little late and things were already in full swing. The dinner was at a pizza place. A nice perk was they had open bar, something that not all events have. The food was excellent deep dish pizza served buffet style. I settled in to chat with some of my speaker friends, Allen White, Eddie Wuerch, Brian Davis, Karen Lopez, Carlton Ramsey and Josh Fennessy.  Lots of good conversation ranging from Big data to SQL Saturday war stories.

Saturday morning I awoke to find about 3 inches of snow outside. Yikes, I thought winter was over. I headed over to the event, held at Lawrence Technological University, known to the locals as “Larry Tech”. There were lots of event organizers and volunteers present and I had no problem finding the place and building. A victory for SQL Saturday signage.

My New Horizons colleague George Squillace was presenting for the 1st time at a SQL Saturday (and a lead off session to boot) so I headed off to his room to make sure everything was OK. George was already set up and ready to go.  I stayed in his session for about a half hour and then headed over to the speaker room to practice my demos.

My 1st session of the day was my “Upgrade Roadmap: Let’s delve into SQL Server 2012″. I have done this one many times and it’s like an old friend. Still lots of useful, relevant content in it though. I changed it up and chose the Upgrade Advisor demo this time. I usually do an extended events trace on Deprecated Features demo  but there’s usually only time for one demo, even with a 75 minute presentation. Just too much content there.  I had about 25 attendees and I thought it was well received with several good questions and comments.

Out in the hall, I ran into David Klee, a fellow speaker. We’ve been crossing paths and almost meeting at SQL Saturdays for almost a year now.  It was good to finally meet David and put a name with a face. We ended up having lunch and chatting about Hyper-V, Vmware and virtualizing SQL Server.

I sat in the Hadoop session by Rob Kerr. It was very informative. Based on some conversations, a lot of people are currently kicking the Microsoft/Hadoop/HDinsight tires but nobody has jumped in the pool yet.

My session on LinkedIn was up next. I really love to present on this topic. I had about 15-20 people attend the session. For a mid afternoon session, on a PD topic at a SQL Saturday, that’s a big turnout.  My initial polling confirmed my audience as I suspected: 75-80% of the attendees were on LinkedIn, most had under 250 connections, and over half did not have a profile 100% complete. That’s why I was presenting on the topic, to teach people on how to get the most out of LinkedIn. The presentation went well, with all presentation feedback of 5 from everyone who filled out an eval.

After that, I decided to skip the last session and head for home to spend some time with my wife.

Thanks and Cudos to Joe Fleming, and his team of volunteers and organizers who did a great job for their 1st SQL Saturday in Detroit. Thanks also to the sponsors of the event. Without you, it would not happen.

 

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Steel mill update

Published on March 17, 2013 by in Personal

Back in August 2012 I described the bankruptcy of RG Steel and the possible fate of three our nation’s remaining steel mills. I now have an update and some commentary based on my experience in the steel industry, several lifetimes ago.

Sparrow’s Point (Baltimore) MD

It’s over folks. Formerly the largest steel mill in the world will be eventually no more. It will likely take several years to break it apart. The nail in the coffin was the purchase of the (relatively new) cold rolling mill by Nucor. That was the only really valuable piece of the mill left. Everything else was operating at an mid 20th century energy usage and efficiency footprint. So the famous “L” blast furnace will likely end up as scrap and what’s left will be probably hauled off to China.

Steubenville North, OH

Reportedly, the mill is in the process of being demolished.  This mill had been shut down for several years so there is no surprise here. Sadly, I was not able to make it down there and take some pictures before the wrecking ball arrived because this mill was unique with the blast furnaces actually part of the bridge overlooking the Ohio River.

Mingo Junction, OH

Mingo has been shut down for about 4 years now. I’m still scratching my head on this one. Mingo has had nearly everything going for it. A nearly brand new Electric Arc Furnace ($100 million+), a newer caster, AND an 84 inch hot strip mill. Some the recent research I have done on the mill has indicated that there was much money put into the hot strip mill in the last 10 years for enhancements and upgrades.  This represents a nearly perfect steelmaking operation with modern, efficient gear.  They just demolished the Ore bridge a couple of weeks ago so it looks like the blast furnace will be next. So the Electric furnace is going to be the future of Mingo.

The jury’s still out on Mingo , folks. Stay tuned.

Warren, OH

This one is close to my heart. A long time ago I saw with my own eyes the continuous caster, installed in 1988, in operation. Watching molten steel being transformed into slabs inside an enormous machine is truly a once in a lifetime event and I will never forget it.  Today if you don’t have a caster you are out of business but back then it was a big deal for Warren.

The good news for Warren is that they were able to winterize the blast furnace.  We still don’t know what will happen but there is an auction coming up this month to sell off some tooling, machinery, and auxiliary supplies. Oddly enough they will auction off the Wean 48 inch galvanizing line. I might argue that this is critical to the operation but I understand that CJ Betters needs to make money.

Pros for Warren are that they have historically been the market leaders for high strength/low alloy, high carbon, and electrical tool steels. The bad news is their customers have likely found other suppliers by now.

After that, we just don’t know about Warren. One serious problem with the Warren mill is that they only have a 56 inch hot strip mill.  That’s kind of like the kiss of death in the steel industry. Anything less that 72 inches these days is considered obsolete.

Another ramification is that, based on some news reports, is that (across the board) much of the workforce is at or very near retirement age. When the accumulated knowledge of how to make steel and operate the equipment is taken off of the table, what does ramifications does that have for the future of steel making in this country?

It should get interesting to see what happens this year with Mingo and Warren.

 

 

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

Touchdown: First class on the board

Published on March 3, 2013 by in Personal, Teaching

I am pleased to report that last week I successfully taught my first class as a Technical Instructor at New Horizons Great Lakes. I taught 20410 Installing and Configuring Windows Server 2012. This is kind of like a homecoming for me because a long time ago I used to be a big fan of Windows Server OS and it was good to get back and relearn it.

I had four students , all virtual on the online Elluminate platform. The more I work with Elluminate, the more I like it. Think if it as a Webex LiveMeeting on Steroids. We had a few mishaps but that is to be expected. Several lessons learned:

– Do not use the IronKey security fob while teaching. It took about 1/2 a day to figure out that this was crashing my IE. Oddly enough, it has worked fine on my laptop for over a year now with no IE crashes.

– Do not scale IE windows up or down (%). I had a window scaled for a screen shot and forgot about it. It causes havoc with the New Horizons online labs (LOD).

– Timing and pacing still count for a lot , even in a 5 day class. Part of me had to keep track of where we would start and end each day that I did not anticipate.

I haven’t seen my reviews yet but I remain hopeful my students had an enjoyable and fruitful learning experience.  Next up for me is the industrial strength:  10774 – Querying Microsoft SQL Server 2012. Stay tuned.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

Windows Server 2012 UI

Since I have landed here at New Horizons, I have spent an enormous amount of time in front of Server 2012 in labs, demos and training in general.  Here’s some thoughts and observations about it and in particular the UI. (Note that I did not say GUI)

  • It’s the biggest Windows Server release since Windows 2000. Absolutely huge and game changing.
  • The strange departure from the Aero Glass look (Vista and Windows 7) is fresh and nicely minimalist. I will note that I was a fan of the Aero Glass look and will miss it.
  • Sometimes the Metro UI is slow to update. When in doubt hit the Refresh button.
  • I don’t think the Metro UI belongs on Servers. Us server administrators took collateral damage on the Metro look.
  • The removal of the Start button and addition to the “hot corner areas” is hokey and not suited for servers. It is also  downright hostile for online labs and RDP sessions. But it is what it is. We have to learn to live with it.
  • Learning Keyboard shortcuts will help you greatly. I have learned more Windows keyboard shortcuts in the past month than in the past 10 years.  Here’s a great chart showing Windows Shortcuts, including some new to Windows 8 / Server 2012 that will really help you get around fast.

I believe the net effect of all these UI changes will be to force greater adoption and usage of Powershell by Administrators on servers. I’ve already learned a lot of Powershell, as it’s just quicker and easier than struggling with the GUI. Stay tuned as I will soon begin a series on Windows Server 2012 UI tips and tricks.

 

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments