Author: Josip Saban

An experienced database developer and software manager with more than 15 years in the field, both in corporate and start-up environments. Josip has strong problem-solving skills and a proven track-record of successfully implementing strategic solutions to meet changing business needs, combined with the ability to build key relationships and communicate well with stakeholders, most of it in finance industry. Focused on Microsoft tool stack, specifically SQL Server, especially in data warehouse modelling and development. from version 2000 to latest versions. He is interested in database architect and engineering management positions, with strong affinity to data-driven industries.

User-Defined Data Types In SQL Server

SQL Server

SQL Server platform comes with many data types, but there are cases when they are not sufficient....
Read More

Varchar To Date Conversions In SQL Server

SQL Server

In many scenarios, date and time information is loaded and stored in the text format. Converting these values to the date/time type is a...
Read More

User-Defined Functions in SQL Server

Database administration, Database Optimization & Structure, SQL Server, Statements

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
Read More

JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation

JSON, Languages & Coding

In the last few years, JSON has positioned itself as a standard data exchange format between...
Read More

Execute Dynamic Query in SQL Server

Database development, Statements, Stored Procedures

Dynamic SQL is a statement constructed and executed at runtime, usually containing dynamically generated SQL string parts, input...
Read More

Storing Binary Data Types in SQL Server

Database administration, 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

Implementing Error and Transactions Handling in SQL Server

Database administration, Troubleshooting Issues

Introduction No matter how hard we try to design and develop applications, errors will always...
Read More

How to Use Array Functionality in SQL Server

Database administration, Work with data

Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to store values in an array in SQL Server....
Read More
Close