Articles tagged SQL Tools

16 November 2015
16 November 2015

SQL Server Data Tools (SSDT) and Database References

0
22
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors.… Read more
25 September 2015
25 September 2015

SQLXML Bulk Loader: The Sequel

0
8
SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of XML data into a SQL Server database then you may come to appreciate the raw speed of which it's capable. Adam Aspin shows how to configure the SQL XML Bulk Loader tool for optimal data loading performance.… Read more
02 June 2015
02 June 2015

SQLXML Bulk Loader Basics

0
24
SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.… Read more
10 December 2013
10 December 2013

SQL Enlight for SQL Server Management Studio

0
16
The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.… Read more
02 December 2013
02 December 2013

SQL Server tablediff utility

0
34
Rob Sheldon continues on his quest to explain all those command-line tools such as SQLCMD, Logparser, SQLIO and tablediff that are part of SQL Server. TableDiff can be used for comparing tables, as when you run automated tests that check a result against a table of expected values. The best way to learn TableDiff is to see it in action and Rob talks you through several examples.… Read more
12 November 2013
12 November 2013

Microsoft’s Log Parser Utility: Swell ETL

0
34
For loading text, CSV or XML files into SQL Server, the Log Parser utility, with its amazing SQL engine, is likely to be the obvious choice. Although initially developed purely for converting IIS logs, the Log Parser can turn its hand to a range of formats including even event logs or the Windows registry.… Read more
15 October 2013
15 October 2013

SQL Server SQLCMD Basics

0
91
Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility… Read more
03 May 2013
03 May 2013

MySQL Compare: The Manual That Time Forgot, Part 1

Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you to compare and synchronise MySQL and Oracle databases. MySQL Compare was originally a 'down-tools' project, so never had the extra features or lavish documentation of its siblings. In respect for a highly useful tool, we publish simple instructions of how to use it.… Read more
30 November 2012
30 November 2012

Free Tools for the DBA: PAL Tool

0
31
The Performance Analysis of Logs tool is a general tool for collecting and analysing log data. With the addition of a template, it becomes an effective way of analysing data from performance counters for SQL Server, in order to diagnose performance problems and capture baseline information.… Read more
28 August 2012
28 August 2012

Registered Servers and Central Management Server Stores

0
42
SQL Server Management Studio (SSMS) has many features that make it particularly convenient for the database developer and DBA. Registered Servers are typical: poorly documented, but essential for the busy DBA, since they are easily scriptable via TSQL or PowerShell as well as the SSMS GUI, to access groups of servers to perform a wide range of tasks.… Read more
26 July 2012
26 July 2012

Database Continuous Integration with Bamboo

0
13
We were so interested in Atlassian's Bamboo, and it's role in Continuous Integration, that we wanted to find out more, such as 'why the name?'. So we sent our roving reporter, Richard Morris, out in his proverbial raincoat and trilby to find out more. Who better to ask than their marketing manager, Sarah Goff Dupont… Read more
02 February 2012
02 February 2012

Using SQL Test Database Unit Testing with TeamCity Continuous Integration

0
18
With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.… Read more