SQL Server

Showing 1-9 of 11 results
EngineeringIcon ChevronBack-end

Solving Bottlenecks With SQL Indexes and Partitions

by Mirko Marović

Indexes and partitioning can help with SQL performance, but they're not cure-alls. Through everyday examples of date range and LIKE queries, find out how to "think like an RDBMS" to make yours run faster.

14 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 2

by Mirko Marović

Sorting a table can make some queries faster—but the maintenance cost is untenable. Enter real database indexes and their most common implementation structure: the B-tree.

10 minute readContinue Reading
EngineeringIcon ChevronBack-end

SQL Indexes Explained, Pt. 1

by Mirko Marović

Properly used, an SQL database index can be so effective that it might seem like magic. But the following series of exercises will show that underneath, the logic of most SQL indexes---and wielding them correctly---is quite straightforward.

8 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 3

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? Code migration tools, public synonyms, and change management are important to keep in mind.

14 minute readContinue Reading
EngineeringIcon ChevronData Science and Databases

Oracle to SQL Server and SQL Server to Oracle Migration Guide - Pt. 2

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? This round of pitfalls to avoid includes coverage of sequences, identity columns, and filtered indexes.

8 minute readContinue Reading
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 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 ChevronData Science and Databases

SQL Database Performance Tuning for Developers

by Kevin Bloch

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.