Migrating to SQL Server 2012

I had the opportunity to deliver my Migrating to SQL Server 2012 presentation at the PASS 2012 Summit last Friday in Seattle. Although I was in the TCC annex of the convention center, I had pretty good attendance, and it seemed to be pretty well received. Here is the abstract:

Migrating to SQL Server 2012

How do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2012 with no data loss and virtually no downtime? What if you have a limited hardware budget for the upgrade effort and you are worried about the new core-based licensing in SQL Server 2012? How can you choose your hardware wisely in light of the new licensing model?

This session will cover several different methods for migrating your data to SQL Server 2012 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that an upgrade makes good sense from a business perspective.

Posted in PASS, SQL Server 2012, Teaching | Tagged | 3 Comments

Book Signing at SQLSentry Booth at PASS Summit 2012

A new book that I wrote a couple of chapters for has just been released. It is Professional SQL Server 2012 Internals and Troubleshooting from Wrox. I really believe this is a high quality book from a collection of great authors (who somehow let me on the project) that I think people will enjoy.

Professional SQL Server 2012 Internals and Troubleshooting

There is a book signing at the SQLSentry booth in the Expo Hall at the PASS Summit 2012 today (November 8) at 12:30PM. SQLSentry is giving away a decent number of books through a raffle, so it is probably worth your while to show up and take your chances on getting a free copy. I hope to meet a lot of people in the Expo Hall today!

Posted in Microsoft, PASS, Teaching | Tagged | 2 Comments

SQL Server 2012 Service Pack 1 Released

Microsoft has released SQL Server 2012 Service Pack 1 for general availability. SQL Server 2012 SP1 includes all of the fixes from SQL Server 2012 RTM CU1 and CU2, but not the fixes from CU3 and CU4.

That is pretty typical, since SQL Server Service Packs undergo longer and more thorough testing than cumulative updates do, which means that they are frozen earlier. If you have already installed SQL Server 2012 RTM CU3 or CU4, you may want to wait until SQL Server 2012 SP1 CU1 is released, which should happen fairly soon. Here is what’s new in SQL Server 2012.

One new development is that Microsoft has released full slipstream images for SQL Server 2012 SP1, which lets you install a fresh copy of SQL Server 2012 that will have SP1 installed. This will also work if you decide to do an in-place upgrade from a previous version of SQL Server (which I don’t recommend).

SQL Server 2012 SP1 is build 11.0.3000. I have updated my SQL Server 2012 Diagnostic Information Queries to reflect SP1.

Posted in Microsoft, SQL Server 2012 | Tagged | Leave a comment

Day One Key Note at PASS 2012 Summit

This is the 14th PASS Summit, and there are nearly 4000 attendees from 57 countries. There are 127K members in PASS now. Those figures are really pretty amazing, showing very good growth over the past several years.

SQL PASS President, Bill Graziano started out the keynote, running through what PASS has been up to and recognizing volunteers, organizers, and speakers. He also announced the new PASS Business Analytics Conference in Chicago on April 10-12, 2013.

Ted Kummert announced that Microsoft has released SQL Server 2012 Service Pack 1. He also announced “Hekaton” which will ship in the next major version of SQL Server.

Microsoft’s Shawn Bice actually did a demonstration of Hekaton on stage during the keynote. He showed an OLTP application with lots of latch waits, then he showed a tool in SSMS that recommends which tables to “memory optimize” into Hekaton. Doing this would end up eliminating the latch waits, with a 10X performance increase. The SSMS wizard will also recommend which stored procedures to convert to be native, compiled code. In the demo, that gave a 30X performance increase (cumulative with the previous increase from the table).

They also did a demo of Columnstore indexes, and announced that they will be updateable in the next major version of SQL Server. You will also be able to create a columnstore clustered index. They showed a nice video of BWIN talking about how fast Hekaton is in their testing.

Microsoft also announced and demonstrated SQL Server 2012 PDW and then announced and demonstrated PolyBase.  Amir Netz did a very long demo of the new self-serve BI capabilities built into Excel 2013. All in all, it was a pretty good keynote.

Posted in Microsoft, PASS, SQL Server 2012 | Tagged , | Leave a comment

