Autore	Du Gordon
Edizione	[1st edition]
Pubbl/distr/stampa	Birmingham, U.K., : Packt Enterprise Pub., 2011
Descrizione fisica	1 online resource (352 p.)
Disciplina	005.75/85 650.0285 658.02/2
Soggetto topico	Small business - Management - Computer programs SQL (Computer program language)
Soggetto genere / forma	Electronic books.
ISBN	1-283-34958-2 9786613349583 1-84968-237-2
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:SAP Business One Query Users and Query Basics; Who can benefit from using SQL Queries in SAP Business One?; Consultant; Developer; SAP Business One end user; Non-SAP Business One users; SQL query and related terms; RDBMS; Table; Field; SQL; T-SQL; Subsets of SQL; Query; Data dictionary; SAP Business One-Database tables reference; Naming convention of tables for SAP Business One; Three letter words; ""O"" tables; ""A"" tables; Document header tables; Document line tables Important table examplesTable links-the key for the right query; Primary key; Foreign key; Example of table links within SAP Business One; Base tables versus target tables; Keeping it simple-The key to build a good query; Summary; Chapter 2:Query Generator and Query Wizard; Query Generator; Query Generator overview; Left part of Query Generator form; Middle and right parts of Query Generator form; Executing a query from query generator form; Query wizard; Query Wizard overview; Step 1-Splash screen; Step 2-Select tables for the report; Step 3-Select fields and sort orders Step 4-Conditions and relationsStep 5-Query wizard completion; What is the difference between Query generator and Query wizard?; Benefitting from built-in system queries; Summary; Chapter 3:Query Manager and Query Statements; Query manager user interface; Display all existing queries; Creating and saving user queries; Deleting user queries; Managing query categories; Commonly used statements; SELECT-first statement to retrieve data; The scope of the value that can be retrieved; The numbers of columns to be included; Column name descriptions; Clauses can follow this statement DISTINCT-duplicated records can be removedTOP-number of lines returned by ranking; FROM-data resource can be assigned; A single table; A group of linked tables; Multiple tables separated by commas; JOIN-addition table or tables can be linked; Inner Join; Outer Join; WHERE-query conditions to be defined; BETWEEN-ranges to be defined from lower to higher end; IN/EXISTS-the value list that may satisfy the condition; LIKE-similar records can be found; GROUP BY-summarizing the data according to the list; HAVING-conditions to be defined in summary report ORDER BY-report result can be by your preferred orderUNION/UNION ALL-to put two or more queries together; Some important functions to return values; ISNULL() predicate; SUM() function; MAX() function; MIN() function; COUNT() function; DATEDIFF() function; DATEADD() function; DATEPART() function; CAST()/CONVERT() function; CASE expressions; IF expressions; Summary; Chapter 4:Query Examples; Why three categories have been chosen; Defining variables for queries; Case 4-R1: Four variables in one query; Case 4-R2: Variables first or last; Date function-where the most problems emerge Case 4-D1: Balance of production for a month
Record Nr.	UNINA-9910456998903321

Autore	Lee Michael <1966->
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, Ind., : Wiley, c2009
Descrizione fisica	1 online resource (795 p.)
Disciplina	005.75/85 005.7585
Altri autori (Persone)	BiekerGentry
Collana	Serious skills
Soggetto topico	Client/server computing Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-282-01235-5 9786612012358 1-118-25738-3 0-470-46739-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	MASTERING Microsoft® SQL Server® 2008; Acknowledgments; About the Authors; Contents at a Glance; Contents; Introduction; Who Should Read This Book; The Mastering Series; What Is Covered in This Book; How to Contact the Authors; Chapter 1: Overview of Microsoft SQL Server 2008; SQL Server in the Enterprise World; Installing SQL Server 2008; The SQL Server Tool Set; The Bottom Line; Chapter 2: Understanding SQL Server Architecture; Essential Internals; The SQL Server System Catalog; Datatyping; The Bottom Line; Chapter 3: Databases, Files, and Resource Management; Planning a Database Creating DatabasesManaging Databases, Files, and Filegroups; The Bottom Line; Chapter 4: Tables and CRUD Operations; Designing Data Storage; Creating and Dropping SQL Server Tables; Selecting Data from a Table; Modifying Data; The Bottom Line; Chapter 5: Procedural Programming; Procedural Structures; Stored Procedures; Views; User-Defined Functions; Using Synonyms; The Bottom Line; Chapter 6: Managing Data Integrity; Understanding Data Integrity Controls; Working with Constraints; Working with DML Triggers; Rule and Default Objects; The Bottom Line; Chapter 7: SQL Server and XML Returning XML from SQL Server Using FOR XMLThe xml Datatype; Validating XML with Schemas; Implementing XQuery; XML Indexes; The Bottom Line; Chapter 8: Managing User Security; The SQL Server Security Infrastructure; Implementing SQL Server Principals and Authentication; Implementing Permissions in SQL Server; The Bottom Line; Chapter 9: Data Recovery; Transaction Architecture; Backup and Restore Strategies; Performing Backups; Performing Restores; Other Issues; The Bottom Line; Chapter 10: Monitoring SQL Server Activity; Using System Monitor; Using SQL Profiler & Trace; DDL Triggers Event NotificationsThe Bottom Line; Chapter 11: Using the SQL Server Agent Service; SQL Agent and Automation; Creating Jobs; Creating Alerts; Creating Operators; Scripting the SQL Agent; The Bottom Line; Chapter 12: Data Availability and Distribution; Overview of SQL Server Availability and Distribution Options; Database Log Shipping; Database Mirroring; Replication; The Bottom Line; Chapter 13: SQL Server Data Security; Understanding the SQL Server Key Infrastructure; Using Transparent Data Encryption; Encrypting Data Using SQL Server; Module Signing; The Bottom Line Chapter 14: Indexing Strategies for Query OptimizationIndex Architecture; Creating and Managing Indexes; Special Index Considerations; The Bottom Line; Chapter 15: Transactions and Locking; The SQL Server Locking Architecture; Transaction Management; Distributed Transactions; Getting Transaction and Locking Information; The Bottom Line; Chapter 16: Using the Resource Governor and Policy-Based Management; The Resource Governor; Understanding Policy-Based Management; The Bottom Line; Chapter 17: SQL Server and the .NET Client; Understanding ADO. NET; Special Operations in ADO.NET Introducing Language Integrated Query (LINQ)
Record Nr.	UNINA-9910145818503321

