Scaling sql server 2012 part | 1E2185008A2D42C89AAC15A6A8C2BC018875DCB4

Scaling sql server 2012 part

Name	Scaling sql server 2012 part 1	DOWNLOAD Copy Link
Total Size	687.1 MB
Total Files	93
Hash	1E2185008A2D42C89AAC15A6A8C2BC018875DCB4

/01. Introduction/
01_01-Introduction.mp4	6.2 MB
01_02-Top Scalability Issues with SQL Server 2012.mp4	4.2 MB
01_03-Postponing the Scaling Decision.mp4	8.1 MB
01_04-Application Architecture and Design Issues.mp4	8.9 MB
01_05-Database Architecture and Design Issues.mp4	5.3 MB
01_06-Indexing Strategy and Maintenance.mp4	6.1 MB
01_07-Summary.mp4	3.1 MB
01_08-Course Structure.mp4	1.4 MB
/02. Top Scalability Issues with SQL Server 2012/
02_01-Introduction.mp4	4.7 MB
02_02-Largest SQL Server Implementations and Your Nightmare.mp4	5.5 MB
02_03-Top Scalability Issues with SQL Server 2012.mp4	3.3 MB
02_04-Handling Scalability Issues.mp4	4.6 MB
02_05-Summary.mp4	2.5 MB
02_06-What is Next.mp4	1.4 MB
/03. Postponing the Scaling Decision/
03_01-Introduction.mp4	3.2 MB
03_02-Postponing the Scaling Decision.mp4	1.2 MB
03_03-Preventing Scalability Problems.mp4	3.3 MB
03_04-Finding Your Bottlenecks and Improving Them.mp4	5.5 MB
03_05-Demo Sample 911 Emergency Script Part 1.mp4	49.8 MB
03_06-Demo Sample 911 Emergency Script Part 2.mp4	80.6 MB
03_07-Using Diagnostic Tools to Find Bottlenecks.mp4	7.9 MB
03_08-Common Performance Bottlenecks.mp4	3.5 MB
03_09-Working with Consultants.mp4	2.7 MB
03_10-Working with Developers.mp4	3.2 MB
03_11-Demo The Bad Man Queries.mp4	31.0 MB
03_12-Working with Stakeholders.mp4	4.1 MB
03_13-Summary and Return on Investment.mp4	5.6 MB
03_14-What is Next.mp4	2.6 MB
/04. Application Architecture and Design/
04_01-Introduction.mp4	4.7 MB
04_02-Application Architecture and Design Issues.mp4	4.4 MB
04_03-Application Refactoring.mp4	5.2 MB
04_04-Overuse of ORM Code Generators.mp4	3.1 MB
04_05-Using Ad Hoc T-SQL from the Application.mp4	3.4 MB
04_06-Overuse of XML Data.mp4	3.0 MB
04_07-SQL Server Scalar User-Defined Functions.mp4	3.4 MB
04_08-Demo T-SQL Scalar UDFs.mp4	27.6 MB
04_09-Too Much Business Logic in the Database.mp4	2.9 MB
04_10-Using DML Triggers for Application Logic.mp4	3.1 MB
04_11-Using CLR Assemblies for Application Logic.mp4	3.8 MB
04_12-Requesting Too Much Data from the Database.mp4	4.4 MB
04_13-User-Controlled, Long-Running Transactions.mp4	2.6 MB
04_14-Overuse of New SQL Server Features.mp4	4.0 MB
04_15-Doing Row-by-Agonizing-Row Processing.mp4	4.8 MB
04_16-Demo Set-Based vs. RBAR Processing.mp4	12.3 MB
04_17-Not Having a Data Archiving Strategy.mp4	3.4 MB
04_18-Not Having a Reporting Strategy.mp4	3.9 MB
04_19-Not Using Middle-Tier Caching.mp4	5.0 MB
04_20-Common Middle-Tier Caching Tools.mp4	2.8 MB
04_21-Summary.mp4	2.8 MB
04_22-What is Next.mp4	1.1 MB
/05. Database Architecture and Design/
05_01-Introduction.mp4	3.5 MB
05_02-Database Architecture and Design Issues.mp4	1.5 MB
05_03-Using Default Database Properties.mp4	8.8 MB
05_04-Demo Creating a New Database.mp4	27.3 MB
05_05-Data File Physical Layout.mp4	5.1 MB
05_06-Transaction Log File Physical Layout.mp4	6.2 MB
05_07-Transaction Log File Configuration.mp4	6.2 MB
05_08-Poor Database Normalization.mp4	2.9 MB
05_09-Lack of Check Constraints.mp4	3.0 MB
05_10-Lack of Foreign Keys.mp4	2.8 MB
05_11-Heap Tables.mp4	2.5 MB
05_12-Inappropriate Data Types.mp4	3.7 MB
05_13-Wide Data Types.mp4	3.9 MB
05_14-Poor Query Design (1).mp4	4.4 MB
05_15-Demo Implicit Conversions.mp4	29.4 MB
05_16-Poor Query Design (2).mp4	4.8 MB
05_17-SQL Server is a Database Server!.mp4	6.8 MB
05_18-Not Using T-SQL Stored Procedures.mp4	6.0 MB
05_19-Overuse of ORM Query Generators.mp4	3.7 MB
05_20-Additional ORM Query Considerations.mp4	3.4 MB
05_21-Summary.mp4	3.1 MB
05_22-What is Next.mp4	2.2 MB
/06. Indexing Strategy and Maintenance/
06_01-Introduction.mp4	2.8 MB
06_02-Common Indexing Issues.mp4	2.4 MB
06_03-Too Many Indexes.mp4	5.2 MB
06_04-Demo Finding Unused Indexes.mp4	9.0 MB
06_05-Having High Impact Missing Indexes.mp4	6.9 MB
06_06-Demo Finding Missing Indexes.mp4	30.1 MB
06_07-Finding Missing Index Warnings.mp4	2.4 MB
06_08-Missing Index Warning Example.mp4	1.8 MB
06_09-Demo Finding Missing Index Warnings.mp4	11.8 MB
06_10-Database Tuning Advisor Issues.mp4	2.6 MB
06_11-Demo Using the DTA Command-Line Utility.mp4	12.4 MB
06_12-Having Poorly-Maintained Indexes.mp4	2.9 MB
06_13-Improper Index Maintenance.mp4	4.2 MB
06_14-Using the SQL Maintenance Plan Wizard.mp4	3.7 MB
06_15-Common XML Index Issues.mp4	3.5 MB
06_16-Common Spatial Index Issues.mp4	3.3 MB
06_17-Not Using Data Compression.mp4	4.1 MB
06_18-Data Compression Considerations.mp4	3.7 MB
06_19-Demo Data Compression.mp4	46.2 MB
06_20-Not Using Columnstore Indexes.mp4	2.7 MB
06_21-Course Summary.mp4	2.8 MB
Total files 93