SQL Server 2012 Cumulative Update 5

Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

Here are a couple of the more important hotfixes:

SQL Server 2012 experiences out-of-memory errors

FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008

This Cumulative Update is only for SQL Server 2012 Cumulative Update 5. It will not work with any other major version of SQL Server or with any other Service Pack Level.

Ideally you should be on the Service Pack 1 branch of SQL Server 2012.

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

SQL Server 2008 R2 SP2 Cumulative Update 4

Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

This Cumulative Update is only for SQL Server 2008 R2 Service Pack 2. It will not work with any other major version of SQL Server or with any other Service Pack Level.

If you are running SQL Server 2008 R2 Service Pack 2, you are on the latest branch of the SQL Server Server R2 “release tree”, which is a good place to be. This means you have a much longer time remaining before your Service Pack is retired.

When a SQL Server Service Pack is “retired” that means that it is considered an “unsupported service pack” by Microsoft CSS. This means that you will only get limited troubleshooting support until you upgrade to a supported Service Pack. It also means that there will be no more Cumulative Updates for that Service Pack.

Posted in Microsoft, SQL Server 2008 R2 | Tagged , | 1 Comment

SQL Server 2008 R2 SP1 Cumulative Update 10

Microsoft has released SQL Server 2008 R2 Service Pack 1 Cumulative Update 10, which is Build 10.50.2868. I count 15 fixes in the public fix list. Some of these fixes look fairly important, so you should take a look at the fix list.

This Cumulative Update is only for SQL Server 2008 R2 Service Pack 1. It will not work with any other major version of SQL Server or with any other Service Pack Level. Speaking of SP levels, I think you should be planning on moving to SQL Server 2008 R2 SP2 if you have not already done so, since SQL Server 2008 R2 SP1 is due to be retired in about six months.

When a SQL Server Service Pack is “retired” that means that it is considered an “unsupported service pack” by Microsoft CSS. This means that you will only get limited troubleshooting support until you upgrade to a supported Service Pack. It also means that there will be no more Cumulative Updates for that Service Pack.

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

Two Blogs, One Writer

I started blogging back on August 9, 2006, so I have been at it for quite a while. I am pretty proud that I have stayed pretty active with relatively frequent posts over the past six-plus years. I don’t plan on changing that anytime soon. I will occasionally write about non-SQL Server topics (such as space exploration, astronomy, etc.) on my personal blog here.

Since I joined SQLskills on May 1, 2012 (where I am extremely happy), I also have a second blog on the SQLskills web site, where I have a lot of new content that tends to be more detailed and technical.

I am also quite active on Twitter, where you can find me here, in case two blogs are not too much!

Posted in Blogging, SQL Server | Tagged | Leave a comment

SQL Server 2005 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements. I dropped a couple of redundant queries, and added a new query at the end.

To go with it is an updated, blank 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. With the SQL Server 2005 version of SQL Server Management Studio (SSMS), you will want to enable the “Copy with Headers” option under Tools, Options,Query Results, SQL Server, Results to Grid in order to be able copy the results with headers.

These queries are designed to work on SQL Server 2005, although many of them will also work on newer versions of SQL Server. If you have a newer version of SQL Server you are really better off getting the proper version of these queries that matches your version of SQL Server.

All of the recent versions of my DMV diagnostic queries can be found here.

Posted in SQL Server 2005 | Tagged , | 4 Comments

OT: Space Exploration and the Future of Humanity

I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after that, I can remember drawing pictures of Saturn V rockets blasting off, with smoke billowing on either side. It is hard to describe how much so many people were inspired by the race to the Moon, watching every launch and mission with great interest.

The race to the Moon, from 1961 to 1969, motivated many young people to go into science, engineering and mathematics. It was strongly reinforced with President Kennedy’s “Moon speech” on September 12, 1962 at Rice University in Houston, Texas. Here is an excerpt of the speech, with the most famous paragraph:

We choose to go to the moon. We choose to go to the moon in this decade and do the other things, not because they are easy, but because they are hard, because that goal will serve to organize and measure the best of our energies and skills, because that challenge is one that we are willing to accept, one we are unwilling to postpone, and one which we intend to win, and the others, too.

Apollo 11 landed on the Moon on July 20, 1969, and the race was over. Even though the primary motivation was really a Cold War competition between the Soviet Union and the United States, there were many technological spinoffs and other benefits for the rest of the world. Many people assumed that we would keep on going, with Mars being the next logical destination. There were existing plans to do just that, including one from Werner von Braun. Unfortunately, NASA was not able to move forward with implementing any plans to continue to do any manned exploration beyond low Earth orbit. Now, over forty years later, we still have not had any manned missions beyond low Earth orbit after Apollo 17.

There has been a lot of good work done since then, both with manned missions to low Earth orbit and with unmanned missions to Mars and other parts of the Solar system. Still, I feel we have lost so much time compared to where we could have been. Of course the question is, why does this matter?

