By George V. Hulme – The company says it will reinforce its security efforts with better patch management, improved operating-system firewalls, and a security outreach program.
Author: SSWUG Research
Log Navigator Passively Audits SQL Server Without Triggers
LockwoodTech has released version 1.0 of Log Navigator, a SQL Server auditing tool that leverages the SQL Server transaction log to passively audit data changes without triggers. As of 25 Sept 2003, the product is being offered at a special introductory price of $599 per developer. Upgrades and supp
Using EXISTS
Many times you’re required to write query to determine if a record exists. Typically you use this to determine whether to insert or update a records. Using the EXISTS keyword is a great way to accomplish this.
SQL Server pressing Oracle on price
Oracle unquestionably is the 800-pound gorilla of database companies. But Microsoft’s SQL Server is mounting a serious challenge to the market leader.
Implementing CRUD Operations Using Stored Procedures: Part 1
By Andrew Novick – This two-part series discusses how to create stored procedures to implement the CRUD operations in SQL Server. This article concentrates on the rational behind using stored procedures and discusses many of the technical issues that are particular to SQL Server.
EMS MS SQL Manager
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 s
DB Ghost – SQLServer database change management made easy
DBGhost is a database change management system. Use to increase developer productivity by insuring code created can be delivered. DB Ghost does this by using the following features: Verify changes made to your database schema and static data. Report on all changes and errors.
Larry Ellison: Everyone Else Must Fail
By Jim Louderback – With all the hoopla surrounding Oracle, PeopleSoft and Larry Ellison, Karen Southwick’s timing couldn’t be better. Her in-depth look at Oracle’s past, present and future—focusing on Larry Ellison—is scheduled to come out in November.
Improve Results with Query Rewrite
Are you tired of waiting for your queries to return results? Have you already tried adding indexes and tuning the SQL, and still can’t improve query performance? Well, have you considered creating materialized views? With materialized views, reports that used to take hours to run can complete in min
Using Web Services to Provide Information to Remote Windows Applications
By Russ Nemhauser – This is the first of an intended two part article on using Web Services to provide information for a remote Windows application. In the article, the author shows how to create a Web service that provides information, then a Windows application that sits in the System Tray and mak