sql prompt

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Enhance your development experience with a free copy of SQL Prompt

Free Copy Of SQL PromptGreetings, I am trying to obtain the free copy of SQL Prompt. So how do I do obtain it?What are you having a problem with?There is a link in the article near the bottom of the page. It takes you to the company's website to download...

Tags: Programming languages, SQL Prompt, SQL

Discussion threads 2006-06-20

sql prompt

WHERE IS THE DOWNLOAD?????????????????

Tags: garynorf@..., sql prompt, windows, SQL

Discussion threads 2006-06-20

Enhance your development experience with a free copy of SQL Prompt

Arthur Fuller explains why you should download a free copy of Red Gate Software's SQL Prompt, an add-on for SQL editors Query Analyzer, Management Studio, and Visual Studio, before the offer ends. Do you ever have trouble remembering the names of hundreds of tables, views, and UDFs? Even...

Tags: SQL, Arthur Fuller, Databases, Programming languages, SQL Prompt, SQL Server Newsletter, TechRepublic Inc., Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2006-06-19

What is in your toolbelt?

As a DBA, you probably have several tools to help you in a bad spot. Have you heard of SQL Professional Toolbelt? It can be a handy addition to keep your SQL Server humming. by Steven Warren

Tags: microsoft sql server, sql, tool, sql compare, sql toolkit, sql log rescue, sql refactor, sql prompt, sql dependency tracker, programming languages, databases, software development, software/web development, enterprise software, software, data management, steven warren

Blog posts 2008-08-08

Additional Resources

Improve dynamic SQL performance with binds

Comments on Dynamic SQLThe article is helpful to gather knowledgeon Dynamic SQL.But it could have been even betterif some ideas were provided on where using Dynamic SQL could enhance the performance,instead of using normal SQL statements.Ties in with my new entry in PL/SQLThanks for a timely article. Editorally speaking, there...

Tags: arpan_d02@..., Dynamic SQL, Example 4, Example 5, software, SQL

Discussion threads 2005-04-13

Connection in Excel Pivot Tables

Hi,we are using MS SQL Server 2000 Analysis Services. Now I want to create a web site where you can access the cube database hosted on sql server. So I created a Excel workbook and published a website from it with interactivity and pivot table functionality.But when I open the...

Tags: Web site development, Web technology, Databases, Microsoft Office, addicted94@..., password, Web site, Microsoft Excel

Discussion threads 2007-11-02

SQL Server 7.0 SP4 sqlagent.exe

I have installed SQL Server 7.0 SP4 and all associated security patches on a Windows 2000 workstation. The sqlagent.exe service now runs in a command prompt that is permanently visible on my desktop. If I exit the command prompt it then stops the service. Do you have any...

Tags: Databases, SQL Server 7.0 SP4

Q&A 2005-04-12

Changing the name of your SQL Server

Have you ever had to change the name of a server that has SQL Server installed on it? If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change. 1. Open SQL...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-22

My SQL problem.

Hello,I am using My SQL 4.1. I am getting following error “conection to MySQL failed” or “too many connections” and as I restart server it started working normally. Please help me out as I host my web site here and it is not good practice to restart every time.I have...

Tags: Programming languages, Databases, vish_20083, SQL

Discussion threads 2007-10-23

Prompt a message before save records in Access

In Access 2000 or 2003, normally records are automatically saved after editing. I’ve just developed a database application using MS Access + SQL Server 2000. Colleagues say that they hope to have prompt message before saving records, so as to avoid mistaken modifications.How can I realize this in MS Access?Do...

Tags: Microsoft Office, Databases, Microsoft Access

Q&A 2005-08-16

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

This white paper details the steps involved in upgrading from SQL Server 6.5 and SQL Server 7.0 to SQL Server 2000. Microsoft SQL Server 2000 improves on the performance, reliability, scalability, quality, and ease of use of its predecessors, SQL Server 7.0 and SQL Server 6.5. SQL Server 2000 offers...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft SQL Server 6.5, Databases, Enterprise Software, Software, Data Management

White papers 2001-07-19

SQL PathFinder for Oracle (msi)

SQL Pathfinder is for Oracle SQL programmers who live in an environment where multiple versions of SQL scripts and multiple SQL execution environments exist. Pathfinder determines the SQL path that SQL Plus will use, and traces and displays all of the script dependencies for your SQL script. The dependencies are...

Tags: Oracle Corp., SQL, SQL PathFinder, Pathfinder, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-11-21

Cache Monitor (zip)

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...

Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-05-11

What is the difference between Oracle, SQL and PL/SQL?

Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...

Tags: Oracle Corp., PL/SQL, SQL

Blog posts 2006-05-30

Some resources on SQL Server 2005

Here are some helpful resources on SQL Server 2005 for those who are evaluating it and/or preparing for it: Microsoft's SQL Server TechCenter MSDN's SQL Server Development Center  SQL Server 2005 downloads SQL Server 2005 Express Edition the free version of SQL Server Free Virtual...

Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management, Jason Hiner

Blog posts 2005-11-11

Transferring SQL Server logins between servers or instances

I recently discussed how to restore a SQL Server to a new server. After the article published, I had some questions on the best way to move SQL Server logins from one SQL Server 2005 instance to another SQL Server 2005 instance. [poll=11] I...

Tags: Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management, Steven Warren

Blog posts 2007-09-25

EMS SQL Manager 2008 for SQL Server (zip)

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...

Tags: Microsoft SQL Server, Server, SQL, SQL Manager 2005, Databases, Enterprise Software, Programming Languages, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

EMS SQL Manager 2008 Lite for SQL Server (zip)

EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration. It has minimal required set of instruments for those users who are new to MS SQL server and need only it's basic functionality. EMS SQL Manager Lite for SQL Server is...

Tags: Microsoft SQL Server, Server, SQL, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-12-20

BlackBall SQL Agent (exe)

The BlackBall SQL Agent fills the gap that Microsoft Express Edition 2005 left with its ommission of a SQL Server Agent. Use the BlackBall SQL Agent to automatically backup your SQL Server database at periodic intervals, or run other arbitrary SQL commands such as executing stored procedures.Also includes email notifications...

Tags: Microsoft SQL Server, SQL, BlackBall SQL Agent, E-mail, Databases, Enterprise Software, Programming Languages, Online Communications, Software, Data Management, Software Development, Software/Web Development

Software downloads 2007-06-29

How do I run code automatically when SQL Server starts?

The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. Today, consultant Tim Chapman gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on...

Tags: Stored Procedure, Microsoft SQL Server, Server, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, John Sheesley

Blog posts 2008-11-10