SQL Server MVP Deep Dives- P23

SQL Server MVP Deep Dives- P23: Each year Microsoft invites all the MVPs from every technology and country to Redmondfor an MVP Summit—all top secret—“don’t tweet what you see!” During theMVP Summit, each product team holds a series of presentations where they explaintheir technologies, share their vision, and listen to some honest feedback.
Nội dung trích xuất từ tài liệu:
SQL Server MVP Deep Dives- P23 INDEX 795SQL Server community 221 SQL Server CSS team 577 SQL Server ManagementSQL Server Compact 3.5 SQL Server data 323 Studio 73, 76, 178, deploying on a desktop 299 SQL Server database engine 270–271, 277, 292, 298, deploying on a device 300 622, 687 300–301, 330, 349, 353, design goals 298 SQL Server Database 362, 365, 382, 453, 476, development tools 300 Mirroring 458 490, 571, 656, 701 SQL Server Management SQL Server databases 745 Database Mirroring Studio 300 compacting 403 Monitor 454 SQL Server Management scaling down 297 database mirroring Studio 2008 302 sharing over network 256 wizard 454 Visual Studio 2008 302 SQL Server destination 747 Graphical User XCOPY deployment 300 SQL Server developers 282 Interface 673SQL Server Compact 3.5 for SQL Server engine 76 Keys branch 178 Devices 300 SQL Server errors 76 Log File Viewer utility 673SQL Server Compact error handling 84 maintenance plan 330 Edition 255, 265, 297, SQL Server events 576 Object Explorer 455 305 SQL Server exceptions 80, 84 PRIMARY filegroup 433 ADO.NET data SQL Server Express Edition query window 728 provider 302 258, 262, 268, 272, 276, SQL Server Memory advantage 303 450, 471 Manager 597 architecture 298 SQL Server Extended Events SQL Server messages 82 connecting to from SQL engine 622–623 SQL Server Mobile 478 Server Management architecture 622 SQL Server Native Client 266, Studio 300 SQL Server Failover 692 deployment 299 Cluster 456 SQL Server performance 324 design goals 298 SQL Server Full Text performance issues 590 developer tool Search Thesaurus, SQL Server plan caches 211 integration 302 custom entries 189 SQL Server Policy-Based Man- development tools 298 SQL Server index 243 agement policies 351 DLLs 299 SQL Server installation 271 SQL Server PowerShell 346 SQL Server Profiler 590, 619 extensions 302 SQL Server instances 257, 259, event data 580 merge replication 298 261, 269, 273, 321, 464, performance mobile environments 303 558–559, 561 information 590 multi-user support 298 finding 259 SQL Server Program Files 440 OLE DB provider 302 IP address 269 SQL Server Query programming operating system 325 Analyzer 277 support 302 production 327 SQL Server query redistribution license 299 upgrading 324 optimizer 211 remote data access 298 SQL Server Integration SQL Server relational scenarios of use 303 Services 108, 321, 326, engine 510 single file 299 330, 575, 687, 726, 743, SQL Server replication 326 SQL Server Management 750 SQL Server Reporting Studio 301 data flow task 744 Services 258, 266, 326, transition path from data profiling tools 709 328, 645, 687 SQL Server Express expressions 726 architecture 643 Edition 304 incremental load 754 Catalog 643 Visual Studio 301 SQL Server Integration Configuration Manager 655 Windows service 298 Services 2008 709 Configuration utility 652 XCOPY-style SQL Server job 180 report catalog 643 deployment 298 SQL Server log 77 SQL Server Reporting ServicesSQL Server SQL Server logins 452 2008, configuration 274, 323 SQL Server management 353 RDL rendering engine 658SQL Server Configuration long-term management SQL Server resources 257, 265 Manager 256–257 362 SQL Server service 262SQL Server connection 262 operations team 353 SQL Server Service mechanism 255 PowerShell 364 Account 452SQL Server counters 613 problems 364 Lock Pages in Memory 452796 INDEXSQL Server Service Account SqlClient .NET 256 package 330–331, 716–717, (continued) Data Provider 260 719 Perform Volume Mainte- data provider 663 Package Designer 697 nance Tasks 452 SqlClient package Designer 330SQL Server Service account connection 266 precedence constraints mirror instance 453 Data Provider 259 732SQL Server Service namespace 266 SQL Server 2005 734 Manager 510 SQLCLR code 227 SQL ...