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.

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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×