Quest Releases TOAD for SQL - Freeware!
Quest Software has recently released TOAD for SQL Server, a freeware version of its highly popular Oracle tool - TOAD
Quest Software has recently released TOAD for SQL Server, a freeware version of its highly popular Oracle tool - TOAD
Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app.
We've run contests from time to time over the past couple years and had a lot of fun doing it. This time we're trying something new, partnering with Red Gate. Lots of good prizes on this one!
Chris (one of our regulars!) installed Log Explorer and took it for a test drive. Written up in our standard review format this will give you a very quick overview of what the product does.
Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.
Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.
This article demonstrates that one way to optimize the data access portion of your app is to do the query once and cache the results. This is not advanced caching just something to get you started thinking about the possibilities.
Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.
In this short article that follows up on an earlier one that discussed dependency issues we have some code that will generate simple treeview type view of the relationships between procs. Mostly code, more so than usual, but we thought you might find the idea useful!
You point this application at a database and it generates a code unti that allows you to easily execute stored procedures and functions from Delphi. (Not Reviewed)
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers