Archives: June 2010
Since the release of SQL Server 2005, Microsoft has been using what they call an Incremental Servicing Model for SQL Server. This means that every eight weeks, they release a cumulative update (CU) for a particular version and service pack of SQL Server. These cumulative updates typically have about 20-40…
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 2 (CU2) today. It became available for download today, and you can request it here. This is Build 1720, and it includes 18 fixes, mostly for Analysis Services and Reporting Services.
Below is a SQL Server 2008, SQL Azure,… Read more
One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual log files (VLFs) inside the SQL Server transaction log file. This usually occurs because the default initial size and autogrowth increment are both far too small for most production databases.… Read more
After getting my new grid-tied solar PV system turned on and operational on June 18, 2010, I have become temporarily obsessed with going outside and looking at the LCD display on my SunPower 3000m inverter to see how much power is being generated by the system. Since January 2010,… Read more
I noticed today that fellow SQL Server MVP Thomas LaRock (blog | twitter) had updated his SQL Server blog rankings, and promoted me to be on the TempDB list. That was quite a nice surprise, and a good way to start out the week. It is amazing… Read more
I took a day off work so I could be here when Namaste Solar and IREA came out to my house to replace my old electric meter with one that is capable of net-metering. This allows you to sell any excess electricity that you generate back to the utility company.… Read more
I will be teaching a special five week version of ICT 4462 – Transact SQL Programming at Denver University, University College starting on Monday, July 12, 2010. The class will meet on campus, on Monday and Thursday nights. It will have the same content as the regular 10 week class,… Read more
The Key Lookup operator is a bookmark lookup on a table with a clustered index. Key Lookups can be quite expensive, so you should try to eliminate them when you can. Of course, you should consider your overall workload, and how often the query with the key lookup is executed.… Read more
This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite new feature or enhancement in SQL Server 2008 R2. I am going to talk about some of the improvements in the core database engine.
Although the… Read more
Over this past weekend, I decided to build a new general purpose workstation from parts, with a goal of getting great performance with the lowest power consumption possible. The nice thing about building a Windows based machine is that you can choose the exact components that you want based on… Read more
After waiting nearly seven months after I signed the contract, my little 3.15Kw grid-tied solar PV system was partially installed today by Namaste Solar. They could have easily finished it today, but they had to stop so that the city inspector could do an “in progress” inspection on Monday… Read more
I was home today, since my 3.15Kw solar PV system was being installed, so I took a few pictures of my backyard with my two vicious guard-dog miniature dachshunds, Ruby and Roxy. Ruby (closest to the camera) is ten years old, and Roxy is seven years old. They both weigh… Read more
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and minor tweaks to many existing queries. Many of these queries will only work on SQL Server 2008 and above. Most of the DMV queries require VIEW SERVER STATE permission.
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There is a limit of four session submissions per speaker this year. Hopefully, I will get lucky and will have one or two sessions selected.
DMV Emergency Room!
If you have…
I was browsing Twitter today, and I noticed some retweets linking to a blog post that Brad McGehee (blog | twitter) had written called Two Blog Series You Don’t Want to Miss. When I clicked on the link, I saw my smiling mug, along side Paul Randal… Read more
While looking over my SQL Server Error logs, I noticed a small flurry of error messages like you see below, every two hours, at the top of the hour:
Login failed for user 'PRODUCTION\SomeSQLAccount'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.xxx.xxx]
Error: 18456, Severity: 14, State: 38.…
Last week, Microsoft released a slightly improved version of Robotics Developer Studio that supports Visual Studio 2010, and adds the functionality of the old Standard Edition of Robotics Developer Studio into one free, integrated package. More details are available at the Microsoft Robotics site. You can use Microsoft Robotics… Read more