SQLCentric
This is an update to v1.2 of the product which does monitoring of your SQL servers. Looks like it checks service status, jobs, disk space, some other things. (Not Reviewed)
2003-08-01
1,425 reads
Articles
SQL Server Security: Why Security Is Important
Regular columnist Brian Kelley reviews the real world impact that inadequate security can have by reviewing some recent incidents in the sql/security world. Very much worth reading, especially if you have credit card data.
2003-07-31
7,545 reads
Lots of Tables and a Little DMO
Andy discusses a recent thread where a reader has very slow login tables with 2000 tables. After writing some DMO code (very handy by the way) and creating some objects, he can't track it down. Have any ideas?
2003-07-30
7,112 reads
MZTools - Addin for VB6
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.
2003-07-30
1,541 reads
Automated Trace File Collection
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.
2003-07-29
9,111 reads
Where Do I Want To Go Today? - Upsert
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.
2003-07-28
7,978 reads
Finding and Deleting Duplicate Data
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!
2003-07-25
19,980 reads
Database Server Clash Revisited (Eweek)
This is a follow up article on the database comparison they did about 18 months ago.
2003-07-24
604 reads
Creating a Chart From a Table
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.
2003-07-23
7,771 reads
The SQL Delete Statement
New Author! Narayana has some ideas on the delete statement and how you can have a fall back plan if something goes wrong.
2003-07-22
19,602 reads
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?