Devart was the GOLD sponsor of the SQL Day | Annual Conference of Polish SQL Server User Group, which was held on the 11th – 13th May 2015 in Wrocław, Poland.
We would like to thank the organizers and speakers for the wonderful conference! Our special thanks to Maciej Pilecki and Katarzyna Nieradka for the assistance and warm welcome. We have had a great chance to meet new people, exchange views, and present our software products to the wide audience. Read the rest of this entry »
dbForge Studio for SQL Server gives you an oppurtunity of automating the variety database management processes. One of them is specifying parameters in a report making use the command line.
The /parameters switch is used to specify values for parameters declared in a query script. To perform this task, you need only type the name of a parameter you want to assign a value to and its correspondent value, like this:
Read the rest of this entry »
Since RAD Studio XE7 Update 1 was released, the ETTracker.dll library was added to installation. Its purpose is obscure, but its presence in the installation caused serious problems for Windows XP users when installing RAD Studio XE7 Update 1. Read the rest of this entry »
One of the best ways to gather information about SQL Server workloads is to capture trace information. In this article, we will look at how to use SQL Trace and Server Events Profiler for tracing SQL Server activity. You can use this information for auditing, monitoring and troubleshooting SQL Server performance. This article is intended for DBAs who need to collect information about workloads running on SQL Server for analytic purposes. Read the rest of this entry »
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 X or Windows platforms. Let’s see how this works in a sample below for RAD Studio XE7. Read the rest of this entry »
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 date to the name of a file. For example, we would like to have separate log files for each execution of data synchronization script. To prevent file overriding, we want to specify date and time in the name of each log file.
Devart was excited to participate at the 363d edition of SQLSaturday as a sponsor. The event took place on January 17, 2015 at the Lipscomb University, Nashville, USA. SQLSaturday’s are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. Read the rest of this entry »
dbForge Studio for SQL Server provides the SQL Events Profiler tool that captures SQL Server events from a server. The events are stored in a trace file. The trace file can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem. Events Profiler shows how SQL Server executes queries internally. This allows you to see exactly what T-SQL statements are submitted to the server and how the server accesses the database to return result sets.
You can use this tool for:
- Stepping through problem queries to find the root of the problem.
- Finding and diagnosing slow-running queries.
- Capturing the series of T-SQL statements that lead to a problem.
- Monitoring the performance of SQL Server to tune workloads.
- Correlating performance counters to diagnose problems.
Devart Company released SDAC and UniDAC for RAD Studio with a new functionality – Direct Mode for connection to SQL Server. The existing providers for SQL Server by Microsoft use the OLE DB interface, that allows using client applications only on Windows platforms. Due to absence of native solutions by Microsoft for Mac OS X, SDAC Direct Mode was the only opportunity to support SQL Server for Mac OS X.
Devart provides a ready solution for work with SQL Server from Mac OS X – Direct Mode. Let’s consider a simple sample of using Direct Mode. Read the rest of this entry »
Summary: This article describes how to estimate the coverage with code review of code written by individual developers.
The article builds upon Estimating Coverage of Project’s Source Code with Code Review. As from version 2.6, Review Assistant, Devart’s code review tool, provides the new Code Coverage report. Developed in response to numerous requests from our customers, the report serves for a better quality control over the code review process. Within the context of this article, we would like to show how to:
- Evaluate team performance in the code review process
- Evaluate individual developer’s performance Read the rest of this entry »