Monthly Archives: April 2008

Troubleshooting SQL Connectivity Issues

Posted on April 30, 2008 by Glenn Berry

The SQL Protocols Blog has a very useful post on how to troubleshoot connectivity issues with SQL Server 2005. One tool that they did not mention is the old Microsoft Data Link trick to test connectivity. This will work with … Continue reading →

Posted in SQL Server 2005 | 72 Comments

Sample T-SQL Scripts for Backup/Restore and Index and Statistics Maintenance

Posted on April 28, 2008 by Glenn Berry

Here are some sample T-SQL scripts for backing up and restoring databases and transaction logs (using AdventureWorks on the C: drive, which would not be a good idea in reality). They also show how to detach and attach a database, … Continue reading →

Posted in SQL Server 2005 | 11 Comments

Self Service Cumulative Updates for SQL Server 2005

Posted on April 27, 2008 by Glenn Berry

Hooray!  Microsoft’s Bob Ward has announced the availability of completely self-service Cumulative Updates for SQL Server 2005.  This is a great time saver, and it something many people had been asking Microsoft to do in recent months. It used to … Continue reading →

Posted in SQL Server 2005 | 7 Comments

SQL Server 2008 Backup Compression Tuning Technical Note on SQLCAT.COM

Posted on April 24, 2008 by Glenn Berry

Microsoft’s Sanjay Mishra and Mike Ruthruff have published a very informative technical note on SQLCAT.com that discusses different methods for increasing performance with compressed backups with SQL Server 2008. One of the more valuable new features in SQL Server 2008 … Continue reading →

Posted in SQL Server 2008 | Leave a comment

SQL Server Storage Best Practices

Posted on April 22, 2008 by Glenn Berry

Lindsey Allen, of the SQLCAT Team has a very useful Top 10 list for Storage Best Practices at SQLCAT.com. Poorly configured and under-sized I/O subsystems are a very common problem with SQL Server 2005. I think that this often happens … Continue reading →

Posted in SQL Server 2005 | 5 Comments

NewsGator Online Integrates With AideRSS

Posted on April 20, 2008 by Glenn Berry

Marshall Kirkpatrick of ReadWriteWeb has a nice post about NewsGator Online’s recently announced AideRSS integration.  We also announced that the final version of NewsGator Inbox 3.0 is available for free download here. Technorati Tags: NewsGator, AideRSS

Posted in NewsGator | Leave a comment

Microsoft Finally Announces SP3 for SQL Server 2005

Posted on April 15, 2008 by Glenn Berry

Today at the MVP Summit in Seattle, we got the word (previously announced by Francois Ajenstadt) that Microsoft will be releasing SP3 for SQL Server 2005 in Q4, 2008. This is great news, especially since Microsoft was getting beat up … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Are Apple Fan Boys Hurting Apple?

Posted on April 10, 2008 by Glenn Berry

Marketing Ninja has a great post about how he will never buy an Apple product (outside of an iPod) because of the fanatical, annoying smugness of so many Apple users.  I must say, I have to agree. I have witnessed … Continue reading →

Posted in Computer Hardware | Leave a comment

The Magic of Data Compression

Posted on April 8, 2008 by Glenn Berry

As Moore’s Law has stayed in effect over the last 40 years, processor performance improvements have long outstripped gains in main memory and disk I/O performance. Hence, the popularity of larger, multi-layer caches, (at the CPU, disk controller, and SAN … Continue reading →

Posted in SQL Server 2008 | 3 Comments

In Redmond Getting More Brainwashing

Posted on April 1, 2008 by Glenn Berry

I have been in Redmond this week, in meetings with some members of the SQL Server Development team about SQL Server 2008 and the next version of SQL Server. Unfortunately, I can’t get into any specifics, but I will say … Continue reading →

Posted in SQL Server 2008 | 1 Comment