Microsoft Surface RT Review

Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in Lone Tree, Colorado at 8AM to see what kind of line they had for the new Microsoft Surface RT. This is a relatively new, attractive mall that is only about six miles from my house.  Since the Microsoft Store is inside the mall, very close to the Food Court, there would be no shivering in the cold and no camping overnight, so this was not a radical move that required any great commitment on my part. Of course, this makes it harder for me to tease my Apple-loving friends about standing in line on release day!

Purchase Experience

When I got there slightly after 8AM, there were about 25-30 people in line, so I decided to get in the line (after getting a blue paper wrist band and a couple of silly pieces of paper). During the next two hours before the store opened at 10AM, the line grew to about 150 people. During this period, they had drawings for two XBOX 360 systems, they gave everyone a sack/backpack with a Microsoft t-shirt, a pen, and a magnet, and they also gave everyone a bottle of water.

There were also small teams of Microsoft employees going through the line showing us the Surface RT, the different keyboards and the available accessories. They were also trying to get us to fill out a little card that specified what exact Surface RT model we wanted along with any accessories, service plans, or personal training. This was all fine, since we were stuck in line anyway, and luckily they were not too aggressive about pushing the $99.00 “Microsoft Complete” service plan. They also told us that there was a purchase limit of five Surface RT units per customer, which reassured me that they had plenty of stock to handle the line.

Once the doors opened at 10AM, there was the obligatory cheering and high fives from the Microsoft employees going down the line. My assumption (which turned out to be wrong) was that they would let a few people in the store at a time, where you would present your filled in card, and then they would go get what you wanted and simply let you pay and take your stuff home. Unfortunately, that was not Microsoft’s plan…

What they wanted to do was have each customer assigned to an associate, who would give a short demonstration of the device, answer any questions, and then guide you through the purchase experience. After you bought the device, they wanted to do an “Out of Box Experience” where they would open up your box, fire up the system, and help you get it configured, and also give you some quick training on how to use it. I am sure that some people appreciate this level of “hand-holding” (especially people who normally go to an Apple Store), but I had absolutely no interest in that whatsoever. They did have about 10-12 associates setup for this whole dog and pony show, so it was a parallel operation, but it was taking 20-30 minutes for each customer.

As I got closer to the front of the line, I could see what they were doing and I figured out why people were going in, but no one had come out yet. Some of my neighbors in line came to the same conclusion, and we all agreed that we did not have time for that nonsense. When I was assigned to my hand-holding associate, I politely told him that I just wanted to buy what I had selected with no demonstration or box opening. This seemed to blow his mind at first, and his initial response was that they “had to make sure that everything was working properly”.  I responded “I am sure everything is fine, and this will save you a lot of time”, which caused him to confer with a supervisor to see if this rebellious behavior would be permitted. Luckily, after much whispering, they decided that this unplanned departure from the plan would be allowed, but it still took nearly 15 minutes more after that for me to simply buy my 64GB Surface RT with a bundled Black Touch Cover and an HD Digital AV Adapter. I am such a troublemaker!

The Surface RT

The available choices are a 32GB device without a Touch Cover for $499.00, a 32GB device with a Black Touch Cover for $599, or a 64GB device with a Black Touch Cover for $699. You can also buy a separate Surface Touch Cover in a variety of colors for $119.99 or a Surface Type Cover for $129.99. This makes the bundles a decent deal, saving you $19.99 over the separate pieces (as long as you like black). It would have been nice to have been able to buy a 64GB device without a Touch Cover for $599, but that is not an option.

The Surface RT uses a quad-core 1.3GHz NVidia Tegra 3 CPU, and it has 2GB of DDR3 RAM. It has 54.1GB of formatted space in the 64GB model in a device that is listed as an MMC Memory Card in Device Manager. It has a single, full-sized USB 2.0 port, that I quickly discovered works great with my Logitech Unifying Receiver for my Anywhere MX mouse.

The Touch Cover keyboard works just fine for me, especially since I am merely a glorified hunt and peck typist. The kickstand works as advertised, and it feels like a tiny laptop when I am using it. The battery life seems like it will easily hit the advertised 9-10 hours of usage. The Wi-Fi system has better range than my regular Toshiba Portege laptop, judging by the number of networks it can pickup in my neighborhood. It seems to stream movies from NetFlix and HuluPlus with absolutely no issues on my Wi-Fi 802.11N network.

