Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the
Intended for C# programmers, this guide explains how to interact with the SQL Server 2005 database using C# 2008, write queries in T-SQL, call stored procedures from C#, work with XML, build Windows F
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 per
Intended for SQL Server developers and administrators, this desk reference provides Transact-SQL solutions for modifying data, creating tables and indexes, performing calculations, executing stored pr
Beginning Oracle PL/SQL gets you started in using the built-in language that every Oracle developer and database administrator must know. Oracle Database is chock-full of built-in application features
Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up t
Create your first turn-based multiplayer game using GameMaker Studio 2’s built-in networking functions as well as using a simple NodeJS server. This book introduces you to the complexities of network
Provides a comprehensive overview of T-SQL and its new features offered in SQL Server 2005 and discusses a wide variety of practical applications, including SQL Server 2005 T-SQL recipes and their use
Build a core level of competency in SQL so you can recognize the parts of queries and write simple SQL statements. SQL knowledge is essential for anyone involved in programming, data science, and data
Master functions and discover how to write functional programs in R. In this concise book, you'll make your functions pure by avoiding side-effects; you’ll write functions that manipulate other functi
SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve com
A beginner's guide to SQL Server 2005 offers a detailed overview of the new features of the relational database program and describes the core jobs and roles involved in developing an SQL Server datab
Beginning Queries with SQL is a friendly and easily read guide to writing queries with the all-important — in the database world — SQL language. Anyone who does any work at all with databases needs to
MODEL clause, and advanced grouping syntax---features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing over
Provides an in-depth look at investigative processes for the iPhone, iPod touch, and iPad devices. Includes methods and procedures that will be admissible in any courtroom. This book is written for co
Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as
Creating 2D and 3D charts is one of the most common uses of computer graphics. Such charts can have wide applications in representing mathematical, physical, and economic functions in your daily life.
Aimed at web developers and designers who need to build e-commerce websites in the C# programming language, this manual provides detailed explanations of how ASP.NET and SQL servers can be used to cre
Features information on the new features and functions of the operating system, along with instruction in using the Aqua interface, customizing and administering Snow Leopard, connecting to the Intern
Teaches the tools one needs to create effective and highly tailored user interfaces and experiences in SharePoint 2010; master the core functions of sites, lists, content types and fields; build a sit
Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy for your database enterprise. This new edition covers threat analysis, common attacks and counte
Features information on the new features and functions of the operating system, along with instruction in using the Aqua interface, customizing and administering OS X Lion, connecting to the Internet,
Learn Lisp programming in a data structures context, including tables, functions, forms, expressions, typed-pointers, I/O, garbage collection and some applications. This short primer contains a carefu
To understand the various BI offerings in SharePoint 2010, you need to understand the core SQL Server BI concepts, and we spend the first part of the book with a comprehensive tutorial on those funda
Use Python's built-in features to create innovative graphics for data visualization and technical illustrations. This book goes beyond simple commands and libraries to explain how to not only display
Discover how a software engineer can leverage Docker in order to expedite development velocity. This book focuses on the fundamental concepts this program is built upon and explores how it can help yo
