SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
Apress | ISBN: 1590599802 | July 23, 2008 | 872 pages | PDF | 4.8MB
Product Description
SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
* Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
* Current: Newly updated for SQL Server 2008.
* Comprehensive: Covers 30 different Transact–SQL problem domains.
What you’ll learn
* Create databases, tables, and indexes.
* Query and manipulate data.
* Store and manage XML inside the database.
* Move business logic into the database.
* Encrypt data and capture changes for compliance purposes.
* Implement Full–Text Search.
* Interface with Service Broker.
* And more!
Who is this book for?
Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.
mirror
Robin Dewson, Julian Skinner, “Pro SQL Server 2005 Assemblies”
Apress | 2008 | ISBN: 1590595661 | 296 pages | PDF | 1,7 MB
Pro SQL Server 2005 Assemblies</i> provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.
Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they’re enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies&emdash;when they should and should not be used, what you can do with them, and how you can get the most out of them.
Grant Fritchey, Sajal Dam, “SQL Server 2008 Query Performance Tuning Distilled (Expert’s Voice in SQL Server)”
Apress | 2009 | ISBN: 1430219025 | 600 pages | PDF | 8,75 MB
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.
Emphasizes the practical. Does not bury readers in theory.
Gives readers practical techniques to immediately apply in their daily work.
Dedicates a chapter to each of the most common, performance–related problem areas.
What you’ll learn
Identify and fix poorly performing queries that are hurting your business.
Read query execution plans and identify bottlenecks in performance.
Record system performance metrics for trend analysis.
Learn to design databases and write Transact–SQL code to avoid common problems.
Understand what an index is, what it does, and how to build one.
Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance.
MySQL (2nd Edition) (Developer’s Library)
Publisher: Sams | ISBN: 0735712123 | edition 2003 | CHM | 1248 pages | 1,9 mb
| “ |
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn’t “free” about MySQL (the application) is its server’s commercial use; all clients and noncommercial server use are free. DuBois’s tome isn’t free either, but its list price is modest in light of its value and the value of its namesake.
The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)
The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces.
Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.
Although it is nearly 800 pages in length, DuBois’s book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application. |
” |
Depositfiles
Megaupload
七月 14th, 2009 in
Database/SQL | tags:
mysql |
No Comments
Rick F. van der Lans, ?SQL for MySQL Developers: A Comprehensive Tutorial and Reference?
Addison Wesley | ISBN: 0131497359 | 2007 | PDF | 1032 pages | 4.75 MB
| “ |
MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs.
|
” |
download
mirror
七月 14th, 2009 in
Database/SQL | tags:
mysql,
sql |
No Comments
