SQL Server
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.
SQL Complete: Parsing performance improved!
SQL Complete allows developers to use IntelliSense when they write SQL queries in SQL Server Management Studio. The tool will tell you the exact formatting you should use for your SQL commands while you are writing them and will therefore help you write fast, perfectly formatted SQL statements.
Refreshing Objects of SQL Server Databases
This article describes how to update the metadata for non-schema-bound objects of a SQL Server database: views, DML triggers, procedures, functions, or DDL triggers.
How To Create SQL Query in One Shot
In this article we describe how to quickly design a MySQL query visually using a special GUI tool - Query Builder.
Moving Database Objects from One Schema to Different Schemas
Database development is not limited to an initial copy of a database. On your road you meet multiple enhancements, refactoring, upgrade and many other...
Enjoy Creating Complex Queries with SQL Query Builder!
Devart development team is glad to present dbForge Query Builder for SQL Server, a modern and affordable tool that will bring you confidence in...
Dare Compare Your SQL Data Much Faster!
We compared some best-of-breed SQL data comparison tools with dbForge Data Compare for SQL Server to find out which one is faster to compare...
Meet Performance-Leading SQL Comparison Tool
Devart announced the release of a new version of the professional tool for SQL server data comparison and synchronization - dbForge Data Compare 2.00....
Synchronizing SQL data between a company database and a data warehouse
Recently we've received a question from one of our customers asking how to synchronize data between companies servers and a data warehouse server. Let's...
Data Comparison Methods and Techniques
Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...
Ensuring Quality of dbForge Schema Compare for SQL Server, v 2.0
The most important characteristic of any software is its quality. The quality, according to the model specified in the ISO 9126 standard, consists of...
Backup Comparison and Database Versioning Added in Schema Compare for SQL Server
Schema Compare for SQL Server 2.00 compares schema snapshots, database backups, and database changes in version control systems to accelerate the work of advanced...
How to Migrate Databases of Different SQL Server Versions
Need to move databases from SQL Server 2000 to SQL Server 2005 - 2008 or vice versa?
dbForge Schema Compare for SQL Server can successfully...
Table data verification for safe schema synchronization
Preserving data in tables after synchronization is one of requirements for successful schema synchronization. dbForge Schema Compare for SQL Server offers two mechanisms of...
Bulletproof database synchronization with dbForge Schema Compare for SQL Server v1.50
Devart, a vendor of native connectivity solutions and database development tools for Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite databases, has announced...
What’s New in dbForge Schema Compare for SQL Server v1.10
Devart has released today the improved version 1.10 of dbForge Schema Compare for SQL Server, a sophisticated tool specially designed to meet your specific...
Coming Soon: dbForge Schema Compare for SQL Server v1.10
After analyzing our users' feedback on the first release of dbForge Schema Compare for SQL Server. We decided to change our roadmap for this...
Synchronization script is too large – what shall I do?
In my previous post Schema Comparison Stress Testing I mentioned problems we met testing dbForge Schema Compare for SQL Server on large database. In...
Schema Comparison Stress Testing
A few weeks after the first version of dbForge Schema Compare for SQL Server had been released we received a letter from one of...
New product: dbForge Data Compare for SQL Server!
Introduction
Devart Company has launched a new product line for working with SQL Server databases. Recently we have released a beta version of the first...
