Work with data

The Importance of SQL Server Data Tools (SSDT)

07:56 Database administation, Tools & technologies, Work with data

Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and...
Read More

What is MySQL ENUM? (Top 12 Key Facts You Need to Know)

10:53 Database administation, Work with data

MySQL ENUM is a string data type with a value chosen from a list of permitted values. You set these permitted values during table creation...
Read More

VARCHAR and NVARCHAR Data Types in SQL Server

11:40 Database administation, Work with data

Relational databases represent an organization’s data in tables that use columns with different data types allowing them to store valid...
Read More

How to Change Server Level Collation of Running SQL Server Instance

09:05 Database administation, Work with data

In my previous article I have explained the basics of SQL Server Collation. I would suggest you...
Read More

Understanding the Database Level Collation and Impact of Changing it for a Database

14:13 Database administation, SQL Server, Work with data • One Comment

When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and...
Read More

The Best SQL VARCHAR Do’s and Don’ts for Faster Databases

10:05 Database administation, Work with data

This post has “strings attached: for a good reason. We are going to explore deep into SQL VARCHAR, the data type that deals with...
Read More

SQL FLOAT: 3 Points that Will Help you to Avoid Weird Math Errors

12:31 Database administation, Work with data

Have you ever thought that SQL can be wrong in math? It sounds crazy. But if you’ve used the SQL...
Read More

Storing Binary Data Types in SQL Server

11:27 Database administation, Work with data

Introduction Daily work rarely requires storing binary data directly to database columns. However, it is very useful in some cases....
Read More

SQL Data Types: 5 Worst Choices You Need to Stop Today

09:33 Database administation, Work with data

Do your choices of SQL server data types and their sizes matter? The answer lies in the result you got. Did your database balloon in a...
Read More

Converting DateTime to YYYY-MM-DD Format in SQL Server

11:44 Database administation, Work with data

An SQL Server database can store a variety of data types, such as numbers, text strings, Boolean...
Read More
Close