Free SQL Functions & Stuff!
Wingenious is offering a free download of some add-in code you may find very useful! It's a subset of their DBAction product (which they you'll look at as well), but the free code is worth a look.
2003-09-24
48 reads
Additional Articles
Disaster Recovery Reporting scripts
Joe Sack returns (is back?) with some scripts you can use to log information you may need when disaster strikes.
2003-08-22
1,438 reads
Script your Data in T-SQL format
SQL Scripter is a tool for SQL Server 7.0/2000 database administrators and developers to script data in a valid T-SQL format which can be executed in Query Analyzer. All types are supported (INSERT, UPDATE, DELETE). It's free in the moment. (Not Reviewed)
2003-08-13
1,259 reads
Red Earth Technologies releases Superior SQL Builder
Red Earth Technologies announces the release of Superior SQL Builder, a new SQL tool that visually builds complete SQL scripts, not just single queries. It employs a completely different method of developing SQL scripts. By taking advantage of new scripting technology, Superior SQL Builder can visually build complete SQL scripts within a single, integrated environment. This means that SQL scripts can be developed faster, while reducing syntax and logic errors. (Not Reviewed)
2003-08-12
68 reads
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)
2003-08-11
48 reads
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)
2003-08-08
552 reads
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
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
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
MSMQ Extended Stored Procedures For SQL Server
As you might guess from the title, this is an extended stored procedure that you can use to interact with MSMQ. It's supposed to be extremely fast, able to handle 4-5k messages per second and have a very small memory footprint. (Press Release)
2003-07-17
1,310 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Forums
Looking for a Recommended Azure SQL Managed Instance Book
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
timeout in vs for ssas tabular deploy is 0 but i still timeout deploying
hi we run 2019 std but i'm testing this on 2016. following some old...
Table variable declared within cursor persists across loop iterations
If you run this code it creates a 2 row cursor loop. Within the...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers