SQL

Showing 1-9 of 9 results
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? There are some significant pitfalls to be aware of...

11 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

An Intro to SQL Window Functions

by Neal Barnett

SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like "group by," have access to individual rows and can even add some of their attributes into the result set. In this article, Toptal Freelance SQL Developer Neal Barnett explains the benefits of SQL functions, describes when you’d use them, and gives you real examples to help with the concepts.

6 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Three Principles of Data Warehouse Development

by Chamitha Wanaguru

Data warehouses aren’t exactly a new concept, but industry demand for data science services, coupled with the rise of AI and machine learning, is making them more relevant than ever. In this post, Toptal Data Warehouse Developer Chamitha Wanaguru outlines three basic principles you need to keep in mind when developing a new data warehouse.

9 minute readContinue Reading
EngineeringIcon ChevronBack-end

Guide to Data Synchronization in Microsoft SQL Server

by Andrej Gajdos

Sharing related information among isolated systems has become increasingly important. There are many methods to choose from to perform that task for SQL Server, but it’s important to know which is better for each use case.

12 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Server 2016 Always Encrypted: Easy to Implement, Tough to Crack

by Josip Šaban

Security has always been a primary concern for database experts, and with the advent of new, decentralized services, it’s become even more crucial. Microsoft addressed the need for an added level of security in SQL with the introduction of Always Encrypted functionality in SQL Server 2016. In this blog post, Toptal Freelance Software Engineer Josip Saban explains how Microsoft’s Always Encrypted concept works, how it’s implemented, and why developers can’t afford to ignore it.

11 minute readContinue Reading
EngineeringIcon ChevronBack-end

The Definitive Guide to NoSQL Databases

by Mohammad Altarade

Limited SQL scalability has prompted the industry to develop and deploy a number of NoSQL database management systems, with a focus on performance, reliability, and consistency. The trend was driven by proprietary NoSQL databases developed by Google and Amazon. Eventually, open-source systems like MongoDB, Cassandra, and Hypertable brought NoSQL within reach of everyone. In this post, Senior Software Engineer Mohamad Altarade dives into some of them and explains why NoSQL will probably be with us for years to come.

15 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

How to Tune Microsoft SQL Server for Performance

by Sripal Reddy Vindyala

To retain its users, any application or website must run fast. For mission critical environments, a couple of milliseconds delay in getting information might create big problems. As database sizes grow day by day, we need to fetch data as fast as possible, and write the data back into the database as fast as possible. To make sure all operations are executing smoothly, we have to tune Microsoft SQL Server for performance.

10 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

MetaDapper: Data Mapping and Conversion Made Easy With the Right Tools

by Richard Rozsa

Data conversion, translation, and mapping is by no means rocket science, but it is by all means tedious. This article introduces MetaDapper, a .NET library that strives to simplify, streamline, and automate the data conversion process to the greatest extent possible.

10 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

SQL Database Performance Tuning for Developers

by Rodrigo Koch

Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most database tuning will be handled by a Database Administrator (DBA). But there are plenty of developers who have to perform DBA-like tasks; meanwhile, DBAs often struggle to work well with developers. In this article, Toptal Freelance Software Engineer Rodrigo Koch provides developers with database tuning tips and explains how developers and DBAs can work together effectively.

9 minute readContinue Reading

Join the Toptal® community.