Do you get tired of reviewing each SQL Agent notifications nightly to determine which SQL Agent jobs failed? Is there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
2002-09-17
11,741 reads
Having trouble with a target server (TSX)? Steve Jones did in his environment. Read about how he worked around the issue to restore administrative capabilities.
2002-09-16
7,250 reads
This program makes it easy to add and maintain extended properties for all objects in SQL Server 2000. Where as the Query Analyzer only allows you to maintain certain object SEPE allows all object to be maintained. This product is freeware for SQLServerCentral.com members.
2002-09-13
426 reads
SQL Server 2000 Enterprise Edition clocked an incredible 308,620 transactions per minute (tpmC)1 running on Windows .NET Server 2003, Datacenter Edition on an NEC TX7 server with 32 Intel Itanium 2 processors. The NEC system sets a new performance record on Windows, nearly doubling the best published 32-bit result. In addition, this Microsoft/Intel/NEC solution delivers the best price-performance of all results on the Top Ten performance list, at just $14.96/tpmC.
2002-09-12
3,369 reads
NGSSoftware have released NGSSQuirreL, a security audit and management tool for SQL Server. Designed to ease the administrative burden of securing SQL Server, NGSSQuirreL finds the security holes then generates a lockdown script based upon the vulnerabilities found so the server can be secured in a matter of minutes; and regular audits can help keep it that way. For more information or an evaluation copy please see the NGSSite - http://www.nextgenss.com/.
2002-09-11
464 reads
During the process of performance tuning queries and stored procedures there comes a time when you will notice that the execution plan selected by SQL Server is not the best plan. On occasion, everything you try doesnt cause SQL Server to choose the best way to execute your code. These are the times when hints can improve performance.
2002-09-10
9,468 reads
It's been a year since Steve Jones last wrote about the state of the DBA job market after the economy soured. Here's an update of the last year.
2002-09-09
4,501 reads
An interesting research paper by David Litchfield on how an attacker might go about attacking your server. Definitely worth a read.
2002-09-06
532 reads
Bitwise operators can be challenging to manage at first. However, with practice and patience, and under the right conditions, these operators can provide remarkable performance improvements in production environments. This article will compare two methods of accomplishing the same output, one with a normalized model and the other with bitwise operators.
2002-09-05
12,036 reads
This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourself, if you want to be a point-and-click DBA or a T-SQL scripting expert!
2002-09-04
781 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Jl. Gunung Krakatau No.51 F-G, Glugur Darat II, Kec. Medan Tim., Kota Medan, Sumatera...
BCA KCP Niaga Grisenda Telpon/wa.085373737699.Komplek, Ruko Niaga Grisenda, Jl. Pantai Indah Kapuk Jl. Kapuk...
Telp/WA.0821°3111°179 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers