Embarcadero Releases New Eclipse SQL Development Tool

Following on its recent series of announcements of key hires from the Eclipse community, Embarcadero is debuting its new professional-grade SQL development tool, PowerSQL, today at EclipseCon 2008. PowerSQL dramatically improves productivity for Eclipse application developers charged with SQL development.

"With the growing sophistication of J2EE, Ruby on Rails and other development frameworks increasingly dependent on databases, application developers require more depth in knowledge and tooling for the underlying DBMS technologies," said Greg Keller, vice president of product management, Embarcadero Technologies. "PowerSQL brings developers what they expect in an IDE with tremendous depth equaling hundreds of man-years worth of experience in database SQL parsing, connection, debugging and general optimization to produce high-performance SQL."

Embarcadero PowerSQL, the company's fourth tool built on the Eclipse framework, is a SQL IDE (Integrated Development Environment) that can be installed as a standalone application (Eclipse RCP) or as an Eclipse plug-in. It offers native support for Oracle, Microsoft SQL Server, Sybase and DB2 for LUW, as well as JBDC support for other prominent DBMSs such as MySQL. PowerSQL runs on both Windows and Linux operating systems. Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with databases.

"We are seeing an upsurge in the number of traditional developers who are taking on more database work and using SQL on a somewhat regular basis," said John F. Andrews, president and CEO of Evans Data Corporation. "In fact, according to research we conducted in September 2007, SQL is the second most popular language among Eclipse users, with 64 percent using it at least some of the time."

Features of the new Embarcadero PowerSQL tool include:
• SQL Code Assist ensures 100% object name accuracy, even when not connected to a database, plus real-time SQL syntax validation
• SQL Project Insight provides project-level SQL file cataloging and search features to help streamline project organization and maintenance
• Migration Wizard imports data sources from Eclipse DTP (Data Tools Project) or Quest TOAD
• Data Source Explorer enables users to easily navigate, search, extract DDL, execute commands, and even browse an outline view without opening the SQL file
• Formatting Profiles ensure consistent, quality code layout for easy review and extension. Profiles can be customized and shared.

"Embarcadero continues to deliver on its commitment to Eclipse," said Mike Milinkovich, executive director, Eclipse Foundation. "By bringing new Eclipse-based tools to market like PowerSQL, more developers are able to experience the many benefits offered by Eclipse. Embarcadero is a great example of a company that is providing innovative solutions to the Eclipse community."

Pricing and Availability
Embarcadero PowerSQL is now available in three versions worldwide: Personal, Standard and Professional. North American pricing for Personal Edition begins with annual subscription-based options as low as $8.25 per month per developer. Embarcadero PowerSQL can be purchased online at www.embarcadero.com/store. For more information, visit www.embarcadero.com/products/powersql.

About Embarcadero Technologies
Embarcadero Technologies, Inc. delivers professional grade database tools that companies use to design, develop and manage databases and the data they contain. More than 12,000 customers worldwide and over 90 of the Fortune 100 rely on Embarcadero's cross-platform tools to reduce complexity, improve productivity and strengthen security. The company's flagship database tools include: ER/Studio, DBArtisan, Rapid SQL and Change Manager. Founded in 1993, Embarcadero Technologies is headquartered in San Francisco with offices in Melbourne, Australia, Munich, Germany and Maidenhead, United Kingdom. For more information, visit www.embarcadero.com.

Embarcadero, the Embarcadero Technologies logos and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.

Source: PRWeb

How to Use SQLXML to Retrieve Data from SQL Server Database

Using SQL Server 2000 and above versions you can retrieve data from SQL Server in XML format directly from the database. Many XML related features were incorporated in the SQL Server database. This enables the development of XML enabled applications very easy and it makes exchange of data over internet easy. In this article we will discuss about how to use SQLXML to retrieve data directly from SQL server database in XML format.

There are some SQL commands and clauses that help you to retrieve data from the SQL Server in the XML format. Syntax for such is given below:

