24 Hours of PASS: Summit Preview Edition

The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one hour live virtual sessions, ending exactly 24 hours later. I have the honor of presenting the final session of the event, so if you are up and about at 11:00 GMT on August 1, I would love to have you listen in to my session!

I will be doing a preview of my day-long pre-con session, called Scaling SQL Server 2012. Here is the abstract:

Scaling SQL Server 2012

SQL Server implementations can rapidly evolve and become more complex, forcing DBAs and developers to think about how they can scale their solution quickly and effectively. Scaling up is relatively easy but can be expensive, while scaling out requires significant engineering time and effort. As your database server nears its load capacity, what can you do? This 24 Hours of PASS session, a preview of the full-day PASS Summit pre-conference session, will give you concrete, practical advice about how to scale SQL Server. We’ll explore how to find and alleviate bottlenecks and cover how you can decide whether you should scale up or scale out your data tier. We’ll also cover how to use middle-tier caching and other application techniques to increase your overall scalability.

I also wanted to point out that Paul Randal just announced a special promotion for the upcoming September IEHW: Immersion Event on SQL Server Hardware and IE0: Immersion Event for Accidental/Junior DBAs, both in Bellevue, WA.

Just to sweeten the deal even further, all attendees of the inaugural session of IEHW will get a free copy of two of my books, SQL Server Hardware, and Professional SQL Server 2012: Internals and Troubleshooting. I’ll even autograph them, if you want to turn them into collector’s items!

Posted in PASS, Teaching | Tagged | Leave a comment

Hardware 201: Selecting and Sizing Database Hardware

On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download my deck here.

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Attendance was quite good for a hardware-related session, and there were a lot of interesting questions after the presentation.

Just in case this session whetted your appetite for a much deeper level of knowledge about SQL Server Hardware, you should consider attending the upcoming two-day IEHW: Immersion Event on SQL Server Hardware course that I will be teaching in Bellevue, WA on September 18-19, 2013.

Posted in Computer Hardware, Intel, Processors, SQL Server 2012, Teaching | Tagged , | Leave a comment

SQL Server 2008 Service Pack 3 CU12

On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count six fixes in the public fix list.

If you are still running SQL Server 2008 (and I know many people are), you should be aware that only Service Pack 3 is still a supported Service Pack. You should also keep in mind that SQL Server 2008 will fall out of Mainstream Support from Microsoft on July 8, 2014, which is not that far away.

I am curious about whether there will be a SQL Server 2008  Service Pack 4 or not? SQL Server 2008 Service Pack 3 was released back on October 6, 2011, which is quite some time ago.

Posted in SQL Server 2008 | Tagged | 1 Comment

SQL Server 2012 Service Pack 1 CU5

On July 15, Microsoft released SQL Server 2012 Service Pack 1 Cumulative Update 5. This is Build 11.0.3373, and I count 30 fixes in the public fix list. This CU is only for SQL Server 2012 Service Pack 1.

If you are running SQL Server 2012, I think you should be on Service Pack 1 by now. If you are on SQL Server 2012 Service Pack 1, I also think you should make an effort to stay on the latest Cumulative Update, even more so than for older versions of SQL Server, because of the large numbers of significant fixes that have been included in each Cumulative Update. The RTM release of SQL Server 2012 Service Pack 1 was released back on June 18, 2012, which is over a year ago now.

Posted in SQL Server 2012 | Tagged | Leave a comment

OT: Kicked Out of a Motel for Charging at 12 Amps

This is a pretty long story…

My wife and I had an interesting road trip to Salida, CO this past weekend, going to the Colorado Brewer’s Rendezvous. We drove down from Parker, CO on US-285, which was 151 miles. I had a range-charge in my P85 before we left, and we arrived in Salida with 107 miles of rated range remaining, despite quite a bit of elevation change on the route. This was my first time past “bingo fuel” in the Model S, but I was not worried since I had planned out the trip.

I had looked online, and found no public charging stations in Salida, and I did not find any motels that mentioned having charging stations either. Using the RVParky website, I had found several RV campgrounds within 10-15 miles of Salida that had 50 Amp service, so I called one and asked about charging my Tesla. At first, they were a little unclear what I wanted, but after I explained, they said I could pay $5.00 plus whatever my actual electrical usage was (at 15 cents/KwH). This seemed like a very good deal, so I made a reservation to charge for a few hours starting Sunday morning. I also made a motel reservation at the Gateway Inn & Suites, on Hwy 50 in Salida. This is a relatively modern motel on the east side of Salida, next to Hwy 50.

