2008, ISBN: 9781617290473

Summary"SQL Server MVP Deep Dives, Volume 2" lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from te… Plus…

Summary"SQL Server MVP Deep Dives, Volume 2" lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more.About this BookTo become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters."SQL Server MVP Deep Dives, Volume 2" picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.What's InsideDiscovering servers with PowerShellUsing regular expressions in SSMSTuning the Transaction Log for OLTPOptimizing SSIS for dimensional dataReal-time BI and much moreThis unique book is your chance to learn from the best in the business. It offers valuable insights for readers of all levels.========================================​=======Table of ContentsPART 1 ARCHITECTUREWhere are my keys?"Yes, we are all individuals" A look at uniqueness in the world of SQLArchitectural growth painsCharacteristics of a great relational databaseStorage design considerationsGeneralization: the key to a well-designed schemaPART 2 DATABASE ADMINISTRATIONIncreasing availability through testingPage restoresCapacity planningDiscovering your servers with PowerShell and SMOWill the real Mr. Smith please stand up?Build your own SQL Server 2008 performance dashboardSQL Server cost recoveryBest practice compliance with Policy-Based ManagementUsing SQL Server Management Studio to the fullestMultiserver management and Utility Explorer - best tools for the DBATop 10 SQL Server admin student misconceptionsHigh availability of SQL Server in the context of Service Level AgreementsPART 3 DATABASE DEVELOPMENTT-SQL: bad habits to kickDeath by UDFUsing regular expressions in SSMSSQL Server Denali: what's coming next in T-SQL Creating your own data typeExtracting data with regular expressionsRelational divisionSQL FILESTREAM: to BLOB or not to BLOBWriting unit tests for Transact-SQLGetting asynchronous with Service BrokerEffective use of HierarchyIdLet Service Broker help you scale your applicationPART 4 PERFORMANCE TUNING AND OPTIMIZATIONHardware 201: selecting and sizing database server hardwareParameter sniffing: your best friend...except when it isn'tInvestigating the plan cacheWhat are you waiting for? An introduction to waits and queuesYou see sets, and I see loopsPerformance-tuning the transaction log for OLTP workloadsStrategies for unraveling tangled codeUsing PAL to analyze SQL Server performanceTuning JDBC for SQL ServerPART 5 BUSINESS INTELLIGENCECreating a formal Reporting Services report part libraryImproving report layout and visualizationDeveloping sharable managed code expressions in SSRSDesigning reports with custom MDX queriesBuilding a scale-out Reporting Services farmCreating SSRS reports from SSASOptimizing SSIS for dimensional data loadsSSIS configurations managementExploring different types of enumerators in the SSIS Foreach Loop containerLate-arriving dimensions in SSISWhy automate tasks with SSIS?Extending SSIS using the Script componentETL design checklistAutogenerating SSAS cubesScripting SSAS databases - AMO and PowerShell, Better TogetherManaging context in MDXUsing time intelligence functions in PowerPivotEasy BI with Silverlight PivotViewer Excel as a BI frontend toolReal-time BI with StreamInsightBI solution development design considerations Media > Book<

2008, ISBN: 9781617290473

Summary"SQL Server MVP Deep Dives, Volume 2" lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from te… Plus…

Summary"SQL Server MVP Deep Dives, Volume 2" lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more.About this BookTo become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters."SQL Server MVP Deep Dives, Volume 2" picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.What's InsideDiscovering servers with PowerShellUsing regular expressions in SSMSTuning the Transaction Log for OLTPOptimizing SSIS for dimensional dataReal-time BI and much moreThis unique book is your chance to learn from the best in the business. It offers valuable insights for readers of all levels.========================================​=======Table of ContentsPART 1 ARCHITECTUREWhere are my keys?"Yes, we are all individuals" A look at uniqueness in the world of SQLArchitectural growth painsCharacteristics of a great relational databaseStorage design considerationsGeneralization: the key to a well-designed schemaPART 2 DATABASE ADMINISTRATIONIncreasing availability through testingPage restoresCapacity planningDiscovering your servers with PowerShell and SMOWill the real Mr. Smith please stand up?Build your own SQL Server 2008 performance dashboardSQL Server cost recoveryBest practice compliance with Policy-Based ManagementUsing SQL Server Management Studio to the fullestMultiserver management and Utility Explorer - best tools for the DBATop 10 SQL Server admin student misconceptionsHigh availability of SQL Server in the context of Service Level AgreementsPART 3 DATABASE DEVELOPMENTT-SQL: bad habits to kickDeath by UDFUsing regular expressions in SSMSSQL Server Denali: what's coming next in T-SQL Creating your own data typeExtracting data with regular expressionsRelational divisionSQL FILESTREAM: to BLOB or not to BLOBWriting unit tests for Transact-SQLGetting asynchronous with Service BrokerEffective use of HierarchyIdLet Service Broker help you scale your applicationPART 4 PERFORMANCE TUNING AND OPTIMIZATIONHardware 201: selecting and sizing database server hardwareParameter sniffing: your best friend...except when it isn'tInvestigating the plan cacheWhat are you waiting for? An introduction to waits and queuesYou see sets, and I see loopsPerformance-tuning the transaction log for OLTP workloadsStrategies for unraveling tangled codeUsing PAL to analyze SQL Server performanceTuning JDBC for SQL ServerPART 5 BUSINESS INTELLIGENCECreating a formal Reporting Services report part libraryImproving report layout and visualizationDeveloping sharable managed code expressions in SSRSDesigning reports with custom MDX queriesBuilding a scale-out Reporting Services farmCreating SSRS reports from SSASOptimizing SSIS for dimensional data loadsSSIS configurations managementExploring different types of enumerators in the SSIS Foreach Loop containerLate-arriving dimensions in SSISWhy automate tasks with SSIS?Extending SSIS using the Script componentETL design checklistAutogenerating SSAS cubesScripting SSAS databases - AMO and PowerShell, Better TogetherManaging context in MDXUsing time intelligence functions in PowerPivotEasy BI with Silverlight PivotViewer Excel as a BI frontend toolReal-time BI with StreamInsightBI solution development design considerations Media ><