|
|
SQL Server 2005 Management and Administration $36.91 "Microsoft SQL Server 2005 Management and Administration," based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators-from simple tips to tactical solutions. "Microsoft SQL Server 2005 Management and Administration "goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more. Understand how to… Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services Harden a SQL Server implementation Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication Monitor a SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure the SQL Server Management Pack and install Operations Manager 2007 Automate SQL Server routine maintenance Encrypt SQL Server data and communications, including setting up a Certificate Authority Performance tune and troubleshoot a SQL Server environment Create Integration Services packages and transfer data On the Web: Download bonus chapters from www.informit.com/title/9780672329562 Introduction 1 Part I Administering SQL Server Components 1 Administering SQL Server 2005 Database Engine 11 2 Administering SQL Server 2005 Analysis Services 67 3 Administering SQL Server 2005 Reporting Services 99 4 Administering SQL Server 2005 Notification Services 149 5 Administering SQL Server 2005 Integration Services 183 6 Administering SQL Server Replication 209 Part II Managing SQL Server 2005 7 Conducting a SQL Server 2005 Health Check 261 8 SQL Server 2005 Maintenance Practices 289 9 Managing and Optimizing SQL Server 2005 Indexes 317 10 Managing Full-Text Catalogs 353 11 Creating Packages and Transferring Data 387 Part III Securing the SQL Server Implementation 12 Hardening a SQL Server 2005 Environment 435 13 Administering SQL Server Security 469 14 Encrypting SQL Server Data and Communications 509 The following chapters are located online: Part IV SQL Server 2005 Overview (located online) 15 SQL Server 2005 Technology Primer 537 16 Tools of the Trade 571 Part V Disaster Recovery and High Availability (located online) 17 Back |
|
|
Microsoft SQL Server 2000 Bible [With CDROM] $3.94 Organization: The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server. Comprehensive coverage: This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server’s development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query. Sample database applications: The book builds on sample database applications to demonstrate topics/concepts. Sidebars: So as readers can focus on practical information, the author is using sidebars throughout to explain the best practices associated with the product and highlight material. ABOUT THE CD-ROM The CD-ROM contains the sample database applications and code examples in the book; SQL Server utilities; and links to Web sites, including the author’s own SQL Server Web site (www.IsNotNull.com). |
|
|
Professional SQL Server 2005 Administration $49.99 SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You’ll learn how to fine-tune queries you’ve already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. What you will learn from this book How to use some of the more advanced concepts of installation Techniques for properly administering development features such as SQL CLR Ways to secure your SQL Server from common threats How to choose the right hardware configuration Best practices for backing up and recovering your database Step-by-step guidelines for clustering your SQL Server Who this book is for This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features. Wrox Professional guides are planned and written by working technologists 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. |
|
|
Beginning Microsoft SQL Server 2008 Administration $49.99 SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker. |
|
|
High Performance SQL Server 2005 on 7 CD-ROMs $570.00 CD-ROM 1 – THE SCIENCE OF TUNING (2 hours 46 minutes) 1. Welcome to Performance Tuning & Optimization 2. High Performance Begins with Database Design 3. The All Important Indexes, Statistics & Locking 4. Tuning & Optimizing Queries and Stored Procedures 5. Enemies of Performance: Locking, Blocking and Deadlocks 6. Dynamic Management Views (DMV) & Functions (DMF) 7. Diagnosing & Fixing Commo… |
|
|
VERITAS DATA LIFECYCLE MGR WIN INCL ( N121268 ) $50.00 Item #: D58159. VERITAS Data Lifecycle Manager facilitates compliance practices and helps reduce data TCO by automatically enforcing data management policies to match data needs with storage attributes. DLM operations are transparent to end-users and applications, and integrated content index and search technology reduces the time and cost of “e-discovery.” Data Lifecycle Manager leverages existin… |
|
|
Microsoft System Center Essentials 2010 With Microsoft SQL Server Technology – License and Media – 1 Server. 1PK SYSTEM CENTER ESSENTIALS W/ SQL 2010 DSP OEI DVD KIT NMG-SW. Monitoring – OEM – DVD-ROM – PC – English Manufacturer/Supplier: Microsoft Corporation Manufacturer Part Number: EEC-00799 Brand Name: Microsoft Product Name: System Center Essentials 2010 With Microsoft SQL Server Technology Marketing Information: Microsoft System Center Essentials 2010 (Essentials 2010) is Microsoft’s second release of an IT systems management product specifically designed for the midsized business. Based heavily on cus… |
|
|
OCZ Technology 100 GB Vertex 2 Series SATA II 2.5-Inch Solid State Drive (SSD) OCZSSD2-2VTX100G $231.99 Speed is the name of the game and once again OCZ delivers with the OCZSSD2-2VTX100G Vertex 2 Solid State Drive!… |
Thwart the Three Biggest Internet Threats of 2007
The same Internet connection that lets you reach out and touch millions of Web servers, e-mail addresses, and other digital entities across the globe also endangers your PC and the information it contains about you. Here's how to stymie the three gravest Internet risks.
Threat1: IE
Internet Explorer heads the list of top Internet security attack targets in the most recent joint report of the FBI and security organization SANS Institute.
One reason: As the most widely used browser, IE provides the biggest payoff for malicious hackers who set out to exploit its flaws. The biggest problem with IE is its reliance on Microsoft ActiveX technology, which allows Web sites to run executable programs on your PC via your browser.
Security patches and upgrades, including Windows XP Service Pack 2 and the recently released IE 7, make ActiveX safer, but the inevitable flaws that allow malware to circumvent those security measures--combined with the reality that we computer users are often a credulous lot--make ActiveX a risk not worth taking.
Happily, with very few exceptions (such as Microsoft Windows Update site), you can browse the Internet effectively without ActiveX.
To disable ActiveX in IE 6 and 7, choose Tools, Internet Options, Security, Custom Level, scroll to 'Run ActiveX controls and plug-ins, and select Disable.
Click OK, Yes, and OK to close the dialog boxes. To enable ActiveX on a known and trusted site, click Tools, Internet Options, Security, choose Trusted Sites, click Sites, enter the site address in the text box, and click Add. Uncheck Require server verification (https:) for all sites in this zone, and click Close and OK.
If you leave ActiveX enabled, you may quickly encounter malware-harboring sites and e-mail attachments that ask you to let them install their ActiveX controls on your system. Unless you are 100 percent certain that the control is safe and legitimate, do not allow it.
Regardless of which browser is set as the default on your system, always keep Windows (and IE) updated to minimize your risk.
To keep Windows XP up-to-date, visit update.microsoft.com (you will have to use Internet Explorer) and install Service Pack 2, if you have not already. Next, choose Start, Control Panel, System, and click the Automatic Updates tab.
Select Automatic (recommended) If you trust Microsoft implicitly, Download updates for me, but let me choose when to install them if you trust the company a little bit, or Notify me but do not automatically download or install them to play it safest. (Click "Do not Let a Windows Update Bring You Down" for more on Windows updates.)
Whichever option you choose, click OK to download and install the most recent security patches.
If you stick with IE, upgrade to version 7, which improves ActiveX security. Still, the best way to reduce your PC vulnerability to ActiveX exploits is to download and install another browser, and set it as your default browser.
Mozilla Firefox is the most popular IE alternative. Unfortunately, Firefox growing popularity has enticed malware authors to exploit its own flaws. While no software is perfectly secure, many experts think the Opera browser is safer than either IE or Firefox.
Threat 2: Phishing and Identity Theft
You have probably seen your share of phishing attacks, which look like communications from your bank, PayPal, eBay, or another online account. The message may ask you to click a link that leads to a bogus Web page, complete with realistic user-name and password log-in fields, or it might ask for a credit-card number.
The fake address often resembles the real institution URL--'citibank.fakesite.com' in place of 'citibank.com', for example. The phishers site and e-mail message may even load images from your bank, or have links to the institution own Web site.
When you take the bait, the phisher harvests your data, and either sells it to someone else, or uses it to drain your account right away. A variant called spear phishing identifies you by name in the lure message or Web site, making the sham even harder to spot.
You may have read that your bank will never send you an e-mail asking you to log in to your account, and it should not, though it does happen on occasion. The vast majority of messages that appear to come from financial institutions are phishing attacks, so assume that such messages are bogus and avoid opening them at all, let alone clicking any links they contain.
If you are concerned that the bank or other service is really trying to notify you of a problem with your account, open your browser manually and log in to the site directly, or better yet, pick up the phone and call a customer service agent (if you can find one via the bank automated phone system).
The place you are most likely to notice that your credit card or bank account has been compromised by a phishing attack or identity theft is on the statement you receive from them via mail. Check it carefully for unauthorized charges, and report any to the institution immediately.
IE 7 asks you a couple of times if you had like to enable its phishing filter during installation; say yes. To enable this feature, choose Tools, Phishing Filter, Turn On Automatic Website Checking, and click OK.
Firefox 2 phishing filter is enabled by default, but it uses a static downloaded list of known phishing sites. Many firewalls and other security programs include identity-protection features that scan the stream of data leaving your PC for sensitive information, such as passwords or social security and credit card numbers, and then block the unauthorized transfers.
Resist the temptation to post personal information on your Web page, blog, or social site (Facebook/MySpace) account. Identity thieves, spammers, and online predators are always on the lookout for such data. Browse to "Safeguard Your Reputation While Socially Networking" for an explanation of the risks to both adults and children, and for tips on what you can do to avoid the dangers.
Threat 3: Malware
Every day, virus, spyware, and adware creators come up with new, ingenious ways to gain access to your PC.
These steps will help keep you safe:
Think before you click.Use a spam filter. Update your antivirus software.Download with discretion.Use a bidirectional firewall.Use antispyware.Cher K Markov articles on various subjects and has a treasure chest of information and resources onSoftware Downloadsat http://online-downloads.blogspot.com
Article Source: http://www.simplysearch4it.com/article/52135.html
|
|
Beginning Microsoft SQL Server 2008 Administration $28.04 New - SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration t |
|
|
Beginning Microsoft SQL Server 2008 Administration $49.99 SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker. |