Obtaining real value from Machine Learning with MLOps
Nowadays the required conditions to obtain value from machine learning, and solve complex business problems are at our reach. We have now the capacity to create and manage large datasets, there are several accelerators on several cloud platforms and with…
Improving the use of Variables and Parameters on SSIS– A tip from the field
As part of my actual job, I frequently use SQL Server Integration Services for developing new packages as well as to change existing ones. Inside SSIS I use and abuse of variables and parameters, and often end up having some…
Azure Databricks and Azure HDinsight Hive Integration
Hello, There is a great hype around Azure DataBricks and we must say that is probably deserved. It will put Spark in memory engine at your work without much effort and with decent amount of “polishedness” and easy-to-scale-with-few-clicks. We also…
KAFKA 101 – Messages To Non-existent Topic
This is a series of Kafka 101 tricks that our team see during our engineer work. Blog posts will be very small and objective. This first post is about sending messages to topics that don’t exists and what happens to…
Did you know… You can change the default file encoding for new query on SSMS?
I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules (Stored Procedures, functions, etc) and the steps I’m following (roughly speaking) for converting are: Open new query window Copy…
Leveraging on SQL Server Data
I’m working on a project where I need to convert Firebird SQL code into T-SQL code. No schema, just the modules. There are more than 1000 objects between stored procedures, views, triggers, user-defined data types, etc. First – the pain……