Monthly Archives: May 2007

Find SQL Server Users that are Connected to your Database

Posted on May 24, 2007 by Glenn Berry

This DMV query will let you determine who is connected to your database, and how many sessions they have. — Get SQL users that are connected and how many sessions they have SELECT login_name, count(session_id) as session_count FROM sys.dm_exec_sessions GROUP … Continue reading →

Posted in SQL Server 2005 | 1 Comment

NewsGator Online Nominated for CNET Webware 100 Award

Posted on May 24, 2007 by Glenn Berry

Our wonderful Online RSS reader, which you can try here, has been nominated for a CNET Webware 100 Award! You can vote for it by going here. Hats off to our hard working Online team!

Posted in NewsGator | 2 Comments

New Chipsets from Intel

Posted on May 21, 2007 by Glenn Berry

Tom’s Hardware has a good post about the new 3-series chipsets from Intel that will support a 1333MHz FSB and DDR3 memory, among other things. Tom’s gives the new chipset family a rave review, noting better USB and RAID performance … Continue reading →

Posted in Computer Hardware | Leave a comment

Intel Tigerton Xeon MP Coming Soon

Posted on May 18, 2007 by Glenn Berry

DailyTech has a short article discussing the upcoming "Tigerton" Xeon MP server CPU that is due next quarter. This CPU is based on the newer, more efficient Core2 architure, rather than the older Pentium 4 "Net Burst" architecture (like the … Continue reading →

Posted in Computer Hardware | 2 Comments

SQL Server 2005 BOL Updates from Microsoft Update

Posted on May 16, 2007 by Glenn Berry

SQL Server 2005 Books Online (BOL) updates are available from Microsoft Update (not from Windows Update), under Software, Optional or SQL Server. The current BOL version is from February 2007.     Technorati Tag: SQL Server

Posted in SQL Server 2005 | Leave a comment

How to Find Out Why Your SQL Server 2005 Transaction Log is Growing

Posted on May 16, 2007 by Glenn Berry

If you ever notice that your transaction log is growing in SQL Server 2005 (either the % space used is increasing or the file itself needs to be grown, then you have a problem that you need to investigate. First, … Continue reading →

Posted in SQL Server 2005 | Leave a comment

SQL Server Storage Best Practices

Posted on May 16, 2007 by Glenn Berry

Here is a good, short article on TechNet listing ten best practices for SQL Server Storage. This has some good information, and it is an easy, quick read. Technorati Tag: SQL Server

Posted in SQL Server 2005 | Leave a comment

Windows Server 2008 Box Shot

Posted on May 15, 2007 by Glenn Berry

It uses the same hard to open package as Windows Vista.

Posted in SQL Server 2005 | Leave a comment

Windows Server 2008

Posted on May 15, 2007 by Glenn Berry

Microsoft has finally officially announced that Windows "Longhorn" Server will have the actual name of Windows Server 2008. Microsoft has a video, explaining "What’s in a Name"? This is kind of funny after all the leaks over the past couple … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Microsoft Announces Plans for Katmai

Posted on May 9, 2007 by Glenn Berry

Microsoft has begun releasing some information about the next version of SQL Server, code named "Katmai", which is due for release in 2008. Here is the Katmai web site, which while pretty sparse, does have a PDF datasheet download available. … Continue reading →

Posted in SQL Server 2005 | Leave a comment