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
Search:
What's New - What's Hot
Listings for Backup & Restore Backup & Restore (14)
Listings for Bug Tracking Bug Tracking (7)
Listings for Data Management Data Management (25)
Listings for Development Tools Development Tools (10)
Listings for DTS DTS (1)
Listings for Management Tools Management Tools (25)
Listings for Miscellaneous Miscellaneous (12)
Listings for Query Tools Query Tools (11)
Listings for Server Management Server Management (8)
Listings for SQL Server 2005 SQL Server 2005 (11)
Listings for Synchronization Synchronization (37)
 


SQL Server Health and History Tool     
Total Hits: 222  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have heard about the SQL Server Health and History tool, but I have never used it. How long has this tool been around for? In your opinion is this a tool worth using? What sorts of functionality does the tool have to offer? What types of limitations does the tool have? Is this tool primarily intended for DBAs, Developers or Network Administrators? Where can I download a copy of the tool and what do I need to do to install it?...

SQL Server Disaster Recovery Planning and Testing     
Total Hits: 242  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

One old adage that has stood the test of time is "you will never know until you try". I would have to say that is the case with a disaster recovery plan. I would be surprised to hear any company relying on IT does not have a disaster recovery plan. Some are probably more formal than others, but in the middle of many of those plans are SQL Servers and the need to recover them quickly to maintain the business operations. But have you put your plan to the test? What about when key people are o...

Login failures connecting to new principal after failover using SQL Server Database Mirroring     
Total Hits: 223  |  Today: 0Author: Chad Boyd      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have configured Database Mirroring successfully between 2 SQL Server 2005 instances. My application is connecting to SQL Server using a SQL Server login, and is built using ADO and the SQL Native Client. My connection strings/connection settings specify the correct information, including the appropriate failover partner. I have also created all the same logins on the mirrored server as on the principal server. Upon testing a database failure, the mirror successfully assumes the principal role ...

Default Trace in SQL Server 2005     
Total Hits: 311  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

I have been running SQL Server 2005 server side traces to address some SQL Server 2005 performance issues. I have noticed an unusual trace session that is running. I know I have not been running this trace and know I have been diligent about running only a single trace to not impact performance. So where did this trace session coming from? SQL Server 2005 is running a default trace. You can think of this as a replacement to the black box mode trace that could have been run in SQL Server 2000...

Dynamic stored procedure execution form in SQL Server 2005 Management Studio     
Total Hits: 225  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

The purpose for most stored procedures is for execution within applications, but there are some stored procedures that may be used for administrative purposes and only get executed ad hoc. In addition, during testing you run stored procedures interactively to make sure things are working correctly. You have the ability to run any stored procedure directly from a query window and include the necessary parameters, but is there any easier way to know what parameters a stored procedure requires a...

Using Visual Studio 6.0 Database Tools with Microsoft SQL Server 7.0     
Total Hits: 218  |  Today: 0Author: Ninia Ingram      Rating:  
Read Reviews | Write Review |  Your Rating: 

Explains how to analyze data from different database management systems with Microsoft® SQL Server™ 7.0 and the Visual Studio® 6.0 Database Tools. (7 printed pages) With the linked server and TOP features in Query Designer you can:
* Access outside OLE DB data sources with the linked server feature.
* Limit the data you want returned by using the TOP clause.
* Improve database performance and efficiency with filegroups.
* Generate unique identifiers with the GUID data...

Accessing the Windows File System from SQL Server     
Total Hits: 447  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Within my SQL Server T-SQL stored procedures and scripts I need to find out the files in a specific directory. What are some approaches to do so? I need some flexibility to capture the file names and general information for subsequent processing. What are the native SQL Server options as well as the custom options that are available?...

EMS SQL Manager PostgreSQL  Version: 3.3     Price: $135.00 / Free Trial  
Total Hits: 716  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS SQL Manager for PostgreSQL is a powerful tool for PostgreSQL Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the latest PostgreSQL features including tablespaces, argument names in functions, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. PostgreSQL Manager has a new state-of-the-a...

EMS MySQL Manager  Version: 3.5     Price: $95.00 / Free Trial  
Total Hits: 707  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS SQL Manager for MySQL is a powerful tool for MySQL Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys, user-definable functions, transaction-safe tables, new MySQL 5 Authentication Protocol, MySQL 4.x user privilege extensions, charsets and collations support for databases and tables. It offers plenty of powerful tools for...

