SQL Server with Mr. Denny


August 23, 2014  1:40 AM

Recommended reading from mrdenny for August 22, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, 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: RealSQLGuy also known as Tracy McKibben

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 21, 2014  3:25 AM

SQLPASS SQL Karaoke Party Location Announced

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, SQL Server

sios_logoI’m pleased to say that we’ve secured a new location for the SQL Karaoke party at the SQL PASS Summit this year. This year we’ll be at a bar called Cow Girls Inc which is at 421 1st Ave S in Seattle, WA. It’s a 20 minute walk or an 8 minute cab ride from the convention center and hotels. Like past years, everyone is welcome to attend even if you don’t get signed up for a wristband. The wristband is only needed for the open bar, and a cash bar will be available for those without a wristband.

Unlike years past, the bar will only be open for us so we ask you to please register in advance (you can get in even if you don’t, but it’ll be a lot easier if you register).

Tickets are limited so be sure to register to attend.  Like in years past the party will start right after the welcome reception ends.

Don’t forget to thank the sponsor for this years party SIOS and be sure to go to their booth and learn more about SANLess Clusters.

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


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: