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

By Robin Dewson

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

Reading this ebook is like being sat down with the bumbling place of work grunt who has simply been instructed to provide you an advent to a bit of unusual software program: he sits there pointing at whatever 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 not likely to inform you something in any respect simply because it isn't a beginner's subject, although he is simply been stating the entire buttons for it). consequently, you are on web page 119 prior to he will get round to displaying you the way to outline a desk, and you have got to attend until eventually web page 245 ahead of he starts off speaking approximately find out how to insert facts into it and practice decide upon queries! when you already be aware of anything approximately databases, this procedure is simply problematic and worsening; in case you do not (i.e. you are one of many newbies this booklet is geared toward) it is complicated to boot. there is not any aspect being informed the functionality of each button on a toolbar (he takes 100 phrases to inform us in regards to the Open, retailer and keep As buttons) or each choice in an strategies conversation, ahead of you will have visible uncomplicated queries in motion (e.g. he tells us that "Pressing this button brings up a conversation field to alter the values in every one of a template's parameters" good sooner than he indicates us queries, not to mention code templates!). in case you are going to establish a creation database, then after all you must learn about defense and management projects earlier than you achieve this, yet this can be purported to be a booklet for newbies (and newbie database builders, no longer directors, for that matter): it really is secure to imagine that they would learn via a great deal of stuff in a extra logical order and scan on a try out set up ahead of embarking on right work!

And here is a pattern of his convoluted writing a few beautiful basic suggestion (deciding no matter if to implement referential integrity on already latest facts whilst including a brand new courting among tables): "By growing the connection, you will want the knowledge in the dating to paintings, for this reason you'll decide upon No in case you have been going to return and fasten the knowledge after the additions. What in case you nonetheless omit rows? may this be an issue? In previous our state of affairs, there might be no transaction files with out shopper documents. yet you should still desire to upload the connection to prevent additional anomalies going forward." this is a few extra linguistic spaghetti: "However, while together with key column(s) from a clustered index in a nonclustered index, as the row pointer is de facto the clustered index key, SQL is sensible 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 ideas he is attempting to clarify, you could frequently make experience of these things (unless he contradicts himself within the area of some sentences, that is), yet it is a ebook purported to be geared toward novices and will current the information clearly.

If you must learn anything like this, i.e. with very little thought of how one can current crucial rules easily, fast and obviously with no distracting aspect, it's possible you'll besides store your funds and skim the Microsoft aid records (which are extra exact and higher written!). if you are going to spend cash, glance somewhere else.

Show description

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

Best database storage & design books

Implementing electronic document and record management systems

The worldwide shift towards supplying prone on-line calls for corporations to conform from utilizing conventional paper records and garage to extra smooth digital tools. There has even though been little or no details on simply the right way to navigate this change-until now. enforcing digital rfile and list administration platforms explains how you can successfully shop and entry digital files and documents in a way that permits speedy and effective entry to info so a company may possibly meet the wishes of its consumers.

Deductive Databases and Their Applications

An introductory textual content geared toward people with an undergraduate wisdom of database & details platforms describing the origins of deductive database in Prolog, & then is going directly to examine the most deductive database paradigm - the datalog version.

Learn SQL Server Administration in a Month of Lunches

Microsoft SQL Server is utilized by hundreds of thousands of companies, ranging in dimension from Fortune 500s to small retailers world wide. no matter if you are simply getting begun as a DBA, helping a SQL Server-driven program, or you have been drafted by means of your workplace because the SQL Server admin, you don't want a thousand-page booklet to wake up and working.

Spark: Big Data Cluster Computing in Production

Production-targeted Spark counsel with real-world use situations Spark: mammoth facts Cluster Computing in creation is going past normal Spark overviews to supply detailed suggestions towards utilizing lightning-fast big-data clustering in creation. Written through knowledgeable staff famous within the significant facts neighborhood, this ebook walks you thru the demanding situations in relocating from proof-of-concept or demo Spark purposes to stay Spark in construction.

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

Sample text

Insert the CD for the Microsoft SQL Server 2005 edition of your choice in your CD-ROM drive and start the installation. What the upcoming text covers is a standard installation. fm Page 7 Monday, January 2, 2006 2:57 PM CHAPTER 1 ■ SQL SERVER 2005 OVERVIEW AND INSTALLATION Preparing to Install First of all, ensure that you have logged on to your machine with administrative rights so that you are allowed to create files and folders on your machine, which is obviously required for installation to be successful.

All the editions of SQL Server, with the exception of the Windows Express and Mobile versions, require a minimum of 512MB of RAM onboard your computer. Many of the editions that could be used will run with this, although you shouldn’t have too many more applications open and running as they could easily not leave enough memory for SQL Server to run fast enough. Microsoft recommends 1GB or above, and really double that at least for when you start using your SQL Server in earnest. The Windows Express and the Mobile versions have a minimum of 128MB of RAM.

This figure shows I have connected to XP-PRO SQL Server using the Windows account XP-PRO\rdewson. Figure 2-3. fm Page 29 Monday, January 2, 2006 2:55 PM CHAPTER 2 ■ SQL SERVER MANAGEMENT STUDIO 5. The first area of SSMS we will look at is the Registered Servers Explorer. Access this explorer, shown in Figure 2-4, by selecting View ➤ Registered Servers or by pressing Ctrl+Alt+G. This area details all SQL Server servers that have been registered by you on this SSMS installation. At present, there will only be the server just registered.

Download PDF sample

Rated 4.02 of 5 – based on 13 votes