Showing posts with label sql server 2005. Show all posts
Showing posts with label sql server 2005. Show all posts

A First Look at SQL Server 2005 for Developers Review

A First Look at SQL Server 2005 for Developers
Average Reviews:

(More customer reviews)
Are you looking to buy A First Look at SQL Server 2005 for Developers? Here is the right place to find the great deals. we can offer discounts of up to 90% on A First Look at SQL Server 2005 for Developers. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

A First Look at SQL Server 2005 for Developers ReviewWhen it comes to SQL Server, I have always found BOL to be 99% comprehensive and 99% usable, so I regard the majority of aftermarket books to be written for people who want to avoid BOL for other reasons.
Of course, BOL 2005 is a work in progress, as is SQL 2005 itself, which makes the learning curve steep, especially if you didn't get started with an earlier beta, so I had high expectations for "A First Look at SQL Server 2005 for Developers" from Addison-Wesley. It's roughly 700 pages (depending on how you count; Amazon apparently counts every single sheet of paper between the covers, even if they aren't normal pages).
Let's get something straight right away: this book is for mainstream app developers. In particular, it's mostly about the CLR integration and XML-related features. Sure, general T-SQL enhancements and other areas like Notification Services get covered, and there's some cursory information about the new GUI tools. But topics like Analysis Services, DTS, Reporting Services, and migration/deployment are totally missing. I think this book does a great job covering its chosen topics in reasonable depth, but the bottom line is that you should set your expectations based on your interest in CLR and XML.
One more thing to get out of the way: The publisher's "Book Support" page is useless. The publisher claims that you should be able to find Errata here, but there's currently no link. Also, the Sample Chapter link is currently broken. (You can, however, find a sample chapter from this book in the Beta 2 Resource Kit recently posted on the MSDN Subscribers Download site. It's Chapter 15 covering the new Service Broker.)
The book has an official web site with updates, downloadable code examples, and errata. To find it, you must visit one of the links on page xxxiii and surf to the book site under Bob Beauchemin's site at DevelopMentor.
This is a very well-written book which does an outstanding job of moving from concepts to code. When concepts are introduced, some books drag out the process of putting them into context (either historical context such as the current situation in SQL 2000, or the context of real-world application usage). This book quickly and concisely explains why a feature is important, then proceeds to show how it works. The authors are careful not to become too concise when it comes to SQL terminology. Their trainer backgrounds probably tell them that many people don't know the formal names for things (especially users of Microsoft products who first learned things on-the-job with no help) so they are careful to define terms like aggregate functions and ACID when first used. Therefore, I think someone with little/no SQL experience will still be able to follow this book. Chapter 6 on security deserves a special mention for being accessible to a wide audience. If you're well-versed in SQL Server 2000, Windows, and .NET security, the reminders in this chapter are quick to review while discovering the 2005 improvements. If you're shamefully ignorant of current security issues, this chapter brings a lot together in only 35 pages.
On the other hand, if you are not already familiar with .NET, this book is not the place to start. There is an attempt in Appendix A to include a brief overview of .NET, but I seriously doubt it would be adequate for the stated audience: people "who haven't done any development at all using .NET."
Code fragments are intermixed with the text at the proper points, and they are just the right length to illustrate the point at hand. This book does not attempt to assemble a complete sample app as you go sequentially through the chapters, which makes it easier to jump around. Simple diagrams are used when needed. Some books use random screenshots and fancy charts just to break up the text and keep it from looking dense, but this book is readable without wasting space on fluff. There very few screenshots in the entire book, most of them in Appendix B which covers the GUI tools.
Based upon what I see in Amazon reviews of various .NET books and upon the fact that many .NET books go to the trouble of providing sample code in both C# and VB .NET, I gather that there are some VB .NET programmers who don't like books which use C# exclusively. If you're one of them, I urge you to give this book a chance, even though all the .NET example code is C#. The examples are short and so clearly written that you shouldn't have any trouble reading them.
The book is meant to cover Beta 2 as best it can, but the majority of the book had to be finalized in early May which you can tell from the sample PDF. Published copies were shipping several weeks before Microsoft built the actual Beta 2 release. Although the screenshots in Appendix B show "Beta 2" on the login dialog, the title bars still say "SQL Workbench" and a footnote acknowledges the discrepancy between the screenshots and the text which refers to SQL Server Management Studio. Luckily, the authors and early readers have been diligent about finding the things which need to be updated and corrected, so make sure to visit the book's web site. I expect relatively little of the book to be affected by Beta 3 and the site will probably cover whatever is.
While RTM remains many months away, this book is a good investment. It doesn't replace BOL, and other 2005 books will be coming out, but if you need a time-efficient way to get your arms around the CLR and XML capabilities of Beta 2, I recommend this book.A First Look at SQL Server 2005 for Developers Overview
Be the first to master SQL Server 2005's breakthrough database development capabilities

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview--accurate, comprehensive, and packed with examples.

A First Look at SQL Server 2005 for Developers starts where Microsoft's white papers and Web articles leave off, showing working developers how to take full advantage of Yukon's key innovations. It draws on exceptional cooperation from Microsoft's Yukon developers and the authors' hands-on access to Yukon since its earliest alpha releases.

You'll find practical explanations of Yukon's new data model, built-in .NET hosting, improved programmability, SQL-99 compliance, and much more. Virtually every key concept is illuminated via sample code tested with Microsoft's public beta.

Key coverage includes:

Yukon as .NET runtime host: enhancing security, reliability, and performance
Writing procedures, functions, and triggers in .NET languages
Leveraging powerful new enhancements to T-SQL
The XML data type and XML query languages
SQL Server 2005 as a Web Services platform
Client-side coding: ADO/ADO.NET enhancements, SQLXML, mapping, ObjectSpaces, and more
Using SQL Server 2005's built-in application server capabilities
Already committed to SQL Server 2005? Simply evaluating it? Looking to set yourself apart from other SQL Server developers? Whatever your goal, start right here--today.
0321180593B04152004

Want to learn more information about A First Look at SQL Server 2005 for Developers?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

SQL Server MVP Deep Dives Review

SQL Server MVP Deep Dives
Average Reviews:

(More customer reviews)
Are you looking to buy SQL Server MVP Deep Dives? Here is the right place to find the great deals. we can offer discounts of up to 90% on SQL Server MVP Deep Dives. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

SQL Server MVP Deep Dives ReviewI bought this book for full price at the SQL PASS conference in 2009 and I didn't even feel bad about paying full price because of the cause. After reading through a number of the chapters, I still don't feel bad for paying full price :-)
This book contains 59 golden nuggets. You name the topic and there is likely a white paper quality or beyond chapter for your interest. From Database Design, to development best practices to complex administrative or BI issues, it covers it.
I could not put the book down on my flights back and still have managed to find the time to leaf throw more. I will be suggesting all of the developers and system administrators (part reluctant DBA) purchase their own copy (primarily because I don't want to share my copy :-P) and get learning.
Some great approaches to common problems, some great forays into areas I have, unfortunately, not forced myself to get into (like Power Shell for my administrative tasks). I will be taking some of the tips, like the Tools database and Aaron Bertrand's version of a great utility script to easily show the important info on active tasks, and putting them to use as early as I find the time next week.
I am also going to force my SSIS developers to read Andy Leonard's chapter on Incremental loads and other SSIS chapters while re-reading Erin Welker's chapter on BI For the relational guy (that's me) a few times myself.
Every chapter is top quality and I really liked the in depth approach. This is a good reference to add to a library with some of the great internals books or in depth books on a single topic. Also nice knowing that these top notch MVPs, mostly all great speakers and authors, gave up their time and royalties to give to a worthy cause.SQL Server MVP Deep Dives Overview
This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you.

SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI.

Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit www.warchild.org for more information.


Want to learn more information about SQL Server MVP Deep Dives?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Review

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET
Average Reviews:

(More customer reviews)
Are you looking to buy Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET ReviewThis book contains much useful information on SQL Server 2005 T-SQL enhancements, but it regularly employs functions and constructs in its examples that are only explained in later passages. Specifically, when attempting to absorb a new concept by examining a code example, you must also contend with looking up items which have not yet been covered. This is a mild stumbling block but it hurts the flow of the book.
Also, the practice database (Asset5) did not attach properly (on my SQL Server 2005 STD edition install regarding appropriate permissions to modify objects) and the most direct workaround was: (1) To use the included, but unreferenced script to initialize the database and all its objects using a "new name" for the database (2) Attach the original database - Asset5 (3) Use the data import feature to populate the "new name" database tables (4) Drop the attached database Asset5 (5) Rename the "new name" database to Asset5. I did first attempt to modify the permissions associated with the login I was using - unsuccessfully...
By way of comparison I am using Oracle Press' "Oracle 9i The Complete Reference" by Koch and Loney as a standard of clarity and conceptual organization for PL-SQL. It is on this basis that I assign this book 3 stars, but admit that I have yet to discover a better book for advanced T-SQL topics. Please feel free to forward me better titles.
As an aside, Murach's SQL for SQL Server is the best introductory text I have found for T-SQL.
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET Overview
Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

Essential Skills for Database Professionals
Group and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic .NETImplement database access using ADO.NETCreate CLR user-defined functions and triggersImplement reliable debugging and error handling techniques and security measuresManage source code in a repository such as Visual SourceSafeCreate stored procedures for web search enginesUse system and extended stored procedures to interact with the SQL Server environment




Want to learn more information about Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Microsoft SQL Server 2005 Reporting Services Review

Microsoft SQL Server 2005 Reporting Services
Average Reviews:

(More customer reviews)
Are you looking to buy Microsoft SQL Server 2005 Reporting Services? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft SQL Server 2005 Reporting Services. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Microsoft SQL Server 2005 Reporting Services ReviewThis book delivers a solid understanding of Reporting Services derived from working through genuinely useful, real world examples preceded by clear technical overviews.
I am a BI consultant always learning new software technologies and as part of this work, read many instructional s/w books. From this standpoint I can state that this book shows great attention to detail (all of the examples actually work). It also incorporates a very useful feature "Task Notes" that further explains the implicit assumptions and underlying factors following each example. This shows that a great deal of care was taken to ensure that the reader is always on the same page as the writer.
This book is rare in its clarity, technical editing and delivery of concrete skills in return for the effort spent with it. Just keep off my turf when you acquire your skills! (;^ )
Microsoft SQL Server 2005 Reporting Services OverviewMicrosoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

Want to learn more information about Microsoft SQL Server 2005 Reporting Services?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Microsoft SQL Server 2008 Reporting Services Review

Microsoft SQL Server 2008 Reporting Services
Average Reviews:

(More customer reviews)
Are you looking to buy Microsoft SQL Server 2008 Reporting Services? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft SQL Server 2008 Reporting Services. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Microsoft SQL Server 2008 Reporting Services ReviewWhat a life saver!
I'm a software developer in a small shop and our biggest client is a large law firm with LOTS of data and users hungry for easy to read reports reflecting said data. None of us have much experience with SQL Reporting Services as most of our experience for reporting is in Crystal Reports.
I've heard of SSRS but until recently I didn't have much experience using it. Our client was in great need of a simple report so I went ahead and setup a report server and decided to give SSRS a whirl. Thankfully Business Intelligence Development Studio (BIDS) was easy for me to grasp as I am a C# developer and I was already in comfortable territory (BIDS is really just a reporting solution in Visual Studio afterall).
I was able to create their report in a very short time and the users were comfortable using the Report Manager Website. Of course what happened next is predictable to anyone that has been in a similar situation - I became "The Report Guy" - for better or worse.
Of course our client started demanding more and more reports - increasing in complexity. I only scratched the surface of what SSRS was capable of and during that time I thought a lot of their report specs may be impossible to realize using SSRS. I began to worry. They wanted graphs, complex groupings, drill down style reports... I needed someone to throw me a life raft. Thank you Brian for throwing me that raft!
This book saved me. Even though this book is rather big weighing in at over 860 pages (including index) it was a breeze to work through. Brian has a clean, easy to read writing style and he injects a bit of humor throughout. I thought this book was going to take forever to work through but because Brian is such a good Author it really became a page turner. This book is one of the easier books to absorb. This book starts very simple and increases in complexity. Parts of the book were so relevant to my business needs that it almost seemed like he was right there telling me how to write my reports!
If there was ever a book that may have really saved my job then this is it. I now don't mind being the "Report Guy" - I feel like I can tackle just about any report spec they throw at me - all thanks to Brian Larson.
If you need to learn about SSRS then I don't see how you can do much better then this book.Microsoft SQL Server 2008 Reporting Services OverviewThe Definitive Guide to Microsoft SQL Server 2008 Reporting Services
Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.

Install, configure, and customize SQL Server 2008 Reporting Services

Want to learn more information about Microsoft SQL Server 2008 Reporting Services?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

MDX Solutions: With Microsoft SQL Server Analysis Services Review

MDX Solutions: With Microsoft SQL Server Analysis Services
Average Reviews:

(More customer reviews)
Are you looking to buy MDX Solutions: With Microsoft SQL Server Analysis Services? Here is the right place to find the great deals. we can offer discounts of up to 90% on MDX Solutions: With Microsoft SQL Server Analysis Services. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

MDX Solutions: With Microsoft SQL Server Analysis Services ReviewLet us begin by acknowledging that MDX is a nontrivial topic. With SQL Server 2000 and Analysis Services, Microsoft is providing arguably the most powerful OLAP solution at perhaps the lowest price. But with power comes complexity. Much of this complexity is to be found in the OLAP query language: MDX. Developers will welcome any assistance in climbing this learning curve, and Spofford's book was quick to fill this gap.
This is a thick book, and it is not padded with screenshots of wizards. More than half of the book deals with the syntax and semantics of MDX. It provides a new OLAP sample database for those of us tired of playing with "Foodmart". There are also chapters on local cubes and client programming in ADO. The last quarter of the book is reference material. The MDX function and operator reference in Appendix A includes easily comprehended graphical explanations of function behaviors.
This is not a book geared towards administrators or end users or casual developers. Expect to sweat the details here and to do so from chapter 1. This is a book to read at your computer as you learn the power of MDX by running the examples queries. This author's experience is apparent in the examples, which demonstrate real-world OLAP use cases. Examples range from simple to sophisticated, so this book will useful to both intermediate and advanced MDX programmers.
One weakness of the book is that, since it was written prior to the final release of Analysis Services, there may be some inconsistencies. But the book's web site should post updates and corrections. Also, the book mentions but does not cover the XML for Analysis technology that was released by Microsoft last month (July). XML for Analysis allows SQL Server tables and cubes to be queried using SOAP and XML. Using the WebService Behavior, Internet Explorer can directly make MDX queries and present the results with HTML or graphically (see intrasight.com).
Since MDX has emerged as the defacto standard for OLAP query, all product developers and report developers will want to add this book to their library.
Chris Harrington Active Interface, Inc.MDX Solutions: With Microsoft SQL Server Analysis Services OverviewA hands-on tutorial on building and using multidimensional data warehousesThe SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques, such as optimization, cube design, and Pareto analysis. Finally, the appendices provide a handy reference guide that users can rely on.

Want to learn more information about MDX Solutions: With Microsoft SQL Server Analysis Services?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) Review

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
Average Reviews:

(More customer reviews)
Are you looking to buy MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)? Here is the right place to find the great deals. we can offer discounts of up to 90% on MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification). Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) ReviewTaking the test which this study guide is focus to is a very important step before give any content's feedback (i'm still preparing myself for the test) But i will give my 1st impression about the book anyway.
Pros:
Very well organized book. Chapters and content are divided in small chunks of information (lessons). For busy people (like me) or those which like to do self study at own pace this is a big aid.
I like the writing style also. Not boring, not too technical altought you should have a previous SQL 2000 background if you want to take full advantage of this book.
I did like chapter 11, the backup and restore processes. This is a must for every SQL admin. and it is well covered. The same for the Maintenance Plan and Job topics (Ch 14)
The 15% off in the test price is a good bonus. You should consider this if you're in a low budget. Cons or critics:
The test engine is an added value but... i don't know ... after taking a few custom tests ... i am not pretty sure about their content's difficulty. I mean, IMO, questions seems too easy for me. I've took a lot of Microsoft tests before (i'm MCSA) and i've never seen easy questions like these in most of them. You must read a lot and think well before mark an answer and i don't feel that when i'm taking this book's test engine. Do not misunderstand what i'm saying, a free Test Engine is a nice bonus, i just want to give a non parcial review. I'm a customer too and we must rely in good study sources to avoid test failures.
Chapter 5: just a brief T-SQL review; use a Sybex SQL 2000 Design book for better preparation or buy the Ben Forta book instead (ISBN: 0672325675), you won't regret and it will help you a lot.
Chapter 12: hey! what happened with the pics here? ... too much words and just a few pics for this topic. Fragmentation concepts are easier to understand when you see how they works; here's when drawings and pics enter into action.
Final comment.
Currently, this is the only book for this test in the market. Sybex and the others are still in press, so there are not much choices either but overall, is a good election anyway; easy to read and very well organized. Find a good PC or laptop, VMWARE or Virtual PC and that's all you need for your study track (SQL 2005 evaluation version is included)
Need extra info? Try SQL 2005 Stanek pocket book ...
UPDATED 7/26/2006:
I already have the new Sybex book for this test. And 'till now, what i've read so far ... i've not found it better than Solid's book. Some Sybex chapters are just a re impression of their old 70-228 book. I keep you informed ...
MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification) Overview
Exam Prep Guide

Ace your preparation for the skills measured by MCTS Exam 70-431-and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you've learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time.

Maximize your performance on the exam by learning to:

Install and configure SQL Server
Create tables and indexes, define columns, and implement constraints
Implement functions, stored procedures, and triggers by using Transact-SQL
Work with relational and XML data
Monitor, troubleshoot and tune queries
Maintain database availability with log shipping, database mirroring, and replication
Prepare a backup strategy and restore a database

Practice Tests

Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies.

Your training kit includes:

15% exam discount from Microsoft. Offer expires 12/31/10. Details inside.
Official self-paced study guide.
Practice tests with multiple, customizable testing options and a learning plan based on your results.
450 practice and review questions.
Case scenarios, practice exercises, and best practices.
180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
Fully searchable eBook.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


Want to learn more information about MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...