fluent in data

Blog

A sample page description

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
 
23Apr

opensource databases – The same path as Linux?

  • 0 Comments
  • databases, mysql, opensource, postgresql, redopendb
The trend is bigger than ever, opensource DBs (mainly PostgreSQL and MariaDB/MySQL) are moving fast and hitting hard commercial databases like Oracle,DB2 or even SQLServer. Recently PostgreSQL was nominated as DBMS of the year by db-engines ranking after suceeding to SQL Server in 2016. That is just a “popularity” number and it is difficult to […]
Read More
 
09Apr

Using dbatools to verify your SQL Server instances version compliance

  • 0 Comments
  • Automation, DBA, dbatools, PowerShell, SQLServer
Using dbatools to verify your SQL Server instances version compliance was original posted in the Cláudio Silva’s Blog     One of the main DBA’s duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service Packs, Cumulative Updates or Security Updates). Recently, dbatools added a new command that turns this […]
Read More