From the Community

• Creating A Bind-Once Structural Directive In Angular 7.1.4

  February 16, 2019
  (Ben Nadel) Over the weekend, I posted my review of Vue.js Up And Running by Callum Macrae. This was my first look at Vue.js; but, coming from an [...]

• MySQL 8 and The FRM Drop… How To Recover Table DDL

  February 16, 2019
  (Marco Tusa) To retrieve and maintain in SQL format the definition of all tables in a database, is a best practice that we all should adopt. To have [...]

• Make public package constants available to SQL

  February 16, 2019
  (stewashton) This is an enhancement request on ODC and a recent Twitter topic. Here is a homemade solution using the SQL Translation [...]

• Parallel package execution in Azure-SSIS Runtime

  February 16, 2019
  (Koen Verbeeck) I have created an SSIS project in Visual Studio. In this project, I have a master package starting multiple child packages. These [...]

• Overview Of Optional Route Parameters In Angular

  February 16, 2019
  (Mohammad Irshad) In this article, we are going to learn the optional route parameters in Angular. Sometimes it may be the requirements that we want [...]

• Angular 7 with .NET Core 2.2 – Global Weather (Part 1)

  February 15, 2019
  (Fred Song) In this article, you will build an Angular 7 app with .NET Core [...]

• Calculate Percentiles to Learn About Data Set Skew in SQL

  February 15, 2019
  (lukaseder) B-Tree indexes are perfect when your data is uniformly distributed. They are not really useful, when you have skewed [...]

• Creating an HTML Table with SQL

  February 15, 2019
  (Hannes du Preez) You can create an HTML Table with SQL. You make use of the ‘FOR XML RAW’ and ‘FOR XML PATH’ statements to [...]

• ODBC Data Sources, The SqlCapabilities Option And Power Query/Power BI Data Refresh Performance

  February 15, 2019
  (Chris Webb) A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen [...]

• A reminder to convert pagesets for Db2 objects to the 10-byte extended RBA and LRSN format

  February 15, 2019
  (Paul McWilliams) APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 [...]

• The Complete Guide to the Java SE 12 Extended Switch Statement/Expression

  February 15, 2019
  (Mohamed Taman) There is no code base that is free from the use of the switch statement; even for performance tweaks, we tend to use it over the [...]

• Getting Started with GraphQL in ASP.NET
• Lifetime Profile Update in Visual Studio 2019 Preview 2
• SQL SERVER – FIX: Msg 41105: Failed to Create the Windows Server Failover Clustering (WSFC) Resource With Name and Type ‘SQL Server Availability Group’