SELECT ... FOR XML mode [, XMLDATA] [, ELEMENTS] [, BINARY BASE64]

There are different modes and that take the values of

• AUTO – In this mode every row of the result of the query forms an element in the returned XML document.
  
• EXPLICIT – This mode defines how to map the columns of the results returned by the query to the XML elements and the attributes.
  
• RAW - All the fields of the result are identified as attributes of an element.
  
• NESTED – The result of this mode is the same as the AUTO mode but the formatting has to be done at the client side.

A simple example of using the above syntax is given below:

SELECT TOP 3 * FROM (SELECT FirstName+' '+LastName as Name FROM Employees) FOR XML AUTO

The query produces this result:

Employees Name="John Peter"
Employees Name="Andrew Dixon"
Employees Name="Tom Hanks"

There are optional parameters in the ‘FOR XML mode’ clause. The XMLDATA option adds an XSD schema which describes the XML format of the result returned. The ELEMENTS options make the fields of the tables in the database to be returned as child elements. If the ELEMENTS option is not there the fields of the tables are returned as attributes instead of child elements of the XML document. The ELEMENTS option is allowed only in the AUTO mode. The BINARY BASE64 option is used to retrieve any binary data. The returned binary data is returned in BASE64 encoded format. The binary data can be retrieved in the RAW or EXPLICIT mode.

An example of the RAW mode is given below:

SELECT EmpName, EmpCity from EMP for XML RAW

The above code returns a result like,

row EmpName=”John” EmpCity=”New York”

In the above result you can note that the fields of the resultset are returned as attributes of the element.

.Net provides with managed classes for interacting with SQL Server. The managed classes of SQLXML provided by .Net are:

• SqlXmlCommand – This is used to perform queries that are stored in XML documents which are also called XML templates. This class also provides support for client side XML processing.
• SqlXmlParameter – this is used to provide parameterized values and is used along with SqlXmlCommand object.
• SqlXmlAdapter – this is the adapter class for SQLXML provider. This is used to fill the dataset.
• SqlXmlException – this is used to trap the error information from the SQL Server.

A sample code using the managed classes is given below. For detailed information on the usage of the above managed classes you can refer to the MSDN documentation.

static string cstr = "Provider=SQLOLEDB;Server=(local);database=EmpPersonal;";

public static void testingSqlXml () {

   Stream oStr = Console.OpenStandardOutput();

   SqlXmlCommand sqlcmd = new SqlXmlCommand(cstr);

   sqlcmd.Root = "Employees";

   sqlcmd.CommandType = SqlXmlCommandType.Sql;

   sqlcmd.CommandText = "SELECT EmpName, EmpCity FROM Employees FOR XML AUTO";

   strm = sqlcmd.ExecuteToStream(oStr);

   oStr.Close();

}

Thus we have seen that SQLXML can be used to retrieve data directly from the SQL Server in XML format. It is easy to handle and transmit data through the internet if it is in the XML format and this can be easily achieved using the SQLXML.

Want to stay current with the latest technology developments realted to XML. Visit Free XML Tutorial to get your FREE subscription now!

Intro to Parameters and Parameterized Reports in Sql Server Reporting Services

You often need more advanced reporting such as drop down lists and the ability to use parameters when working in Sql Server Reporting Services. This first video in the series will give a great introduction of how to work with parameters in Sql Server Reporting Services, as well as get you started with working with parameters by briefly demonstrating how to create a drop-down list for managing your parameters.

Choosing Between Views, Functions,and Stored Procedures in SQL

This instructional video will continue comparing Views, Functions, and Stored Procedures in SQL and present you with the correct option for your task at hand.

Intro to Using Variables in SQL Server Integration Services

