SQL Server with Mr. Denny


October 8, 2014  4:00 PM

Still Time To Sign Up To Be In SQL PASS Speaker Idol

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

Speaker Idol 2014 BadgeEver wanted to be a speaker at the PASS Summit? Now is your chance to impress some top notch judges and sign up to be one of the contestants in the PASS Summit Speaker Idol competition. Entering is easy, simply fill out the registration form and if you are selected to be one of the 12 contestants you’ll have a chance to win a speaking spot at the PASS summit.  The registration form is very basic, no abstracts just your contact info and why you want to speak at the PASS summit.  And the price is worth your time, the winner of the competition will has a guaranteed session at the SQL PASS Summit 2015.

You can read more about the speaker idol on the Community Session Room page on the PASS Summit site, and all the official rules are available on this blog post.

I hope to see you on stage in the Community Session Room, at the PASS Summit during Speaker Idol, and then hopefully on stage giving your own presentation during the SQL PASS 2015 Summit.

Denny

 

October 4, 2014  2:01 PM

Recommended reading from mrdenny for October 03, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
CASE, SQL, SQL Azure, SQL Server, statistics, Windows Azure

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: m__wild also known as Martin Wild

Hopefully you find these articles as useful as I did.

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

Denny


October 1, 2014  12:52 PM

The SQL Saturday After Party is Part of the Job

Denny Cherry Denny Cherry Profile: Denny Cherry
community, social, SQL Server

SQL Saturday organizers do an amazing job putting together their events. The number of hours that the organizing team for each of these events put in to get these events to come together is just staggering. They schedule pre-cons, speaker dinners, the event, the after party, snacks, coffee, breakfast, etc. And all on their own time without getting paid for it.

As speakers we need to do better about attending things like the speakers dinner and after party when the organizers put them on. They are frankly part of your job for being at the event. Now if you have to fly home the evening of the event, I get that. But if you are there in town, socializing with the organizing team, sponsors, speakers and attendees for a couple of hours is kind of part of the deal.

I’ve heard about a couple of SQL Saturdays where the after party was pre-paid because that’s how group events are arranged. After a short time of talking to people, the bulk of the speakers and attendees suddenly took off to go somewhere else leaving about a half dozen people at the after parties. This left the organizers with $1000 in beer and food that was already paid for, that no one drank or ate.

Scheduling these sorts of social events which conflict with the official events is basically a dick maneuver. Especially when you don’t tell the event organizer that you are going somewhere and taking all of their event attendees with them. If the after event it’s your kind of thing you’ve got a couple of options.

1. Don’t go to the after event
2. Go, pretend to have a good time and suck it up
3. Go, pretend to have a good time, then once the after event has been a success, go socialize. You are going to stay out all night anyway. Let the good times roll.
4. Fly home Saturday night

But for the love of god, don’t ruin the organizers after party for their team and their attendees just because you want to do something else. When you run your local event, you get to plan everything. When you attend someone else’s event you do what they have planned, you act professional and you ensure that the attendees have a good time at the official events. If you don’t like these rules, we’ll call them “Denny’s Rules” don’t go. This is why when I have a BBQ at the SoCal SQL Saturday’s, I have it on Thursday nights. I know that I don’t have room for everyone, so the people that do come, come a day early so that we don’t impact the official event.

Denny


September 26, 2014  5:11 PM

Recommended reading from mrdenny for September 26, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
EMC, EMC Arrays, EMC VNX, Microsoft MVP, SQL Server 2014, SQL Server Express, VMware

On a personal note, today is my 15th wedding anniversary to Kris.  Thank you to my Kris who’s put up with me for all these years.

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: SueBrownawell also known as Sue Brownawell

Hopefully you find these articles as useful as I did.

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

Denny


September 24, 2014  7:00 PM

All Your Hardware Should Be Of The Same Class

Denny Cherry Denny Cherry Profile: Denny Cherry
Cisco UCS, Data Center Hardware, SQL, SQL Server

I’m seeing a really disturbing trend in enterprise hardware purchases these days. Companies will spend hundreds of thousands of dollars on their Compute environment (the servers) but they cheap out on the storage. In the last two weeks I’ve talked to people from two different companies who have top of the line Cisco UCS servers, but for their storage they have low to mid end storage systems.

This just doesn’t make sense to me. If you know that your workload is going to be high enough to justify the cost of the Cisco UCS platform why cheap out on the storage which is really the key to making things run faster? If I know that I need to run 200 VMs in my farm, including a bunch of SQL Server instances, why are you going to buy storage that can handle 14k IOPs max (at RAID0) then after RAID something like 8k IOPs? That just doesn’t make a lot of sense at all to me.

If you are going to spend this kind of cash, spend a little more and do it all right. Everything will work much better in the long run this way.

Denny


September 19, 2014  5:09 PM

Recommended reading from mrdenny for September 19, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
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: ygtaktn also known as Yigit Aktan

Hopefully you find these articles as useful as I did.

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

Denny


September 17, 2014  4:00 PM

Getting Windows Authentication to Work Without a Domain

Denny Cherry Denny Cherry Profile: Denny Cherry
Active Directory, Authentication, SQL Server, Windows authentication, Windows Workgroups and Networking, Workgroup, Workgroup Servers

Not every company has Active Directory setup to give them a centralized way of managing authentication. For those who manage SQL Servers within a Workgroup getting authentication to work correctly with Windows logins can be tricky if you haven’t done it before.

In order to get Windows logins working correctly the trick is to create a local account on both the machine which you log into and the SQL Server with the same username and the same password. Once that is done you can grant permissions within the SQL Server instance to the local account.

So if your workstation is PC1 and your SQL Server is SQL1, then within the OS of SQL1 you create a login named dcherry. Then within SQL you create a login for SQL1\dcherry and give it the rights which are needed. Now in PC1 create a login called dcherry. Now log into PC1 as dcherry, open SQL Server Management Studio, and you can connect to SQL1 using your Windows account.

Now if you need to change your password for any reason, you’ll need to log onto SQL1 and change your password there as well as the passwords on both machines must be the same.

If you’ve got even a few computers I’d recommend looking at getting Active Directory up and running as it’ll make your life easier in the long run as you don’t have to do all this to get Windows Authentication working.

Denny


September 13, 2014  10:15 AM

Recommended reading from mrdenny for September 12, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Hacking, SQL Server, SSD, Support

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: datachick also known as Karen Lopez

Hopefully you find these articles as useful as I did.

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

Denny


September 10, 2014  4:00 PM

Dangers of Mixing Native Backups and VSS Backups

Denny Cherry Denny Cherry Profile: Denny Cherry
Backup and restore, SQL Server

In today’s modern world of virtualization there are a lot of different ways to backup databases. You’ve got native backups, VSS backups taken by snapshotting the VMs, third party backup tools which take snapshots, etc.

When you have multiple backup techniques all being used at once you run the risk of breaking the LSN chain for your transaction log backups. For your full and differential backups you could end up having a differential backup that you took with one method which is built off of a full backup taken from another backup method. Trying to unwind this during a production down situation becomes very stressful, and depending on the tools which you are using basically impossible to restore from as some tools don’t allow you to restore from them, then restore another layer of backups from another method.

To make life simple and easy to manage only use a single backup method to backup the databases.

Denny


September 5, 2014  5:03 PM

Recommended reading from mrdenny for September 05, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Database mirroring, In-Memory Database, SQL Server, SQL Server 2014, TechEd

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: jasonhorner also known as Jason Horner

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: