SQL Server Pivot Function – Converts Rows To Columns – 1 Cool Example!
Sometimes you got business requirements to create dashboard and you must use SQL Server Pivot function to convert rows to…
SQL Server articles and posts. Check and learn something new!
How to run Microsoft ms SQL Server ms docker docker-compose? – check how it is easy and simple in 5 mins!
In this post I will show you how you can easily run Microsoft ms SQL Server ms docker docker-compose. You…
SQL Server To Teradata: Data Migration And Conversion Of Data Types From MS – Full And Useful Guide In 5 Mins!
Data migration between two different database systems always involves the conversion of data types [ SQL Server to Teradata ].…
How To Check Column Data Types In SQL Server Database – 2 Secrets To Be SQL Master!
There are at least a few ways to get column data types in Microsoft SQL Server database. I will show…
Photo by rafzin p on Unsplash
SQL Server Extract Year Month Or Day From DATE Data Type? – 2 simple and useful queries!
If you used databases like Oracle or Teradata, you can be surprised that very popular function like [ SQL Server…
Photo by Campaign Creators on Unsplash
SQL Developer: How to connect to Teradata / MS SQL Server database in Oracle SQL Developer? – 1 great tool for 2 databases!
In this tutorial I will show you How to connect to Teradata using Oracle SQLDeveloper which provides the feature to…