Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Applications > SQL > Development Tools


Search:
What's New - What's Hot
SQL Server statements currently running with fn_get_sql     
Total Hits: 228  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you have ever had the need to troubleshoot current processing that is occurring on your SQL Server there are a few different ways to see what is going on. These options include:
1. using Enterprise Manager and looking at current activity
2. using the system stored procedures sp_who2 or sp_who
3. or maybe querying the system tables directly
Using any of these methods allows you to see which connections are currently active as well part of the statement that is currently r...

AdventNet SwisSQL - SQLOne Console  Version: 1.9.3     Price: $145.00 / Free Trial  
Total Hits: 297  |  Today: 0Author: Susan      Rating:  
Read Reviews | Write Review |  Your Rating: 

AdventNet SwisSQL offers SQLOne Console, an easy to use Graphical user interface tool to convert SQL queries from one dialect to another. DB Administrators and developers working with multiple databases can just type a query in one SQL dialect and view the equivalent query in different databases’ dialects. It supports Oracle, MS-SQL Server, DB2, Informix, Sybase, MySQL, PostgreSQL and ANSI-SQL SQL dialects.The product is available in both Java and Visual Basic Editions....

Streamlining SQL Server Documentation     
Total Hits: 225  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I work for a company that has auditing requirements and with those auditing requirements comes the need to document the environment, specific processes and policies in our organization. I read your Defining and Establishing SQL Server Policies and Procedures tip and found that it was a help with the policies that we needed to have for the audit. Although document is not a very exciting topic, it is something that I need to do for my job and for my organization to meet compliance. If we do not...

Common SQL Server Development and Administrative Issues     
Total Hits: 121  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Blunders, mistakes, absent mindedness, being over extended - you name, it happens. Whether it happens to you or someone on your team, the repercussions can be severe. Over most people's careers you have seen issues to a varying degree of severity. To me the biggest blunder is knowing that a problem exists and either ignoring it or procrastinating on the implementing the resolution. Do not be upset when the problem strikes and you have to drop everything you are doing to fix an issue that cou...

Automate SQL Server Testing with Profiler, SQLCMD and SQL Server Integration Services     
Total Hits: 230  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of the Edgewood Solutions team members recently spoke at a testing conference held in Washington, DC by the name of Verify. During the presentation, a few different questions were asked about automating database testing with the native SQL Server 2005 tool set. In this tip, we will outline some options to automate database testing and verification with Profiler, SQLCMD and SQL Server Integration Services. Conducting thorough testing of a database driven application or automated (database) ...

Overview of the Analysis Services Development and Management Environments     
Total Hits: 107  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 introduces a rich set of tools, supporting the development and management of Business Intelligence applications. This includes applications utilizing Analysis Services (OLAP and Data Mining), as well as Reporting Services and Data Transformation Services (DTS). This paper provides an overview of the various environments for users who develop or manage OLAP or Data Mining applications. It does not provide details of all the different designers hosted within these environments. The...

dbQwikEdit  Version: 2.5     Price: $39.00 / Free Trial  
Total Hits: 283  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

dbQwikEdit is a all purpose SQL tool for webmasters and programmers. Simple enough for the novice but powerful enough for the SQL expert....

SQLDBCompare  Version: 2.0     Price: $99.00 / Free Trial  
Total Hits: 428  |  Today: 0Author: Best SoftTool, Inc.      Rating:  
Read Reviews | Write Review |  Your Rating: 

The powerful database schema comparison and synchronization tool for SQL Server database. It compares either an individual object or the entire database objects within two databases, and also synchronizes the database objects from one database to the other....

Building a Blog Server with SQL Anywhere and Wordpress     
Total Hits: 167  |  Today: 0Author: Jason Hinsperger      Rating:  
Read Reviews | Write Review |  Your Rating: 

In this article, we are going to cover the basics of how you could migrate any PHP database application to SQL Anywhere. SQL Anywhere is a small-footprint, self-managing, fully functional relational database that provides all of the features of an enterprise database, but can run on commodity hardware with a minimal amount of administration. In addition, SQL Anywhere offers robust, high performance, bi-directional synchronization that allows you to easily integrate your SQL Anywhere database app...

SQL Effects Clarity - Diff Tool - Free Eval Download  Version: Release 1.     Price: $139.00 / Free Trial  
Total Hits: 182  |  Today: 0Author: SQL Effects      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Effects Clarity is a unique MS SQL Server database comparison tool. It features a unique side by side GUI results analysis display and has extensive and flexible comparison options, Reports and results export. Free evaluation....



Disclaimer - Privacy
© 2002-2017 DevASP.net