Monthly Archives: June 2008

New Column in sys.dm._os_sys_info

Posted on June 27, 2008 by Glenn Berry

There is a new column in the sys.dm_os_sys_info dynamic management view in SQL Server 2008, called sqlserver_start_time, which shows the last time SQL Server was started. I have a couple of sample queries below that show some of the other … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Improvements in Integrated FullText Search (iFTS) in SQL Server 2008 RC0

Posted on June 27, 2008 by Glenn Berry

SQL Server 2008 RC0 was released to the public a couple of weeks ago, and we have been using it on a couple of Production servers for about three weeks. So far, I am pretty happy with RC0, especially compared … Continue reading →

Posted in SQL Server 2008 | 2 Comments

My Own Walden Pond

Posted on June 24, 2008 by Glenn Berry

I am spending a few days with a group of veteran SQL Server DBAs on the beautiful campus of Ohio University in Athens, Ohio, which was founded in 1804. It really is a wonderful setting, next to the Hocking River, … Continue reading →

Posted in SQL Server 2008 | Leave a comment

SQL Server DML Triggers Are Evil

Posted on June 19, 2008 by Glenn Berry

Conor Cunningham (formerly of Microsoft, and now with SQLSkills) has a good post up about the performance disadvantages of DML triggers.  I completely agree with him here. I am happy to say that we have zero DML triggers in any … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Cumulative Update Package 8 For SQL Server 2005 Service Pack 2 Released

Posted on June 17, 2008 by Glenn Berry

Microsoft has released Cumulative Update 8 (CU8) for SQL Server 2005 SP2, which is a roll-up of all post SP2 fixes. It is Build 3257. This article explains the difference between the various types of patches that Microsoft issues for … Continue reading →

Posted in SQL Server 2005 | 4 Comments

Activity Monitor in SQL Server 2008 RC0

Posted on June 16, 2008 by Glenn Berry

Microsoft has finally taken the wraps off of a completely revised feature called Activity Monitor in the RC0 version of SQL Server 2008, which has been available to the public since June 10, 2008. If you have used Vista or … Continue reading →

Posted in SQL Server 2008 | 9 Comments

SQL Server 2008 Jumpstart Material

Posted on June 16, 2008 by Glenn Berry

Microsoft has posted quite a bit of new material about different new features in SQL Server 2008. There are lots of technically oriented PowerPoints, hands on lab documents and even VirtualPC Images that you can download.   Technorati Tags: SQL … Continue reading →

Posted in SQL Server 2008 | Leave a comment

New “Optimize For Ad hoc Workloads” Option in SQL Server 2008 RC0

Posted on June 13, 2008 by Glenn Berry

There is a very useful new sp_configure option in SQL Server 2008 RC0 called “Optimize for Ad hoc workloads”. This is how Books Online (BOL) describes it: The optimize for ad hoc workloads option is used to improve the efficiency … Continue reading →

Posted in SQL Server 2008 | 5 Comments

Microsoft Adds New Master Certification Level

Posted on June 12, 2008 by Glenn Berry

Microsoft has announced a new, Microsoft Certified Master technical certification level that will be added later this year. Initially, this will be available for Exchange Server 2007, SQL Server 2008, and Windows Server 2008 Active Directory. I have always been … Continue reading →

Posted in Microsoft | Leave a comment

SQL Server 2008 RC0 Available To the Public

Posted on June 10, 2008 by Glenn Berry

The RC0 version of SQL Server 2008 is available from the Microsoft Download Center. They have Enterprise, Standard, Evaluation and Express Edition available. RC0 will expire after 180 days. Previously, Microsoft’s Anthony Carabino announced on June 7, that SQL Server … Continue reading →

Posted in SQL Server 2008 | Leave a comment