Microsoft SQL Server 2005 Programming For Dummies

From the Back Cover
Create and modify databases and keep them secure
Get up to speed on using T-SQL to store and manipulate data

SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You’ll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.

Create queries to retrieve data
– Ensure SQL Server security
– Use Visual Studio® 2005 with SQL Server
– Create tables, views, and indexes
– Work with Common Language Runtime
– Query XML data

About the Author
Andrew Watt wrote his first computer programs back in 1985. He is an independent consultant, experienced author, and Microsoft MVP (Most Valuable Professional) for SQL Server. His areas of interest and expertise include SQL Server 2005, Windows PowerShell, XML, and Microsoft InfoPath.

Andrew first used SQL Server in version 7.0 and was an active participant in the SQL Server 2005 beta program from August 2003.

Among the books Andrew has written, or co-written, are SQL Server 2005 For Dummies, Beginning Regular Expressions, Beginning XML (3rd edition), Beginning RSS & Atom Programming, Professional XML (2nd edition), and Designing SVG Web Graphics.

Andrew is often seen answering questions in Microsoft’s SQL Server and other newsgroups. Feel free to get involved in the community there. He can be contacted direct at [email protected] Due to the volume of e-mail he receives, he can’t guarantee to respond to every e-mail.

Related Articles

Microsoft SQL Server 2005 for Dummies

Create and modify databases and keep them secure

Get up to speed on using T-SQL to store and manipulate data

SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You’ll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.

* Create queries to retrieve data
* Ensure SQL Server security
* Use Visual Studio(r) 2005 with SQL Server
* Create tables, views, and indexes
* Work with Common Language Runtime
* Query XML data

Microsoft SQL Server 2005 for Dummies

Now updated to reflect the much-anticipated “Yukon” release of SQL Server, this friendly guide shows database developers and administrators as well as those who use database application how to get up to speed fast Offers a gentle introduction to relational database design and shows how to build databases, create database applications, and maintain and optimize database performance Covers the major new features of the “Yukon” release-including analysis services, reporting services, and notification services

Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to:
Build and maintain tables
Design a database and communicate with it
Retrieve, analyze, and report data
Build solid, robust database applications
Use the SQL Server Optimizer and Query Designer
Navigate SQL Server with Visual Studio
Develop useful reports with the Report Builder and Report Designer
Create Business Intelligence solutions with Business Intelligence Development Studio
Configure your server and perform major administrative tasks
To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks:

Essential Concepts
Designing and Using Databases
Interacting With Your Data
Database Programming
Reporting Services
Analysis Services
Performance Tips and Tricks
Database Administration
Appendixes

Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Microsoft SQL Server 2005 Express Edition For Dummies

– Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
– Written in the typical nonintimidating For Dummies style, the book’s emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft’s Express product line
– Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files
– Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database

The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Microsoft Exchange Server 2007 for Dummies

Microsoft Exchange Server 2007 was made to help you handle e-mail, meeting management, and other essential office services. Microsoft Exchange Server 2007 For Dummies helps you get a handle on Exchange Server. Pretty slick, huh?
Here’s the lowdown on installing and administering Microsoft Exchange Server 2007 and taking advantage of all the enhancements in Service Pack 1. With this handy guide, you’ll be able to maximize the security, reliability, and speed that Exchange Server 2007 provides.

Assess your organization’s needs to determine which edition of Exchange Server best meets them
Explore what Exchange Server does, then plan, install, and configure it
Consider how your users work with their mail and customize your set-up to facilitate their needs
Learn to use the Exchange Management Console
Use the new Exchange Server security features to protect e-mail from viruses, spam, phishing, and other threats
Set up an offline address book, use templates, and develop custom forms
Create settings for the most efficient interaction with clients, use multiple mailboxes, and view digital certificates
Manage resource scheduling and interactive calendars
Troubleshoot your configuration, perform regular maintenance, and be able to recover from mail-specific problems
Monitor Exchange Server performance and maintain databases, mail flow, and peak performance

Microsoft Exchange Server 2007 For Dummies gets you ready to exchange problems for solutions.