How to use Pivot SQL function in Microsoft SQL Server
Sometimes you got business requirements to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
How to run Microsoft SQL Server database using docker and docker-compose
In this post I will show you how you can easily run Microsoft SQL Server Database using docker and docker-compose. Microsoft provides official images in docker hub, so you can…
Data migration – conversion of data types from MS SQL Server to Teradata
Data migration between two different database systems always involves the conversion of data types. In this post, I will introduce the concept of data migration and show how to convert…
SQL Server: How to check column data types in SQL Server database?
There are at least a few ways to get column data types in Microsoft SQL Server database. In this short post, I will show you two the most popular ways…
SQL Server: How to extract only year, month or day from date data type?
If you used databases like Oracle or Teradata, you can be suprised that very popular function like extract(year from date) not work for Microsoft's databases. In this post I show…
Photo by Campaign Creators on Unsplash
SQL Developer: How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?
Oracle SQL Developer provides the feature to connect to many databases, including to Teradata, Microsoft SQL Server, IBM DB2, Sybase, MySQL and even Microsoft Access. All you need is the…