SQL Server with Mr. Denny


January 2, 2015  10:08 PM

Recommended reading from mrdenny for January 02, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
Reporting Services, SQL, SQL Server, Windows 10

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: PASS_RM_Canada also known as PASS RM Canada

Hopefully you find these articles as useful as I did.

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

Denny

December 31, 2014  4:00 PM

2014 By The Numbers

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

2014 was another great year for my blog. This year I passed by 1000th blog post which is a pretty impressive milestone if I do say so.

My top 10 blog posts for 2014 are:
How to configure DTC on Windows 2008 – 5915 Views
What exactly is MSDTC, any when do I need it? – 5385 Views
SQL Server 2014 Licensing – 4687 Views
Any Little Thing Can Kill a SQL Server Upgrade – 1821 Views
Recommended reading from mrdenny for May 23, 2014 – 1804 Views
Fixing TempDB database problems when starting SQL using a minimum config – 1594 Views
PASS Summit 2014 Speaker Idol Competition – 1548 Views
How I Setup TempDB – 1548 Views
How Much Is That Query Costing? – 1511 Views
SQL 2012 Cluster, Windows 2012 R2 OS, Windows 2008 R2 Domains – 1461 Views

So for my top 10 posts for the year that’s about 27274 page views this year.  All in all, not bad.  Hopefully next year the numbers will go up again.  Based on these numbers I know that in 2015 I should be writing about MS-DTC, Licensing, TempDB and the SQL PASS Speaker Idol.  I think I can handle this.

See you in 2015.

Denny


December 26, 2014  7:09 PM

Recommended reading from mrdenny for December 26, 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: 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


December 24, 2014  5:00 PM

What’s the Best Upgrade Path from SQL 2005 to SQL 2014?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server upgrades, Upgrades

I get this question a decent amount in my Intro to SQL Server Management Session (called “I’ve got a SQL Database Now What?” or “SQL Server Management for the non Database Administrator”).

Frankly it doesn’t really matter. As long as you attach the database to a SQL Instance that is somewhere between SQL Server 2005 and SQL Server 2014 you’ll be fine. So why do we need to do this? Because Microsoft in their infinite wisdom has decided that they will only support upgrades from SQL Server 2008 and higher into SQL Server 2014. This presents a problem for those running SQL Server 2000 or SQL Server 2005 that want to jump directly into SQL Server 2014.

In order to make this upgrade happen, you need to attach the databases to a supported server. In the case of upgrading to SQL Server 2014 that means that you need to attach the database to a database instance running SQL Server 2008 through SQL Server 2012. If you are upgrading from SQL 2005 you can attach to any of those instances. If you are upgrading from SQL Server 2000 you’ll need to attach the databases to a SQL Server 2008 or SQL Server 2008 R2 instance. This is because SQL Server 2012 doesn’t support a direct upgrade from SQL Server 2000.

It makes no difference which version you attach to on the way to SQL Server 2014. The upgrade steps which need to be done between versions will be done in either location. And you don’t have to leave the database attached for very long. Just attach it, then detach it, then move it to the SQL 2014 server and attach it there for the final upgrade.

Just keep in mind that once you take that SQL 2005 instance and attach it to a SQL 2008 or higher instance you are committed and there’s no rolling back.

Denny


December 19, 2014  6:13 PM

Recommended reading from mrdenny for December 19, 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: 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


December 17, 2014  5:00 PM

Farewell TechEd

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

Last month I had the privilege of speaking at what is supposed to be the last Microsoft TechEd conference at TechEd Europe 2014. I’ve been lucky enough to speak at both the North American and European Microsoft TechEd events for a few years now, having spoken at the 4 most recent TechEd North America events as well as the most recent 3 TechEd Europe events.

Speaking at TechEd has been a very interesting experience as it is typically a different audience than the other events which I’ve spoken at in the past. Events such as the SQL PASS Summit and SQL Saturdays, and even SQL Connections are mostly focused on Microsoft SQL Server while the audience at TechEd is made up mostly of developers as systems administrators.

I’m excited to see what the Ignite event looks like when it happens in Chicago in 2015. It is expected to be a larger event than TechEd has been recently due to the fact that many events are being rolled into a single event.

It has been a privilege to speak at TechEd the last few years, and I hope to continue the trend at the Ignite conference for years to come.

Denny


December 12, 2014  4:58 PM