Variables are a very flexible addition to the SQL Services Integration Services package that store values for passing data from Task A to Task B. In this essential introduction to the world of variables in SSIS, Scott will show you how to get started using variables in Integration Services, both directly and indirectly within certain tasks like the script task or the Execute SQL, as well as show you the many things in SSIS they actually can do. Many find that variables are a worthwhile subject for enhancing your SSIS knowledge and this video series will help you to do just that!

How to Save an Image in a SQL Server Database

Most of the web applications have a lot of images used in it. These images are usually stored in a web server folder and they are accessed by giving the relative path to the file with respect to the root folder of the website. .Net being the platform for distributed application now, ASP.Net can be used to store images that are small to be stored in a database like SQL Server 2000 and later versions. For this purpose the SQL Server database provides a data type called “image” which is used to store images in the database.

To access these images stored in the database we will be using the ADO.Net classes. To find out how to insert and retrieve an image in to the SQL Server database, you can create a .aspx page which can have a HTMLInputFile control which is used to select the image file that is to be saved in the database. You can also create a textbox control in which you can add the image name or some comment or an image id for the image saved. Use a button control to upload the image to the database. Namespaces like System.Data.SqlClient, System.Drawing, System.Data, System.IO, and System.Drawing.Imaging are used in this task.

In the OnClick property of the button you can write the following code to upload an image to the database.

// create a byte[] for the image file that is uploaded
int imagelen = Upload.PostedFile.ContentLength;
byte[] picbyte = new byte[imagelen];
Upload.PostedFile.InputStream.Read(picbyte, 0, imagelen);

 



// Insert the image and image id into the database
SqlConnection conn = new SqlConnection(@"give the connection string here...");

 



try
{
   conn.Open ();
   SqlCommand cmd = new SqlCommand ("insert into ImageTable " +
                                    " (ImageField, ImageID) " +
                                    " values (@pic, @imageid)",
                                    conn);
   cmd.Parameters.Add ("@pic", picbyte);
   cmd.Parameters.Add ("@imageid", lblImageID.Text);
   cmd.ExecuteNonQuery ();
}
finally
{
   conn.Close();
}

You can also write the above code in a function and call that function in the OnClick event of the upload button. The code given above performs the following steps in the process of inserting an image into the database.

1. Get the content length of the image that is to be uploaded
2. Create a byte[] to store the image
3. Read the input stream of the posted file
4. Create a connection object
5. Open the connection object
6. Create a command object
7. Add parameters to the command object
8. Execute the sql command using the ExecuteNonQuery method of the command object
9. Close the connection object

To retrieve the image from the SQL Database you can perform the following steps.

1. Create a MemoryStream object. The code can be something like, MemoryStream mstream = new MemoryStream ();

2. Create a Connection object

3. Open the connection to the database

4. Create a command object to execute the command to retrieve the image

5. Use the command object’s ExecuteScalar method to retrieve the image

6. Cast the output of the ExecuteScalar method to that of byte[] byte[] image = (byte[]) command.ExecuteScalar ();

7. Write the stream mstream.Write (image, 0, image.Length);

8. Create a bitmap object to hold the stream Bitmap bitmap = new Bitmap (stream);

9. Set the content type to “image/gif” Response.ContentType = "image/gif";

10. Use the Save method of the bitmap object to output the image to the OutputStream. bitmap.Save (Response.OutputStream, ImageFormat.Gif);

11. Close the connection

12. Close the stream mstream.Close();

Using the above steps you can retrieve and display the image from the database to the web page.

You can use these algorithms and take advantage of the “image” data type available in the SQLServer 2000 database to store small images that correspond to a particular record in the table of the database. This method of storing avoids the tedious task of tracking the path of the web folder if the images are stored in a web folder.

Visit A Guide to .NET for a complete introduction to .NET framework. Learn about ASP.NET, VB.NET, C# and other related technologies.

Learn SQL Server Integration Services Using Visual Studio 2005 with new book from Packt