In the words of Carl Sagan:

“Since, in the long run, every planetary civilization will be endangered by impacts from space, every surviving civilization is obliged to become spacefaring–not because of exploratory or romantic zeal, but for the most practical reason imaginable: staying alive… If our long-term survival is at stake, we have a basic responsibility to our species to venture to other worlds.”

In the words of Stephen Hawking:

“I don’t think the human race will survive the next thousand years, unless we spread into space. There are too many accidents that can befall life on a single planet. But I’m an optimist. We will reach out to the stars.”

In the words of Isaac Asimov:

“There are so many benefits to be derived from space exploration and exploitation; why not take what seems to me the only chance of escaping what is otherwise the sure destruction of all that humanity has struggled to achieve for 50,000 years?”

Neil deGrasse Tyson has a good explanation of the importance of space exploration here.

Personally, I have believed for a long time that mankind has a limited window of opportunity to expand into space. This window first opened when we initially developed the technology and engineering prowess (along with the necessary economic resources) to actually launch missions outside of Earth’s atmosphere in the late 1950’s.  The window will close when we no longer have the desire or ability to to expand into space. The likelihood of this happening increases as time goes by, as world population increases and we eventually begin to exhaust the finite resources on the planet.

People can argue about whether or when that will ever happen. I for one hope that it does not happen, and we actually start moving out of low Earth orbit while we still can. I am a lot more optimistic about than I used to be, due to a number of emerging private efforts that seem to have a lot of promise.

The first is SpaceX, founded by Elon Musk. He is also in charge of Tesla Motors and SolarCity. The three of these companies are sort of designed to work synergistically together to help advance Elon Musk’s vision for the future. He is quite serious about establishing a permanent colony on Mars in the relatively near future, hopefully in the next 12-15 years. SpaceX has shown real results with their successful cargo deliveries to the International Space Station (ISS).

The second effort is Planetary Resources, whose goal is to bring the solar system within humanity’s sphere of influence by exploiting near-Earth asteroids (NEAs). The idea is to mine these asteroids both for their high platinum content and for water (which can be converted to high-energy rocket propellant: hydrogen and oxygen) that is outside the gravity well of a planet. This would dramatically reduce the cost and complexity of later flights to the Moon, Mars, and the Asteroid Belt. Planetary Resources has a number of billionaires from the high technology industry as investors, and they seem quite serious about what they are doing.

Space Advocacy Resources

The National Space Society

The Planetary Society

The Mars Society

The Case for Mars: The Plan to Settle the Red Planet and Why We Must

Martian Outpost: The Challenges of Establishing a Human Settlement on Mars

Entering Space: Creating a Spacefaring Civilization

Mining The Sky: Untold Riches From The Asteroids, Comets, And Planets

The High Frontier: Human Colonies in Space 

Hopefully you found this topic interesting, as a short break from all SQL Server, all the time.

Posted in Space Exploration | Tagged , | 1 Comment

SQL Server 2008 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. 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.

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 , | Leave a comment

Free One Week Passes to PluralSight

As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly half of all of the SQL Server courses on Pluralsight have been produced by the SQLskills team, and more are on the way.

Just in case you would like to try out using Pluralsight for one week, I have about 50 free passes that I want to give out. You will have to jump through a couple of simple hoops to get one. 

First, you need to follow me on Twitter. I am @GlennAlanBerry, which you can find here. After you follow me, just send me a Tweet asking for the code, and I will DM it to you. That’s it!

If you get one of these passes, I would like for you to listen to my Understanding Server Hardware course and tell me what you think about it.

The idea here is to get more people to try using Twitter and to get more people to try Pluralsight. It is free, and it won’t hurt at all…

Posted in Microsoft, Pluralsight, Teaching | Tagged | 1 Comment

SQL Server 2012 Service Pack 1 CU1 is Available

Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 1, which is Build 11.0.3321. I count 44 fixes in this Cumulative Update.

You will need SQL Server 2012 Service Pack 1 installed before you install this Cumulative Update. If you already have SQL Server 2012 installed, you only need the actual Service Pack itself. You don’t want the full FullSlipstream installation that is also listed on that same page.

If you are getting ready to deploy SQL Server 2012 (or even if you already have it deployed), you really should be on the SP1 branch. I also think that you should be on SP1 CU1, so that you are completely up-to-date with all of the released fixes. Microsoft continues to fix lots of issues in each of these early cumulative updates for SQL Server 2012, so I think it is more important than usual to stay current.

Posted in Microsoft, SQL Server 2012 | Tagged , | 1 Comment

SQL Server 2012 Diagnostic Information Queries (Nov 2012)

Here is the November 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. I want to thank Mike Fal (blog/Twitter) who made a very useful suggestion for Query #36.

To go with this new version 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 | Tagged , | 3 Comments