SQL Server with Mr. Denny


August 25, 2014  2:00 PM

PASS Summit 2014 Speaker Idol Competition

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

PASSLogoBWIf you watched my SQL PASS 1st Timers webcast last week (which you can see the recording of here) you saw that I announced that this year the PASS Summit will be hosting it’s first ever speaker idol competition.  The goal behind the Speaker Idol competition is to give speakers who are known in their region a chance to be seen at the international level so that they can improve their chances of being selected to speak in future years, to get some real time feedback from other speakers about their presentation style, and so that they can improve as speakers.

pass_2014_banner

In order to qualify to be a contestant in the SQL PASS 2014 Speaker Idol competition there are a few simple requirements:

  1. You have spoken at a SQL Saturday or SQL Rally event (or other large non-pass event, such as SQL Bits, a TechEd Conference, etc.).
  2. You have not spoken at the PASS Summit or PASS Business Analytics Conference for a breakout, spotlight or pre-con session.  (If you gave a lightning talk and no other session you are eligible.)
  3. You will be in Seattle during the PASS Summit (attending PASS isn’t needed, and if you aren’t attending PASS we will get you to the session roomSpeaker Idol 2014 Badge for Speaker Idol).
  4. You are available to attend which ever speaker idol session you are assigned to.
  5. You have a 5 minute technical presentation which you can give.
  6. You sign up on the registration form before October 10th 2014 at 11:59:59pm (23:59:59) Pacific time according to Denny Cherry’s Verizon Cell Phone.

The rules for Speaker Idol are pretty simple.  12 contestants will be selected from those who have submitted.  Those 12 people will be broken up into three groups of four, which will be the initial rounds.  One group will compete each day (Wednesday, Thursday and Friday) with the winners from each round moving on to the final round.  A wild card contestant will be selected from the 9 contestants who didn’t win their initial round.  These four contestants will compete in the final round on Friday.  The winner will be guaranteed a session at the PASS Summit 2015.  The exact times for the Speaker Idol sessions won’t be known until the PASS Summit Schedule is announced.

Judging will be done by a panel of experienced speakers (who haven’t been announced yet) who have spoken at conferences such as the PASS Summit, TechEd, Dev Connections, Intersections, etc.  Judges will give each speaker feedback as soon as they are done presenting.

If you think you have what it takes to compete in this years PASS Summit 2014 Speaker Idol Competition, then I invite you to signup on the registration form.  You’ll notice on the form that there is no session abstract requirement which is correct.  There is no abstract review for selecting the people for Speaker Idol.

So go submit yourself, and I’ll see you at the first speaker idol session on Wednesday.

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


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: