(Koen Verbeeck) I have created an SSIS project in Visual Studio. In this project, I have a master package starting multiple child packages. These child packages run in parallel. When executing my project on a local server, everything runs fine and performance is optimal.
Community
Overview Of Optional Route Parameters In Angular
(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 the component view to be rendered on the basis of some values coming from the route parameter or we just want to render the component with some additio
Calculate Percentiles to Learn About Data Set Skew in SQL
(lukaseder) B-Tree indexes are perfect when your data is uniformly distributed. They are not really useful, when you have skewed data.
Creating an HTML Table with SQL
(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 organize the Table Body (TBODY), Table Header (THEAD) and Table Footer (TFOOT).
ODBC Data Sources, The SqlCapabilities Option And Power Query/Power BI Data Refresh Performance
(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 before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh an
A reminder to convert pagesets for Db2 objects to the 10-byte extended RBA and LRSN format
(Paul McWilliams) APAR PH02437 introduces the new DSNB233I message in Db2 12 and Db2 11.
The Complete Guide to the Java SE 12 Extended Switch Statement/Expression
(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 if/else statements.
Lifetime Profile Update in Visual Studio 2019 Preview 2
(Kyle Reed) The C++ Core Guidelines’ Lifetime Profile, which is part of the C++ Core Guidelines, aims to detect lifetime problems, like dangling pointers and references, in C++ code.
SQL SERVER – FIX: Msg 41105: Failed to Create the Windows Server Failover Clustering (WSFC) Resource With Name and Type ‘SQL Server Availability Group’
(Pinal Dave) Sometimes there are errors which give us the solution to the problem and I love to discover other ways to fix it.
21 New Tools and Extensions for Visual Studio 2017
(Terrence Dorsey) Microsoft is hard at work on Visual Studio 2019, but developers are still rolling out increasingly helpful and sophisticated tools and extensions for Visual Studio 2017.