My hope was to at least charge at 120V, 12Amps over Saturday night (at 3 miles of range/hr), and then drive to the RV campground on Sunday morning at charge at 240V, 40 Amps (at 26-30 miles of range/hr) until I had enough range to get home with a safe reserve. After I made my online reservation, I sent an email to the motel, asking them about charging, as shown below:

“I have booked a reservation though Booking.com, checking in on July 13 and checking out on July 14. I drive a Tesla Model S, which is an all-electric car. I was wondering whether there might be some place at the motel where I can plug-in my car from about noon on Saturday until we check out on Sunday? I would be happy to pay extra for this service, whether it is a 120V, 20 amp circuit or a 240V, 50 amp circuit. Please let me know. Thanks!”

Unfortunately, I never got a response to that e-mail. I later called and asked about charging, but the person I talked to did not know anything about EV charging.
After the Brewer’s Rendezvous was over, we had dinner and took a walk along the river, and then drove about a mile to the motel and checked in at about 6:30PM. Our room was Room 305, which was about 100 feet away from the motel office. We were able to park two spaces to the left of our room door, which was just a little too far away for my UMC cable to reach.

This is where I made my first mistake. There was a grounded, 120V outlet in the room under the front window, and I had a short, very heavy duty extension cord that would easily reach. I decided to use the extension cord and plug-in, running the cord through the open window, past the edge of the screen. I sat in the car for a few minutes and watched it happily charge at 120V and 12 Amps, getting 3 miles/hour of range. There was no warning about a voltage drop or a long extension cord from the Tesla. I also felt the extension cord to make sure it was not warm, even though I had used this same extension cord to charge at home for a couple of weeks (before I got my NEMA 14-50 outlet).

Thinking everything was fine, we read for a little while and then went to bed. Then, at about 11:30PM, we were awoken by a loud pounding on the door. I opened the door to be met by a very angry man who starting yelling about me damaging the wiring and burning down the motel. He also yelled that I had two minutes to unplug the car or else he would call the fire department and the police. He also threw in a comment about how “$#cking ridiculous it was to charge an electric car from a hotel room”.

I was a little shocked by all of this, but I immediately unplugged the UMC cord from the extension cord, and then unplugged the UMC cord from the car and put it away. The guy was still yelling about how they had security cameras to make sure I did not plugin again later. I tried to explain that the car was only drawing 12 Amps which was perfectly safe, and we had used about 4KwH of electricity. I asked him to feel the extension cord to see if it was warm, but he refused, and then walked away towards the office. No circuit breaker in the room had been tripped.

After this, I went back inside. only to get a phone call from the front desk. I asked to speak to manager, but the woman on the phone told me that the guy I had talked to was the manager. Next, she said that they were going to turn off the circuit breakers for our room for the night. Hearing this, I said, “If you do that, I will have to write a negative review of the motel”. Of course this angered her even more, so she demanded that we leave the motel immediately, and she wanted to know when we would be gone. I said “in the morning”. After this, she threatened to call the Salida Police, and I said that was a good idea.

Next, the manager came back and pounded on our door again, demanding that we leave immediately. I told that I was going to call the Police myself, and asked him what his name was, which he refused to give me.

A few minutes later, a Salida Police Officer showed up and talked to the manager and front desk clerk for a couple of minutes, and then came over to talk to me alone. I calmly explained what had happened, telling him how the Tesla monitors the incoming current and limits it to 12 Amps on a 120V 20 Amp circuit. I also showed him the extension cord, and explained how little electricity we had used over the past five hours of charging.

I also explained that we lived in Parker, and did not have enough range to get home until we could charge at the RV campground in the morning. Because of the Brewer’s Rendezvous, there were unlikely to be any vacant rooms in any other motels in Salida that night. The officer was very understanding, and left to go talk to the manager some more.

When the officer came back, he was very apologetic, but said that he was sorry, but we would have to check-out and leave, although we were going to get a full refund. So, we packed up, got our refund and left, but not before the officer told me how sorry he was, and that they had had previous similar situations with this manager at the motel over kicking people out in the middle of the night (but not related to EVs).

