Morris Lewis

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
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.
Upcoming Conferences

Register now to get the best rate available!

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
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More
Exclamation marke on yellow road sign
Sep 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 5: Setting Up Failover Alerts

Alerts represent a great way to take a proactive stance on being notified or alerted when something ugly, potentially ugly, or important happens on a SQL Server. On most servers that I manage, I typically deploy a whole bevy of different alerts....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) ×