SQL Books
-
SQL Wait Stats Joes 2 Pros: SQL Performance Tuning Techniques Using Wait Statistics, Types & Queues
Published 9 years ago
by Pinal Dave, Rick Morelan, CreateSpace
You learn a lot when thrown into a crisis situation, where everyone is looking to you for answers. The system is down, the CEO is pleading to you for answers as the each minute cuts the company’s bottom line. When you are in a hurry, you need some new ideas right away. This book is your helpful tool. When used correctly, you can determine solutions and even related solutions to simple (yet lesser known) areas of SQL Server. Learn what causes SQL tasks to wait or site in queues.
-
Thor's Microsoft Security Bible: A Collection of Practical Security Techniques
Published 9 years ago
by Timothy Thor Mullen, Syngress
Thor's Microsoft® Security Bible provides a "one-stop-shop" for Microsoft-related security techniques and procedures as applied to the typical deployment of a Microsoft-based infrastructure. The book contains detailed security concepts and methodologies described at every level: Server, Client, Organizational Structure, Platform-specific security options, application specific security (IIS, SQL, Active Directory, etc.
-
Microsoft Windows Azure Development Cookbook
Published 9 years ago
by Neil Mackenzie, Packt Publishing
This cookbook offers practical, immediately usable task-based recipes covering a wide range of advanced development techniques for building highly scalable cloud-based services on the Windows Azure platform. It shows you how to improve these services and how to solve particular problems/scenarios when developing them on the Windows Azure platform.
-
Expert Oracle GoldenGate
Published 9 years ago
by Ben Prusinski, Steve Phillips, Richard Chung, Apress
Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server.
-
Oracle Database 11g Building Oracle XML DB Applications (Osborne ORACLE Press Series)
Published 9 years ago
by Jinyu Wang, McGraw-Hill Osborne Media
Master the XML Programming Features in Oracle Database 11gDevelop, debug, and administer data-backed XML applications using the expert instruction and best practices in this Oracle Press guide. Oracle Database 11g: Building Oracle XML DB Applications discusses the latest development tools, technologies, and components. Find out how to set up Oracle XML Database (Oracle XML DB), build XML applications in Oracle JDeveloper 11g, work with XSLT stylesheets, and incorporate full-text search.
-
SQL Programming Joes 2 Pros: Programming & Development for Microsoft SQL Server 2008 (SQL Exam Prep Series 70-433 Volume
Published 9 years ago
by Rick A. Morelan, CreateSpace
The SQL developer needs to be able to create processes for the working database by using one of the many programming objects (like functions, stored procedures, constrains, or triggers). By creating objects that talk with SQL you simply the way other programs (like applications or web pages) can interconnect. These eternal programs only need to call on the names of your programming objects by name rather than needing to submit large pieces of advance code.
-
Expert Oracle Application Express
Published 9 years ago
by Dietmar Aust, Martin Giffy DSouza, Doug Gault, Dimitri Gielis, Roel Hartman, Michael Hichwa, Sharon Kennedy, Denes Kubicek, Raj Mattamal, Dan McGhan, Francis Mignault, Anton Nielsen, John Scott, Apress
Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database.
-
Pro Access 2010 Development
Published 9 years ago
by Mark Collins, Apress
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.
-
Windows PowerShell in Action, Second Edition
Published 9 years ago
by Bruce Payette, Manning Publications
Windows PowerShell transformed the way administrators and developers interact with Windows, allowing them to script administrative tasks and control Windows from the command line. It's now a daily timesaver for anyone working with Windows Server, Exchange Server, SQL Server, and other mission-critical tools.
-
Microsoft Dynamics GP 2010 Reporting
Published 9 years ago
by Christopher Liley, David Duncan, Packt Publishing
Part tutorial, part reference guide, this book will show you how to create and manage reports as well as identify the most appropriate reporting tool for any reporting challenge. In addition, you will learn universal topics such as how to locate data for any given report. Although some of the reporting tools addressed in this book are exclusive to Dynamics GP 2010, many of the topics discussed also apply to older versions of GP.