Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions By Itzik Ben-Gan
244 Pages | 2012 | ISBN: 0735658366 | EPUB + PDF | 21 MB
Apply powerful window functions in T-SQL—and increase the performance and speed of your queries
Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.
Das Programmierhandbuch SQL Server 2008
German | ISBN: 3836213958 | 2009 | 1149 pages | PDF | 56,4 MB
Our book is intended for all developers who want to use the new version of Microsoft's database. The focus is on integration of the. NET framework that enables programming with the. NET languages. From the initial database design and SQL basics, the migration of SQL Server 2000 to the new features and concrete programming examples, the authors describe everything necessary to the SQL Server 2005 to use as a programming platform and data management server. In the new edition, the book was updated and expanded to include many topics such as indexed views, partitioning of tables, etc. Event Notification in ADO.NET
Professional MySQL GUI admin tool with support all the latest MySQL 5.0 and 5.1 features such as views, procedures, triggers and table partitioning.The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more.
SQL Server MVP Deep Dives, Volume 2
Publisher: Man..ning Public..ations 2011 | 688 Pages | ISBN: 1617290475 | PDF | 21 MB
SQL Server MVP Deep Dives, Volume 2 lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more.
Professional Microsoft SQL Server 2012 Administration By Adam Jorgensen, Steven Wort, Ross LoForte, Brian Knight
960 Pages | 2012 | ISBN: 1118106881 | EPUB + PDF | 68 MB + 88 MB
An essential how-to guide for experienced DBAs on the most significant product release since 2005!
Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years.
Professional Microsoft SQL Server 2012 Integration Services By Brian Knight, Erik Veerman and more
960 Pages | 2012 | ISBN: 111810112X | EPUB + PDF | 51 MB + 72 MB
An in-depth look at the radical changes to the newest release of SISS
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL).
SQL in a Nutshell - 3rd Edition
English | PDF | 594 Pages | 51.38 Mb
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:
MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance By Erik Veerman, Teo Lachev, Dejan Sarka
640 Pages | 2009 | ISBN: 0735626367 | EPUB + PDF + CD | 14 MB + 16 MB + 49 MB
Ace your preparation for the skills measured by MCTS Exam 70-448—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Introducing Microsoft SQL Server 2012 By Ross Mistry, Stacia Misner
290 Pages | Publisher: Mic{ros}oft Pre-ss 2012 | ISBN: 073566515X | EPUB + PDF | 19 MB + 11 MB
Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management.
Michael Lee, Gentry Bieker "Mastering SQL Server 2008"
795 pages | Publisher: S--ex | 2009 | ISBN: 047028904X | PDF | 19 MB
As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.
Microsoft SQL Server 2012 Pocket Consultant By William R. Stanek
592 Pages | Publisher: Mi[cro]soft Pr[es]s 2012 | ISBN: 0735663769 | EPUB + PDF | 10 MB + 33 MB
Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!
Microsoft SQL Server 2012 Enterprise-KOPiE | 4.1 Gb
SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; Cloud On Your Own Terms by enabling the creation and extension of solutions across on-premises and public cloud.
PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
