SQL Server
New version of dbForge Source Control for SQL Server released
We are excited to announce that a new version of the SSMS add-in for SQL Server database change management, dbForge Source Control for SQL...
Export SQL Stored Procedure to a File and Generate Its Script
In previous articles, we have reviewed a general algorithm of finding and deleting incomplete open transactions in SQL Server databases, created a table for...
Find and Delete Incomplete Open Transactions in SQL Server – Part 3
In two previous articles, we have reviewed a solution for deleting incomplete open transactions in SQL Server.
By incomplete transaction, we shall basically understand an...
How to Create Custom SQL Server Replication for Read-only Databases
Quite often there’s a need to create a read-only replica of a SQL Server database. This might be required, for example, for the purpose...
Find and Delete Incomplete Open Transactions in SQL Server – Part 1
Frequently enough, MS SQL Server open transactions are incompleted and their initiators forget about them. This is quite a commonly encountered situation in routine...
Enjoy Continuous Integration in TeamCity with dbForge DevOps Automation
We are thrilled to inform our users of dbForge DevOps Automation for SQL Server that we have extended the range of supported automation systems...
How to Generate and Use CRUD Stored Procedures in SQL Server
Most database systems operate on the basis of 4 simplest data
manipulation operations that are called by the acronym CRUD. This
acronym stands for Create, Read,...
Pimp the database diffs management with new dbForge Studio for SQL Server v5.8
We are glad to announce that we have just rolled out the new dbForge Studio for SQL Server, v5.8. This version features massive improvements...
Performing audit changes and rollback transactions is now simpler than ever
There is an old joke that goes something like this: “There are two types of system administrators – those who don’t back up their...
Devart sponsored SQLSaturday Kharkiv 2019
For the past decade, Devart has been actively supporting SQL Saturday events including this year's conference in Kharkiv, Ukraine. As usual, Devart was a...
Devart sponsored SQL Saturday Lviv 2019
We are delighted to inform you that Devart was a Gold sponsor of the SQL Saturday Lviv 2019 event that took place on September 21 in...
A New Look of Differences in Compare Bundle!
We are thrilled to announce a huge update of our SQL Server comparison tool pack, dbForge Compare Bundle for SQL Server. The new versions...
Store and Share Static Data in Updated Source Control!
We are pleased to announce the release of the new version of our MS SSMS add-in for easy tracking and deployment of changes, dbForge...
Linking and Comparing SQL Server and PostgreSQL Databases
In this article, we will describe how to link a PostgreSQL Database to SQL Server, compare and deploy the PostgreSQL data against SQL Server...
How to automatically synchronize data in two SQL Server databases on a schedule
Data in SQL databases often needs to be synchronized in real time – this can be achieved by checking one database for updates and...
How To Generate and Fill a Doubly Linked List Table
Introduction
In this article, we’ll learn how to fill a doubly linked list table with SQL test data. In such tables, there can be various...
Welcome to the Future of SQL Database Development!
We are thrilled to announce the most notable addition to our dbForge for SQL Server product line in years, dbForge DevOps Automation for SQL...
Devart sponsored SQLSaturday 857 in Kyiv, Ukraine
SQLSaturday is one of the largest free-to-attend IT events in Ukraine, and Devart was its Gold Sponsor this time.
We had a lot of new...
Automatic Schema Comparison Log Delivery via Email
In this article, we will show how to set up automatic email delivery of the log file when a comparison of multiple SQL schemas...
How to quickly generate documentation for your SQL Server database
In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using SQL documentation tool from...
SQL Server 2016 Stretch Database
On June 1, SQL Server 2016 was released. It brought a large number of novelties into normal development, including the long-announced Stretch Database technology...
Getting Real Currency Exchange Rates with SQL Server Data Generator
This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.
The currency...
Generating Related Data Elements with SQL Data Generator
Recently we got an interesting question from our user:
The docs don't address directly, but how can we generate three related data elements,...
SQL Server 2016 RC0
The news about Microsoft's intention to "chum" SQL Server with Linux keeps floating around. But I haven't heard a single word about SQL Server...
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...
Enabling AUTO_CLOSE Is a Bad Idea?
From a personal perspective, allowing a production database to run with AUTO_CLOSE option is not the best practice. Let me explain why you should...
What is faster inside SUM & AVG: 0 or NULL?
There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously,...
How to Build a Database from Source Control
There is no doubt that database developers can and should benefit from using source control systems. Regardless of the type of source control system, developers...
How to reduce MSDB size from 42Gb to 200Mb
Recently I've got a spare minute to see why an old test server was running too slow... I had nothing to do with this,...
XML, XQuery & Performance Issues
In this article, we will discuss some pitfalls related to XML and XQuery that may lead to performance issues.
The following code will generate a test...
What is the fastest way to calculate the record COUNT?
I have always liked simple questions with lots of pitfalls. Here is the one: how do you count the total number of records in...
SQL Server 2016 CTP3.1 – What’s New for Developer?
Not that long ago, I remember Microsoft's CEO Satya Nadella has been announcing a new version of SQL Server 2016. And all of a...
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 Typical Maintenance Plans: Automatic Statistics Update
Some time ago, we reviewed the automation of index defrag. Now, it is time to look at statistics.
First of all, what do we need...
How to generate SQL Linked List Data with Python Generator
In this post, we would like to show how to quickly generate table values that are based on the values of another column of...
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.
Generate Meaningful Test Data with Data Generator for SQL Server
Why is meaningful test data important?
While developing an application, you need to make sure you are testing it under conditions that closely simulate a...
SQL Complete Enhanced Functionality
While working on the new version of SQL Complete, we focused on adding the most needed features discussed on Devart's uservoice site – devart.uservoice.com....
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...
Adding Timestamp to a Filename
Summary: This article describes how to add time and date to a filename using the command line.
Sometimes it is crucial to append time and...
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...
Connecting to SQL Server from Mac OS X in Direct Mode Using SDAC
Devart Company released SDAC and UniDAC for RAD Studio with a new functionality – Direct Mode for connection to SQL Server. The existing providers...
Adventures of CLR Types in .Net Framework
Summary: This article describes the issue occurred with execution of the a polygon instance of the geography type and the possible solution for it.
Once...
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,...
dbForge Studio for SQL Server is Ready for Work!
Devart proudly presents dbForge Studio for SQL Server — a new set of SQL Server tools for database developers and administrators.
All users who have...
SQL Complete is ready for SQL Server 2012 now!
Devart Team is glad to announce the new release of SQL Complete v3.5. It includes support of all versions and editions of SQL Server,...
SQL Complete extends its functionality
Devart Team is glad to announce the new release of SQL Complete v3.1. The new version includes some improvements in both Standard and free...
New version of add-in that can replace native Intellisense for SSMS is available!
When working on the new version of SQL Complete, we were focused on the idea of providing the most needed functionality to our users....
Improving Performance for Parsing UNION Clause in SQL Complete
Devart's prompt SQL tool can help SQL Server developers and DBAs to write SQL smoothly, with code-completion. SQL Complete works with current and older databases, thanks to backwards compatibility.
