(Pinal Dave) As a part of my consulting, I see many clients who use SSIS. In this blog we would learn how to fix error “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”.
Community
SQL Server Management Studio (SSMS) from Command Prompt
(Vadivel) When using SQL Server Management Studio I feel it be a pain and waste of time to choose the same SQL server instance, authentication details again and again.
TechTip: What Is ETL, and Why Should I Care?
(Tom Snyder) You may have read my MC Press Online articles about Microsoft SQL Server Integration Services (SSIS). I’d like to broaden the topic to discuss Extract, Transform, and Load in a philosophical sense to give you a better understanding of how you could use it. However you decide to implemen
Encryption of the InnoDB System Tablespace and Parallel Doublewrite Buffer
(Ceri Williams) In my last post I compared data at-rest encryption features available for MySQL and MariaDB.
Why the Trim Spaces setting on APEX items is important
(Peter Raganitsch) Oracle APEX offers a declarative setting for Text and Textarea items to “Trim Spaces”, which would remove leading/trailing spaces from the user input before saving the value to the database.
SLOB Chewed Up All My File System Space and Spit It Out. But, Why?
(kevinclosson) This is a quick blog post in response to a recent interaction with a SLOB user. The user reached out to me to lament that all her file system space was consumed as the result of a SLOB execution (runit.sh).
Checking compatibility for a SQL Server database migration to Azure with sqlpackage.exe
(Jack Vamvas) The SSMS installation comes with a command line utility called sqlpackage.exe . Commonly used to export sql server databases to Azure.
Imperative Loop or Functional Stream Pipeline? Beware of the Performance Impact!
(lukaseder) I like weird, yet concise language constructs and API usages
Improved operational control and versioning support for Db2 REST services
(Tom Toomire and Emily Alameida) In Db2 11 and 12, APAR PI98649 introduces three new Db2 commands, START RESTSVC, STOP RESTSVC, and DISPLAY RESTSVC for operational control of Db2 REST services and support for versioning of REST services.
Reuse UI With Razor Class Libraries (RCL) In ASP.NET Core
(Bipin Joshi) Developers always look for ways to reuse their code and markup. ASP.NET Core offers several ways to reuse code and markup within a project (partials, custom tag helpers, view components etc.).