SQL Server

One of the most popular database systems, Microsoft SQL Server 2019 Express, is presented and implemented in the book with over 40 real projects. This undergraduate textbook covers fundamental and advanced database programming techniques, which students learn by programming a database for both the web and desktop.

Paperback

Business Intelligence (BI) has emerged as a field which seeks to support managers in decision-making. It encompasses the techniques, methods and tools for conducting analytically-based IT solutions, which are referred to as OLAP (OnLine Analytical Processing). Within this field, SQL has a role as a leader and is continuously evolving to cover both transactional and analytical data management. This book discusses the functions provided by Microsoft® SQL Server 2014/2016 in terms of business intelligence. The analytic functions are considered as an enrichment of the SQL language. They combine a series of practical functions to answer complex analysis requests with all the simplicity, elegance and acquired performance of the SQL language. Drawing on the wide experience of the author in teaching and research, as well as insights from contacts in the industry, this book focuses on the issues and difficulties faced by academics (students and teachers) and professionals engaged in data analysis with the SQL Server 2014/2016 database management system.

Paperback

Paperback

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.<BR><BR>Essential Microsoft® SQL Server® 2017 installation, configuration, and management techniques for Linux<BR>Foreword by Kalen Delaney, Microsoft SQL Server MVP<BR>This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. The book offers clear instruction on adaptive query processing, automatic tuning, disaster recovery, security, and much more.<BR>¿Understand how SQL Server 2017 on Linux works¿Install and configure SQL Server on Linux¿Run SQL Server on Docker containers¿Learn Linux Administration¿Troubleshoot and tune query performance in SQL Server¿Learn what is new in SQL Server 2017¿Work with adaptive query processing and automatic tuning techniques¿Implement high availability and disaster recovery for SQL Server on Linux¿Learn the security features available in SQL Server<BR><BR>

The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered.In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.

Paperback

Few software developers would build an application without using source control, but its adoption for databases has been slower. Yet without source control to maintain the scripts necessary to create our database objects, load lookup data, and take other actions, we cannot guarantee a reliable and repeatable database deployment process, let alone coordinate database upgrades with changes to the application. We also run the risk that our "ad hoc" database patching will cause inconsistencies and data loss. Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started. It provides 'just enough' detail about the core components of a source control system and how to incorporate that system into the database development and deployment processes, covering: - Database Source Control architecture - what to include, how to structure the components - Collaborative editing - teamwork on a database project, while minimizing change conflicts and data loss. - Change auditing - what changed between versions and who changed it? - Branching -work independently on separate features and control what to deploy and when - Merging - what happens if one user changes a column name while another updates its data type? A merge operation lets the team decide the correct outcome - Building and Deploying databases - building new databases and upgrading existing ones from source control Every chapter follows the same "half-theory, half practice" template, so you learn the concepts then see how they work.

CDROM

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.- Provides practical and proven solutions towards creating resilient ETL environments - Clearly answers the tough questions which professionals ask - Goes beyond the tools to a thorough discussion of the underlying techniques - Covers the gamut of data integration, beyond just SSIS - Includes example databases and files to allow readers to test the recipes

The purpose of this work is to develop an application to create a financial reporting that following the reporting standards from ED PSAK 1 (Exposure Draft Pedoman Standar Akuntansi Keuangan 1). This application prototype is created to accommodate the user in creating a faster and complete financial report that is adapting official standards in Indonesia. Excel VBA technology is considered as the right tool to complete the job because spreadsheet is easy to use, user friendly, and some useful functions already embedded within the spreadsheet. The VBA and database MS SQL will support the lack of spreadsheet that cannot handle the data integrity and consistency. It will make the reporting process easier and faster