SQL Server with Mr. 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


June 30, 2014  2:00 PM

Congratulation SQL PASS 2014 Speakers

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

I’d like to congratulate the freshman class of SQL PASS Speakers for 2014.  You are joining a very small group of people who have spoken at the SQL PASS Summit.  In total there have only been a few hundred people who have spoken at the SQL PASS Summit.  The number of speakers year to year as we all know is a pretty small group, and each year we also have a small group of people who are first time speakers.  Let’s review some of the numbers which this handy chart that I made (we are all data people here after all).

speakers1

As you can see from my graph, the total number of speakers has hovered around 200 speakers for the last 5 years (all the years worth of data which is available on the SQL PASS website).  The number of new speakers is obviously a smaller number, with the number of new speakers each year getting to be a smaller and smaller number.  As we can see in the next chart the number of new speakers year over year is actually getting smaller (again, only using data since 2010 as that is all that’s available).

year_over_year_changes

And if you prefer percentages instead of numbers, I made one of those as well (yes those 2011 percentages really are that high as this is change, not growth)…

per_year_over_year_changes1

If you haven’t figured it out by now, getting into the club of SQL PASS speaker is a really hard club to get into, and you’ve earned the spot which you’ve received.  Never let anyone tell you that don’t deserve that session spot, or that you took someone else’s session.  Sessions are given based on abstracts which means that you earned your spot.

Now do yourself and your fellow speakers proud this November.  Give a great presentation, don’t be nervous if someone you’ve seen present comes and sits in your session, and have a great time at the PASS Summit.  There’s nothing like speaking at PASS, so have fun and enjoy what’s probably your first (and hopefully not last) session on the big stage of international conferences.

UPDATE: The speaker count for 2014 does NOT include all Microsoft speakers as they haven’t been announced yet. This is one of the reasons that the speaker count is lower for 2014. Another is the fact that this year a lot more speakers have two sessions, where in previous years only a few speakers have had more than one session (see graphic which I stole from Kendal below).

sessions1

Denny


June 27, 2014  5:19 PM

Recommended reading from mrdenny for June 27, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Big Data, Cloud Computing, Net Neutrality, SQL Server, T-SQL

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: SQLBalls also known as Bradley Ball

Hopefully you find these articles as useful as I did.

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

Denny


June 26, 2014  4:50 AM

SQL PASS 2014 Here I Come

Denny Cherry Denny Cherry Profile: Denny Cherry
Hyper-V, Server virtualization, SQL, SQL Server, SQL Server 2014, VMware vSphere, Windows Azure

I’m pleased to report that I’ll be presenting at the SQL PASS 2014 Summit this year. I’ll be presenting two breakout sessions this year. The first session that I’m presenting is “Optimizing SQL Server Performance in a Virtual Environment” where we’ll talk about the various ways that we can make SQL Server run better in a virtual environment. My second session is a newer talk titled “SQL Server 2014 and Azure Integration” where we’ll be talking about all the new features where you can use Windows Azure along with your on premise SQL Server 2014 installations.

I hope that you’ll join me at the SQL PASS summit. To give you a good excuse to get registered RIGHT NOW I’ve even got a discount code for you where you can save $150 (US) off the current cost whenever you sign up. That code is CCSUM14. Just use that when you register for the conference and it’ll knock $150 off whatever the price is when you register. The sooner you register the cheaper the cost will be.

Denny


June 20, 2014  8:12 PM

Recommended reading from mrdenny for June 20, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Cloud Computing, Managers, Recommended reading, SQL Server, Storage, Storage virtualization

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: DBA_ANDY also known as Andy Galbraith

Hopefully you find these articles as useful as I did.

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

Denny


June 18, 2014  4:00 PM

Getting Replication Distribution Back After a MASSIVE Failure

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, SQL Server 2008 R2, SQL Server 2014, SQL Server replication
Distribution

Image from Shutterstock

Recently I had to upgrade a SQL 2008 R2 server to SQL Server 2014 on the fly, because the server in question was the SQL Server replication distributor and a couple of databases which were being replicated were being moved to a SQL Server 2014 instance. The Distributor’s upgrade didn’t go well.

After I got SQL up and running and happy with SQL 2014 CU1 it was time to get replication running again. The first thing I wanted to deal with was getting the SQL Agent jobs back up and running. SQL Server had decided that it was going to put the database files into E:\MSSQL\MSSQL12.MSSQLSERVER\MSSQL\DATA. The first thing that I did was backup the folder as I was going to be playing in here, and I needed a backout plan in case things went horribly wrong.