EMS MS SQL Manager  Version: 2.1     Price: $135.00 / Free Trial  
Total Hits: 728  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-...

EMS MS SQL Manager  Version: 1.8     Price: $195.00 / Free Trial  
Total Hits: 820  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS MS SQL Manager is a powerful graphical tool for Microsoft SQL Server administration and development. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and search metadata, export data to 15 available formats and import them from most popular formats, view and edit BLOB fields, and many more....

EMS MySQL Manager  Version: 3.1     Price: $135.00 / Free Trial  
Total Hits: 694  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS MySQL Manager is a powerful tool for MySQL Database Server administration and development. It works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features. It offers plenty of powerful tools for experienced users to satisfy all their needs. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system....

EMS PostgreSQL Manager  Version: 2.8     Price: $195.00 / Free Trial  
Total Hits: 709  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS PostgreSQL Manager is a powerful graphical tool for PostgreSQL administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, manage users and their privileges, build SQL queries visually, extract, print and search metadata, export and import data using most popular file formats, view and edit BLOB fields, and many more....

EMS IB/FB Manager  Version: 3.9     Price: $195.00 / Free Trial  
Total Hits: 733  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS IB/FB Manager is a high-performance tool for administering InterBase and FireBird. Its Graphical User Interface allows you to create/edit all InterBase/Firebird database objects in a simple and direct way, design databases visually, run SQL scripts, manage users and privileges, visually build SQL queries, extract, print, and search metadata, create database structure reports in HTML format, export/import data, view/edit BLOBs and many more....

EMS DBISAM Manager  Version: 1.6     Price: $95.00 / Free Trial  
Total Hits: 697  |  Today: 0Author: EMS Software Development      Rating:  
Read Reviews | Write Review |  Your Rating: 

EMS DBISAM Manager provides you with powerful tools for DBISAM Server administration and object management. Its Graphical User Interface (GUI) allows you to easily and simply create/edit all DBISAM database objects, run SQL scripts, manage users and administer user privileges, visually build SQL queries, extract and print metadata, export/import data, view/edit BLOBs, and supplies many more features....

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

SQLSourceSafe is the right version control solution for project teams and developers to manage their development in SQL Server. By providing an integrated console to access functions from both Visual SourceSafe and SQL Server, it offers a seamless integration of these two software. The development platform from SQLSourceSafe allows developers to create table structures, edit SQL scripts, and execute SQL queries all directly from SQLSourceSafe....

SQL Server Business Intelligence Software Package     
Total Hits: 1347  |  Today: 0Author: Rob volk      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Microsoft SQL Server™ Accelerator for Business Intelligence (SQL Server Accelerator for BI) makes it easy to build a customizable business intelligence solution from your operational data, enabling your organization to realize the power of business analytics....

OmniView   Price: $49.00  
Total Hits: 372  |  Today: 0Author: Krell Software      Rating:  
Read Reviews | Write Review |  Your Rating: 

OmniView is a general-purpose data viewing/editing utility. We built OmniView in recognition of the need for easy, powerful access to raw data in database servers. OmniView is very useful for anyone involved in database development or maintenance. DBAs and developers will find data access through OmniView quicker, easier, and more convenient than that which is provided natively with SQL Server. Technical support staff, QA teams, project managers, trainers, and others often need to directly exami...

OmniAudit   Price: $399.00 / Free Trial  
Total Hits: 355  |  Today: 0Author: Krell Software      Rating:  
Read Reviews | Write Review |  Your Rating: 

OmniAudit is a MS SQL Server auditing system which tracks any changes made to data regardless of source. You pick which tables and columns to audit and OmniAudit automatically creates triggers to log changes made to that data including the user, date/time, workstation and application used to change the data....

Bug Tracking from Red Gate     
Total Hits: 1021  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Bug tracking tools (also known as defect tracking tools, issue tracking tools or problem trackers) are used to track the bugs found in software applications. When a bug is found, a tester or quality analyst records the bug and the steps needed to reproduce it. A developer will then fix it and tell the tester it has been fixed. The tester will then check the bug has really been fixed, and close it. Project managers can then see which bugs have been fixed, which are outstanding and how long it is ...



Disclaimer - Privacy
© 2002-2017 DevASP.net