New OfficeTV Video Posted PowerPoint Presentation Tips for a More Energized Presentation, Color-Coding Appointments in Outlook. Also, Charts in Access 2007 and Thoughts About the Real Costs of Losing Information. (From our sister site, OfficeUsers.org) [Watch the Show] Featured Article(s) MySQL Web Hosting Package – What To Look For Structured query language is what SQL means and MySQL is one […]
Author: Ben Taylor
Storing Hierarchical Data, Why Departmental Databases Thrive
Featured Article(s) Storing Hierarchical Data – An Early Solution Have you ever faced a situation of handling hierarchical data, where retrieving them according to the tree structure is important? This article finds a way of storing data that could be retrieved faster. Sample of Great Jobs on the Job Boards Database Administrator San Diego, CA Great American Insurance Co. Application […]
Storing Hierarchical Data, Why Departmental Databases Thrive
Featured Article(s) Storing Hierarchical Data – An Early Solution Have you ever faced a situation of handling hierarchical data, where retrieving them according to the tree structure is important? This article finds a way of storing data that could be retrieved faster. Sample of Great Jobs on the Job Boards Database Administrator San Diego, CA Great American Insurance Co. Application […]
Working with Departmental Databases – Reader Comments
Working with Departmental Databases Jeff wrote in with some experiences (share yours here): "As a consultant, I like to run osql –L on a regular basis at my clients. When “unknown” servers raise their heads I review the list with the local manager to decide it the DB needs to brought “into the fold”, ignored or actively removed. As a […]
Working with Departmental Databases – Reader Comments
Working with Departmental Databases Jeff wrote in with some experiences (share yours here): "As a consultant, I like to run osql –L on a regular basis at my clients. When “unknown” servers raise their heads I review the list with the local manager to decide it the DB needs to brought “into the fold”, ignored or actively removed. As a […]
Departmental Database Discovery
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 […]
Departmental Database Discovery
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
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 […]
SQL Server 2008 Install VS SP1 Available
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 […]
Are You Ready for Some Football?
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 […]