Beginning SQL Server 2005 for Developers: From Novice to by Robin Dewson

By Robin Dewson

This fairly is among the worst computing books i have ever learn: it's totally badly established, poorly written and never too scorching at the evidence either.

Reading this publication is like being sat down with the bumbling place of work grunt who has simply been advised to provide you an creation to a section of strange software program: he sits there pointing at something and every thing he sees, as he sees it, telling you heaps of inconsequential aspect and asserting that he will inform you extra later (or that he is unlikely to inform you something in any respect simply because it isn't a beginner's subject, even if he is simply been declaring all of the buttons for it). consequently, you are on web page 119 ahead of he will get round to displaying you ways to outline a desk, and you've got to attend until eventually web page 245 ahead of he starts off conversing approximately tips to insert facts into it and practice decide on queries! when you already be aware of whatever approximately databases, this technique is simply difficult and aggravating; in the event you do not (i.e. you are one of many newbies this publication is geared toward) it really is complicated besides. there isn't any aspect being informed the functionality of each button on a toolbar (he takes 100 phrases to inform us in regards to the Open, store and keep As buttons) or each alternative in an strategies conversation, earlier than you've gotten noticeable uncomplicated queries in motion (e.g. he tells us that "Pressing this button brings up a conversation field to alter the values in each one of a template's parameters" good earlier than he exhibits us queries, not to mention code templates!). if you are going to establish a creation database, then in fact you must learn about defense and management projects prior to you accomplish that, yet this can be alleged to be a publication for newcomers (and newbie database builders, now not directors, for that matter): it truly is secure to imagine that they might learn via a substantial amount of stuff in a extra logical order and scan on a try out install ahead of embarking on right work!

And here is a pattern of his convoluted writing a few lovely uncomplicated idea (deciding even if to implement referential integrity on already current info whilst including a brand new dating among tables): "By developing the connection, you will have the knowledge in the dating to paintings, accordingly you are going to pick out No for those who have been going to return and fasten the information after the additions. What in case you nonetheless pass over rows? might this be an issue? In previous our state of affairs, there can be no transaction files with no patron files. yet you should still desire to upload the connection to forestall extra anomalies going forward." this is a few extra linguistic spaghetti: "However, whilst together with key column(s) from a clustered index in a nonclustered index, as the row pointer is admittedly the clustered index key, SQL makes sense adequate to not shop the data two times within the nonclustered index, and you may explicitly outline the order of the clustered index keys as they're utilized in the nonclustered index." in case you already comprehend the thoughts he is attempting to clarify, you could often make feel of these things (unless he contradicts himself within the area of some sentences, that is), yet it is a publication alleged to be aimed toward newbies and may current the guidelines clearly.

If you must learn whatever like this, i.e. with very little considered the way to current crucial principles easily, speedy and obviously with no distracting element, chances are you'll in addition shop your funds and skim the Microsoft support documents (which are extra actual and higher written!). if you are going to spend cash, glance in different places.

Show description

Read Online or Download Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice) PDF

Similar database storage & design books

Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours

Written with readability and a down-to-earth technique, Sams educate your self SQL Server 2005 convey in 24 Hours covers the fundamentals of Microsoft's most up-to-date model of SQL Server. specialist writer Alison Balter takes you from easy recommendations to an intermediate point in 24 one-hour classes. you'll research all the easy initiatives priceless for the management of SQL Server 2005.

Microsoft sql server 2008 integration services problem-design-solution

This publication is a treasury for ETL builders / architects. it's very varied from different ETL books within the method that it's written with a top-to-bottom method rather than targeting info of an ETL software. every one bankruptcy provides an issue that an ETL developer/architect will face in the course of a true venture.

Database Programming with JDBC and Java

Java and databases make a strong mixture. Getting the 2 aspects to interact, besides the fact that, takes a few effort--largely simply because Java bargains in gadgets whereas so much databases don't. This ebook describes the normal Java interfaces that make transportable object-oriented entry to relational databases attainable and gives a strong version for writing purposes which are effortless to keep up.

Learn SQL Server Administration in a Month of Lunches

Microsoft SQL Server is utilized by thousands of companies, ranging in measurement from Fortune 500s to small retailers around the globe. no matter if you are simply getting all started as a DBA, helping a SQL Server-driven software, or you have been drafted via your place of work because the SQL Server admin, you don't want a thousand-page e-book to wake up and working.

Extra resources for Beginning SQL Server 2005 for Developers: From Novice to Professional (Expert's Voice)

Example text

Fm Page 39 Monday, January 2, 2006 2:55 PM CHAPTER 2 ■ SQL SERVER MANAGEMENT STUDIO • Show Visual Glyphs: Enabled when word wrap is checked. Shows text glyphs when a line has been word wrapped. This is a logical character that doesn’t physically exist, and therefore will not appear on any printouts. • Apply Cut or Copy Commands to Blank Lines: If this is checked, and you “copy” a blank line, a blank line will be pasted. If this is unchecked, nothing is inserted. • Line Numbers: Displays line numbers only against the code.

Hard disk space is cheap as well, and it is better to buy one disk too large for your needs than have one hard drive that suits now, and then have |to buy another later, with all the attendant problems of moving information to clear up space on the original drive. Again, you will need spare space on the drive for the expansion of SQL Server and the databases, as well as room for temporary files that you will also need in your development process. So think big—big is beautiful! Operating System Requirements You will find that SQL Server 2005 will run on Windows 2000 Professional Edition and above with Service Pack 4, or all editions of Windows XP Service Pack 2 or above.

Exe, found at the root level of the CD-ROM. You are now presented with the installation screen for the Microsoft SQL Server 2005 edition of your choice, as shown in Figure 1-1. After you accept the SQL Server End User Agreement, SQL Server then installs some support files prior to set up. These files are part of SQL Server that will be included in service packs and form part of the installation process. NET Framework version if it is not already installed. Figure 1-1. NET, C#, and other programming languages to have as a common compile set for computers.

Download PDF sample

Rated 4.29 of 5 – based on 13 votes