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 > Management Tools


Search:
What's New - What's Hot
SQL Server 2005 Data Modeling Tools     
Total Hits: 216  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Rarely do we (Developers and DBAs) have sufficient time for our projects and every day tasks. So when it comes to building a new system, inevitability what happens is time is limited and individual tables end up being built instead of a comprehensive data model. As the system grows, we hope that the front end code is correct and keeps the data related, but when you have a data problem it may take hours to check and validate that the data is correct. So how can we break this cycle and migrate ...

Finding SQL Server Code Errors using Query Analyzer and a Double Click     
Total Hits: 239  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When dealing with large scripts it is sometimes difficult to find all errors in your code prior to executing the code. You can review the code and look for syntax issues as well as do searches to make sure the code is intact, but when dealing with a large amount of code some problems are sure to surface. By using Query Analyzer or a query window in SQL Server Management Studio to parse your query to determine if there are any syntax errors is a great step to ensure your code will work when exec...

Comma Delimited Result Sets in SQL Server 2005 Management Studio     
Total Hits: 213  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

How can I return a comma delimited result set with my queries? I am currently using SSIS to be able to generate a comma delimited result set to a text file, but this is just over kill. I thought about using the graphical result set and then massaging the data in Excel or just stringing the results together with a comma, but this just seems like the wrong approach. What is the best way to return a comma delimited result with SQL Server 2005 Management Studio? Although those other options do wo...

Accessing the Windows File System from SQL Server     
Total Hits: 451  |  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?...

SQL Server Task Management Best Practices     
Total Hits: 143  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

Do you feel like all of your projects are going in circles with little progress being made on a weekly basis? Do these projects prevent you from working on the latest and greatest technologies? If so, consider taking the first step in trying to move forward with your projects in a more straight forward manner....

SQL Server Command Line Tools To Manage Your Server     
Total Hits: 195  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

There are several useful commands and functions that are available in SQL Server, but not knowing what they are or where to find more information about them is sometimes a problem. Having these commands at your fingertips is very helpful when trying to solve a problem or for just doing general analysis on your database instances. Following is a list of useful commands that can be run using Query Analyzer. A lot of this information can be retrieved using Enterprise Manager, but it is often fast...

SQL Server 2005 Management Studio Query Designer     
Total Hits: 270  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

When writing queries I either need to reference an existing data model or visualize the tables in my head in order to complete my query. Does a visual query tool exist in the SQL Server 2005 tool set? If so, how can I access it and use it to streamline my development process? The SQL Server 2005 Management Studio ships with Query Designer which in a nutshell is a visual querying tool to build SELECT statements. (*** NOTE *** - This tool was available in SQL Server 2000 from Enterprise Manager...

Using Visual Studio 6.0 Database Tools with Microsoft SQL Server 7.0     
Total Hits: 222  |  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...

EMS MySQL Manager  Version: 3.1     Price: $135.00 / Free Trial  
Total Hits: 698  |  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....

SQL Server Business Intelligence Software Package     
Total Hits: 1353  |  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....

PremiumSoft MySQL Studio  Version: 4.6     Price: $64.00 / Free Trial  
Total Hits: 563  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

PremiumSoft MySQL Studio is a set of graphical database management, reporting and monitoring tools for MySQL database systems. ASP developers or webmasters would makes it easier than ever to manage your MySQL database...

OmniView   Price: $49.00  
Total Hits: 380  |  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...

How to: Initiate Synchronization Between Local and Remote Databases  Version: 0.00     Price: $0.00  
Total Hits: 88  |  Today: 0Author: Microsoft Corporation      Rating:  
Read Reviews | Write Review |  Your Rating: 

After you add a Local Database Cache and provide configuration information in the Configure Data Synchronization dialog box, you must still add code to your application to actually synchronize the local and remote databases. Initiate synchronization by calling the Synchronize method of a SyncAgent....

Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1     
Total Hits: 153  |  Today: 0Author: Narayana Vyas Kondreddi      Rating:  
Read Reviews | Write Review |  Your Rating: 

In a previous review, I looked at SwisSQL SQLOne Console from AdventNet, that converts SQL statements from one SQL dialect to another. That's a generic SQL Converter and supports conversion to and from Microsoft SQL Server, Sybase, Oracle, IBM DB2, Informix, MySQL, PostgreSQL and ANSI SQL. Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates th...

SQL Server Health and History Tool     
Total Hits: 226  |  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: 246  |  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: 227  |  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 ...

SQL Server 2005 Peer to Peer Replication     
Total Hits: 208  |  Today: 0Author: Edgewood Solutions Engineers      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2005 has a lot of new features and sometimes these new additions are overlooked as a new way of configuring and managing your SQL Server environment. One of these new features is Peer to Peer transactional replication. In the past, people have used transactional replication for load balancing, to keep a read only version for reporting purposes or possibly for a failover solution. With Peer to Peer replication all of these tasks are made much simpler, because all nodes act as both a...

Dynamic stored procedure execution form in SQL Server 2005 Management Studio     
Total Hits: 230  |  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...

SQL Server 2005 Row Versioning-Based Transaction Isolation     
Total Hits: 175  |  Today: 0Author: Kimberly L. Tripp, Neal Graves      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications....



Disclaimer - Privacy
© 2002-2017 DevASP.net