We were basically screwed, with not enough range to get home without a charge, and no where to stay for the night. By this time it was a little after midnight, so I tried calling the RV campground we had a reservation at The SugarBush Store and Campground, hoping they might have someone on duty.

Unfortunately, I woke up a very nice woman, who agreed to meet us when we got there and let us plug in for the night. We apologized for waking her and thanked her profusely (and I also gave her a nice tip when we got there). Their 50 Amp circuit worked great, putting out a steady 240-244V at 40 Amps, so we were getting 27-29 miles per hour of charge. We left the campground at 6AM with a full range charge, and drove back home without any more excitement. I averaged 282 Wh/mi for the trip which was quite good.

So to recap, I made a few mistakes here:

  1. I should not have charged without explicit permission
  2. I should not have used the extension cord to charge
  3. I should not have threatened to write a negative review of the motel

On the other hand, the motel manager made a number of mistakes:

  1. He should have called us first, and asked us to unplug and/or explain what we were doing
  2. He should have let me explain what I was doing and actually investigated to see if it was a problem
  3. He should not have used profanity towards a motel guest
  4. He should not have called the police over the incident
  5. He should not have evicted two guests in the middle of the night

If they had been willing to calm down and listen to me, I am sure we could have resolved the situation. I could have let them keep my UMC cord for the night, or I could have paid some excessive fee for the roughly $1.00 of electricity I would have used by morning. As it was, there was no damage to the motel, and they lost my $129.99 room rate for the night (which was nearly double their normal rate due the Brewer’s Rendezvous).

I am curious what people think of this whole situation?

Posted in Travel | Tagged , , | 10 Comments

SQL Server Diagnostic Information Queries for July 2013

I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this month. Rather than having a separate blog post for each version, I’ll just put the links for all four versions here.

SQL Server 2005 Diagnostic Information Queries          SQL Server 2005 Blank Results

SQL Server 2008 Diagnostic Information Queries          SQL Server 2008 Blank Results

SQL Server 2008 R2 Diagnostic Information Queries    SQL Server 2008 R2 Blank Results

SQL Server 2012 Diagnostic Information Queries           SQL Server 2012 Blank Results

About half of the queries are instance specific and about half are database specific, so you will want to make sure you are connected to a database that you are concerned about instead of the master, system database.

The idea is that you would run each query in the set, one at a time (after reading the directions). You need to click on the top left square of the results grid to select all of the results, and then right-click and select “Copy with Headers” to copy all of the results, including the column headers to the Windows clipboard. Then you paste the results into the matching tab in the spreadsheet.

There are also some comments on how to interpret the results after each query. Please let me know what you think of these queries.

Posted in Diagnostic Queries | Tagged , | 9 Comments

SQL Server 2008 R2 Cumulative Updates Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 R2 Service Pack 1 and the other one is for SQL Server 2008 R2 Service Pack 2.

SQL Server 2008 R2 Service Pack 1 CU13 is Build 10.50.2876, and it has five fixes in the public fix list.

SQL Server 2008 R2 Service Pack 2 CU7 is Build 10.50.4286, and it has eleven fixes in the public fix list (plus a new feature description).

As always, these Cumulative Updates are only for SQL Server 2008 R2 SP1 or SP2, not for any other version or service pack level.

Posted in SQL Server 2008 R2 | Tagged | Leave a comment

Speaking in Denver and Boulder in June

I will be speaking at the Boulder SQL Server User’s Group on June 18, 2013 and at the Denver SQL Server User’s Group on June 20, 2013. In both cases, I will be presenting an updated version of  Hardware 201. Here is the abstract:

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Just in case you are curious, I will be driving my red Tesla Model S P85 to both meetings, so if you are interested in seeing and possibly riding in a Tesla, you might want to show up… Smile

Regardless of that, both meetings should be a lot of fun, and I hope to see a lot of people there!

Posted in Computer Hardware, PASS, Teaching | Tagged | Leave a comment

New Immersion Event Classes at SQLskills

There are three new upcoming Immersion Event classes from SQLskills, including one that I will be teaching, which is the two-day IEHW class on September 18-19.

I am really excited to get the chance to teach the IEHW class, and I think it will be a lot of fun!  Here is the rundown on all three classes:

My colleagues Jonathan Kehayias and Erin Stellato will be teaching the three day IE0 class on September 30-October 2.

My colleague Bob Beauchemin will be teaching the four day advanced T-SQL class on September 30-October 3.

These classes are all open for registration now.

