El Libro del Día: 2014-12-17
Titulo: Implementing a Data Warehouse with Microsoft SQL Server 2012
Autor: Dejan Sarka, Matija Lah, Grega Jerkic
Editorial: Microsoft
Nro Paginas: 848
Capítulos:
Part I - Designing and Implementing a Data Warehouse
Chapter 1 Data Warehouse Logical Design
Chapter 2 Implementing a Data Warehouse
Part II - Developing SSIS Packages
Chapter 3 Creating SSIS Packages
Chapter 4 Designing and Implementing Control Flow
Chapter 5 Designing and Implementing Data Flow
Part III - Enhancing SSIS Packages
Chapter 6 Enhancing Control Flow
Chapter 7 Enhancing Data Flow
Chapter 8 Creating a Robust and Restartable Package
Chapter 9 Implementing Dynamic Packages
Chapter 10 Auditing and Logging
Part IV - Managing and Maintaining SSIS Packages
Chapter 11 Installing SSIS and Deploying Packages
Chapter 12 Executing and Securing Packages
Chapter 13 Troubleshooting and Performance Tuning
Part V - Build ing Data Quality Solutions
Chapter 14 Installing and Maintaining Data Quality Services
Chapter 15 Implementing Master Data Services
Chapter 16 Managing Master Data
Chapter 17 Creating a Data Quality Project to Clean Data
Part VI - Advanced SSIS and Data Quality To pics
Chapter 18 SSIS and Data Mining
Chapter 19 Implementing Custom Code in SSIS Packages
Chapter 20 Identity Mapping and De-Duplicating
Descarga:
Implementing_Data_Warehouse_Microsoft_SQL_Server_2012
Blog de Luis Dueñas dedicado a la difusión del Desarrollo en Microsoft .NET, Visual Studio, WinForms, WebForms, MVC, ASP .NET, jQuery, AJAX, HTML5, JavaScript, Móviles, etc. Encontrarás Libros, Demos, Artículos Técnicos, Entrenamiento.
Mostrando las entradas con la etiqueta SQL Server 2012. Mostrar todas las entradas
Mostrando las entradas con la etiqueta SQL Server 2012. Mostrar todas las entradas
miércoles, 17 de diciembre de 2014
El Libro del Día: Implementing a Data Warehouse with Microsoft SQL Server 2012
Etiquetas:
Auditing,
Control Flow,
Data Flow,
Data Warehouse,
Dejan Sarka,
Deploying,
Dynamic Packages,
Exam 70463,
Grega Jerkic,
Libros,
Logging,
Logical Design,
Matija Lah,
Microsoft,
Securing,
SQL Server 2012,
SSIS Packages
martes, 16 de diciembre de 2014
El Libro del Día: Learning SQL Server Reporting Services 2012
El Libro del Día: 2014-12-16
Titulo: Learning SQL Server Reporting Services 2012
Autor: Jayaram Krishnaswamy
Editorial: Packt
Nro Paginas: 566
Capítulos:
Chapter 1: Overview and Installation - SQL Server Reporting Services 2012
Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012
Chapter 3: Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools
Chapter 4: Working with Report Manager
Chapter 5: Working with Report Builder 3.0
Chapter 6: Power View and Reporting Services
Chapter 7: Self-service Data Alerts in SSRS 2012
Chapter 8: Reporting Services and Programming
Chapter 9: Windows Azure SQL Reporting
Chapter 10: Applications Accessing Report Servers
Descarga:
Learning_SQL_Server_Reporting_Services_2012
Titulo: Learning SQL Server Reporting Services 2012
Autor: Jayaram Krishnaswamy
Editorial: Packt
Nro Paginas: 566
Capítulos:
Chapter 1: Overview and Installation - SQL Server Reporting Services 2012
Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012
Chapter 3: Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools
Chapter 4: Working with Report Manager
Chapter 5: Working with Report Builder 3.0
Chapter 6: Power View and Reporting Services
Chapter 7: Self-service Data Alerts in SSRS 2012
Chapter 8: Reporting Services and Programming
Chapter 9: Windows Azure SQL Reporting
Chapter 10: Applications Accessing Report Servers
Descarga:
Learning_SQL_Server_Reporting_Services_2012
Etiquetas:
Architecture,
Data Alerts,
Features,
Installation,
Jayaram Krishnaswamy,
Libros,
Packt,
Power View,
Programming,
Report Builder,
Report Manager,
Reporting Services,
SQL Server 2012,
SSRS,
Tools,
VS 2012
lunes, 15 de diciembre de 2014
El Libro del Día: Pro SQL Server 2012 Reporting Services
El Libro del Día: 2014-12-15
Titulo: Pro SQL Server 2012 Reporting Services
Autor: Brian K. McDonald, Shawn McGehee, Rodney Landrum
Editorial: Apress
Nro Paginas: 506
Capítulos:
Chapter 1: Introducing the Reporting Services Architecture
Chapter 2: Report Authoring: Designing Efficient Queries
Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools
Chapter 4: Laying Out a Report
Chapter 5: Implementing Dashboard-Style Report Objects
Chapter 6: Building Reports
Chapter 7: Using Custom .NET Code with Reports
Chapter 8: Deploying Reports
Chapter 9: Rendering Reports from .NET Applications
Chapter 10: Managing Reports
Chapter 11: Securing Reports
Chapter 12: Delivering Business Intelligence with SSRS
Chapter 13: Creating Reports Using Report Builder 1.0, 2.0, and 3.0
Descarga:
Pro_SQL_Server_2012_Reporting_Services
Titulo: Pro SQL Server 2012 Reporting Services
Autor: Brian K. McDonald, Shawn McGehee, Rodney Landrum
Editorial: Apress
Nro Paginas: 506
Capítulos:
Chapter 1: Introducing the Reporting Services Architecture
Chapter 2: Report Authoring: Designing Efficient Queries
Chapter 3: Introduction to Reporting Services Design with SQL Server Data Tools
Chapter 4: Laying Out a Report
Chapter 5: Implementing Dashboard-Style Report Objects
Chapter 6: Building Reports
Chapter 7: Using Custom .NET Code with Reports
Chapter 8: Deploying Reports
Chapter 9: Rendering Reports from .NET Applications
Chapter 10: Managing Reports
Chapter 11: Securing Reports
Chapter 12: Delivering Business Intelligence with SSRS
Chapter 13: Creating Reports Using Report Builder 1.0, 2.0, and 3.0
Descarga:
Pro_SQL_Server_2012_Reporting_Services
Etiquetas:
.NET,
Apress,
Architecture,
BI,
Brian K. McDonald,
Dashboard,
Data Tools,
Deploying,
Laying,
Libros,
Managing,
Queries,
Rendering,
Report Builder,
Reporting Services,
Securing,
Shawn McGehee,
SQL Server 2012,
SSRS
domingo, 14 de diciembre de 2014
El Libro del Día: Pro SQL Server 2012 Relational Database Design and Implementation
El Libro del Día: 2014-12-14
Titulo: Pro SQL Server 2012 Relational Database Design and Implementation
Autor: Louis Davidson, Jessica M. Moss
Editorial: Apress
Nro Paginas: 767
Capítulos:
Chapter 1: The Fundamentals
Chapter 2: Introduction to Requirements
Chapter 3: The Language of Data Modeling
Chapter 4: Initial Data Model Production
Chapter 5: Normalization
Chapter 6: Physical Model Implementation Case Study
Chapter 7: Data Protection with Check Constraints and Triggers
Chapter 8: Patterns and Anti-Patterns
Chapter 9: Database Security and Security Patterns
Chapter 10: Table Structures and Indexing
Chapter 11: Coding for Concurrency
Chapter 12: Reusable Standard Database Components
Chapter 13: Considering Data Access Strategies
Chapter 14: Reporting Design
Descarga:
Pro_SQL_Server_2012_Relational_Database_Design_And_Implementation
Titulo: Pro SQL Server 2012 Relational Database Design and Implementation
Autor: Louis Davidson, Jessica M. Moss
Editorial: Apress
Nro Paginas: 767
Capítulos:
Chapter 1: The Fundamentals
Chapter 2: Introduction to Requirements
Chapter 3: The Language of Data Modeling
Chapter 4: Initial Data Model Production
Chapter 5: Normalization
Chapter 6: Physical Model Implementation Case Study
Chapter 7: Data Protection with Check Constraints and Triggers
Chapter 8: Patterns and Anti-Patterns
Chapter 9: Database Security and Security Patterns
Chapter 10: Table Structures and Indexing
Chapter 11: Coding for Concurrency
Chapter 12: Reusable Standard Database Components
Chapter 13: Considering Data Access Strategies
Chapter 14: Reporting Design
Descarga:
Pro_SQL_Server_2012_Relational_Database_Design_And_Implementation
Etiquetas:
Apress,
Components,
Concurrency,
Constraints,
Data Model,
Design,
Fundamentals,
Implementation,
Indexing,
Libros,
Louis Davidson,
MDL,
Normalization,
Patterns,
Reporting,
Security,
SQL Server 2012,
Triggers
sábado, 13 de diciembre de 2014
El Libro del Día: Microsoft SQL Server 2012 Security Cookbook
El Libro del Día: 2014-12-13
Titulo: Microsoft SQL Server 2012 Security Cookbook
Autor: Rudi Bruchez
Editorial: Packt
Nro Paginas: 322
Capítulos:
Chapter 1: Securing Your Server and Network
Chapter 2: User Authentication, Authorization, and Security
Chapter 3: Protecting the Data
Chapter 4: Code and Data Encryption
Chapter 5: Fighting Attacks and Injection
Chapter 6: Securing Tools and High Availability
Chapter 7: Auditing
Chapter 8: Securing Business Intelligence
Descarga:
Microsoft_SQL_Server_2012_Security_Cookbook
Titulo: Microsoft SQL Server 2012 Security Cookbook
Autor: Rudi Bruchez
Editorial: Packt
Nro Paginas: 322
Capítulos:
Chapter 1: Securing Your Server and Network
Chapter 2: User Authentication, Authorization, and Security
Chapter 3: Protecting the Data
Chapter 4: Code and Data Encryption
Chapter 5: Fighting Attacks and Injection
Chapter 6: Securing Tools and High Availability
Chapter 7: Auditing
Chapter 8: Securing Business Intelligence
Descarga:
Microsoft_SQL_Server_2012_Security_Cookbook
Etiquetas:
Attacks,
Auditing,
Authentication,
Authorization,
BI,
Cookbook,
Encryption,
High Availability,
Injection,
Libros,
Network,
Packt,
Protecting,
Rudi Bruchez,
Security,
Server,
SQL Server 2012,
Tools
viernes, 12 de diciembre de 2014
El Libro del Día: SQL Server 2012 Query Performance Tuning
El Libro del Día: 2014-12-12
Titulo: SQL Server 2012 Query Performance Tuning
Autor: Grant Fritchey
Editorial: Apress
Nro Paginas: 521
Capítulos:
Chapter 1: SQL Query Performance Tuning
Chapter 2: System Performance Analysis
Chapter 3: SQL Query Performance Analysis
Chapter 4: Index Analysis
Chapter 5: Database Engine Tuning Advisor
Chapter 6: Lookup Analysis
Chapter 7: Statistics Analysis
Chapter 8: Fragmentation Analysis
Chapter 9: Execution Plan Cache Analysis
Chapter 10: Query Recompilation
Chapter 11: Query Design Analysis
Chapter 12: Blocking Analysis
Chapter 13: Deadlock Analysis
Chapter 14: Cursor Cost Analysis
Chapter 15: Database Performance Testing
Chapter 16: Database Workload Optimization
Chapter 17: SQL Server Optimization Checklist
Descarga:
SQL_Server_2012_Query_Performance_Tuning
Titulo: SQL Server 2012 Query Performance Tuning
Autor: Grant Fritchey
Editorial: Apress
Nro Paginas: 521
Capítulos:
Chapter 1: SQL Query Performance Tuning
Chapter 2: System Performance Analysis
Chapter 3: SQL Query Performance Analysis
Chapter 4: Index Analysis
Chapter 5: Database Engine Tuning Advisor
Chapter 6: Lookup Analysis
Chapter 7: Statistics Analysis
Chapter 8: Fragmentation Analysis
Chapter 9: Execution Plan Cache Analysis
Chapter 10: Query Recompilation
Chapter 11: Query Design Analysis
Chapter 12: Blocking Analysis
Chapter 13: Deadlock Analysis
Chapter 14: Cursor Cost Analysis
Chapter 15: Database Performance Testing
Chapter 16: Database Workload Optimization
Chapter 17: SQL Server Optimization Checklist
Descarga:
SQL_Server_2012_Query_Performance_Tuning
Etiquetas:
Analysis,
Apress,
Blocking,
Cursors,
DB Engine,
Deadlock,
Execution Plan,
Fragmentation,
Grant Fritchey,
Index,
Libros,
Lookup,
Performance,
Query,
Recompilation,
SQL Server 2012,
Statistics,
Testing,
Tuning,
Workload
jueves, 11 de diciembre de 2014
El Libro del Día: Expert Performance Indexing for SQL Server 2012
El Libro del Día: 2014-12-11
Titulo: Expert Performance Indexing for SQL Server 2012
Autor: Jason Strate, Ted Krueger
Editorial: Apress
Nro Paginas: 345
Capítulos:
Chapter 1: Index Fundamentals
Chapter 2: Index Storage Fundamentals
Chapter 3: Index Statistics
Chapter 4: XML, Spatial, and Full-Text Indexing
Chapter 5: Index Myths and Best Practices
Chapter 6: Index Maintenance
Chapter 7: Indexing Tools
Chapter 8: Index Strategies
Chapter 9: Query Strategies
Chapter 10: Index Analysis
Descarga:
Expert_Performance_Indexing_For_SQL_Server_2012
Titulo: Expert Performance Indexing for SQL Server 2012
Autor: Jason Strate, Ted Krueger
Editorial: Apress
Nro Paginas: 345
Capítulos:
Chapter 1: Index Fundamentals
Chapter 2: Index Storage Fundamentals
Chapter 3: Index Statistics
Chapter 4: XML, Spatial, and Full-Text Indexing
Chapter 5: Index Myths and Best Practices
Chapter 6: Index Maintenance
Chapter 7: Indexing Tools
Chapter 8: Index Strategies
Chapter 9: Query Strategies
Chapter 10: Index Analysis
Descarga:
Expert_Performance_Indexing_For_SQL_Server_2012
Etiquetas:
Analysis,
Apress,
Best Practices,
Full Text,
Indexing,
Jason Strate,
Libros,
Maintenance,
Myths,
Performance,
Query,
Spatial,
SQL Server 2012,
Statistics,
Storage,
Strategies,
Ted Krueger,
Tools,
XML
miércoles, 10 de diciembre de 2014
El Libro del Día: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
El Libro del Día: 2014-12-10
Titulo: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
Autor: Itzik Ben-Gan
Editorial: Microsoft
Nro Paginas: 244
Capítulos:
Chapter 1 SQL Windowing
Chapter 2 A Detailed Look at Window Functions
Chapter 3 Ordered Set Functions
Chapter 4 Optimization of Window Functions
Chapter 5 T-SQL Solutions Using Window Functions
Descarga:
Microsoft_SQL_Server_2012_High_Performance_TSQL_Using_Window_Functions
Titulo: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions
Autor: Itzik Ben-Gan
Editorial: Microsoft
Nro Paginas: 244
Capítulos:
Chapter 1 SQL Windowing
Chapter 2 A Detailed Look at Window Functions
Chapter 3 Ordered Set Functions
Chapter 4 Optimization of Window Functions
Chapter 5 T-SQL Solutions Using Window Functions
Descarga:
Microsoft_SQL_Server_2012_High_Performance_TSQL_Using_Window_Functions
Etiquetas:
Functions,
Itzik Ben-Gan,
Libros,
Microsoft,
Optimization,
Performance,
SQL Server 2012,
SQL Windowing,
T-SQL,
Window Functions
martes, 9 de diciembre de 2014
El Libro del Día: Microsoft SQL Server 2012 Step By Step
El Libro del Día: 2014-12-09
Titulo: Microsoft SQL Server 2012 Step By Step
Autor: Patrick LeBlanc
Editorial: Microsoft prePress
Nro Paginas: 364
Capítulos:
Part I Getting started with Microsoft SQL Server 2012
Chapter 1 Overview of Microsoft SQL Server 2012
Chapter 2 Installing, configuring, and upgrading Microsoft SQL Server 2012
Chapter 3 Using SQL Server 2012 administration and development tools
Part II Designing databases
Chapter 4 Designing SQL Server databases
Chapter 5 Creating your first table
Chapter 6 Building and maintaining indexes
Part III Advanced database design topics
Chapter 7 Table compression
Chapter 8 Table partitioning
Chapter 9 Database snapshots
Chapter 10 The SELECT statement
Part IV Using Transact-SQL (TSQL)
Chapter 11 Advanced data retrieval topics
Chapter 12 Modifying data
Chapter 13 Built-in scalar functions
Part V Creating other database objects
Chapter 14 Advanced TSQL topics
Chapter 15 Views
Chapter 16 User-defined functions
Chapter 17 Stored procedures
Chapter 18 Data manipulation triggers
Part VI SQL Server replication
Chapter 19 Replication
Part VII Database maintenance
Chapter 20 Backups
Chapter 21 Managing and maintaining indexes and statistics
Chapter 22 Maintenance plans
Part VIII Database management
Chapter 23 SQL Server Profiler
Chapter 24 Extended events
Chapter 25 SQL Server
Chapter 26 Resource Governor
Chapter 27 SQL Server Agent
Descarga:
Microsoft_SQL_Server_2012_Step_By_Step
Titulo: Microsoft SQL Server 2012 Step By Step
Autor: Patrick LeBlanc
Editorial: Microsoft prePress
Nro Paginas: 364
Capítulos:
Part I Getting started with Microsoft SQL Server 2012
Chapter 1 Overview of Microsoft SQL Server 2012
Chapter 2 Installing, configuring, and upgrading Microsoft SQL Server 2012
Chapter 3 Using SQL Server 2012 administration and development tools
Part II Designing databases
Chapter 4 Designing SQL Server databases
Chapter 5 Creating your first table
Chapter 6 Building and maintaining indexes
Part III Advanced database design topics
Chapter 7 Table compression
Chapter 8 Table partitioning
Chapter 9 Database snapshots
Chapter 10 The SELECT statement
Part IV Using Transact-SQL (TSQL)
Chapter 11 Advanced data retrieval topics
Chapter 12 Modifying data
Chapter 13 Built-in scalar functions
Part V Creating other database objects
Chapter 14 Advanced TSQL topics
Chapter 15 Views
Chapter 16 User-defined functions
Chapter 17 Stored procedures
Chapter 18 Data manipulation triggers
Part VI SQL Server replication
Chapter 19 Replication
Part VII Database maintenance
Chapter 20 Backups
Chapter 21 Managing and maintaining indexes and statistics
Chapter 22 Maintenance plans
Part VIII Database management
Chapter 23 SQL Server Profiler
Chapter 24 Extended events
Chapter 25 SQL Server
Chapter 26 Resource Governor
Chapter 27 SQL Server Agent
Descarga:
Microsoft_SQL_Server_2012_Step_By_Step
Etiquetas:
Administration,
Backups,
Compression,
Designing,
Events,
Functions,
Indexes,
Libros,
Microsoft,
Partitioning,
Patrick LeBlanc,
Profiler,
Replication,
Selects,
Snapshots,
SPs,
SQL Server 2012,
T-SQL,
Triggers,
Views
lunes, 8 de diciembre de 2014
El Libro del Día: SQL Server 2012 T-SQL Recipes
El Libro del Día: 2014-12-08
Titulo: SQL Server 2012 T-SQL Recipes
Autor: Jason Brimhall, David Dye, Jonathan Gennick,
Andy Roberts, Wayne Sheffield
Editorial: Apress
Nro Paginas: 794
Capítulos:
Chapter 1: Getting Started with SELECT
Chapter 2: Elementary Programming
Chapter 3: NULLs and Other Pitfalls
Chapter 4: Querying from Multiple Tables
Chapter 5: Grouping and Summarizing
Chapter 6: Advanced Select Techniques
Chapter 7: Aggregations and Windowing
Chapter 8: Inserting, Updating, Deleting
Chapter 9: Working with Strings
Chapter 10: Working with Dates and Times
Chapter 11: Working with Numbers
Chapter 12: Transactions, Locking, Blocking, and Deadlocking
Chapter 13: Managing Tables
Chapter 14: Managing Views
Chapter 15: Managing Large Tables and Databases
Chapter 16: Managing Indexes
Chapter 17: Stored Procedures
Chapter 18: User-Defined Functions and Types
Chapter 19: Triggers
Chapter 20: Error Handling
Chapter 21: Query Performance Tuning
Chapter 22: Hints
Chapter 23: Index Tuning and Statistics
Chapter 24: XML
Chapter 25: Files, Filegroups, and Integrity
Chapter 26: Backup
Chapter 27: Recovery
Chapter 28: Principals and Users
Chapter 29: Securables, Permissions, and Auditing
Chapter 30: Objects and Dependencies
Descarga:
SQL_Server_2012_TSQL_Recipes
Titulo: SQL Server 2012 T-SQL Recipes
Autor: Jason Brimhall, David Dye, Jonathan Gennick,
Andy Roberts, Wayne Sheffield
Editorial: Apress
Nro Paginas: 794
Capítulos:
Chapter 1: Getting Started with SELECT
Chapter 2: Elementary Programming
Chapter 3: NULLs and Other Pitfalls
Chapter 4: Querying from Multiple Tables
Chapter 5: Grouping and Summarizing
Chapter 6: Advanced Select Techniques
Chapter 7: Aggregations and Windowing
Chapter 8: Inserting, Updating, Deleting
Chapter 9: Working with Strings
Chapter 10: Working with Dates and Times
Chapter 11: Working with Numbers
Chapter 12: Transactions, Locking, Blocking, and Deadlocking
Chapter 13: Managing Tables
Chapter 14: Managing Views
Chapter 15: Managing Large Tables and Databases
Chapter 16: Managing Indexes
Chapter 17: Stored Procedures
Chapter 18: User-Defined Functions and Types
Chapter 19: Triggers
Chapter 20: Error Handling
Chapter 21: Query Performance Tuning
Chapter 22: Hints
Chapter 23: Index Tuning and Statistics
Chapter 24: XML
Chapter 25: Files, Filegroups, and Integrity
Chapter 26: Backup
Chapter 27: Recovery
Chapter 28: Principals and Users
Chapter 29: Securables, Permissions, and Auditing
Chapter 30: Objects and Dependencies
Descarga:
SQL_Server_2012_TSQL_Recipes
Etiquetas:
Aggregations,
Blocking,
Dates,
Deleting,
Grouping,
Indexes,
Inserting,
Libros,
Locking,
Numbers,
Querying,
SPs,
SQL Server 2012,
Strings,
T-SQL,
Tables,
Times,
Transactions,
Updating,
Views
jueves, 4 de diciembre de 2014
El Libro del Día: Pro T-SQL 2012 Programmer's Guide
El Libro del Día: 2014-12-04
Titulo: Pro T-SQL 2012 Programmer's Guide
Autor: Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles
Editorial: Apress
Nro Paginas: 679
Capítulos:
Chapter 1: Foundations of T-SQL
Chapter 2: Tools of the Trade
Chapter 3: Procedural Code and CASE Expressions
Chapter 4: User-Defined Functions
Chapter 5: Stored Procedures
Chapter 6: Triggers
Chapter 7: Encryption
Chapter 8: Common Table Expressions and Windowing Functions
Chapter 9: Data Types and Advanced Data Types
Chapter 10: Full-Text Search
Chapter 11: XML
Chapter 12: XQuery and XPath
Chapter 13: Catalog Views and Dynamic Management Views
Chapter 14: CLR Integration Programming
Chapter 15: .NET Client Programming
Chapter 16: Data Services
Chapter 17: Error Handling and Dynamic SQL
Chapter 18: Performance Tuning
Appendix A: Exercise Answers
Appendix B: XQuery Data Types
Appendix C: Glossary
Appendix D: SQLCMD Quick Reference
Descarga:
Pro_TSQL_2012_Programmer's_Guide
Titulo: Pro T-SQL 2012 Programmer's Guide
Autor: Jay Natarajan, Scott Shaw, Rudi Bruchez, Michael Coles
Editorial: Apress
Nro Paginas: 679
Capítulos:
Chapter 1: Foundations of T-SQL
Chapter 2: Tools of the Trade
Chapter 3: Procedural Code and CASE Expressions
Chapter 4: User-Defined Functions
Chapter 5: Stored Procedures
Chapter 6: Triggers
Chapter 7: Encryption
Chapter 8: Common Table Expressions and Windowing Functions
Chapter 9: Data Types and Advanced Data Types
Chapter 10: Full-Text Search
Chapter 11: XML
Chapter 12: XQuery and XPath
Chapter 13: Catalog Views and Dynamic Management Views
Chapter 14: CLR Integration Programming
Chapter 15: .NET Client Programming
Chapter 16: Data Services
Chapter 17: Error Handling and Dynamic SQL
Chapter 18: Performance Tuning
Appendix A: Exercise Answers
Appendix B: XQuery Data Types
Appendix C: Glossary
Appendix D: SQLCMD Quick Reference
Descarga:
Pro_TSQL_2012_Programmer's_Guide
Etiquetas:
Apress,
CASE,
CLR,
Data Types,
Dynamic SQL,
Encryption,
Functions,
Jay Natarajan,
Libros,
Michael Coles,
Rudi Bruchez,
Scott Shaw,
Search,
SQL Server 2012,
Stored Procedures,
T-SQL,
Tools,
Triggers,
Views,
XML
miércoles, 3 de diciembre de 2014
El Libro del Día: Microsoft SQL Server 2012 T-SQL Fundamentals
El Libro del Día: 2014-12-03
Titulo: Microsoft SQL Server 2012 T-SQL Fundamentals
Autor: Itzik Ben-Gan
Editorial: Microsoft
Nro Paginas: 442
Capítulos:
Chapter 1 Background to T-SQL Querying and Programming
Chapter 2 Single-Table Queries
Chapter 3 Joins
Chapter 4 Subqueries
Chapter 5 Table Expressions
Chapter 6 Set Operators
Chapter 7 Beyond the Fundamentals of Querying
Chapter 8 Data Modification
Chapter 9 Transactions and Concurrency
Chapter 10 Programmable Objects
Descarga:
Microsoft_SQL_Server_2012_TSQL_Fundamentals
Titulo: Microsoft SQL Server 2012 T-SQL Fundamentals
Autor: Itzik Ben-Gan
Editorial: Microsoft
Nro Paginas: 442
Capítulos:
Chapter 1 Background to T-SQL Querying and Programming
Chapter 2 Single-Table Queries
Chapter 3 Joins
Chapter 4 Subqueries
Chapter 5 Table Expressions
Chapter 6 Set Operators
Chapter 7 Beyond the Fundamentals of Querying
Chapter 8 Data Modification
Chapter 9 Transactions and Concurrency
Chapter 10 Programmable Objects
Descarga:
Microsoft_SQL_Server_2012_TSQL_Fundamentals
Etiquetas:
Concurrency,
Expressions,
Fundamentals,
Itzik Ben-Gan,
Joins,
Libros,
Microsoft,
Modifications,
Objects,
Operators,
Programming,
Querying,
SQL Server 2012,
Subqueries,
T-SQL,
Tables,
Transactions
martes, 2 de diciembre de 2014
El Libro del Día: Beginning T-SQL 2012
El Libro del Día: 2014-12-02
Titulo: Beginning T-SQL 2012
Autor: Scott Shaw, Kathi Kellenberger
Editorial: Apress
Nro Paginas: 449
Capítulos:
Chapter 1: Getting Started
Chapter 2: Writing Simple SELECT Queries
Chapter 3: Using Functions and Expressions
Chapter 4: Querying Multiple Tables
Chapter 5: Grouping and Summarizing Data
Chapter 6: Manipulating Data
Chapter 7: Understanding T-SQL Programming Logic
Chapter 8: Working with XML
Chapter 9: Moving Logic to the Database
Chapter 10: Working with Data Types
Chapter 11: Writing Advanced Queries
Chapter 12: Where to Go Next
Descarga:
Beginning_TSQL_2012
Titulo: Beginning T-SQL 2012
Autor: Scott Shaw, Kathi Kellenberger
Editorial: Apress
Nro Paginas: 449
Capítulos:
Chapter 1: Getting Started
Chapter 2: Writing Simple SELECT Queries
Chapter 3: Using Functions and Expressions
Chapter 4: Querying Multiple Tables
Chapter 5: Grouping and Summarizing Data
Chapter 6: Manipulating Data
Chapter 7: Understanding T-SQL Programming Logic
Chapter 8: Working with XML
Chapter 9: Moving Logic to the Database
Chapter 10: Working with Data Types
Chapter 11: Writing Advanced Queries
Chapter 12: Where to Go Next
Descarga:
Beginning_TSQL_2012
Etiquetas:
Advanced Queries,
Apress,
Data Types,
Expressions,
Functions,
Grouping,
Kathi Kellenberger,
Libros,
Manipulating,
Programming,
Queries,
Scott Shaw,
Select,
SQL Server 2012,
Summarizing,
T-SQL,
Tables,
XML
lunes, 1 de diciembre de 2014
El Libro del Día: Beginning SQL Server 2012 for Developers
El Libro del Día: 2014-12-01
Titulo: Beginning SQL Server 2012 for Developers
Autor: Robin Dewson
Editorial: Apress
Nro Paginas: 714
Capítulos:
Chapter 1: Overview and Installation
Chapter 2: SQL Server Management Studio
Chapter 3: Database Design and Creation
Chapter 4: Security and Compliance
Chapter 5: Defining Tables
Chapter 6: Creating Indexes and Database Diagramming
Chapter 7: Database Backups and Recovery
Chapter 8: Database Maintenance
Chapter 9: Data Insertion, Deletion, and Transactions
Chapter 10: Selecting and Updating Data
Chapter 11: Building a View
Chapter 12: Stored Procedures, Functions, and Security
Chapter 13: Essentials for Effective Coding
Chapter 14: Advanced T-SQL and Debugging
Chapter 15: Triggers
Chapter 16: Connecting via Code
Descarga:
Beginning_SQL_Server_2012_For_Developers
Titulo: Beginning SQL Server 2012 for Developers
Autor: Robin Dewson
Editorial: Apress
Nro Paginas: 714
Capítulos:
Chapter 1: Overview and Installation
Chapter 2: SQL Server Management Studio
Chapter 3: Database Design and Creation
Chapter 4: Security and Compliance
Chapter 5: Defining Tables
Chapter 6: Creating Indexes and Database Diagramming
Chapter 7: Database Backups and Recovery
Chapter 8: Database Maintenance
Chapter 9: Data Insertion, Deletion, and Transactions
Chapter 10: Selecting and Updating Data
Chapter 11: Building a View
Chapter 12: Stored Procedures, Functions, and Security
Chapter 13: Essentials for Effective Coding
Chapter 14: Advanced T-SQL and Debugging
Chapter 15: Triggers
Chapter 16: Connecting via Code
Descarga:
Beginning_SQL_Server_2012_For_Developers
Etiquetas:
Apress,
Backups,
Creation,
Debugging,
Design,
Functions,
Installation,
Libros,
Maintenance,
Recovery,
Robin Dewson,
Security,
SPs,
SQL Server 2012,
T-SQL,
Tables,
Transactions,
Triggers,
Views
Suscribirse a:
Entradas (Atom)













