New build of xSQL Data Compare that fixes an issue with the sync script serialization is available for download. Under certain conditions the serialization of the synchronization script would fail – while that failure is mostly transparent to the end user as the process will continue normally, it would be exposed in cases when the synchronization script is very large.
xSQL Data Compare provides for comparing and synchronizing data in two SQL Server databases. The current version supports SQL Server 2008/2005/2000 - all editions. xSQL Data Compare is free for SQL Server Express with no restrictions. For other editions of SQL Server it is only free if the number of objects does not exceed certain limits listed here: http://www.xsql.com/LiteEdition.aspx. You can download your free copy from here: http://www.xsql.com/download/sql_server_data_compare/
Monday, November 29, 2010
Monday, November 22, 2010
Script Executor for DB2 free today
Today only you can get a free license for Script Executor for DB2 - use discount code TWITDB2EX when placing the order. Script Executor is one of the best tools for deploying t-sql scripts to your database server "farm". Whether you are running DB2, SQL Server, MySQL or a combination of those platforms, Script Executor allows you to easily create deployment packages involving hundreds of scripts that have to be executed in a certain order targeting as many servers as you need on any of those platforms, simultaneously.
Download a free, fully functional trial version and see for yourself what you have been missing until now: http://www.xsql.com/download/script_executor/
Download a free, fully functional trial version and see for yourself what you have been missing until now: http://www.xsql.com/download/script_executor/
Friday, November 12, 2010
Profiler for SQL Express
The lack of profiling tools for SQL Server Express has been one of the issues small developers have had to grapple with. If you are one of those developers check out xSQL Profiler – it provides all the functionality of the SQL Profiler and more. It supports all editions of SQL Server including MSDE and SQL Express. What’s more the xSQL Profiler is free for two SQL Server instances – fully functional, no strings attached.
So, if you are looking for a profiler for SQL Express you can get it here for free.
So, if you are looking for a profiler for SQL Express you can get it here for free.
Wednesday, November 10, 2010
xSQL Documenter V4 released
One of the best database documenting tools in the market just got better - we released xSQL Documenter V4 with the following new and enhanced features:
- support for Microsoft Integration Server 2005/2008, Teradata 13 and SQLite;
- enhanced Extended Property Editor to support more platforms and support for comments on procedure parameters;
- A new “columns” section for table valued functions shows what columns they return (SQL Server only);
- Deterministic, schema bound and inline properties for functions were added (SQL Server only);
- Ability to suppress object dependencies on schemas (SQL Server only);
- Ability to specify max number of threads in GUI (the equivalent of the command line switch /threads);
- Support for replacing tabs with spaces in DDL;
- Scripting of users, logins, and roles for SQL Server;
- Support for connecting to Oracle using ODBC;
- More details in the foreign keys section for SQL Server;
- Specify sample rows from tables separately from sample rows for views since views can be very "expensive";
- Ability to order sample rows;
- Microsoft SQL Server 2000/2005/2008
- Microsoft Analysis Server 2005/2008
- Microsoft Report Server 2005/2008
- Oracle 9i and above
- DB2 8.2 and above
- MySQL 5.0 and above
- Sybase ASE 12.0 and above
- Sybase SQL Anywhere 10.0 and up
- Informix IDS 10.0 and above
- PostgreSQL 8.0 and above
- Microsoft Access 97 and above
- VistaDB 3.0 and above
- ENEA Polyhedra 7.0 and above
- Raima RDM Server 8.1
Tuesday, November 9, 2010
xSQL Builder new build available
Just published a new build of xSQL Builder with improved handling of backup files when the user chooses the "Create destination database from a backup" option. The new build also comes with a new and improved install mechanism.
Targeting primarily software publishers, xSQL Builder is one of the best SQL Server database deployment tools. In just minutes you can create an executable package that embeds wither the schema of the master database only or a complete backup of the master database. When you run the executable on the client depending on the configuration it will either create and restore the database from scratch or compare the existing database with the embedded schema and update the target with the changes. Of course software publishers are not the only ones who would benefit from using xSQL Builder - anyone in need of deploying a SQL Server database will find xSQL Builder to be an indispensable tool.
You can download the new build from: http://www.xsql.com/download/sql_database_deployment_builder/
Targeting primarily software publishers, xSQL Builder is one of the best SQL Server database deployment tools. In just minutes you can create an executable package that embeds wither the schema of the master database only or a complete backup of the master database. When you run the executable on the client depending on the configuration it will either create and restore the database from scratch or compare the existing database with the embedded schema and update the target with the changes. Of course software publishers are not the only ones who would benefit from using xSQL Builder - anyone in need of deploying a SQL Server database will find xSQL Builder to be an indispensable tool.
You can download the new build from: http://www.xsql.com/download/sql_database_deployment_builder/
Monday, November 1, 2010
Best way to create an rss feed from SQL Server
If you are looking for a quick and easy way to create and maintain dynamic rss feeds from SQL Server then RSS Reporter is your best bet. Completely free for one SQL Server instance RSS Reporter for SQL Server supports SQL Server 2008, 2005 and 2000. It allows you to write a t-sql query and automatically generates an rss feed with the results of the query. Every time a feed reader refreshes the feed the query you have defined will be executed against the chosen database and the feed will be updated with the new results.
Need to change the rss feed? No problem – simply login to the rss reporter admin interface, modify the query, save it and you are done – all users that are reading that feed will get the new results next time the feed is refreshed.
Best of all: RSS Reporter for SQL Server is completely free (no strings attached) for a single SQL Server instance and only $99 for 5 SQL Server instances. A DBA in charge of monitoring SQL jobs from multiple servers will greatly appreciate the pre-built SQL Server jobs feeds – all jobs from all servers in one aggregate rss feed; that is efficiency!
Need to change the rss feed? No problem – simply login to the rss reporter admin interface, modify the query, save it and you are done – all users that are reading that feed will get the new results next time the feed is refreshed.
Best of all: RSS Reporter for SQL Server is completely free (no strings attached) for a single SQL Server instance and only $99 for 5 SQL Server instances. A DBA in charge of monitoring SQL jobs from multiple servers will greatly appreciate the pre-built SQL Server jobs feeds – all jobs from all servers in one aggregate rss feed; that is efficiency!
Friday, October 22, 2010
One to many join – pick only one corresponding row from the "many" table
It is hard to "synthesize" this problem into one sentence hence the cryptic title, but here is the long description: You have table T1 that has a one to many relationship with table T2. You need to update a particular column, let's say C1, on table T1 with a value that can be extracted (with some manipulation) from one of the corresponding rows on table T2.
The first thing that comes to mind is a simple update like this:
UPDATE T1 SET C1 = SomeFunction(t2.C1)
FROM T1 INNER JOIN T2 ON t1.ID = t2.t1ID
WHERE t2.c1 fulfills some criteria – we need this since not all the rows on T2 contain the values we need.
The problem with this is that it keeps needlessly updating T1 rows as many times as it finds corresponding rows on T2. For each row on T1 we need to pick only one of the corresponding rows from T2 that fulfills the criteria. One option would be to use a cursor, but we want to avoid using a cursor and handle this within one query. Here is one of the ways of accomplishing this:
UPDATE T1 SET C1 = tempt2.C1
FROM T1 INNER JOIN
(SELECT DISTINCT t1ID, SomeFunction(t2.C1) AS C1
FROM T2 WHERE t2.c1 fulfills some criteria
) AS tempt2 ON t1.ID = tempt2.t1ID
Now, the sub-query will produce a temporary table that contains a single corresponding row for each row on T1 and it also contains the value with which we need to update column C1 on T1. This is based on the assumption that SomeFunction(t2.C1) generates the same value for all rows in T2 that are related to the same row on T1.
With small tweaks in the sub-query you can use this solution for all scenarios when you need to restrict the number of rows that are returned from a one to many JOIN.
Note: don’t forget to try our cool SQL Tools and remember that when you follow us on Twitter http://twitter.com/xsqlsoftware and “like” us on Facebook http://www.facebook.com/xsqlsoftware you will get a complimentary 12 months upgrade subscription when you purchase any of our products.
The first thing that comes to mind is a simple update like this:
UPDATE T1 SET C1 = SomeFunction(t2.C1)
FROM T1 INNER JOIN T2 ON t1.ID = t2.t1ID
WHERE t2.c1 fulfills some criteria – we need this since not all the rows on T2 contain the values we need.
The problem with this is that it keeps needlessly updating T1 rows as many times as it finds corresponding rows on T2. For each row on T1 we need to pick only one of the corresponding rows from T2 that fulfills the criteria. One option would be to use a cursor, but we want to avoid using a cursor and handle this within one query. Here is one of the ways of accomplishing this:
UPDATE T1 SET C1 = tempt2.C1
FROM T1 INNER JOIN
(SELECT DISTINCT t1ID, SomeFunction(t2.C1) AS C1
FROM T2 WHERE t2.c1 fulfills some criteria
) AS tempt2 ON t1.ID = tempt2.t1ID
Now, the sub-query will produce a temporary table that contains a single corresponding row for each row on T1 and it also contains the value with which we need to update column C1 on T1. This is based on the assumption that SomeFunction(t2.C1) generates the same value for all rows in T2 that are related to the same row on T1.
With small tweaks in the sub-query you can use this solution for all scenarios when you need to restrict the number of rows that are returned from a one to many JOIN.
Note: don’t forget to try our cool SQL Tools and remember that when you follow us on Twitter http://twitter.com/xsqlsoftware and “like” us on Facebook http://www.facebook.com/xsqlsoftware you will get a complimentary 12 months upgrade subscription when you purchase any of our products.
Subscribe to:
Posts (Atom)