Where Do I Want To Go Today? - Real Time Defragging
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
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)
Altering Replicated Tables (SQL 2000)
Changing a replicated table in SQL 7 was a lot of work. SQL 2000 offers some help, but in many cases it's not enough. This article by Andy Warren shows you which changes SQL 2000 will help you with and which ones it won't.
AutoCode - Beta Release of SQL Editor
The authors of the application are offering a 30% discount off of the release price to those that participate in the beta cycle. Feature list includes autocomplete, db comparison and reconciling, and point/click constraint generation. (Not reviewed)
Using Built in Functions in User Defined Functions
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
Review of Murachs SQL for SQL Server
Andy rates this one 4.5 out of 5 stars and likes it enough to recommend it's use at work. This is a book that should teach a developer how to use the key abilities of SQL. If you're looking for a book to guide your beginning/intermediate developers, this might be it.
What Your SP Can Return
Return values from stored procedures (not output params, true return values) probably aren't used as often as they should be. Robert gives you some good examples of how to use them.
DBMS vs File Management System
This is a high level article that compares the use of a DBMS with file management systems. Interesting to think about products that use the file system successfully - not everything needs SQL...or does it?
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.
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)
Blogs
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
repeat results without loops, MSSQL2005 Express
hello everybody, new here and this is my first question I have a table...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers