Featured Article(s) Troubleshooting SQL Server 2005 Triggers In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2005 triggers. He also tells how you can resolve these problems. Are You Ready for Some Football? (Notice 3/3) LAST CALL – Need your entry by Fri 8/15/2008 Amazingly, it’s that time again. Are you interested in playing […]

SQL Server 2008 Install VS SP1 Available In case you didn’t hear, one of the issues with the SQL Server installation was a dependency on Visual Studio 2008 SP1. The issue only really arose in certain situations, but I know a know of people were holding off on the install until they could get the update. SP1 for VS wasn’t […]

New SQL Server Video Show Posted! SelectViews: Index Fragmentation, Import Options, Data/Time Conversions, DBA Data Validation Thoughts. Also, upcoming events, a look at SQL Server 2008, current release versions, noise and news and much more. [Watch Show] Featured Article(s) How to Calculate the Number of Business Days in a Month This article describes a simple function that can be used […]

New SQL Server Video Show Posted! SelectViews: Index Fragmentation, Import Options, Data/Time Conversions, DBA Data Validation Thoughts. Also, upcoming events, a look at SQL Server 2008, current release versions, noise and news and much more. [Watch Show] Featured Article(s) Oracle 2-Day DBA in x Days Post 11; Oracle Physical Storage Structures This article takes a look at the physical storage […]

Build Your Data Warehouse in the Cloud Start leveraging the technologies, accessibility and capacity of cloud-based systems. the BI Cloud is an on-demand data warehouse system that uses a distributed database clustering technology. You won’t have to worry about scalability or uptime issues again – and you can focus on providing a great Data Warehouse solution. Get more information here! […]

Featured Article(s) Troubleshooting SQL Server 2005 User-Defined Functions In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 user-defined functions. He also tells how you can resolve these problems. Watch the Latest SQL Server Video Program SQL Server 2008 Features: Chris Shaw takes a look at some of the new features […]

Real-Time Monitoring, Diagnostics, Tuning… …for your SQL Server and Windows Server metrics. Find out about real-time information, historical reporting, performance and diagnostics information and a whole lot more. SQL Sentry Performance Advisor brings a new, killer tool that you can use to dig into and keep track of your servers. Check it out – it may be just the ticket […]

Featured Article(s) How to determine membership in Windows Groups using T-SQL I lead a recent serverdatabase migration from SQL Server 2000 to SQL Server 2005. Several of my team were supposed to be added to a Windows group that was to have been granted access to the new SQL Server. We tested their access and they were not able to […]

New Video Show Posted SQL Server 2008 Features: Chris Shaw takes a look at some of the new features of SQL Server – and how they work. This is a special airing of his session from the June Virtual Conference. Find out about key features, what benefits they offer, how they could apply to your work and your upgrade efforts […]

Data Usage – A Great Analysis I really liked the analogies and information in this post from Jill – good food for thought. Wanted to be sure to pass it along. "You’ve just begun to scratch the surface of a huge issue that is not new at all. However, the problem is growing as data becomes more easily accessible. I […]