SQL Server with Mr. Denny


August 6, 2014  5:00 PM

What security options should you be using for linked servers?

Denny Cherry Denny Cherry Profile: Denny Cherry
Linked Server, Linked servers, SQL, SQL Server

When setting up linked servers, what security settings do you typically setup for that question at the bottom of the window?
linked_server

As you can see from the screenshot there are four options. Two of them are good options, two of them are bad options. Do you know which ones are which?

The Bad Options
The two bad options to choose are the second (Be made without using a security context) and fourth options (Be made using this security context). These both have different problems, but for the most part they are just bad.

When you select the without a security context the SQL Server attempts to connect to the remote database using anonymous authentication. If the remote server is setup to allow anonymous authentication then the user is able to log into that system and run queries against the remote database, possibly even dropping objects or changing data that shouldn’t be changed. All without any possible auditing on the remote machine.

When you select using this security context anyone who comes into the SQL Server can access the remote server using whatever account is specified. So if the account which you list has admin rights then everyone on your SQL Server has admin rights on the remote server, which is bad.

The Good Options
The much better options are to use the first option (Not be made) or the third option (Be made using the login’s current security context). These are much more secure because they either don’t allow access through the linked server, or they require that the users login has access to the remote server. Either way, these are much more secure options than the two listed above.

Now there are cases when you need to use one of the two options listed above as the bad options. For example if you need to access a Microsoft Access database, or an Excel sheet, etc. But these are the exception not the rule.

Denny

August 1, 2014  6:59 PM

Recommended reading from mrdenny for August 01, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
MSDN, Recommended reading, SQL Server, 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: PASSAppDev also known as PASS AppDev VC

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 30, 2014  4:00 PM

Beating Jetlag

Denny Cherry Denny Cherry Profile: Denny Cherry
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, 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
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, Recommended reading, SQL Server

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
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


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: