SØG - mellem flere end 8 millioner bøger:
Viser: Microsoft SQL Server 2014 Unleashed
Microsoft SQL Server 2014 Unleashed Vital Source e-bog
Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
(2015)
Pearson International
177,00 kr.
159,30 kr.
Leveres umiddelbart efter køb
Microsoft SQL Server 2014 Unleashed Vital Source e-bog
Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
(2015)
Pearson International
211,00 kr.
189,90 kr.
Leveres umiddelbart efter køb
Microsoft SQL Server 2014 Unleashed Vital Source e-bog
Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
(2015)
Pearson International
199,00 kr.
179,10 kr.
Leveres umiddelbart efter køb
Microsoft SQL Server 2014 Unleashed
Ray Rankins, Paul Bertucci, Chris Gallelli og Alex Silverstein
(2015)
Sprog: Engelsk
Pearson Education
512,00 kr.
460,80 kr.
Denne titel er udgået og kan derfor ikke bestilles. Vi beklager.
Detaljer om varen
- 1. Udgave
- Vital Source 180 day rentals (dynamic pages)
- Udgiver: Pearson International (Maj 2015)
- Forfattere: Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
- ISBN: 9780134084459R180
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions. Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server. Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features. Detailed information on how to… Understand SQL Server 2014’s new features and each edition’s capabilities and licensing Install, upgrade to, and configure SQL Server 2014 for better performance and easier management Streamline and automate key administration tasks with Smart Admin Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups Strengthen security with new features for enforcing “least privilege” Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures Control workloads and Disk I/O with the Resource Governor Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse
Licens varighed:
Bookshelf online: 180 dage fra købsdato.
Bookshelf appen: 180 dage fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Bookshelf online: 180 dage fra købsdato.
Bookshelf appen: 180 dage fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Detaljer om varen
- 1. Udgave
- Vital Source 90 day rentals (dynamic pages)
- Udgiver: Pearson International (Maj 2015)
- Forfattere: Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
- ISBN: 9780134084459R90
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions. Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server. Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features. Detailed information on how to… Understand SQL Server 2014’s new features and each edition’s capabilities and licensing Install, upgrade to, and configure SQL Server 2014 for better performance and easier management Streamline and automate key administration tasks with Smart Admin Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups Strengthen security with new features for enforcing “least privilege” Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures Control workloads and Disk I/O with the Resource Governor Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse
Licens varighed:
Bookshelf online: 90 dage fra købsdato.
Bookshelf appen: 90 dage fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Bookshelf online: 90 dage fra købsdato.
Bookshelf appen: 90 dage fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Detaljer om varen
- 1. Udgave
- Vital Source 365 day rentals (dynamic pages)
- Udgiver: Pearson International (Maj 2015)
- Forfattere: Ray Rankins, Paul Bertucci, Chris Gallelli og Alex T. Silverstein
- ISBN: 9780134084459R365
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage of SQL Server’s core database server and management capabilities: all the real-world information, tips, guidelines, and examples you’ll need to install, monitor, maintain, and optimize the most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions. Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You’ll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server. Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014’s most powerful capabilities and its newest tools and features. Detailed information on how to… Understand SQL Server 2014’s new features and each edition’s capabilities and licensing Install, upgrade to, and configure SQL Server 2014 for better performance and easier management Streamline and automate key administration tasks with Smart Admin Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups Strengthen security with new features for enforcing “least privilege” Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures Control workloads and Disk I/O with the Resource Governor Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse
Licens varighed:
Bookshelf online: 5 år fra købsdato.
Bookshelf appen: 5 år fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Bookshelf online: 5 år fra købsdato.
Bookshelf appen: 5 år fra købsdato.
Udgiveren oplyser at følgende begrænsninger er gældende for dette produkt:
Print: 2 sider kan printes ad gangen
Copy: højest 2 sider i alt kan kopieres (copy/paste)
Detaljer om varen
- Paperback: 2000 sider
- Udgiver: Pearson Education (Juni 2015)
- Forfattere: Ray Rankins, Paul Bertucci, Chris Gallelli og Alex Silverstein
- ISBN: 9780672337291
The industry's most complete, useful, and up-to-date guide to SQL Server 2014.
You'll find start-to-finish coverage of SQL Server's core database server and management capabilities: all the real-world information, tips, guidelines, and examples you'll need to install, monitor, maintain, and optimize the
most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions.
Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You'll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server.
Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014's most powerful capabilities and its newest tools and features.
Detailed information on how to...
You'll find start-to-finish coverage of SQL Server's core database server and management capabilities: all the real-world information, tips, guidelines, and examples you'll need to install, monitor, maintain, and optimize the
most complex database environments. The provided examples and sample code provide plenty of hands-on opportunities to learn more about SQL Server and create your own viable solutions.
Four leading SQL Server experts present deep practical insights for administering SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, tuning performance, and much more. You will benefit from their behind-the-scenes look into SQL Server, showing what goes on behind the various wizards and GUI-based tools. You'll learn how to use the underlying SQL commands to fully unlock the power and capabilities of SQL Server.
Writing for all intermediate-to-advanced-level SQL Server professionals, the authors draw on immense production experience with SQL Server. Throughout, they focus on successfully applying SQL Server 2014's most powerful capabilities and its newest tools and features.
Detailed information on how to...
- Understand SQL Server 2014's new features and each edition's capabilities and licensing
- Install, upgrade to, and configure SQL Server 2014 for better performance and easier management
- Streamline and automate key administration tasks with Smart Admin
- Leverage powerful new backup/restore options: flexible backup to URL, Managed Backup to Windows Azure, and encrypted backups
- Strengthen security with new features for enforcing "least privilege"
- Improve performance with updateable columnstore indexes, Delayed Durability, and other enhancements
- Execute queries and business logic more efficiently with memoryoptimized tables, buffer pool extension, and natively-compiled stored procedures
- Control workloads and Disk I/O with the Resource Governor
- Deploy AlwaysOn Availability Groups and Failover Cluster Instances to achieve enterprise-class availability and disaster recovery
- Apply new Business Intelligence improvements in Master Data Services, data quality, and Parallel Data Warehouse
Introduction 1 Who This Book Is For 2 What This Book Covers 2 Conventions Used in This Book 4 Good Luck! 5
Part I Welcome to Microsoft SQL Server 1 SQL Server 2014 Overview 9 SQL Server Components and Features 9 The SQL Server Database Engine 10 SQL Server 2014 Administration and Management Tools 12 Replication 15 Merge Replication 16 SQL Server AlwaysOn Features 17 SQL Server Service Broker 18 Full-Text and Semantic Search 18 SQL Server Integration Services (SSIS) 20 SQL Server Analysis Services (SSAS) 21 SQL Server Reporting Services (SSRS) 23 Master Data Services 23 Data Quality Services 24 SQL Server 2014 Editions 24 SQL Server 2014 Standard Edition 25 SQL Server 2014 Enterprise Edition 26 Differences Between the Enterprise and Standard Editions of SQL Server 26 Other SQL Server 2014 Editions 28 SQL Server Licensing 30 Web Edition Licensing 31 Developer Edition Licensing 32 Express Edition Licensing 32 Choosing a Licensing Model 32 Mixing Licensing Models 32 Licensing SQL Server of High Availability 32 Licensing SQL Server in a Virtual Environment 34 Summary 35 2 What''s New in SQL Server 2014 37 New SQL Server 2014 Features 37 Memory-Optimized Tables/In-Memory OLTP 38 New Cardinality Estimation Logic 38 Delayed Durability for Transactions 38 Buffer Pool Extension 38 SQL Server Data Tools for Business Intelligence 39 SQL Server 2014 Enhancements 39 Resource Governor Enhancements 39 Security Enhancements 39 Backup and Restore Enhancements 40 Indexing Enhancements 40 Monitoring Enhancements 41 SQL Server AlwaysOn and Availability Groups Enhancements 42 New Transact-SQL Enhancements 42 Deprecated and Discontinued Features 42 Summary 45
Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 49 What''s New in SSMS 50 The Integrated Environment 50 Window Management 50 Integrated Help 53 Administration Tools 56 Registered Servers 56 Object Explorer 58 Activity Monitor 60 Log File Viewer 62 SQL Server Utility 64 Development Tools 69 The Query Editor 69 Managing Projects in SSMS 77 Integrating SSMS with Source Control 78 Using SSMS Templates 80 Using SSMS Snippets 84 T-SQL Debugging 85 Multiserver Queries 86 Summary 87 4 SQL Server Command-Line Utilities 89 What''s New in SQL Server Command-Line Utilities 90 The sqlcmd Command-Line Utility 91 Executing the sqlcmd Utility 93 Using Scripting Variables with sqlcmd 95 The dta Command-Line Utility 96 The tablediff Command-Line Utility 99 The bcp Command-Line Utility 102 The sqldiag Command-Line Utility 103 The sqlservr Command-Line Utility 105 The sqlLocalDB Command-Line Utility 106 Summary 108 5 SQL Server Profiler 111 What''s New with SQL Server Profiler 111 SQL Server Profiler Architecture 112 Creating Traces 113 Events 115 Data Columns 117 Filters 120 Executing Traces and Working with Trace Output 122 Saving and Exporting Traces 123 Saving Trace Output to a File 123 Saving Trace Output to a Table 124 Saving the Profiler GUI Output 124 Importing Trace Files 125 Importing a Trace File into a Trace Table 125 Analyzing Trace Output with the Database Engine Tuning Advisor 128 Replaying Trace Data 128 Defining Server-Side Traces 131 Monitoring Running Traces 141 Stopping Server-Side Traces 143 Profiler Usage Scenarios 145 Analyzing Slow Stored Procedures or Queries 145 Deadlocks 146 Identifying Ad Hoc Queries 148 Identifying Performance Bottlenecks 148 Monitoring Auto-Update Statistics 150 Monitoring Application Progress 151 Summary 153 6 SQL Distributed Replay 155 What''s New for Distributed Replay 155 Overview of Distributed Replay 155 Distributed Replay Components 156 Distributed Replay Administrative Tool 157 Distributed Replay Controller 157 Distributed Replay Clients 158 Target Server 158 Configuring Distributed Replay 158 Controller Configuration File 159 Client Configuration File 159 Preprocess Configuration File 160 Replay Configuration File 161 Replay the Trace Data 163 Configure Permissions and Security 163 Capture the Workload 165 Preprocess the Trace File 166 Apply the Workload 167 Summary 169
Part III SQL Server Administration 7 SQL Server System and Database Administration 173 What''s New in SQL Server System and Database Administration 173 System Administrator Responsibilities 174 System Data
Part I Welcome to Microsoft SQL Server 1 SQL Server 2014 Overview 9 SQL Server Components and Features 9 The SQL Server Database Engine 10 SQL Server 2014 Administration and Management Tools 12 Replication 15 Merge Replication 16 SQL Server AlwaysOn Features 17 SQL Server Service Broker 18 Full-Text and Semantic Search 18 SQL Server Integration Services (SSIS) 20 SQL Server Analysis Services (SSAS) 21 SQL Server Reporting Services (SSRS) 23 Master Data Services 23 Data Quality Services 24 SQL Server 2014 Editions 24 SQL Server 2014 Standard Edition 25 SQL Server 2014 Enterprise Edition 26 Differences Between the Enterprise and Standard Editions of SQL Server 26 Other SQL Server 2014 Editions 28 SQL Server Licensing 30 Web Edition Licensing 31 Developer Edition Licensing 32 Express Edition Licensing 32 Choosing a Licensing Model 32 Mixing Licensing Models 32 Licensing SQL Server of High Availability 32 Licensing SQL Server in a Virtual Environment 34 Summary 35 2 What''s New in SQL Server 2014 37 New SQL Server 2014 Features 37 Memory-Optimized Tables/In-Memory OLTP 38 New Cardinality Estimation Logic 38 Delayed Durability for Transactions 38 Buffer Pool Extension 38 SQL Server Data Tools for Business Intelligence 39 SQL Server 2014 Enhancements 39 Resource Governor Enhancements 39 Security Enhancements 39 Backup and Restore Enhancements 40 Indexing Enhancements 40 Monitoring Enhancements 41 SQL Server AlwaysOn and Availability Groups Enhancements 42 New Transact-SQL Enhancements 42 Deprecated and Discontinued Features 42 Summary 45
Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 49 What''s New in SSMS 50 The Integrated Environment 50 Window Management 50 Integrated Help 53 Administration Tools 56 Registered Servers 56 Object Explorer 58 Activity Monitor 60 Log File Viewer 62 SQL Server Utility 64 Development Tools 69 The Query Editor 69 Managing Projects in SSMS 77 Integrating SSMS with Source Control 78 Using SSMS Templates 80 Using SSMS Snippets 84 T-SQL Debugging 85 Multiserver Queries 86 Summary 87 4 SQL Server Command-Line Utilities 89 What''s New in SQL Server Command-Line Utilities 90 The sqlcmd Command-Line Utility 91 Executing the sqlcmd Utility 93 Using Scripting Variables with sqlcmd 95 The dta Command-Line Utility 96 The tablediff Command-Line Utility 99 The bcp Command-Line Utility 102 The sqldiag Command-Line Utility 103 The sqlservr Command-Line Utility 105 The sqlLocalDB Command-Line Utility 106 Summary 108 5 SQL Server Profiler 111 What''s New with SQL Server Profiler 111 SQL Server Profiler Architecture 112 Creating Traces 113 Events 115 Data Columns 117 Filters 120 Executing Traces and Working with Trace Output 122 Saving and Exporting Traces 123 Saving Trace Output to a File 123 Saving Trace Output to a Table 124 Saving the Profiler GUI Output 124 Importing Trace Files 125 Importing a Trace File into a Trace Table 125 Analyzing Trace Output with the Database Engine Tuning Advisor 128 Replaying Trace Data 128 Defining Server-Side Traces 131 Monitoring Running Traces 141 Stopping Server-Side Traces 143 Profiler Usage Scenarios 145 Analyzing Slow Stored Procedures or Queries 145 Deadlocks 146 Identifying Ad Hoc Queries 148 Identifying Performance Bottlenecks 148 Monitoring Auto-Update Statistics 150 Monitoring Application Progress 151 Summary 153 6 SQL Distributed Replay 155 What''s New for Distributed Replay 155 Overview of Distributed Replay 155 Distributed Replay Components 156 Distributed Replay Administrative Tool 157 Distributed Replay Controller 157 Distributed Replay Clients 158 Target Server 158 Configuring Distributed Replay 158 Controller Configuration File 159 Client Configuration File 159 Preprocess Configuration File 160 Replay Configuration File 161 Replay the Trace Data 163 Configure Permissions and Security 163 Capture the Workload 165 Preprocess the Trace File 166 Apply the Workload 167 Summary 169
Part III SQL Server Administration 7 SQL Server System and Database Administration 173 What''s New in SQL Server System and Database Administration 173 System Administrator Responsibilities 174 System Data
De oplyste priser er inkl. moms
Butikker og åbningstid
Handler du som firma
Forretningsbetingelser
Porto og forsendelse
Data & cookiepolitik
Handler du som firma
Forretningsbetingelser
Porto og forsendelse
Data & cookiepolitik
Polyteknisk Boghandel og Forlag A/S - Anker Engelundsvej 1 - 2800 Lyngby
Tlf 77 42 43 44 - email poly@polyteknisk.dk - CVR 34072655 - Sydbank Reg: 6748 Konto 0001107927
Tlf 77 42 43 44 - email poly@polyteknisk.dk - CVR 34072655 - Sydbank Reg: 6748 Konto 0001107927