* No other book covers all existing versions of SQL Server – this one does. * No other book contains as detailed explanations of the inner workings of the authentication and authorization processes. * This book is the result of nearly two years of research, and every example has been tested exhaustively to ensure the book is technically accurate. * Lewis has been a contributing author to SQL Server Magazine since its inception and trained hundreds of students on SQL Server since 1995; therefore, he knows how to make complex topics understandable to a wide range of people. * Lewis has consulted with several Fortune 500 companies on various aspects of database administration, and the book draws on his experience to highlight the critical weaknesses commonly found in even large companies with well-trained administrators. * If properly applied, the recommendations in this book result in a safer, more secure database environment. For example, this book recommended configuring firewalls to block the traffic used by the "Slammer" virus long before the virus became news. Those who read this book and followed its advice slept soundly the weekend that "Slammer" was taking the Internet down.
Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using, or administering Microsoft’s latest enterprise database? Need to understand what’s new in SQL Server 2005, and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you need–quickly, clearly, and objectively. Former SQL Server team member Eric L. Brown offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more. Brown draws on his extensive experience consulting with enterprise users, outlining realistic usage scenarios that leverage SQL Server 2005’s strengths and minimize its limitations. Coverage includes Architectural overview: how SQL Server 2005’s features work together and what it means to you Security management, policies, and permissions: gaining tighter control over your data SQL Server Management Studio: Microsoft’s new, unified tool suite for authoring, management, and operations Availability enhancements: online restoration, improved replication, shorter maintenance/recovery windows, and more Scalability improvements, including a practical explanation of SQL Server 2005’s complex table partitioning feature Data access enhancements, from ADO.NET 2.0 to XML SQL Server 2005’s built-in .NET CLR: how to use it, when to use it, and when to stay with T-SQL Business Intelligence Development Studio: leveraging major improvements in reporting and analytics Visual Studio integration: improving efficiency throughout the coding and debugging process Simple code examples demonstrating SQL Server 2005’s most significant new features
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance–related problem areas.
Search engine optimization (SEO) is not only the job of the marketing department. It must be considered from a web site's inception and throughout its lifetime by you, the web site developer. Making changes to the architecture of a web site and modifying presentation techniques can dramatically increase search engine rankings and traffic levels. Written for the ASP.NET developer or tech-savvy marketer, this unique reference provides techniques for creating and maintaining web sites optimized for search engines. You'll discover how to facilitate the indexing of your site, as well as how to leverage specific technologies and services for site promotion. You will understand the role of web site architecture in search engine optimization and explore various topics therein. Knowing this will help you to develop a site that achieves great search engine rankings. What you will learn from this book Understand the criteria that influence search engine rankings Create keyword-rich URLs using ASP.NET, ISAPI_Rewrite, and UrlRewriter.NET Use HTTP Headers to properly indicate the status of web documents Create optimized content and cope with duplicate content effectively Avoid being the victim of black hat SEO techniques Understand and implement geo-targeting and cloaking Use site maps effectively—for users as well as search engines SEO enhancements that can easily be applied to an existing web site Build a search engine–friendly e-commerce catalog Who this book is for This book is for ASP.NET developers who need to incorporate search engine optimization principles into their web applications, as well as marketers who want to gain a better understanding of the technologies involved in search engine marketing. Enhance Your Knowledge Advance Your Career Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
* One of the first books devoted solely to PHP security * Covers a wide swath of both defensive and proactive security measures, showing readers how to create captchas, validate email, fend off SQL injection attacks, and more * Methods discussed are compatible with PHP 3, 4, and 5
"Scott Schnoll has the amazing ability to present deeply technical information in an easy-to-understand, light-hearted way. This book is a must-read for anyone who is implementing Exchange 2003." --Paul Bowden, lead program manager, Exchange Server Development, Microsoft Corporation "Scott Schnoll''s clear, concise writing style and diverse knowledge makes his Exchange 2003 book readable and valuable to anyone deploying, inheriting, or considering Exchange Server 2003. An excellent, thorough, all-purpose Exchange 2003 book." --William Lefkovics, senior messaging and systems analyst,eEye Digital Security "This is one Exchange Server book that you''ll actually enjoy reading from cover to cover. You won''t want to put it down . . . I didn''t! It''s easy to read, yet it contains all of the essential information that you need to know." Christopher Meirick, co-blogger, MS Exchange Blog: http://www.msexchange.co.uk "Scott Schnoll''s knowledge of Exchange is second to none, and he has the ability to take very technical topics and explain them in a manner that is easy to digest. This book should be in every Exchange administrator''s toolkit." Mark Fugatt, MCT,Exchange MVP "I really enjoyed reading this book. I found it to be extremely informative, especially in covering the new features of Exchange 2003. I have no doubts in recommending this book to those who are serious about Exchange 2003." --Neil Hobson, Exchange MVP, lead messaging consultant,Silversands "Scott has written the essential administrative guide for Exchange 2003 deployment. Not only covering the ''how-to,'' but also truly exploring the ''what-if'' scenarios as well." --Kevin T. Price, deputy chief technical officer, CMS Information Services, Inc. "An essential technical reference containing the critical information necessary for successful administration and deployment of Exchange Server 2003. New features, removed features--this book covers it all." --James V. Walker, consultant "Scott Schnoll''s clear, concise writing style and diverse knowledge make his Exchange 2003 book readable and valuable to anyone deploying, inheriting, or considering Exchange Server 2003. An excellent, thorough, all-purpose Exchange book." --William Lefkovics, Senior Messaging and Systems Analyst, eEye Digital Security Nearly three years in the making, Exchange Server 2003 is the most reliable and secure messaging solution that Microsoft has ever produced. Microsoft Exchange Server 2003 Distilled is a practical, hands-on guide designed to bring readers quickly up to speed on the latest changes and enhancements to the leading e-mail server. Drawing on his involvement in Microsoft''s Exchange Server 2003 Joint Development Program, author Scott Schnoll offers the detailed technical information that Exchange administrators need to know. He has a clear and concise style, and focuses on what''s new, what''s improved, and what''s been removed from Exchange Server 2003. Throughout the book Scott illustrates key points with real-world scenarios, and provides best practices drawn from his years of experience working with Exchange. You will find answers to a variety of important questions, such as: What features have been included in Exchange Server 2003 to replace Exchange Server 2000 and 5.5 features? Chapter 3 How do you use Internet Mail Wizard to configure Exchange for Internet messaging? Chapter 4 What does Exchange Server 2003 offer for remote security, and how can you now better block unwanted e-mail? Chapter 6 How do you back up, restore, and recover data using Recovery Storage Groups, Windows Volume Shadow Service, and other features? Chapter 8 How do you use the new Outlook Mobile Access and Exchange ActiveSync features? Chapter 9 What tuning and configuration patterns will work best for your organization? Chapter 10 032124592XB04022004
Securing SQL Server is one of the most important responsibilities of the SQL Server professional. Ensuring your data are safe requires a combination of good systems and database administration, and intelligent application design – weaving a security plan that matches the capabilities and vulnerabilities of each contributing part. But at its root, security is concerned with controlling access – authenticating who can access the data on the server, authorizing what users can do with that data, and securing data as they are transported. These core topics are the focus of this book. SQL Server Security Distilled shows you: What you can do to secure date in SQL Server How SQL Server handles authentication and authorization in different versions How SQL Server security integrates with Windows security The security pros and cons of different transport protocols Ways to tailor SQL Server security to different applications, including client-server and Web applications How to secure DTS packages The implications of different types of replication for security The security features of SQL Server CE and its server-side agents
Any company using .NET will eventually (if it hasn't already) expose part of its functionality as a .NET Web service, and securing these features will become job number one. Expert Web Services Security in the .NET Platform is a comprehensive treatment on how to secure Web services on the .NET platform. This book specifically focuses on Web services security, not general .NET security. Authors Brian Nantz and Laurence Moroney lay the foundation for a complete discussion of Web services security in the .NET platform by first describing the key aspects of security for the Windows operating system, Internet Information Services, and ASP.NET. They show developers how to use the WS-Security W3C specifications for industry-standard authentication, encryption, authorization, XML signature, attachments, and routing with Web services. The specific working code examples and clear-cut explanations will assist developers in readily integrating Web services security into their applications.
*Completely up to date with the ASP.NET 2.0 technology and demonstrates the new best-practices and coding styles that it requires *Focuses on the needs of the developer and explains the technology in a way that is easy to apply to their development projects *Provides a comprehensive coverage of the whole of ASP.NET 2.0 (with VB .NET 2.0) to give the reader the best possible understanding of the whole subject area
