If you haven't changed the SA password on your SQL Server, you may be soon paying the price. Beginning last week, an old worm has come back in full force, infecting about 100 SQL Servers an hour. Reports of heavy port 1433 scanning began in early may but by the 22nd, the virus really began to take its hold on systems with no SA password.
2002-05-28
4,812 reads
Here's a general overview for creating and editing stored procedures. Head over to the discussion forum for this article and present your creative ideas for using this powerful feature of SQL Server to the SSC community.
2002-05-27
19,777 reads
Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!
2002-05-27
10,428 reads
SQL Spy 4.0 is a program that lets you monitor your server real time to look for locking problems, unusual user activity or users that are using large amounts of your server resources. The program is like SQL Profiler in a tighter, easier package.
2002-05-22
145 reads
In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!
2002-05-21
9,321 reads
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,365 reads
SQLServerCentral.com is proud to launch it's first Resource Center for security. It's a one-stop shop for anything related to SQL Server security. All content is user-contributed and contains links to content throughout the web.
2002-05-20
76 reads
It provides an infrastructure to create and manage various SQL Server stored procedure based reports into HTML output. You can add reports, categorize them in a treeview, edit, delete and manage the report parameters - all through the web interface. Members can now download this as Freeware at SQLServerCentral.com.
2002-05-16
124 reads
Is the Identity property part of a transaction? I always thought so, but decided to test it and see what happens.
2002-05-16
4,573 reads
2002-05-15
2,962 reads
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
You can merge PST files efficiently by using a professional PST merge tool instead...
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers