The system table, "sysperfinfo," is the representation of the internal performance counters of SQL Server. This article demonstrates how to retrieve and store information from "sysperfinfo" to a CSV file, so that it can be analyzed.
2004-11-30
3,347 reads
Auditing in SQL Server is something that is becoming more and more prevelant, and will likely become more regulated over time. Dinesh Asanka brings us a new article on the basics of SQL Servers most powerful auditing configuration, C2 level auditing.
2004-11-03
38,096 reads
SQL Server will autogrow your databases as they run out of space. But the process doesn't manage space, nor does it check the free space on the drive. Allowing autogrow to grow unchecked and unmanaged will eventually use up all the free disk space and potentially crash your server. New author Mark Nash brings you his system for monitoring space usage and generating a report that eases this process.
2017-02-02 (first published: 2004-07-01)
45,016 reads
Leo reviews a new product as a follow up to his recent article about Monitoring Failed Job Steps.
2004-04-12
4,445 reads
The first part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2003-12-24
16,064 reads
Log Navigator 1.0, a passive SQL auditing system that uses the SQL Server transaction log, instead of triggers, to audit data changes has been released.
2003-09-29
1,076 reads
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
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
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
This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.
2002-07-24
14,897 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers