Microsoft released SQL Server 2008 CTP5 to beta testers last week. It's now available for download on the Microsoft Connect site. This CTP includes a number of long-awaited ... Read More

In a recent forum posting, Access.Ignorant wrote: "I'm new to Access and I am totally lost. I am trying to add a new record, but the New Record button is disabled. ... Read More

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models ... Read More

In a recent forum posting, Sarah wrote: "I have multiple Count queries in a database and need to write a query that will allow me to sum the results of the ... Read More

SQL Server user-defined functions and stored procedures offer similar functionality. Both allow you to create bundles of SQL statements that are stored on the server for future use. This offers ... Read More

Microsoft announced at TechEd this week that "The November Community Technology Preview (CTP) for Microsoft SQL Server 2008 is available for customer download this month." They promised that this ... Read More

SQL Server 2008 is coming soon! Microsoft released the most recent Community Technology Preview (CTP) in July and I've heard rumors from several industry sources that a new CTP ... Read More

In a recent forum posting, TMCHAM wrote: "I am trying to maintain a set of queries in several databases on our network. The queries I write in my local copy are ... Read More

SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center. Read ... Read More

If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you "Is that database normalized?" or "Is that in BCNF?" All ... Read More

Looking to easily share and manage data in your organization with Microsoft SharePoint Services? In addition to using this collaboration tool for traditional Office documents, you can also integrate ... Read More

In a recent forum posting, Cooper Austin wrote: "How do I partition an EXISTING very large SQL Server table that is a fact table in a DW Schema. I want ... Read More

Earlier this month, Gartner released their well-known "Magic Quadrant" analysis of the data warehouse database management systems market in 2007. If you're not familiar with this analysis, Gartner evaluates ... Read More