Autore	Jayanty Satya Shyam K
Pubbl/distr/stampa	Birmingham, U.K., : Packt Enterprise Pub., 2011
Descrizione fisica	1 online resource (468 p.)
Disciplina	005.75/85 005.7585
Soggetto topico	Client/server computing Database management Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-283-34950-7 9786613349507 1-84968-145-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Copyright; Credits; Foreword; About the Author; Acknowledgment; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with SQL Server 2008 R2; Introduction; Adding SQL Server 2008 R2 Service Pack; features using Slipstream technology; Designing a best practice approach to; upgrading to SQL Server 2008 R2; Working with Data-Tier applications; Designing and adopting SQL Server 2008 R2; solutions; Designing Applications to use federated; servers; Chapter 2: Administrating the Core Database Engine; Introduction; Designing automated administration practicesImplementing Security feature; enhancements; Implementing Availability feature; enhancements; Implementing, Monitoring, and Tuning for; performance; Administering SQL Server workloads with; Resource Governor; Designing SQL Server Agent scheduled jobs; for ETL processes; Troubleshooting multi-server instances with; utility administration; Administering SQL Server Replication; processes; Chapter 3: Managing the Core Database Engine; Introduction; Implementing Central Management feature; enhancements; Designing Multi-server management from; SQL Server 2008 R2 Managing the Utility Control Point datawarehouse database; Implementing Utility & Non-utility collection; sets; Designing and refreshing a Scalable Shared; database; Managing SQL Server Replication processes; Implementing security for SQL Server Agent; jobs management; Multiserver Management Using Utility; Explorer; Chapter 4: Administering Core Business Intelligence Services; Introduction; Preparing and Installing SQL Server Analysis; Services; Implementing Scale-Out of SQL Server; Analysis Services; Administering SQL Server Reporting; Services; Implementing Scale-Out deployment of SQL Server Reporting ServicesPreparing and Installing SQL Server; Integration Services; Managing the ETL process efficiently; Chapter 5: Managing Core SQL Server 2008 R2 Technologies; Introduction; Planning and implementing Self-Service; Business Intelligence services; Implementing Microsoft StreamInsight; Technologies Platform; Implementing SQL Azure connectivity; features; Installing and configuring a Master Data; Services Solution; Designing and deploying framework to use; Master Data Services; Chapter 6: Improving Availability and enhancing Programmability; Introduction Preparing new Failover Cluster featuresInstalling and configuring Failover Cluster; Services; Recovering and troubleshooting Failover; Cluster Failure; Implementing Database Mirroring features; and performance enhancements; Managing Database Mirroring in a Failover; Cluster environment; Managing Log Shipping scenarios in a; Database Mirroring environment; Improving Replication scalability at; multiple sites; Implementing compressed storage features; for tables and indexes; Designing a storage solution for; unstructured data and new collations; Designing data partitioning solutions for tables and indexes
Record Nr.	UNINA-9910461284403321

Edizione	[1st ed.]
Pubbl/distr/stampa	San Jose, CA, : IBM Corp., International Technical Support Organization, 2005
Descrizione fisica	xxviii, 524 p. : ill
Disciplina	005.75/85
Collana	Redbooks
Soggetto topico	Database management Software maintenance
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Record Nr.	UNINA-9910783563303321