Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
| Beginning Microsoft SQL Server 2012 Programming [[electronic resource]] |
| Autore | Atkinson Paul (Software engineer) |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (866 p.) |
| Disciplina |
004.36
005.7585 |
| Altri autori (Persone) | VieiraRobert |
| Soggetto topico |
Client/server computing
Database management Relational databases SQL server Engineering & Applied Sciences Computer Science |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-94101-5
1-118-22388-8 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints Foreign Key Constraints |
| Record Nr. | UNINA-9910461589803321 |
Atkinson Paul (Software engineer)
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
| Beginning Microsoft SQL Server 2012 Programming [[electronic resource]] |
| Autore | Atkinson Paul (Software engineer) |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (866 p.) |
| Disciplina |
004.36
005.7585 |
| Altri autori (Persone) | VieiraRobert |
| Soggetto topico |
Client/server computing
Database management Relational databases SQL server Engineering & Applied Sciences Computer Science |
| ISBN |
1-283-94101-5
1-118-22388-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints Foreign Key Constraints |
| Record Nr. | UNINA-9910790275803321 |
|
Atkinson Paul (Software engineer)
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning Microsoft SQL Server 2012 Programming
| Beginning Microsoft SQL Server 2012 Programming |
| Autore | Atkinson Paul (Software engineer) |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (866 p.) |
| Disciplina |
004.36
005.7585 |
| Altri autori (Persone) | VieiraRobert |
| Soggetto topico |
Client/server computing
Database management Relational databases SQL server Engineering & Applied Sciences Computer Science |
| ISBN |
1-283-94101-5
1-118-22388-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints Foreign Key Constraints |
| Altri titoli varianti |
Microsoft SQL Server 2012 programming
Beginning SQL Server 2012 programming SQL Server 2012 programming |
| Record Nr. | UNINA-9910824087703321 |
|
Atkinson Paul (Software engineer)
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]]
| SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]] |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910453416803321 |
|
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]]
| SQL Server Analysis Services 2012 Cube Development Cookbook [[electronic resource]] |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910790721203321 |
|
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
SQL Server Analysis Services 2012 Cube Development Cookbook
| SQL Server Analysis Services 2012 Cube Development Cookbook |
| Autore | Dewald Baya |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham, : Packt Publishing, 2013 |
| Descrizione fisica | 1 online resource (340 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) |
TurleyPaul
HughesSteve |
| Collana | Quick answers to common problems |
| Soggetto topico |
Client/server computing
Computer networks -- Security measures SQL server Web servers Engineering & Applied Sciences Computer Science |
| ISBN | 1-84968-981-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views
Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session Checking whether cubes are accessible |
| Record Nr. | UNINA-9910812566203321 |
|
Dewald Baya
|
||
| Birmingham, : Packt Publishing, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
