Microsoft SQL Server Black Book

Microsoft SQL Server Black Book, 9781576101490 (1576101495), Coriolis Group Books, 1997

Welcome to the world of Microsoft SQL Server! Here is finally a client/server database product that can deliver world-class performance at a price that most enterprises can afford not only to purchase, but also to support. SQL Server’s ease of use, coupled with the incredible feature set that accompanies it, delivers enterprise-level client/server computing to everyone. Microsoft SQL Server Black Book will focus on the tasks involved in harnessing Microsoft SQL Server’s capabilities to create a solid production data server. This book focuses on the current release of Microsoft SQL Server while using many techniques that can be applied as far back as version 4.21.

Each chapter is broken into two sections. The first part of each chapter presents explanatory material about the chapter topics. The second page of this first part is a blank Administrator’s Notes page, for you to write on and refer back to later. The first part of the chapter ends with a Summary section, which is a bulleted list of the important points of the chapter. The second part of each chapter (the Practical Guide) supplies you with some step-by-step tasks that reinforce the content of the chapter and provide hands-on practice. Chapters 1to3 cover the installation and configuration of Microsoft SQL Server for both development and production environments. Chapter 4 explains the setup and terminology needed to implement replication between SQL servers. Chapters 5 to9 discuss the SQL language and the many objects that can be created for and utilized in client/server applications. Chapters 10, 11, and 12 cover the troubleshooting and tuning skills you will need to support your system over the long haul.

This book is geared toward readers with a broad range of backgrounds. Many readers may have never worked with Microsoft SQL Server before, so I have tried to write a book that can transform a beginner into a power user. At the same time, I have added plenty of advanced concepts and techniques to each chapter that experienced DBAs can use to get your server running like a thoroughbred.

The book assumes a basic understanding of Windows NT. The exercises and examples will run on any machine that can run the client utilities for Microsoft SQL Server.

Comments

Amazing Books

Human Geoscience (Advances in Geological Science)

Springer, 2019

This book is a product of the joint efforts of interdisciplinary academic fields under the integrative framework of human geoscience. Human geoscience is a new genre of geoscience concerned with the natural phenomena that occur on the surface of the Earth and their relations with human activities. It therefore has connections with many...

UI Design with Adobe Illustrator: Discover the ease and power of using Illustrator to design Web sites and apps

Adobe Press, 2012

I realize right off the bat that I am going to date myself here. I began my career as a graphic designer when the web was still in its infancy. I learned paste-up techniques and created marker comps before I ever knew that same stuff could be done faster on a computer. once I got out of school, it became apparent...

Craniofacial Identification

Cambridge University Press, 2012

The promotion of CCTV surveillance and identity cards, along with ever heightened security at airports, immigration control and institutional access, has seen a dramatic increase in the use of automated and manual recognition. In addition, several recent disasters have highlighted the problems and challenges associated with current disaster...

Sennacherib at the Gates of Jerusalem: Story, History and Historiography (Culture and History of the Ancient Near East)

Brill Academic Publishers, 2014

Mordechai Cogan (Ph.D. University of Pennsylvania) is Professor Emeritus of Biblical History in the Department of Jewish History, The Hebrew University of Jerusalem. He has written widely on the relationship of Israel and Judah with the Mesopotamian empires during the first millennium b.c.e., and history-writing in the ancient...

Create!: The No Nonsense Guide to Photoshop Elements 2

McGraw-Hill, 2003

Because Your Computer Should Improve Your Life, Not Complicate It

No Nonsense Guides are here. With a plainspoken approach, these books are inexpensive starters that are light on idle chat and heavy on practical advice. They're lean and mean and stripped down to fighting weight, so you'll get from point A to point Z with instruction...

1001 Ways to Make Money If You Dare

Adams Media, 2009

Everyone’s in search of a quick buck, and now they know where to find it—if they dare. Whether it’s becoming a living, breathing billboard, or selling bootleg concert t-shirts in the arena’s parking lot, there’s plenty of ways to rake in the dough on daring ventures and ballsy entrepreneurial moves. This book...