Morris Lewis


Morris Lewis is the database administrator for Digichart, an application service provider for the healthcare industry. He is the author of SQL Server Security Distilled (2nd ed., Apress).

Winning the Fragmentation Battle 10
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.
Relevant T-SQL Stored Procedures 7
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.
Buyer's Guide: Backup and Restore Software
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.
Lab Report: LiteSpeed and UltraBac 2
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.
Guard Your Data with Kerberos
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.
IPSec vs. Kerberos
Examine the strengths and weaknesses of each encryption method for the best security.
Feng Shui and Database Design
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.
Bibliography of Resources
Bibliographic references for all books, online resources, and MOC courses that Morris Lewis describes in "Learning for Life."
Learning for Life
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.
Finding What You Need to Use SQL Server CE
Handy reference resources for setting up SQL Server CE and merge replication.
You Can Take It with You 1
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.
Creating a Manageable Security Plan
Build a security plan for SQL Server 2000 or SQL Server 7.0 that is manageable, flexible, and verifiably secure.
An Early Look: SQL Server 2000 Windows CE
This pint-sized application gives mobile users powerful database functionality.
Nine Ways to Optimize SQL Server 6.5 Queries
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.
Tuning SQL Server 6.5 for High-Performance Queries
An application’s performance depends on your database’s design and query structure. A few simple tweaks of your database and queries can give you optimal performance.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×