SQL Server with Mr. Denny


July 30, 2014  4:00 PM

Beating Jetlag

Denny Cherry Denny Cherry Profile: Denny Cherry
Long distance information travel., SQL, SQL Server, Travelling

The biggest downside of traveling to places far and wide is jetlag. If you’ve never flown father than 1 or 2 timezones you’ve never experienced the true joy that is jetlag. For most people traveling east, sucks while traveling west isn’t to bad. I’m one of these people.

What most people do, especially the first time they fly east (from the US to Europe for example) is they figure that they’ll just be fine when they land. I’d be willing to bet that anyone that’s tried that was wrong. Changing 8 or 9 timezones in one shot is VERY brutal.

A couple of times now when traveling from California to Europe I’ve decided to deal with the jetlag while at home. Basically this means that every morning I get up a couple of hours earlier and go to bed a couple of hours earlier until I end up on European time (9 hours ahead). This takes me around 4 days to do it. It isn’t fun, but it’s a lot better than spending the first 3 days of my trip in Europe dealing with the jet lag (it normally takes me between 2 and 4 days to kick the jetlag depending on what I’m doing during the day).

It isn’t a very complex process. The first day I simply set my alarm to get me up 2 hours early. When I get up I set the next days alarm for 2 hours earlier (I can handle 2 hours of jetlag in a day no problem). I also set an alarm for when I need to go to bed, so that I actually do.

After a few days I’m getting up at midnight (which is 9am in Europe) and going to bed at 4-5pm (which is 1am in Europe). This usually works well with flights getting to Europe. For example this last trip I flew from home (San Diego) to Toronto (sadly no I didn’t see the crack head mayor at the airport). That flight left at 8:15am so I needed to be at the airport by 6:15am. Normally this would suck, but as I’m getting up at midnight that’s no problem. My flight landed in Toronto (all the timezone switching makes things really hard to figure out) at 4pm EST (9pm in Europe). My flight from Toronto to Europe left at 5:45pm EST (11pm in Europe), which served dinner then breakfast. So basically I had a late dinner, then fell asleep and woke up for breakfast just before landing (breakfast is usually served about an hour before landing) at 11:30pm PST (2:30am EST, 8:30am in Europe). My final flight of the day left at 10:30am and arrived at 11:30am, just in time for lunch. I had a day of sightseeing and the next day I was off and ready to go at the SQL Tune In conference, thankfully without feeling like I was going to die.

Now will this technique work for everyone? No probably not. As I work from home I’ve got the ability to work basically whatever hours I want, so slowly shifting my hours day by day isn’t that big of a deal. If you’ve got this sort of flexibility before going on a trip, either for business or pleasure I’d highly recommend it. The first mistake that 1st time travels make is not accounting for jetlag recovery in their schedule.

Denny

July 25, 2014  6:39 PM

Recommended reading from mrdenny for July 25, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Cluster, Diagnostic logging, SQL Server, SQL Server Analysis Services, Wireless

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

This weeks SQL Server person to follow on Twitter is: bob_duffy also known as Bob Duffy

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny.

Denny


July 23, 2014  5:00 PM

How to Get Rid of My Magazine On Your New Android Phone

Denny Cherry Denny Cherry Profile: Denny Cherry
Android, phone, SQL

Recently I picked up the new Samsung S5 from Verizon. 2014-04-23 17.37.14Over all it’s a great phone, but one REALLY annoying thing which is shoved down your throat is the  “My Magazine” feature which sits to the pane to the left of the home screen. So if you are on the home screen and swipe left you are dropped into this annoying application, which you can’t uninstall because Samsung (or Verizon, but I’m pretty sure Samsung) has decided that you WILL have this application up and running on your phone if you like it or not.

If you go into the application’s properties you can’t uninstall it.  If you halt it, it just comes back to haunt you.  When I first came across this little nightmare everything online said that you needed to root the phone to make this go away.

Turns out that isn’t actually the case.  There is a hidden settings screen which is available to you that you can use to turn off the “My Magazine” feature of the phone.

Start by going to your home screen (pressing the button at the bottom of the phone until you see your default icons).

2014-04-23 06.24.49Once on the home screen, press and hold the task manager button (it should be the one to the left of the home button and should look like one rectangle on top of another rectangle).  When that happens you’ll get another screen that’ll look similar to the screen to the left with three new buttons appearing on the screen named “Wallpapers”, “Widgets” and “Home screen settings”.  Tap on the “Home screen settings” button to get to the hidden settings menu.

Once you are on the “Home screen settings” menu you’ll see an option to remove2014-04-23 06.24.53 the “My Magazine” feature by simply unchecking the check box next to the “My Magazine” feature.  This will remove “My Magazine” from being to the left of the home screen, and will go a long way to making you stop hating Samsung.

Why this isn’t available from the normal settings menu, I have no idea.  The only possible reason that I can think of is so that it’s harder to turn off so that more people will use it.  That’s about the only reason that makes any sense to me.

But at least it’s removable once you no where to look for the setting to kill it.

Denny

(No I didn’t find this myself.  My wife told me about it, but she doesn’t blog and I do.  So she gets the credit for finding this however she found it.)


July 18, 2014  2:00 PM

Recommended reading from mrdenny for July 18, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Big Data, Microsoft, Recommended reading, SQL Server 2014

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

This weeks SQL Server person to follow on Twitter is: ColinStasiuk also known as Colin Stasiuk

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny.

Denny


July 16, 2014  5:00 PM

Why Should I Backup Dev & QA Servers?

