SQL Server with Mr. Denny


August 19, 2014  6:26 PM

What’s New at #sqlpass / 1st Timers Session TOMORROW!!!

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences, SQL, SQL Server

Just a reminder that my SQL PASS 1st Timers Session is TOMORROW, and that you have to register for the session.  During this session we’ll cover where everything has moved in the convention center, which includes the keynotes, some session rooms, as well as some big community announcements about how YOU can get a speaking slot at the PASS Summit in 2015!

So don’t forget to sign up for the webcast and see what all the changes are for the PASS 2014 Summit.  If you haven’t attended the PASS Summit and you are attending this year, you’ll want to check out this webcast for sure.  Another big thank you to SIOS for hosting the Webcast for me this year.  Seats for this years webcast are limited, so be sure to get signed up!

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

August 15, 2014  5:19 PM

Recommended reading from mrdenny for August 15, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
community, Heartbleed, iSCSI, Opex, 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: russjohnson also known as Russ Johnson

Hopefully you find these articles as useful as I did.

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

Denny


August 13, 2014  2:00 PM

Why Should I Attend The 1st Timers Webcast

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences, SQL, SQL Server

So you may have heard, that next week I’ll be presenting my annual SQL PASS 1st Timers webcast. Even if you have attended PASS before you may want to attend this webcast. There’s going to be some changes to how things are laid out at the convention center (hint, registration has moved). We are using more session rooms this year then we ever had before as well.sios_logo

I’ve got some big stuff which is being announced at the webcast as well, so you won’t want to miss the webcast. But you MUST sign up to attend.

So don’t forget to sign up for the webcast and see what all the changes are for the PASS 2014 Summit.  If you haven’t attended the PASS Summit and you are attending this year, you’ll want to check out this webcast for sure.  Another big thank you to SIOS for hosting the Webcast for me this year.  Seats for this years webcast are limited, so be sure to get signed up!

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


August 11, 2014  5:00 PM

Full-Day Workshop: Storage and Virtualization for DBAs

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL

I’m pleased to say that I’ve been asked to present a full day session at Dev Connections titled “Storage and Virtualization for DBAs”.  In this two-part session will focus on two of the biggest topics in the DBA field: how to properly design your SAN solution and how to properly design your virtualization solution. In the first half of the session we’ll focus on the storage array. Storage can be one of the biggest bottlenecks when it comes to database performance. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often don’t speak the same language. In this session we’ll look at storage from both the database and storage perspectives. After going over the components we’ll dig into some advanced storage configurations, including RAID groups, multi-pathing software, and proper redundant storage network design. We’ll also dig into some advanced storage array backup techniques, including taking storage-level clones and snapshots. After we cover these advanced techniques, we’ll dig into how we can best use them to back up a SQL Server environment to provide maximum redundancy with no recurring tape costs. In the second half of the day we’ll look at the pros and cons of moving SQL Server systems into a virtual server environment. Specifically, we’ll discuss when it’s a good idea and when it’s probably not a good idea.

If you’ve been working in IT for really any period of time, and you want to learn move about how the storage and virtualization platforms that we use every day work, and how to make them work better for you, then this is the session for you to attend.

Seats are still available for the session, you just need to register to attend this great session being held September 15th, 2014 at Dev Connections in Las Vegas, NV.

I hope to see you in Las Vegas,

Denny


August 8, 2014  5:24 PM

Recommended reading from mrdenny for August 08, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Data Domain, EMC, EMC VNX, EMC World, HIPAA, 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: amy_lewisAZ also known as amy_lewisAZ

Hopefully you find these articles as useful as I did.

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

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


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: