December 2003
The Internet and the emergence of new protocols have driven computing to new levels. The threat from viruses and network intruders has never been higher. Here are seven steps to setting up better security for your SQL Server systems.
November 2003
Microsoft has had plenty of time to add many new features to SQL Server’s next release, code-named Yukon. Here are seven important features that they have announced for Yukon.
October 2003
XML has become a vital interoperability tool and a core component of many applications. Here are seven XML document types that are most often used in SQL Server database application development.
September 2003
These connection-string examples illustrate the seven most common connection scenarios.
August 2003
SQL Server Reporting Services, set for release by the end of the year, will fill the only hole in the SQL Server product--the lack of a built-in reporting component. Here are Reporting Services' seven most important features.
July 2003
Microsoft provides several tools for working with BLOB objects. Here are seven of the most important BLOB access technologies.
June 2003
Knowing what not to do is important because violating these precautions can ruin your ADO.NET application's performance or compromise the security of your SQL Server system.
May 2003
ADO.NET isn’t just a fancy new wrapper for the COM-based version of ADO. Here are seven tips to help you write better ADO.NET applications.
April 2003
A lot of people are confused about the differences between MSDE 2000 and SQL Server 2000, especially about how MSDE differs from SQL Server 2000 Personal Edition. Michael Otey counts seven important ways that MSDE differs from SQL Server 2000.
March 2003
Here are seven important features for database developers in Visual Studio .NET 2003.
February 2003
Michael Otey revisits SQL Server’s six major releases, then looks to the future and the upcoming Yukon release.
January 2003
Mike Otey shows you seven methods you can use to start SQL Server.
December 2002
There are more ways to stop SQL Server than you might think.
November 2002
Web Matrix is a great way to get your feet wet using ASP.NET without shelling out the money for a full copy of Visual Studio .NET. Here are the seven best things about Web Matrix.
October 2002
Here's a quick introduction to fixed server roles in SQL Server 2000 and 7.0.
September 2002
Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.
August 2002
The Web provides many opportunities for you to exchange ideas with other SQL Server professionals. Here are links to seven of the best online SQL Server discussion groups.
July 2002
Developers are learning how important Visual Studio .NET will be to Yukon, the next release of SQL Server. Are you ready to begin testing Visual Studio .NET? Here are the answers to seven common questions that you might ask.
June 2002
Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.
May 2002
Query Analyzer is one of the most frequently used utilities in SQL Server’s tool set. Here are seven keyboard shortcuts that make Query Analyzer a more effective and productive tool.
Add these Headlines to your Website