Freeware! This add-in gives you some great extra features when working in VB6. It has a tab index setter, options to add a chunk of error handling code, a simple code analyzer that gives you some metrics, and my favorite - an option to identify unused code and variables. If you're still using VB6 it's worth trying.
This article shows how to create a trace and capture it into a table using a combination of SQL and VBScript. Direct and to the point, you can read this and try it easily.
Where should SQL Server go in the future? What enhancements are needed? Steve Jones starts to explore his wish list for future versions of SQL Server.
Bad data is almost a given, but true duplicate data can really cause you some headaches. How do you remove all the duplicates and still leave a 'keeper' record? If you think procedural code it's not too hard, but can you do a set based solution? Chris shows you show!
This is a follow up article on the database comparison they did about 18 months ago.
New author! This article has a stored procedure that will generate an HTML document - as long as the table has the proper schema. If you try it, be sure to download the associated zip which has some images and the script for the stored procedure.
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP.
Everyone uses a text editor. Whether for programming, editing configuration files, or reviewing logs. Here's a look at an inexpensive replacement for notepad that performs a number of functions that DBAs might be interested in having.
If your shop is even close to the typical Microsoft SQL Server environment there are several people that can make changes to the production environment and what's in SourceSafe does not match what's on the SQL Server. This freeware by Bill Wunder will make archiving DDL and DTS packages a piece of cake and simplify deployment of SQL Server code. Available exclusivily for SQLServerCentral.com members.
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