Autore	Hiten Geoff
Edizione	[1st ed. 2025.]
Pubbl/distr/stampa	Berkeley, CA : , : Apress : , : Imprint : Apress, , 2025
Descrizione fisica	1 online resource (317 pages)
Disciplina	005.75/85
Collana	Certification Study Companion Series
Soggetto topico	Database management - Examinations Microsoft Azure (Computing platform) - Examinations SQL (Computer program language) - Examinations
ISBN	979-88-6881-585-0
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	1. About the DP-300 Exam, this book, and Azure -- Part 1: Plan and Implement Azure SQL Data Platform Resources -- 2. Plan and Implement Azure SQL Database Solutions -- 3. Configure Resources for Scale and Performance -- 4. Plan and Implement a Migration Strategy -- Part 2: Implement a Secure Environment -- 5. Configure Database Authentication and Authorization -- 6. Implement Security for Data at Rest and Data in Transit -- 7. Implement Compliance Controls for Sensitive Data -- Part 3: Monitor, Configure, and Optimize Database Resources -- 8. Monitor Resource Activity and Performance -- 9. Monitor and Optimize Query Performance -- 10. Configure Database Solutions for Optimal Performance -- Part 4: Configure and Manage Automation -- 11. Create and Manage SQL Agent Jobs -- 12. Automate Deployment of Database Resources -- 13. Create and Manage Database Tasks in Azure -- Part 5: Plan and Configure a High Availability and Disaster Recovery (HA/DR) Environment -- 14. Recommend a HA/DR Strategy for Database Solutions -- 15. Plan and Perform Backup and Restore of a Database -- 16. Configure HA/DR for Database Solutions.
Record Nr.	UNINA-9911031578603321

Autore	Pollack Edward
Edizione	[2nd ed.]
Pubbl/distr/stampa	Berkeley, CA : , : Apress L. P., , 2026
Descrizione fisica	1 online resource (249 pages)
Disciplina	005.75/85
Collana	Professional and Applied Computing Series
Soggetto topico	Client/server computing Database management
ISBN	9798868826108
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Analytics Optimization with Columnstore Indexes in Microsoft SQL Server -- Introduction -- Acknowledgments -- Table of Contents -- About the Author -- About the Technical Reviewer -- 1. Introduction to Analytic Data in a Transactional Database -- 2. Transactional vs. Analytic Workloads -- 3. What Are Columnstore Indexes? -- 4. Columnstore Index Architecture -- 5. Columnstore Compression -- 6. Columnstore Metadata -- 7. Batch Execution -- 8. Bulk Loading Data -- 9. Delete and Update Operations -- 10. Segment and Rowgroup Elimination -- 11. Partitioning -- 12. Non-clustered Columnstore Indexes on Rowstore Tables -- 13. Non-clustered Rowstore Indexes on Columnstore Tables -- 14. Columnstore Index Maintenance -- 15. Columnstore Index Performance -- 16. Ordered Columnstore Indexes -- Index.
Record Nr.	UNINA-9911114308503321

Autore	Vieira Robert
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, IN, : Wiley Pub., 2008
Descrizione fisica	1 online resource (724 p.)
Disciplina	005.75/85
Collana	Wrox beginning guides.
Soggetto topico	Database management Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-118-05960-3 1-282-68296-2 9786612682964 0-470-42394-3
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; Contents; Introduction; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; Chapter 2: Tools of the Trade; Chapter 3: The Foundation Statements of T-SQL; Chapter 4: JOINs; Chapter 5: Creating and Altering Tables; Chapter 6: Constraints; Chapter 7: Adding More to Our Queries; Chapter 8: Being Normal: Normalization and Other Basic Design Issues; Chapter 9: SQL Server Storage and Index Structures; Chapter 10: Views; Chapter 11: Writing Scripts and Batches; Chapter 12: Stored Procedures Chapter 13: User-Defined FunctionsChapter 14: Transactions and Locks; Chapter 15: Triggers; Chapter 16: A Brief XML Primer; Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services; Chapter 18: Getting Integrated with Integration Services; Chapter 19: Playing Administrator; Appendix A: System Functions; Appendix B: Very Simple Connectivity Examples; Index
Record Nr.	UNINA-9910454130303321

Autore	Aspin Adam
Edizione	[1st ed. 2015.]
Pubbl/distr/stampa	Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015
Descrizione fisica	1 online resource (413 p.)
Disciplina	005.75 005.75/85
Collana	The expert's voice in SQL server
Soggetto topico	Database management Data structures (Computer science) Data mining Database Management Data Structures and Information Theory Data Mining and Knowledge Discovery
ISBN	9781484205327 1484205324
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform""; ""Business Intelligence Concepts""; ""Key Performance Indicators""; ""Scorecards""; ""Dashboards""; ""SSRS for Business Intelligence, Practically""; ""Getting the Data Right""; ""Prepare the Data""; ""Use Views and Stored Procedures""; ""Views""; ""Stored Procedures""; ""Some Ideas on Source Data Definition""; ""Real-World Data"" ""Designing SQL Server Reports for Business Intelligence""""Presentation""; ""Design""; ""Layout""; ""Interface and Interactivity""; ""Multi-Purposing""; ""The Sample Database""; ""Preparing Your Environment""; ""Creating an SSDT Project""; ""Adding a Shared Datasource""; ""Add Shared Datasets""; ""Configuring Parameters""; ""Code and Stored Procedures""; ""Reusability""; ""The CarSales_Reports Database""; ""Book Audience""; ""How Best to Use This Book""; ""Conclusion""; ""Chapter 2: KPIs and Scorecards""; ""What Are Key Performance Indicators?""; ""KPI Value""; ""KPI Goal""; ""KPI Status"" ""KPI Status Thresholds""""Threshold Flags""; ""KPI Trends""; ""KPI Trend Thresholds and Flags""; ""A Simple KPI""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""A More Complex KPI Using Sparklines""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""Gauge-Based KPIs""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge-Based KPI""; ""How It Works""; ""Hints and Tips""; ""Text-Based KPIs""; ""A Simple Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Text-Based KPI"" ""How It Works""""A Complex Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Complex Text-Based KPI""; ""How It Works""; ""Conclusion""; ""Chapter 3: Gauges for Business Intelligence""; ""Gauge Elements""; ""Data for Gauges""; ""Gauge Development""; ""Classic Gauges""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Using Multiple Pointers in Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating the Gauge""; ""How It Works""; ""Varying the Pointer Types and Assembling Gauges"" ""The Source Data""""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Gauges with Multiple Elements""; ""The Source Data""; ""Creating the Gauge""; ""How It Works""; ""Hints and Tips""; ""Less Traditional Gauges""; ""Thermometers""; ""The Source Data""; ""How the Code Works""; ""Building the Thermometer""; ""How It Works""; ""Hints and Tips""; ""Sub-Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating Gauges with Sub-Gauges""; ""How It Works""; ""Hints and Tips""; ""Interesting Tricks with Gauges""; ""The Source Data""; ""How the Code Works"" ""Creating and Assembling the Gauges""
Altri titoli varianti	Business intelligence with structured query language server reporting services
Record Nr.	UNINA-9910300638303321

Autore	Lawson Susan
Edizione	[1st ed.]
Pubbl/distr/stampa	Ketchum, Idaho, : MC Press, 2006
Descrizione fisica	1 online resource (1009 p.)
Disciplina	005.75/85 005.7585
Altri autori (Persone)	LuksetichDan
Soggetto topico	Electronic data processing personnel - Certification Database management
Soggetto genere / forma	Electronic books.
ISBN	1-58347-645-8
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Cover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands DB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups Database Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources Practice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery Tracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions SQL Execution Validation
Record Nr.	UNINA-9910453088703321