Specialist IT publisher Packt is pleased to announce a new book which teaches SQL using Visual Studio 2005. It is a step-by-step, hands on guide into the Visual Studio 2005 Integrated Development Interface. This book will help users understand how Business Intelligence Projects and Packages are created using the Visual Studio designer.

Sql Server Integration Services (SSIS) is a comprehensive ETL tool that made its debut with SQL Server 2005. It is an improved tool tightly integrated with the Visual Studio 2005 having all the functionalities that its forerunner DTS (Data Transformation Services) had in SQL Server 2000.

Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 provides users with the basic knowledge needed before moving on to more advanced ETL [Extraction, Transformation, and Loading]. In each chapter users will get a background of the SSIS task that they are going to create. The book will also provide users with a comprehensive description of the many designer windows that they may encounter while working with the designer.

This book is written for beginners in the developer track who are looking to get an exposure to SQL Server Integration Services; DBA's who are testing water with the Visual Studio IDE but without a wide programming experience and SQL 2000 Data Transformation Services users who are trying to move into SQL Server 2005 Integration Services.

This book is out and is available from Packt. For more information about this book, please visit: www.packtpub.com/sql-server-integration-services-visual-studio-2005/book

Disaster Recovery for Microsoft SQL Server 2005

Learn about expanded SQL Server 2005 database mirroring capabilities from EMC's Chad Sakac, senior practice manager for databases and messaging. And see how EMC RecoverPoint solutions—with consistency technology, compression, and continuous data replication—can help your SQL Server 2005 environment survive a total site disaster.

SQL Server Disk Optimization

Since the release of SQL Server 2005, companies have been investing heavily in SQL Server for their business-critical applications. DBAs are now challenged with supporting ever-growing datasets and making efficient use of allocated disk space in both production and enterprise storage environments. Yet DBAs seldom have a clear picture of their data storage and therefore cannot determine whether they are getting a worthwhile return on their storage investment or if an out-of-disk situation is looming.

In this presentation, Kevin will address these challenges and explore methodologies to help you efficiently use allocated disk space for enterprise storage and production environments.

Database Change Tracking for Microsoft SQL Server

It has often been said that the only constant is change. For the dynamic enterprise this means significant IT challenges in managing your application database environment. Often, a database system that was performing well yesterday experiences a significant performance problem the next day. What changed?

This webcast will discuss:
- Changes that occur in a database environment
- Impact of those changes on database performance
- Resolving problems to improve availability, reliability, and performance of the database system

How Do I Know When to Use a JOIN or UNION

So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.

SQL Server Database Backup and Recovery

Ask The Expert: Everything you wanted to know about SQL Server Database Backup and Recovery, but were afraid to ask.

This archived webcast features Quest Product Manager, Bob Boule, leading an open forum on Backup and Recovery for SQL Server databases, giving the audience a chance to ask questions or discuss anything regarding backup and recovery.

AquaFold Releases Enterprise Sybase, MS SQL, Oracle, Server Database Administration Tools for Windows, Linux and OSX

AquaFold, Inc. has released Aqua Data Studio 6.5, a powerful upgrade to its already versatile, multi-platform application that provides complete database administration and query tools for Oracle, DB2, Microsoft SQL Server, MySQL, Sybase, Informix, and PostgreSQL on Linux, OSX and Windows. Within this single application, database managers can save time and money in the design, development and maintenance of enterprise relational databases.

Version 6.5 includes new Source Control Support for Subversion and CVS. With Source Control, multiple users can store, check in and update scripts and other files from within Aqua Data Studio, eliminating the need for other versioning software. This will free system memory, and create a more efficient server update process. ADS also now has a SQL Debugger for Sybase and Oracle which allows users to locate and eliminate problems in SQL statements, eliminating the rigorous searching usually required to locate and correct errors in Sybase and Oracle.

One of the most powerful new features added to the Query Analyzer is its Excel supported Grids, Pivot Grids and Graphs/Charts which allow the grouping and summarizing of selected columns and rows of data into reports. Pivot Grids and Graphs display on multi-level split-panes which allow full control over size configurations persisting over multiple runs of the same query in the same query panel. Their configurations are saveable and reloadable into existing pivot tables for quick and efficient access later. The results can be visualized in three dimensional, fully rotatable graphs, and can be exported directly to, and from, Excel.

Version 6.5 includes a complete set of enhancements for Schema, Directory and File difference tools, including Object Permissions, Filtering by File Size, Background Processing, Refresh, Data Compare, Save as HTML, Preview in Browser, Difference Count and, for File Diff, the ability to Drag & Drop files into the tool. There is also a new Results Difference tool which gives users the ability to view differences between two result sets obtained from either the same or two different queries. The Results Difference tool also allows users to view where columns and rows have been added or deleted and where cells have been edited in different result sets.

In addition, there is now support for auto-completion across multiple databases which allows users to complete a table in a database other than the one they are currently working in. Users can now share the autocompletion schema data across different query windows through the new Global Auto Completion Cache which increases speed by minimizing memory consumption. There are a variety of client side command enhancements which are supported by Query Analyzer scripts, and a new Morph to Delimited List which allows users to convert a block of text into a delimited list with the appropriate options for completing a query or other documentation.

Aqua Data Studio 6.5 is available for immediate download at http://www.aquafold.com/downloads.html A complete list of new features and descriptions may be viewed at http://www.aquafold.com/features_6_5.html The cost of a single-user commercial license is $399(USD). Multi-license purchase discounts are also available and can be viewed here http://aquafold.com/licensing.html

About AquaFold, Inc.
AquaFold, Inc. is a provider of software tools for relational databases. More than 300,000 users from over 90 different countries use AquaFold's products to design, develop and administer databases in Oracle and other popular programs. For more information visit http://www.aquafold.com

Source: PRWeb

Avoiding Commond Data Modeling Mistakes for SQL Server

Join SQL Server MVP and President of PASS, Kevin Kline as he:

• Identifies the issues that can arise from relying only on modeling tools
• Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical
• Describes how to correctly identify and resolve serious problems
• Provides best practices to resolve issues

How to Build an Index for SQL Server

If you're tired of your database-driven website taking "forever" to load or you just want to understand how to add an index to a database table you must watch this video. By using an index you can often speed up your database queries by 5, 10, even 50 times! What are waiting for?

Maximize SQL Server Performance with SQL Tuning

This presentation will help you understand Microsoft tuning techniques. It will teach tips and tricks for making queries perform better, and how to use tools to tune SQL.

SQL Farms, Inc Releases Software Packaging and Remote SQL Server Code Deployment Solution for ISVs

SQL Farms, Inc. announced a new database code packaging and remote deployment solution to help software vendors ship projects and deploy database code changes at customer sites, without requiring any remote installations. The new technology is part of SQL Farms' redistributable components and license offerings, which enable ISVs and virtualization providers to deploy updates and collect data from all SQL Server instances and databases in remote networks and data centers.

With SQL Farms' remote deployment solution, software vendors can now develop database code in-house, embed the code in their software releases, and then use SQL Farms' components in their installation packages and software products to automatically push changes to multiple SQL Server databases and instances in remote IT environments. Additional features ALSO allow ISVs to collect data and obtain deployment results from customer sites for verification and debugging purposes.

"In the last six months we were contacted by leading software vendors that heavily rely on Microsoft SQL Server in their product offerings, who asked us to help them push database changes to remote sites," said Dr. Omri Bahat, co-founder and CEO of SQL Farms. He added, "SQL Server environments are growing at a vast rate. Some software vendors use a single database for their application while others use an entire farm of databases and servers. Our new technology offers simple, intuitive, and fully automated deployment solutions that covers all deployment needs and cases, from deploying code to one database on a single client machine to hundreds or thousands of databases and servers across the network."

The redistributable components and licensing are available as part of SQL Farm Combine 1.9, the latest release of SQL Farms' flagship product. Additional redistributable features include agent-less data retrieval and distributed querying capabilities in remote environments, as well as collection of performance metrics from all SQL Servers and instances in remote IT sites and data centers.

About SQL Farms:
SQL Farms, Inc. is a leading provider of tools and frameworks for working with many databases and servers. SQL Farms products are focused on database management, administration, and deployment in mid-size to very large SQL Server environments and data centers. Key features of SQL Farms products include distributed deployment of changes to all databases and servers, collection of data and performance metrics from all servers through distributed querying capabilities, and deployment of admin changes to multiple databases and servers in parallel. SQL Farms tools are based on patent-pending technologies and do not require any remote agents or installations. For additional information please visit SQL Farms website at http://www.sqlfarms.com

Source: PRWeb

Idera Improves SQL Server Database Performance with Solution for Automated Defragmentation

Idera, a leading provider of management and administration solutions for Microsoft SQL Server environments, today announced the availability of SQL defrag manager 1.2. The first and only product of its kind, SQL defrag manager continuously analyzes SQL Server fragmentation levels, pinpoints fragmentation hot spots, and intelligently defragments SQL Server tables and indexes automatically or on demand – providing improved and more consistent SQL Server database performance and response times.

Over time, as data is inserted, updated, and deleted, databases become fragmented – a condition that adversely affects database performance, especially in large scale SQL Server environments. Fragmentation ranks as one of the top causes of poor database performance, yet the task of defragmentation is often neglected because it can be extremely time-consuming, labor-intensive, and often must be done in off-hours to avoid service interruption.

“SQL defrag manager is the first and only product that intelligently and safely automates the process of SQL Server database defragmentation,” said Rick Pleczko, President and CEO at Idera, “It significantly increases DBA productivity by reducing the time spent finding and remediating fragmented tables and indexes and ensures the performance and availability of critical SQL Servers.”

“One of the most difficult tasks in my day to day operations has been to maintain index optimization.” commented Mike Flanagan, Senior DBA with Aries Systems Corporation, “SQL defrag manager allows me to configure automated index maintenance based on the fragmentation level of the individual indexes. The maintenance process runs each night, takes a fraction of the time it used to and has very little load impact. I find SQL defrag manager to be an indispensable tool in my day to day duties as a DBA.”

Key features and benefits provided by SQL defrag manager include:

• Improved SQL Server performance: SQL defrag manager continuously monitors fragmentation levels and takes automated action to resolve fragmentation issues, resulting in better, and more consistent database performance.
• Automatic Analysis: SQL defrag manager automatically analyzes index and table fragmentation levels to quickly pinpoint “hot spots” or areas where performance is severely hindered.
• Customizable Remediation: SQL defrag manager offers three easy options for performing SQL Server defragmentation:

Automated: Performs automatic remediation according to user-specified parameters and fragmentation levels.

Semi-automated: Performs automatic analysis and highlights fragmentation problem areas in a to-do list for subsequent ‘one-click’ remediation.

Manual: Initiate fragmentation analysis on demand and remediate manually as required.

• Centralized Management: View fragmentation analysis in real-time and manage defragmentation activity across hundreds of servers and thousands of databases from a central console.
• Comprehensive Reporting: Generate comprehensive reports of analysis and defragmentation activity providing proof that database performance is continuously optimized.

Pricing and Availability
SQL defrag manager is now available and is priced at $995 per SQL Server instance. More information about SQL defrag manager as well as a free, 14 day, fully-functional evaluation copy is available at: www.idera.com/products/sqldefrag

About Idera
Idera delivers a new generation of tools for proactively managing, administering, and securing the world's fastest growing database management system – Microsoft SQL Server. Battle-proven and engineered for distributed enterprises, Idera’s solutions help companies ensure database availability while also reducing tedious administrative tasks and expense. Idera’s solutions include: Security and Compliance Management, Performance and Availability Management, Backup and Recovery, and Change and Configuration Management. Headquartered in Houston, Texas, Idera’s products are sold and supported directly and via authorized resellers and distributors around the globe.

