fluent in data

Blog

A sample page description

28Aug

Red Summer Machine Learning Lab

  • 0 Comments
This summer, from the 10th to the 14th of September, a group of students will come together a Redglue’s offices to participate in the first edition of Red Summer Machine Learning Lab. In this summer lab, the participants will work with Data Science tools in order to solve a Credit Card Fraud Classification problem. To […]
Read More
 
24Jul

Azure DataBricks and Azure HDInsight Hive integration

  • 0 Comments
  • azure, bigdata, databricks, hdinsight
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 have to remember also that Spark is an somehow old horse in the zoo as it is […]
Read More
 
17Jul

Did you know…you can change the default file encoding for new query on SSMS?

  • 0 Comments
  • Did You Know, Encoding, SQL Server Tip, SQLServer, SSMS
Did you know…you can change the default file encoding for new query on SSMS? was originally posted in Cláudio Silva’s Blog   If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server. The client provided the scripts with all modules […]
Read More
 
27Jun

Tips for backup Azure Data Lake Store with Azure Data Factory

  • 0 Comments
Hi RedGluers, Our Hadoop HDP IaaS cluster on Azure uses Azure Data Lake Store (ADLS) for data repository and accesses it through an applicational user created on Azure Active Directory (AAD). Check this tutorial if you want to connect your own Hadoop to ADLS. Our ADLS is getting bigger and we’re working on a backup strategy for […]
Read More
 1
05Jun

Using CAST() function with User-Defined Data Types…Did you know…

  • 0 Comments
  • CAST, CONVERT, Firebird, SQLServer, UDDT, USER-DEFINED DATA TYPES
Using CAST() function with User-Defined Data Types…Did you know… was originally posted in Cláudio Silva’s Blog   I’m converting some Firebird database code to T-SQL and I’m seeing a lot of code that doesn’t work in the same way that SQL Server. No surprise – I already expected that but for those that still say […]
Read More
 
26May

Redatasense v3.1 – “Happy GDPR day”

  • 0 Comments
Good morning, A bunch of GDPR related emails right? So Happy GDPR day. For celebrating GDPR, we are announcing version 3.1 of our popular Data Sensitive searching tool that uses NLP models for search and catalog your data that can be in any place, databases and files. This version as we called it “Happy GDPR […]
Read More
 
07May

I have the wrong collation!!!

  • 0 Comments
  • Change Collation, Collation, Database Collation, Instance Collation, SQLServer
Why does a DBA ask for details when requested to install or create a SQL Server Instance\ Database? One of those details is Collation. I’ve seen this a lot of times, when creating a database you don’t verify the default collation of the server and create databases with a collation you don’t want. Problem: – […]
Read More
 
04May

redopendb – PostgreSQL smart migration tool from Oracle

  • 0 Comments
  • migration, oracle, postgresql, redopendb
We are working on a new thing, a PostgreSQL migration tool from Oracle databases. We do believe that opensource databases are moving forward and catching up commercial databases like SQL Server or Oracle. See our full post about our take on opensource relational databases. Redopendb is still under development, but we can share a few […]
Read More
 
02May

Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object *

  • 0 Comments
  • DefaultDisplayPropertySet, Get-Member, PowerShell, PowerShell Tip, Scripting, Select-Object *
Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object * was original posted in the Cláudio Silva’s Blog   Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command. For instance, someone was using the Get-Service command to query […]
Read More
 
24Apr

Did you know…you can’t do arithmetic operations with datetime2 like with datetime?

  • 0 Comments
  • DATETIME, DATETIME2, Did You Know, Firebird, Operand type clash, SQLServer
Did you know…you can’t do arithmetic operations with datetime2 like with datetime? was original posted in the Cláudio Silva’s Blog     I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I haven’t seen for some time. The error message is the following: Msg 206, […]
Read More