Microsoft SQL Server 2005 for Dummies

From the Back Cover
Check out enhanced security, Integration Services, Reporting Services, and more

What’s new in SQL Server 2005? Plenty, and this guide will help make it all clear! You’ll get the rundown on how to create databases, create queries using the traditional Transact-SQL language, work with the Common Language Runtime, use the new user interface to manage SQL Server 2005, generate business intelligence applications, and more — in plain English.

Discover how to:
– Formulate and run queries
– Create databases, tables, and relationships
– Create stored procedures and triggers
– Secure your data and protect it from loss
– Create business intelligence applications
– Maintain a SQL Server system

About the Author
Andrew Watt (Scotland, UK) is a Microsoft Most Valuable Professional (MVP). He specializes in Microsoft technologies, including the SQL Server database and InfoPath. He is an independent consultant and experienced computer book author. He first used SQL Server in version 7.0. He is using SQL Server 2005 beta in the beta programs since August 2003.

Related Articles

Microsoft SQL Server 2005 Programming 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

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 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 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 Reporting Services For Dummies

Find the right information and present it the right way
Take full advantage of all SQL Server Reporting Services can do for you

Without a way to interpret it, the data in your database just sits there doing nothing. Now you have help! This handy guide shows you how to retrieve data and create reports with the newest version of SQL Server Reporting Services, so you can deliver both hard copy and interactive, Web-based reports that tell your story.

Discover how to

Access information from different databases
Build the right queries
Choose the best report type
Move from other reporting tools
Deliver reports on demand
Produce drill-down and drill-through reports