Denny Cherry Denny Cherry Profile: Denny Cherry
Data backups, SQL, SQL Server

While the development and QA servers are by definition not customer facing production servers, they are in fact production servers to some. In this case they are production servers for your Development and QA teams. Because of this I always recommend backing up development and QA servers to my clients. The dev and QA teams aren’t able to work without their respective servers, and if large amounts of data change are lost from the dev and QA databases then that data or schema changes will need to be identified and reapplied which takes time and resources costing the company money.

Because of this I always recommend that these systems should be backed up just like the customer facing production servers are.

Denny


July 11, 2014  2:57 PM

Recommended reading from mrdenny for July 11, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Blogging, HP, IT conferences, IT conferences and events, press, Recommended reading, SQL Server, Tech conferences, technology conferences

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

This weeks SQL Server person to follow on Twitter is: BenjaminNevarez also known as Benjamin Nevarez

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny.

And don’t forget to get signed up for my SQL PASS 1st Timers Webcast on August 20th.  Even if you aren’t a 1st time attendee to PASS this webcast will be full on great information about the summit, the after events, and will be a good reminder on how to get around the Seattle convention center and where things will be at this years conference.

Denny


July 9, 2014  3:14 PM

#sqlpass Summit 1st Timers Webcast 2014 Edition

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences, IT conferences and events, Microsoft, Microsoft MVP, SQL, SQL Server, Webcast

I’m pleased to announce that my now annual SQL PASS 1st Timers Webcast 2014 Edition will be Wednesday August 20th, 2014 at 11am Pacific sios_logo/ 2pm Eastern / 6pm (1800) GMT.  This years event is being sponsored by the fine folks at SIOS Technology Group.

During this session I’ll be talking about the things you need to know if this is your first PASS Summit, or if this is your first trip to Seattle (in case last year was your first PASS summit).  I’ll be talking about things like the best ways to get from the airport to downtown, which hotels are your best bet, how to get around the city, where the must see things if you’ve got some tourist time scheduled, and a lot more.  And of course I’ll be announcing this years SQL Karaoke party including sponsor, location and of course where to sign up for your wristband.PASS Summit 2014

This years PASS Summit will be a little different from prior years as the MVP summit will be held the same week so you may see a bunch of extra MVPs floating around and finding the SQL Server MVPs may be a little difficult on Monday and Tuesday as may of us will be at our MVP summit those days.

You’ll want to get signed up for the webcast in advance so that you can be sure to get a spot, as the webcast site does have a limit to the number of people who can attend.

I’ll see you on the webcast, and at the PASS Summit. Like last year I’ll be at my booth, the Consultants Corner with a couple of other great consulting companies, so be sure to swing by and say hello.

Denny


July 4, 2014  7:58 PM

Recommended reading from mrdenny for July 04, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
CYBER SECURITY, Microsoft, Recommended reading, SQL Server, SQL Server 2014


For all my US readers, I hope that you have a happy fourth of July.

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

This weeks SQL Server person to follow on Twitter is: SQLRockstar also known as SQLRockstar

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny.

Denny


June 30, 2014  2:00 PM

Congratulation SQL PASS 2014 Speakers

Denny Cherry Denny Cherry Profile: Denny Cherry
Conferences, IT conferences, Microsoft Excel graphs, Public speaking, Speakers, SQL, SQL Server

I’d like to congratulate the freshman class of SQL PASS Speakers for 2014.  You are joining a very small group of people who have spoken at the SQL PASS Summit.  In total there have only been a few hundred people who have spoken at the SQL PASS Summit.  The number of speakers year to year as we all know is a pretty small group, and each year we also have a small group of people who are first time speakers.  Let’s review some of the numbers which this handy chart that I made (we are all data people here after all).

speakers1

As you can see from my graph, the total number of speakers has hovered around 200 speakers for the last 5 years (all the years worth of data which is available on the SQL PASS website).  The number of new speakers is obviously a smaller number, with the number of new speakers each year getting to be a smaller and smaller number.  As we can see in the next chart the number of new speakers year over year is actually getting smaller (again, only using data since 2010 as that is all that’s available).

year_over_year_changes

And if you prefer percentages instead of numbers, I made one of those as well (yes those 2011 percentages really are that high as this is change, not growth)…

per_year_over_year_changes1

If you haven’t figured it out by now, getting into the club of SQL PASS speaker is a really hard club to get into, and you’ve earned the spot which you’ve received.  Never let anyone tell you that don’t deserve that session spot, or that you took someone else’s session.  Sessions are given based on abstracts which means that you earned your spot.

Now do yourself and your fellow speakers proud this November.  Give a great presentation, don’t be nervous if someone you’ve seen present comes and sits in your session, and have a great time at the PASS Summit.  There’s nothing like speaking at PASS, so have fun and enjoy what’s probably your first (and hopefully not last) session on the big stage of international conferences.

UPDATE: The speaker count for 2014 does NOT include all Microsoft speakers as they haven’t been announced yet. This is one of the reasons that the speaker count is lower for 2014. Another is the fact that this year a lot more speakers have two sessions, where in previous years only a few speakers have had more than one session (see graphic which I stole from Kendal below).

sessions1

Denny


June 27, 2014  5:19 PM

Recommended reading from mrdenny for June 27, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Big Data, Cloud Computing, Net Neutrality, SQL Server, T-SQL

This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.

This weeks SQL Server person to follow on Twitter is: SQLBalls also known as Bradley Ball

Hopefully you find these articles as useful as I did.

Don’t forget to follow me on Twitter where my username is @mrdenny.

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: