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

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

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

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

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

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

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

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

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

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

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

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

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

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

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