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

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

SQL Server JSON – Part 2

JSON, Languages & Coding

Introduction In the previous article, we covered the basics of JSON and showed how to use JSON in SQL Server, demonstrating these concepts...
Read More

SQL Server User-defined Functions

Database administation, Database Optimization & Structure

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

JSON for SQL Server. Part 1

JSON, Languages & Coding

In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used....
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 administation, Work with data

Introduction Daily work rarely requires storing binary data directly to database columns. However,...
Read More

Implementing Error and Transactions Handling in SQL Server

Database administation, Troubleshooting Issues

Introduction No matter how hard we try to design and develop applications, errors will always occur. There are two general categories –...
Read More

How to Use Array Functionality in SQL Server

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