Articles

Technical Article

Red Earth Technologies releases Superior SQL Builder

Red Earth Technologies announces the release of Superior SQL Builder, a new SQL tool that visually builds complete SQL scripts, not just single queries. It employs a completely different method of developing SQL scripts. By taking advantage of new scripting technology, Superior SQL Builder can visually build complete SQL scripts within a single, integrated environment. This means that SQL scripts can be developed faster, while reducing syntax and logic errors. (Not Reviewed)

2003-08-12

68 reads

Technical Article

Log Navigator Final Beta Released

The final beta of Log Navigator has been released. This sql server auditing tool reads the MS SQL Server transaction log to track all data changes with no performance overhead or use of triggers. You can read database auditing trails from activity that took place even before the tool was installed. Powerful filters allow you to sort audit data by date, user, table and more. New features include LIVE LOG support and XML export. (Not Reviewed)

2003-08-11

48 reads

SQLServerCentral Article

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-08-01

15,787 reads

Blogs

T-SQL Tuesday #196: Taking Risks

By

This month we have a new host, James Serra. I’ve been trying to find...

The First Steps: Understanding the Basics of FinOps

By

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

By

AI is everywhere. It’s in the news, it’s being added to every product, management...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

By stan

Hi, ssms is free here.   I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens? 

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers