HomeHow To

How To

Backup and Restore Databases in SQL Server

In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies. The immediate purpose of...

Increasing SQLite Performance

One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue. Perhaps, a classic case everyone gets...

SQL Server Typical Maintenance Plans: Automated Database Backups

There are a lot of posts appealing to one simple truth – need perform backups on a regular basis. People will always be divided...

SQL Server Index Fragmentation In-depth

In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.

Capturing SQL Server Trace Data

One of the best ways to gather information about SQL Server workloads is to capture trace information. In this article, we will look at...

Connecting to SQL Server from Android and iOS in Direct Mode Using SDAC

Using SDAC in Direct Mode for access to SQL Server from iOS and Android platforms doesn’t significantly differ from the one on Mac OS...

Analyzing SQL Server Events with help of Events Profiler

dbForge Studio for SQL Server provides the SQL Events Profiler tool that captures SQL Server events from a server. The events are stored in...

Creating TFS Custom Check-in Policy

This article explains implementation of the TFS custom check-in policy for pre-commit code review. We developed this policy for Review Assistant - our code review tool. Idea Behind...

SQL Server Typical Maintenance Plans – Part 1: Automated Index Defragmentation

It's incorrect to consider a database as a stable unit, since various kinds of undesirable situations can appear over time — database performance degradation,...

How to Develop Android Database Applications in RAD Studio XE5

Not so long ago, in RAD Studio XE5 there was introduced support for Android application development. On the Internet there can be found a...

Social

Topics

Products