Backing up the folder is easy. You stop the SQL Server services (SQL Server and the Agent) and copy the folder. I then grabbed the msdb database files from the SQL 2008 R2 folder and dropped them into the SQL 2014 database folder and restarted SQL. To my surprise this actually worked. All the jobs were listed as expected.

Next step, getting the distribution database up and running and getting SQL Server to think that replication has been running perfectly for years. The first step of this was to make a backup of the replication database files. If something went wrong, I needed a copy of these to restore from as the only backups that I had were missing transactions as those transactions weren’t backed up as the entire upgrade process was supposed to be smooth.

Attaching it was pretty straight forward. I just needed to run through the distribution setup wizard and get the T-SQL for it, then change the database name to match the old I’d been using.

Some permissions needed to be granted, and most importantly the linked servers needed to be added in the correct order. Once you’ve got them in there you can’t take them back out easily. I ended up with them in the wrong order so I had to switch the ID numbers around by putting the instance into single user mode from the command prompt and editing the sys.servers table manually via T-SQL.

Once that was all straightened out, the replication agents all came online and everything pretty much started working.

Denny


June 13, 2014  5:05 PM

Recommended reading from mrdenny for June 13, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Internet, Microsoft MVP, Recommended reading, salary, VMware vSphere, VMware vSphere 5.5, XBOX

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: sqlpass also known as PASS

Hopefully you find these articles as useful as I did.

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

Denny


June 11, 2014  4:00 PM

Any Little Thing Can Kill a SQL Server Upgrade

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server 2008 R2, SQL Server 2014
Fail

Image from Shutterstock

So I was going along upgrading a SQL Server 2008 R2 RTM server to SQL Server 2014. I had to install SQL 2008 R2 SP2 or newer before I could upgrade. That’s fine, I can live with that.

Then I get to the SQL 2014 installer. I get all the way to the end, when it fails. All because the folder E:\MSSQL\MSSQL10_50.MSSQLSERVER\MSSQL\Jobs isn’t there (SQL is installed on the E drive). All the other folders were there, just this one wasn’t. Now honestly I have no idea why this folder even exists. To the best of my knowledge and remembering there’s never been anything inside of it in the 15 years that I’ve been working with SQL Server. God forbid the installer just create this folder and move on, or I don’t know check to see if it exists during one of the three rules checks that it does during the install process.

So fine, I created the folder and reran the installer. Only to be created with this annoying screen.

upgrade

According to this annoying little screen I’ve got two components to upgrade, but it says that there’s no components available to upgrade. So that’s awesome. Way to be consistent Microsoft.

 

Next step way to try and force the upgrade via the command line. Pretty straight forward upgrading via the command line. Only takes a few switches.

cmdline

Once that was done the install was totally hosed. SQL wouldn’t start. It would just give me a warning about a corrupt installation. Attempting to start it from the command line wouldn’t help either. Hell the command line upgrade process installed the bits and removed the 2008 R2 bits, but didn’t bother to change the service to point to the new files, which apparently is fine because the rest of the SQL install is hosed now.

Repairing the installation did no good, because the installer couldn’t find a valid installer on the server.

The upgrade process couldn’t find anything to work with either.

The next thing that I tried was to add the features that I needed (the SQL Database Engine) through the normal install wizard so add features to an existing installation. At this point the SQL installer didn’t even see an instance on the server, so there was up add features option. I was simply prompted to do a normal install of SQL Server 2014. When I went to install it stopped me from using my Instance ID which was MSSQLSERVER because it was apparently already in use by the SQL Server instance “MSSQLSERVER.INACTIVE”, what ever the hell that is.

Fixing this required using this blog post which talks about how to get rid of this instance manually. If you read the instructors here and think “damn that’s crazy”, yep you’re right it is.

So once that was done I went through the installer yet again. That got me through the installer. I was even able to give the installer the data folder of the old SQL 2008 R2 folder so that it would be able to pick up all the databases when it came online.

The database installed successfully. However it didn’t pick up the databases and attach them. The database that I was really hoping that it would pickup was the distribution database for replication so that I wouldn’t need to recreate all the replication by hand. How I deal with that is for another blog post.

The moral to this post is that apparently you need to make sure that every single folder is where it should be before you try and upgrade SQL Server from one version to another. Otherwise a 45 minute process could easily take you hours to get through.

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: