Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Wednesday, March 30, 2011

SQL Server MVP Deep Dives



SQL Server MVP Deep Dives
| 2009-12-13 00:00:00 | | 0 | SQL Server


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.



Download this book!

Free Ebooks Download

Tuesday, March 8, 2011

Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer)



Professional Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer)
| 2009-04-27 00:00:00 | | 0 | SQL Server


Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.

User review



User review



User review



User review



User review



User review



User review



User review



User review




Download this book!

Free Ebooks Download

Tuesday, January 11, 2011

LINQ Unleashed: for C# (Unleashed)



LINQ Unleashed: for C# (Unleashed)
| 2008-07-24 00:00:00 | | 0 | SQL Server


Foreword by Darryl Hogan, Architect Evangelist, Microsoft Corporation

 

Microsoft?s highly anticipated LINQ query technology makes it easy to retrieve any information programmatically from any data source, no matter where it comes from or how it?s stored. Using LINQ, developers can query objects, relational databases, XML documents, and ADO.NET datasets--and do it all directly from C# 3.0, leveraging the powerful capabilities of LINQ.

 

This is a definitive guide to getting real-world results with LINQ, using C# 3.0 and Visual Studio 2008. In LINQ Unleashed, Microsoft MVP Paul Kimmel covers every facet of LINQ programming, showing how LINQ can help you dramatically improve your productivity and build more reliable, maintainable applications.

 

Kimmel begins by reviewing the state-of-the-art C# programming techniques LINQ uses, including anonymous types, partial methods, and Lambda expressions. Next, using realistic examples and easy-to-adapt sample code, he details the most powerful new LINQ techniques for accessing objects, databases, and XML. You?ll gain a deep and practical understanding of how LINQ works ?under the hood?--and learn how to do everything from selecting data through integrating XML with other data models.

 

Build efficient LINQ queries to .NET objects, SQL databases, and XML content Utilize anonymous types to reduce design time, coding effort, and debugging time Automatically generate .NET state machines with the new yield return construct Master LINQ query syntax, operators, extension methods, sorting, grouping, aggregate and set operations, and more Make the most of select--and use it in the business layer of your n-tier applications Query relational data stored in Microsoft SQL Server Use nullable types to eliminate unnecessary database access plumbing code Use LINQ with ADO.NET 3.0 and Microsoft?s powerful new Entity Framework Extract XML data without the hassles or complexity of XPath Automatically construct XML from CSV files and other non-XML data Query Active Directory by extending LINQ

Introduction  1

Part I     Getting Ready for LINQ

       1     Programming with Anonymous Types 5

       2     Using Compound Type Initialization  29

       3     Defining Extension and Partial Methods  61

       4     yield return: Using .NET?s State Machine Generator  85

       5     Understanding Lambda Expressions and Closures  97

       6     Using Standard Query Operators  121

Part II    LINQ for Objects

       7     Sorting and Grouping Queries 137

       8     Using Aggregate Operations 151

       9     Performing Set Operations  167

       10   Mastering Select and SelectMany  185

       11   Joining Query Results  211

       12   Querying Outlook and Active Directory  239

Part III   LINQ for Data

       13   Querying Relational Data with LINQ 265

       14   Creating Better Entities and Mapping Inheritance and Aggregation  289

       15   Joining Database Tables with LINQ Queries  309

       16   Updating Anonymous Relational Data  349

       17   Introducing ADO.NET 3.0 and the Entity Framework  383

Part IV  LINQ for XML

       18   Extracting Data from XML 415

       19   Comparing LINQ to XML with Other XML Technologies  437

       20   Constructing XML from Non-XML Data  453

       21   Emitting XML with the XmlWriter  463

       22   Combining XML with Other Data Models  469

       23   LINQ to XSD Supports Typed XML Programming  485

Index



User review
rambling - not really instructive
I question the value of the previous reviews. The review of Sept. 18 does not convince me the reviewer ever read the book.


The book starts off decently with an introduction to concepts related to LINQ. Then it falls off sharply when the author attempts to explain key words and the underlying logic of LINQ queries.


The table of contents has to be taken as a statement of intent. The chapters on LINQ for Objects are disappointing -- bulky examples without much analysis or explanation of LINQ syntax.


It all gets a bit rambling as the author, or editor if there was one, loses sight of the goal, which should be to instruct.


I give it 4 stars because it is no worse than some other books I've read.




User review
Awesome LINQ For C# Textbook
I purhased that book a couple weeks ago, and man, I love it so much. The author has done an execellent job in explaining the subject. If you really serious about learning Microsoft Language Integrated Query (LINQ), I highly recommend that you buy that book and let the journey begins.

User review
Linq
I higly recommend this book. It is easy to read and keeps you interested.

It is the first book that tries to describe the Entity Framework in one of its chapters.

The author gives a thorough description of hundreds of ways to make a select statement. Update, insert, and delete are described in very few paragraphs which seems a little bit thin.

User review
Check out the not so mundane examples and the LINQ to XML chapters
One of the author's stated goals for this book was to make learning LINQ interesting. I believe he succeeded. Whenever he had a chance to use less mundane examples to illustrate LINQ applications, he did so. This is also the first published book on LINQ that had interesting chapters on LINQ to XML.


Download this book!

Free Ebooks Download

Saturday, December 25, 2010

Microsoft SQL Server 2000 Weekend Crash Course



Microsoft SQL Server 2000 Weekend Crash Course
| 2001-10-01 00:00:00 | | 509 | SQL Server


Microsoft SQL Server 2000 Weekend Crash Course includes 30 sessions on the key aspects of Microsoft SQL Server 2000. Each session is designed to take 30 minutes to complete, so the Crash Course is an intense 15-hour learning period. You can complete the Crash Course over a weekend -- but you can also easily adapt the Crash Course sessions to whatever schedule best suits your needs.

User review
Great and easy to understand
If you just starting out or need to refresh your memory -- this is the book.

Recomend it together with Beginning SQL Server 2005 Programming by Robert Vieira (WROX)

User review
All content removed from CD, only SQL server remains
I bought this book because it advertised that examples and code were on the included CD. Wiley (current publisher)has apparently removed the content without removing the promise of content in the book, on the cover, or in the advertising. I tried to contact Wiley and the author, but got no response from either. Lack of promised content makes this book useless as a weekend crash course.

User review
Hope this author never works on my Database -
Admittedly I do have a fair amount of programming skills. Albeit not specifically in SQL server, but enough to understand most programming syntax and business logic. By page 83 where the author finally begins his first programming lesson he has his first typographical error. A typo in a line of program code is like a surgeon saying, `oh darn` during open-heart surgery. A typo present in an example line of program code for a student is disastrous. As I said I do have prior programming language experience so it might be a bit easier for me than most who purchase this `piece of work` book to correct the authors mistakes. I can only imagine the frustration a novice will have when they type in WORD FOR WORD the example program and receive nothing but error messages.


In all fairness I have not finished the book. In fact I gave up on his book half way though. I did go back and count the corrections I penciled in over his program errors, both in Syntax and Logic, to discover 16 blatant errors by page 132.


One thing ever programmer knows is that we test and retest our code before release into a production environment. I would expect the same of an author of technical manuals. Like I said, `Hope this author never works on my Database`.



User review
Great book for beginners! Covers good topics Concisely!
This book ideal for:

1) Those who do not know SQL at all.

2) Those who knows SQL little but want to learn more but quick and easy way.

3) Those who do want to know what SQL can do can not do.


This book is highly recommended. It teaches you quickly and easily. This book do not claim that they will make you mater in two days but they do teach you everything they can and quick and easy way. This book does provide some good references and covers all the quick points about SQL. I have really read this book in weekend and I learn myself from the point where this books ends.


Pinal Dave (Macromedia Certified Advanced ColdFusion MX Developer)

User review
Lives up to its promise
Lives up to its promise: introduction ito MSSQL Server, no less, no more.

I moved from Oracle and was somehow confused by the `database`, `filegroups` etc.

I've got my answers here (and from couple more titles, to be sure)

I neither had problems with instalation, nor with running the examples (save for one: the

chapter on cursor sports keyword DEALLOCATED, has to be - DEALLOCATE; had to check BOL on that)

The Transact-SQL examples could be better (I know PL/SQL, so I had some base here), but again

the book does not claim to teach T-SQL,,

The code snippets sometime seem to be taken out of the contexts of bigger procedures, and

I had to figure out how to fit them in; the usp_FindFactorial example seems too complex for

the task it solves (it uses intermediate table to accumulate results

instead of calling itself recursively; should it then be a function?),

but my understanding is that the elegancy was sacrificed to cram in more techniques than requred.

My examples did run correctly, though

After I was through with the book, I had to buy an additional one on Transact-SQL

(IMHO: O'Reily's book Transact-SQL Programming did NOT live up to my expectattions

and the publisher's reputation; I used Sam's T-SQl in 21 days, and then Ken Henderson's book)

To sum up: if you are new to SQL server, and find yourself

somewhat overwhelmed by the Books-On-line style

(comes free with every MSSQL Server installation), get this book

NB: better download new installation from microsoft site; the one included with the book does not have latest security patches)




Download this book!

Free Ebooks Download

Tuesday, December 21, 2010

SQL Server Security Distilled, Second Edition



SQL Server Security Distilled, Second Edition
| 1969-12-31 00:00:00 | | 0 | SQL Server


SQL Server is the dominant relational database in the Windows market and data security is a huge and growing concern for all businesses. Securing SQL Server is one of the most important responsibilities of the SQL Server professional.

SQL Server Distilled, Second Edition is a very carefully researched, clearly explained book on securing SQL Server, by an author who knows SQL Server inside and out. If you follow the practical guidelines that are clearly set out in this book, then you stand a very good chance of making sure that the data stored in your database is secure and that the conversation between your applications and the database is secure (preventing SQL injection attacks, etc.). For example, any DBA who implemented the security precautions detailed in the book would not have been affected by the infamous Slammer virus.

This second edition offers practical advice on how to implement good practices that will ward off future viruses before they are even created, and it contains new content that reflects all updates to SQL Server's security mechanisms.



User review
Very good book, i wish there is one book for 2005
It is good book for 6.5, 7.0 and 2000. But it does not cover 2005 i think manily because it is old publication.


Still reading some more chapter, after that i will review my review!

User review
A holistic approach to security
If you are responsible for a SQL Server database, can you afford not to think about security? Of course not. And this book definitely puts you on the right track. It offers a great great and encompassing view of the issues we as IT professionals face when it comes to SQL Server Security. It's not the same old best practices, rather it explains the why's behind the how's.

User review
Good book, but nothing extraordinary
This is a good book on security and covers most of the SQL security issues. It even goes in depth in describing the SQL security at the network layer. But if you already know that you should use Windows authentication, not use SA or other SQL accounts, stay away from port 1433, and regularly update SQL security patches, then you probably won't benefit substantially by reading this book. Nevertheless, it provides a comprehensive review of the SQL security.

User review
A Note from the Author
I spent just under 2 years doing the research for this book. In terms of breadth of coverage, there is no better book on the market. Rather than searching Microsoft's mammoth site for articles and white papers, everything you need to understand SQL Server security from version 6.5 to 2000 is in one book.

This book also goes deeper than the basic introduction to the various security mechanisms. Many books will tell you what SQL Server offers, but very few provide detailed information on *how* and *why* it works the way it does. Each chapter provides insights into the inner workings of SQL Server's security architecture and provides practical advice on how to use that information to keep your systems safe.

There are some other books that focus on showing you `hackers' tricks` for attacking your database servers, but this book takes the premise that if you do things the right way from the beginning, no hacker is ever going to find a trick that works on your systems. As an example, this book recommended configuring firewalls to block the traffic used by the Spammer virus long before the virus became news. Those who read this book and followed its advice slept soundly the weekend that Spammer was taking the Internet down.

Since the future of Curlingstone is in doubt, support for the book has moved to www.,.,,,com, and the author is not only committed to maintaining the current work but also planning to release an interim update in electronic format in the fall covering changes in SQL Server 2000 Service Pack 3 and any new discoveries found since December, 2002. The author also plans to release additional chapters on Yukon early next year for early adopters. This book is alive and will be updated periodically to keep its readers safe from the bad guys.

User review
Excellent Security Reference
I've been working with SQL Server for 11 years and run SQL Server Central.

And I learned a bunch from this book. This is one of the best references on SQL Server Security that I have seen written and I recommend it highly to every SQL Server DBA.

The book is written to cover versions 6.5, 7.0, and 2000. And it does a great job with each. It starts by looking at the way that logins are authenticated by the server. Great detail is given, even to the point of examining network sniffer traces to show how the communication occurs between the client and server.

From there, the database security is examined with separate chapters for v6.5 and 7/2000 since they work differently. Not only is the process explained, but the author notes where there are bugs and unforseen consequences of assigning security in certain ways.

The early chapters provide insight into how security works in SQL Server. The later chapters build on this to give hints and suggestions for implementing security in your applications, DTS, replication, and even SQL Server CE.

Overall, this is a must read for SQL Server DBAs. Developers will benefit as well since a thorough understanding can solve a great many problems and prevent even more.


Download this book!

Free Ebooks Download