Posted in Computer Hardware, SQL Server, Teaching | Tagged , | Leave a comment

Tesla Time

I now  have a red, P85 Tesla Model S. I picked it up at the Denver Tesla Service Center on May 3, 2013.  After slightly more than a week of ownership, I am still extremely happy. It is incredibly quick (0-60 in 4.0 seconds), it handles well, and it has great Brembo brakes. It has a very smooth, comfortable ride, and it is very quiet while you are driving it.

It also has a lot of useful, high-tech features, such as a 17” touch screen and built-in 3G connectivity (so you have web access and can receive over the air firmware updates). This allows Tesla to add new functionality to the car without even having to physically touch the car.

The Tesla Model S is a battery electric vehicle (BEV).  That means it is not a hybrid, there is no gasoline engine. There is no drive tunnel in the center of the car, and there is a second trunk (called a frunk) where an internal combustion engine would be in most cars. There is a hatchback in the rear, and the rear seats fold down, so you have as much storage space as many SUVs.

My Model S has the larger, 85KwH lithium-ion battery pack that has an EPA-rated range of 265 miles. Your actual range depends on how fast you drive, your elevation change, the outside temperature, and whether there are headwinds or cross-winds. This gives you more than enough range for normal day-to-day driving.

The current weak point of the Tesla Model S is the proverbial “road trip”, the one that everyone talks about, but very rarely actually does. Right now, it is possible to drive a Tesla Model S anywhere you want to go, with some planning and extra patience. The current high-speed, public EV charging infrastructure is still somewhat lacking.

If you need to do a complete charge of an 85KWh battery, it will take some time, unless you can use a Tesla SuperCharger (which is free). Right now, there are only a relatively small number of Tesla SuperChargers in California and in New England, but Tesla will adding many more SuperChargers around the country over the next year.

There are also some pretty strong rumors and hints (from Elon Musk) about faster SuperChargers, a faster SuperCharger network build-out, and some form of battery swapping option in the very near future.

In the meantime, Table 1 shows the charge times and charge rates for various power sources.

Power Available Charge Time Charge Rate
110V  12A > 60 hours < 4 miles per hour
220V 12A 27-37 hours 8 miles per hour
220V 24A 13-19 hours 17 miles per hour
220V 30A 11-15 hours 21 miles per hour
220V 40A 8-10 hours 28 miles per hour
220V 60A (dual chargers) 5-6 hours 42 miles per hour
220V 80A (dual chargers) 4-5 hours 56 miles per hour
Tesla SuperCharger 1 hour 270 miles per hour

Table 1: 85KWh Charging Time Table

It is pretty common and relatively easy and inexpensive to get a 240V, 50A, NEMA 14-50 outlet installed in your garage that will completely charge an 85KWh battery overnight. This is more than sufficient for day to day use, especially since you are very unlikely to completely run down your battery during normal daily usage. You will have a full battery every morning, with no trips to a gas station, ever. It costs about $9.00 in electricity to fully charge the 85KWh battery, which is about 25% of the equivalent gasoline cost.

The Tesla Model S is an amazing, game-changing automobile. Not just an amazing electric vehicle, but an amazing vehicle, period. It was awarded Motor Trend Car of the Year for 2013. It was also awarded Automobile Magazine 2013 Automobile of the Year.

More recently, Consumer Reports gave the Tesla Model S the highest test rating (99/100) they have given any car since 2007.

Here are a number of other reviews:

2012 Tesla Model S: Riding Shotgun

2013 Tesla Model S

2013 Tesla Model S Review

Tesla Model S first drive: Quiet satisfaction

Tesla Model S

2012 Tesla Model S Review

Tesla Model S review

In case you are wondering, “Tesla Time” is a term among Tesla owners that refers to the time that we typically spend answering questions and showing the Model S to curious, but generally interested and enthusiastic people. It is extremely common for people to approach you with lots of questions about the Tesla and EVs in general whenever you get in or out of one. This is something we generally don’t mind…

On the other hand, I am perfectly aware that there is a lot of anti-EV hostility, primarily from the conservative side of the political spectrum. There is a pretty predictable set of talking points that you will see trotted out in the comments for any mainstream story on the Internet about Tesla or EVs. There is not much I can do about that, except to accurately relate my experiences and try to address some of the more glaring misconceptions about EVs.

Posted in Automobiles | Tagged | 24 Comments