» » Microsoft SQL Server 2008 Step by Step (Step by Step Developer)

Free eBook Microsoft SQL Server 2008 Step by Step (Step by Step Developer) download

by Mike Hotek

Free eBook Microsoft SQL Server 2008 Step by Step (Step by Step Developer) download ISBN: 0735626049
Author: Mike Hotek
Publisher: Microsoft Press; 1 edition (November 22, 2008)
Language: English
Pages: 544
Category: Technologies and Future
Subcategory: Operating Systems
Size MP3: 1831 mb
Size FLAC: 1581 mb
Rating: 4.6
Format: lit azw mbr doc

Teach yourself SQL Server 2008-one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications.

Teach yourself SQL Server 2008-one step at a time.

Whether you're a report developer, IT administrator, or business user, this sequential, learn-by-doing tutorial shows you how to deliver the business intelligence information your organization needs.

Whether you’re a report developer. Condition: Used: Acceptable.

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence-one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Create tables and index structures. Manipulate and retrieve data.

Teach yourself how to design and create SQL Server 2008 databases one step at a time. Next, you ll learn techniques to manipulate, maintain, and retrieve data. Finally, you ll learn more-advanced techniques, such as using views, functions, and triggers.

Microsoft SQL Server 2008 book. Goodreads helps you keep track of books you want to read. Start by marking Microsoft SQL Server 2008: Step by Step as Want to Read: Want to Read savin. ant to Read. Teach yourself SQL Server 2008-one step at a time  .

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step. Contained Items Statement. Contains 1 Paperback and 1 CD-Rom. Country of Publication.

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence tools—Reporting, Analysis, and Integration Services CD features: Practice exercises and code samples Fully searchable eBook

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

User reviews
This book is meant to follow examples step-by-step, which means the sample databases have to be installed first. The instruction tells you to take the CD, and install two samples. It goes in great detail explaining that C:drive letter may need to be changed to D: (repeated 4 times), but it does not give you a slightest hint that different processes of SQL Server use different autentication regardless of your login name, and you need to give these permissions to the sample source files.
After spending several hours googling and experimenting, I got thru with permissions; fixed the problem with the log file (the only one mentioned on-line for book support), managed to load the first database, and got stuck with all kind of error messages loading the analysis services database.
Without the source code the only option was to send an email to Microsoft Support team. All I got back is auto-reply, so instead of studying the new language I spend days waiting.
Unless you are a SQL Server DBA who loves debugging for fun, pick something else.
I just completed a different MS SQL Server 2008 book, and am now wishing that I would have read this first, basically because the author, Hotek, is so much more concise and is defining terms as he goes, and is clearer when describing database concepts. So now I am forced to read this book too, just to clear up what was confusing in the first book!

What this book has that the *other* didn't is a really organized approach to MS SQL Server, including a description of all the tools that come with it and a meaty section on Business Intelligence with chapters on SQL Server Integration, Reporting and Analysis Services, which is the reason I bought this book originally.

As a side note, Mr. Hotek also obviously has a lot of experience and is sane... in Chapter 5, he gives an opinion on database design that I have secretly thought for years and I can't believe he said this:
"...Lost in all of this material is the simple fact that tables have to be created to support an application and the people creating the tables have more important things to worry about than which normal form a database is in or if they remembered to build a logical model and render a physical model from the logical model."

That totally floored me and impressed me. I have read many books where the author is so freaked out about 1st, 2nd and 3rd normal form, that it made me completely cross-eyed. It is the application and the basic design of the database, and what the users need that is what's important... not worrying about conforming to some theoretical utopia. I'm not saying we should build tables full of redundant data - obviously not - but let's stay focused on the task at hand.

Anyway, I would say this is not a book for beginning programmers, but it is a great book for beginning MS SQL server developers.

I recommended in my review of the *other* MS SQL Server 2008 book that you should get more than one book on any technical subject to help fill in the gaps, and hopefully one book can explain concepts that the other can't... I still stand by that.
If you are a beginner to intermediate MDX person, then I can't think of any better book on the subject. Don't let the "step-by-step" label misguide you into believing this book is only for the beginners. This book covers from the simple to the complex MDX queries.

The book deals from the very basic "Select { } on columns, { } on rows from [Cube]" to using Expressions, Aggregation, and navigating the hierarchies. You will learn to use all MDX keywords, functions, and syntax structures.

I would not recommend this book as a first book on SQL BI (I like Brian Larson's "Delivering Business Intelligence"). Rather, this book should be an important supplement to anyone's SQL BI knowledge. Although SQL 2008 provides a handy GUI to build a MDX queries on an existing cube, it is not a good substitute for complex MDX queries. Trust me, when the pressure is on, and the senior management wants to get key information in a hurry, understanding MDX well can save you a lot of stress and reduce the blame game so prevalent in IT.

If you are never going to use MDX, I would question the need to build and process Cubes (also called Data Mart) all together. If you have a solidly designed Data Warehouse and a well functioning ETL process, you can just query the DW using SQL for most of the information you would need. But MDX releases the potential of the Cube and makes the entire SQL BI, and the Cube in particular, far more valuable and usable.

MDX is used across multiple Business Intelligence platforms. Even if you do not plan to exclusively use SQL BI, this book will help you to understand MDX that you can apply to, let's say, Microstrategy and SAS.

This book also comes with a CD that provides sample SQL BI Development Project and a corresponding Data Warehouse database.

If you want a well written, highly structured, and clear explanations of MDX from simple to complex, then this book is the right book for you.
I bought the book to try and get up to speed with SQL and expected more. The book describes summaries of what is supposed to happen with the code, but then just has you copy and paste the code without further explaining the code after the fact. Some of the code is incorrect, but easy to figure out the mistake and correct if you're already familiar with sql. I would not recommend for a beginner.
Old but good
This book was a pleasant surprise, I was looking for an introduction to SQL Server and this book was exactly that. The chapters were all in manageable sizes with the right amount of detail and exercises (%95+ worked as expected) to reinforce the topic. I don't usually write reviews, but if you are looking like I was for a book provide a basic introduction to SQL Server 2008 I would recommend this one. As a bonus there script which the author says can be used in production to perform backups.