Recommended reading from mrdenny for December 12, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Database migration, 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: morzhov_m also known as Maxim

Hopefully you find these articles as useful as I did.

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

Denny


December 10, 2014  5:00 PM

Session’s Are a Specific Length For A Reason

Denny Cherry Denny Cherry Profile: Denny Cherry
Business presentations, Conferences, SQL, SQL Server

Nothing irks me more when I walk into my session room than the prior presenter still standing up there doing his thing eating into my 15 minutes of prep/setup time. Conferences have fixed length sessions for a reason. So that the audience knows how long the session will be, so that the presenter knows how much material to prepare, and so that the speaker knows how long they have before their session to get setup.

When a presenter runs over their time into the next presenters setup time this shows that the presenter didn’t have a good enough grasp of their session to set the right cadence, and they didn’t have good time management skills to know when they should have skipped some slides so that they’d finish on time.

Vendors are the worst at this at their lunch sessions. Lunch sessions at events like SQL Saturday’s typically don’t have much prep time between the lunch session and next session, so when the vendor runs over they are eating directly into the next presenters time.

Giving a session which runs short isn’t good either. As presenters we like to pad a sessions with 5-10 minutes of questions that we think are going to show up during the session. But when they don’t we need to have enough material to fill the time slot fully. After all that’s what the audience came to see. If you’ve got a 60 minute session slot, and 45 minutes of material and no questions, you’d better have some extra material to fill the extra 15 minutes with. When I was a TechEd Europe this year I wondered up to my session room very early, while the prior speaker should have still been presenting. I figured that I’d stand at the back and catch the last few minutes of his session before I got setup for mine. However when I got there his session was already done, with him standing at the front with a small group of people asking him questions. He finished easily 15 minutes early (I’m guessing).

Time management is hard. Especially when giving a presentation to a group, as you may not have a clock running to tell you how much time you have left. But there’s apps for your phone, or you can use the timer in PowerPoint (as long as you don’t close PowerPoint to do a demo), or a room monitor who can give you a signal at 5,10,15 minutes before you end, etc. There’s lots of ways to fix the problem so that the attendees get the session of the length that they are expecting while still getting the information across to them.

Denny


December 5, 2014  7:19 PM

Recommended reading from mrdenny for December 05, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
IT conferences, 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: SqlFreccia also known as Marcos Freccia

Hopefully you find these articles as useful as I did.

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

Denny


December 3, 2014  5:00 PM

Never Tempt the Demo Gods

Denny Cherry Denny Cherry Profile: Denny Cherry
Business presentations, Presentation software, SQL, SQL Server

Demos are one of the most fun parts of presenting, and one of the riskiest. This is because the demo gods have two options. They can smile upon you and give you a perfect demo, or they can piss all over you and your demo can crash and burn. How you handle those demo failures shows how good of a speaker you really are.

If you are able to recovery from the failure and fix the problem without anyone noticing the problem, you are a master speaker. If you point out the failure, then work around it, you’re pretty good (this is where I usually fall in the demo failure recovery event). If you stumble from the failure and get stuck and can’t continue, you need to practice your demos more (or not use demos if you can get away from it).

There’s a few ways to avoid demo failure. The easiest is to avoid demos. If possible stick to screenshots, they can’t fail you and you don’t have to drop out of the PowerPoint to get to them. Many demos out there don’t really need to be demos. If all you are doing is showing code, and the output I can do that with screenshots. Or at the very least have screenshots handy in a hidden slide so that if the demo fails you can toss them up on the screen to show how it’s supposed to work.

Another way to avoid demo failure, is to not type in the demo. People laugh when I (and others) say to never type in a demo, but we aren’t kidding. When you are on stage presenting you are nervous and odds are you’ll hit a key wrong and get a lovely error on the screen when you shouldn’t. Have all the code you’ll be using pre-written (and tested) so you can just open it and show it, then run it. The same goes for T-SQL scripts, PowerShell scripts, etc. Just open the script, show it, and run it. (And when showing PowerShell scripts don’t use the PowerShell prompt, use the damn ISE so the audience can read the screen.)

My final suggestion is to use something like DemoMate to record the demos ahead of time. This way if there’s a demo failure you can show the recorded version of it working. Now don’t plan on just using DemoMate and never showing an actual demo because that won’t fly with your audience. But if the demo blows up you need a way to get your point across.

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: