Archives: January 2011
I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I also had a number of Tweets directed at me (@GlennAlanBerry) and several e-mails from people asking me what I thought about this.
First, I hate to see something like this… Read more
Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty close attention to my electrical power usage. I try to generate more electricity than I use, because I care about the environment and because I hate my electric company ( Read more
Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack level for Business and Developer products, which include Windows Server and SQL Server. The term “supported service pack level” means that you cannot be on a retired service pack (which… Read more
I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on March 5, 2011 in Denver, Colorado. This event (which is in its third year) is like a mixture of a SQLSaturday and a Code Camp, with tracks devoted to SQL… Read more
I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado Springs. I will be talking about hardware evaluation and selection, and the full abstract is below:
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database… Read more
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in Windows Server 2008 R2 (which works the same way in Windows Server 2008).
As you can see in Figure 1 below, the Core Speed with the Balanced Power Plan is… Read more
Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of these are completely separate from SQL Server 2008 R2 (which is considered a separate, major release from SQL Server 2008).
My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is new in SQL Server “Denali” at the Denver SQL Server User’s Group Meeting on Thursday, January 2011. The meeting place has changed back to the Microsoft office in the… Read more
If you are in charge of one or more SQL Server instances, whether they are on a laptop, or a large Production data center, you need to be aware of how SQL Server updates and fixes are released, and how you can obtain them.
First, a few definitions:
Here is a small collection of links to tools for measuring and evaluating mobile and desktop processors, along with some marketing hype from Intel about Sandy Bridge.
CPU-Z info for… Read more
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty low on my favorites list.
One pretty easy way to include some “built-in” database documentation for your databases (which could be the beginnings of a data dictionary) is to add… Read more
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small blizzard), so I could get my hands on a 32nm Intel “Sandy Bridge” Core i7 2600K processor. It is a good thing I was there early, since they only… Read more
I woke up bright and early this morning to take the beta version of the Microsoft Certified Master in SQL Server 2008 Knowledge Exam at a Prometric Testing center in Greenwood Village, CO. Since 1995, I have passed about 25 different Microsoft Certification exams, including several beta exams. My first… Read more
I was browsing a public web site from a large company today, when I saw the error page shown below. It looks like they are using ColdFusion to talk to SQL Server using JDBC, and they are missing a stored procedure called getBladeList. This made me curious as to what… Read more
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is the number and composition of your SQL Server relational indexes. It is extremely important to have neither too many or too few relational indexes on each table, and that the… Read more
If you are a college or high school student, you can get a very valuable assortment of free software from the Microsoft DreamSpark program. As Microsoft says on the web site:
DreamSpark is simple:
It’s about giving students Microsoft professional tools at no charge
You can get things like Visual…
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information out there now. If you are in the market for a new laptop in the near future, I would be looking for a system with an Intel Core i7-2820QM processor,…
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database, so I could easily query and do some basic analysis against the results. I did a little data cleansing so that the data would always use the same terms for…