I did go into Windows Update and install Microsoft Update, and then I pulled down all of the available updates (I think there were four or five updates including one for Office 2013). This process was not so difficult as to force me to give up on the Surface RT and write an angry blog post, but your mileage might vary.

On the downside, the magnetic connector for the charger is a little hard to get connected, and the cord is a little too short. Application startup time is slower than what I am used to, but I am spoiled with very fast 6Gbps SSDs and Ivy Bridge processors in my regular machines. Once you are in an application, everything seems pretty snappy. There are fewer applications than I would like to see in the Store, but I am sure this will improve over time. The ones that I have downloaded and tried so far all seem to work pretty well.

The contrast and brightness on the screen are excellent, and it does not have a huge problem with glare or reflections. It would have been nice to have had higher resolution, but that would have affected the battery life and performance, and would have pushed the cost even higher than it already is. I think Microsoft would have been better off to come in at a lower price point, even if that caused them to sell them at a loss for a while.

I am going to be keeping my Surface RT, but I may end up giving it to one of my nieces after the Surface RT Pro comes out in a few months. The Pro will have an Ivy Bridge Core i5 processor and will be running the regular Windows 8 Professional, so it will have a lot more horsepower at the cost of less battery life and a few ounces more weight.

I plan on taking it to the SQL PASS Summit next week as a backup presentation machine and for carrying around on the days when I am not presenting. My biggest problem is simply getting used to the Windows 8 user interface, but that is something I have to do anyway since I have to work with Windows Server 2012.

Posted in Computer Hardware, Microsoft, Windows RT | Tagged , | 1 Comment

Understanding Server Hardware Course from Pluralsight

My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server section of the course catalog, even though it is not really SQL Server specific. It is meant as a foundational course to give you the basic concepts that are applicable to all types of Windows-based servers.

I plan on developing additional hardware-related courses that are SQL Server specific, and even deeper in scope. In the meantime, you might appreciate my recent post on SQLskills.com, Two Database Servers Compared.

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

SQL Server 2008 Diagnostic Information Queries (Oct 2012)

Here is the October 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries, and one new query. To go with it is an updated, blank 2008 results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries. The idea is that you can run these queries one by one, click on the top left square of the results grid, and then right-click and select “Copy with Headers” to select and copy the results of the query and then paste them into the matching tab of the results spreadsheet.

These queries will work on both SQL Server 2008 and SQL Server 2008 R2 (although some of them will only work on SQL Server 2008 R2 SP1 or later). This is indicated in the instructions for each query.

I have removed three of the queries from the previous version, since they were somewhat redundant, and I have made some minor improvements to a number of the other queries.

You should be aware that both Query 46 and Query 49 could take some time to run, depending on the size of your database and the speed of your hardware and storage subsystem. 

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 6 Comments

SQL Server 2012 RTM Cumulative Update 4

Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25 fixes in the public fix list for this cumulative update.

The first four cumulative updates for SQL Server 2012 have all had relatively high numbers of fixes, which shows that the Sustained Engineering team has been busy fixing issues with SQL Server 2012.

This KB article shows all of the released, post SQL Server 2012 RTM build: The SQL Server 2012 builds that were released after SQL Server 2012 was released

Posted in Microsoft, SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

SQL Server 2012 Diagnostic Information Queries (October 2012)

Here is the October 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a number of the existing queries.  I also removed three of the existing queries, since they seemed a little redundant.

To go with it is an updated, blank SQL Server 2012 results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries. The idea is that you can run these queries one by one, click on the top left square of the results grid, and then right-click and select “Copy with Headers” to select and copy the results of the query and then paste them into the matching tab of the results spreadsheet.

Many of these queries only work on SQL Server 2012, although some will work on older versions of SQL Server. If you are using an older version of SQL Server, you should use the version of my diagnostic queries for that version of SQL Server.

As always, I welcome any feedback you may have about these queries.

Posted in SQL Server 2012, SQL Server Denali | Tagged , | 3 Comments

DMV Emergency Room!

I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 2012.

I had a nice, full room with about 40-50 people, which is pretty good for a local event. I want to thank the organizers and volunteers for putting together a very well-run event!

My presentation deck is here, and my script is here.

Posted in SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 | Tagged | 3 Comments