To learn more, please contact Idera at 713-523-4433 or visit http://www.idera.com/.

Source: PRWeb

Learn SQL Server 2005 with AppDev's Newest Release

AppDev recently released the SQL Server™ 2005 Power Suite for developers using or learning Visual Basic 2005 or Visual C# 2005. A major upgrade from its very successful predecessor, SQL Server™ 2000, SQL Server™ 2005 includes numerous new features and functionalities. By utilizing the AppDev SQL Server™ 2005 Power Suite developers can learn how to take advantage of these improvements and increase productivity and performance.

The SQL Server™ 2005 Power Suite includes seven courses on 66 CD’s or eight DVDs. It is also available on AppDev’s latest learning solution, KSource Online Learning™. The SQL Server™ 2005 Power Suite begins with AppDev’s exploring series for an overview of the new features and functionality of SQL Server™ and moves onto more in-depth discussion of topics including Business Intelligence, BizTalk Server and ADO.NET.

Each course is led and written by some of the most recognized names in the industry and most include hands-on labs, sample code, printable courseware, and pre/post exams.

“The AppDev SQL Server™ 2005 Power Suite is an excellent way to get up to speed with the over five years of Microsoft SQL Server™ enhancements,” AppDev President and CEO Craig Jensen said. “AppDev’s easy to follow instruction and award-winning content ensures that developers will be able to capitalize on all these SQL improvements.

AppDev is an award-winning technical learning company providing in-depth, real-world content in multiple formats. AppDev offers 80+ titles for today's latest technologies including Microsoft® SQL Server™ 2005, Business Intelligence, ASP.NET 2.0, Visual Basic® 2005, Visual C#® 2005 and more. For more information on the AppDev training or for additional training and reference resources, contact AppDev at (800)578-2062 or http://www.appdev.com.

Source: PRWeb

Restart SQL Server Services on all Network Devices and Instances in One Click

SQL Farms, Inc. announced one-click restart of SQL Server services on all network machines to assist network and database administrators (DBAs) handle automated SQL patches and multi-server configuration changes. The new features are available as part of SQL Farm Combine 1.8, the latest release of SQL Farms' flagship product, which aims to assist enterprises with large SQL Server environments and data centers.

The ability to control SQL services on all network computers eliminates the need for tedious manual work. Instead of logging to individual machines and restarting services, database managers can now easily enable automated patches and then select the servers that they wish to restart from a single client interface, without any remote agents or installations. In addition, configuration changes can be pushed to all servers in one click within the same interface and the appropriate services can be restarted to load configuration updates.

With the recent advancement in SQL Server patches, the ability to stop or start SQL services throughout the network allows DBAs to handle and monitor their servers much more effectively after patch-Tuesday and other automatic updates", said Thomas Goff, Founder and CTO at SQL Farms. He added, "DBAs can now manage, push changes, configurations, and pull status or monitoring data from multiple servers and easily manage even the largest server farms".

SQL Farm Combine 1.8 represents a recent addition in managing the data tier of modern datacenters and SQL server environments. The company also reported that new distributed management and monitoring capabilities will be avaialble in the near future as part of the ongoing frequent release plan of its award-winning user interfaces.

About SQL Farms
SQL Farms, Inc. is a leading provider of tools and frameworks for working with many databases and servers. SQL Farms products are focused on database management, administration, and deployment in mid-size to very large SQL Server environments and data centers. Key features of SQL Farms products include distributed deployment of changes to all databases and servers, collection of data and performance metrics from all servers through distributed querying capabilities, deployment of admin changes to multiple databases and servers in parallel, and more. SQL Farms tools are based on patent-pending technologies and do not require any remote agents or installations. For additional information please visit SQL Farms website at http://www.sqlfarms.com

Source: PRWeb