February 2006
Table and database-file fragmentation are performance-killers that require ongoing vigilance to keep them in check. Learn about one DBA's creative methods for troubleshooting and fixing these problems.
SQL Server Magazine
December 29, 2005
Here's a brief guide to the stored procedures mentioned in the main article as well as a few additional ones that the author used in his fragmentation solution.
Windows IT Pro
May 2005
Backup and recovery software offers fabulous new features to help you work safer and faster; but which software is best for you? Use this handy guide to narrow down your choices.
SQL Server Magazine
September 2004
For database backup, Imceda LiteSpeed for SQL Server and UltraBac give you backup to a hard disk and good data compression. LiteSpeed might be the fastest database-backup software, but UltraBac offers strong management capabilities.
SQL Server Magazine
July 2002
All security operations in SQL Server depend on authentication and authorization. Kerberos authentication, the Windows 2000 default, offers identification of both the client and the server.
SQL Server Magazine
July 2002
Examine the strengths and weaknesses of each encryption method for the best security.
SQL Server Magazine
March 2002
Bring the ancient art of Feng Shui into your design to let your data flow more smoothly. When you orient the data flow toward the user and remove bottlenecks that block the flow, you can achieve true balance and harmony in your system.
SQL Server Magazine
January 2002
SQL Server trainer and consultant Morris Lewis recommends a variety of resources that SQL Server administrators and developers can use to improve their knowledge and advance their careers.
SQL Server Magazine
January 2002
Bibliographic references for all books, online resources, and MOC courses that Morris Lewis describes in "Learning for Life."
SQL Server Magazine
July 2001
Put your database in the palm of your hand. After you learn how to configure distributed computing with SQL Server CE and merge replication, your laptop might be taking a fewer trips out of the office.
SQL Server Magazine
July 2001
Handy reference resources for setting up SQL Server CE and merge replication.
SQL Server Magazine
March 16, 2001
This week's questions apply to topics for Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0.
Windows IT Pro
March 9, 2001
This week's questions focus on topics for the SQL Server exams 70-029 and 70-229.
Windows IT Pro
March 2, 2001
This week's set of questions is the second to cover topics relating to Exam 70-028, Administering Microsoft SQL Server 7.0.
Windows IT Pro
February 23, 2001
This week's questions cover basic server administration topics for Exam 70-028, Administering Microsoft SQL Server 7.0.
Windows IT Pro
January 18, 2001
Morris Lewis presents three more questions that will help you prepare for Exam 70-028: Administering Microsoft SQL Server 7.0.
Windows IT Pro
January 12, 2001
Morris Lewis presents questions that will help you prepare for Exam 70-028: Administering Microsoft SQL Server 7.0.
Windows IT Pro
October 2000
Build a security plan for SQL Server 2000 or SQL Server 7.0 that is manageable, flexible, and verifiably secure.
SQL Server Magazine
August 2000
This pint-sized application gives mobile users powerful database functionality.
SQL Server Magazine
January 2000
What a difference an index can make! You can get better performance by configuring everything from your hardware to your database options. Here are my top nine ways to performance-tune SQL Server 6.5.
SQL Server Magazine
Add these Headlines to your Website