How to Get the Version of a SQL Server Database

When working with SQL Server, you may wonder how to get the version number of a database instance. Thankfully, there are a number of ways to get the database’s version number. These methods can be used in FileCabinet CS, SQL Server Management Studio, and even T-SQL. These steps will help you find out the exact … More How to Get the Version of a SQL Server Database

Technology – An Introduction to SQL Server Express

If you use SQL, several options are open to you, from the Enterprise editions down to SQL Server Express, a free version of Microsoft’s main RDBMS (Relational Database Management System), SQL Server. SQL Server is used to store information and access other information from multiple other databases. Server Express Edition is packed with features, such … More Technology – An Introduction to SQL Server Express

Technology – The Difference Between Float Vs. Double Data Types

It would be incorrect to say that floating-point numbers should never be used as an SQL data type for arithmetic. I will stick to double-precision floating-point data types for SQL Server that are suitable for my requirements. The double-precision floating-point data type is ideal for modeling weather systems or displaying trajectories but not for the … More Technology – The Difference Between Float Vs. Double Data Types

Technology – The Advantages of Using Microsoft SQL Server Integration Services

Microsoft SQL Server Integration Services (SSIS) is designed to combine the features of SQL Server with components of Enterprise Management System (EMMS) so that they can work together for enterprise solutions. Its core area of expertise is bulk/batched data delivery. As a SQL Server collection member, Integration Services is a logical solution to common organizational … More Technology – The Advantages of Using Microsoft SQL Server Integration Services

Technology – Can SQL Server Run On Linux?

Microsoft SQL Server provides organizations with industry-leading data capabilities, enhanced security, performance, and total cost of ownership. Unfortunately, up until 2017, SQL Server could only run on a windows ecosystem. This was a huge pain point for many SQL server customers who preferred the Linux system over Windows for performance, security, and manageability. They had … More Technology – Can SQL Server Run On Linux?

Technology – What Are The SQL Minus and Except Clauses

Structured Query Language (SQL) is the de-facto query language used in most database management systems (DBMS) such as Oracle and Microsoft SQL Server. This domain-specific language is used in programming to query and return the desired data from a database. We use SQL to write queries that declare what data to expect from a dataset … More Technology – What Are The SQL Minus and Except Clauses

Technology – Microsoft SQL Server Temp Table Types

There are a few basics to get to know when it comes to Microsoft SQL server temp table types. For the SQL server, temp table types global-local are two main types that are employed. DB developers are known for using temporary tables, but at the same time, they also may not be keen to go … More Technology – Microsoft SQL Server Temp Table Types

SQL Server Length Function Equivalent

The purpose of the Length function in SQL The SQL LENGTH function returns the number of characters in a string. The LENGTH function is available in many Database Management Systems (DBMS). The LENGTH Function Syntax LENGTH(string) LENGTH Function Notes If the input string is empty, the LENGTH returns 0. If the input string is NULL, … More SQL Server Length Function Equivalent

Technology – What is the difference between left join and left outer join in SQL

If you’re confused between a LEFT JOIN and a LEFT outer JOIN in SQL, you’re not alone. There are plenty of examples that explain both. In this article, we’ll explore LEFT JOIN, which combines the records from table1 with any matched records in table2, and OUTER JOIN, which combines records from both tables. RIGHT joins … More Technology – What is the difference between left join and left outer join in SQL