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).

Articles by Morris Lewis
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.
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×