Auditing Your SQL Server Environment Part II Auditing Your SQL Server
In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.
2002-05-30
9,845 reads
Articles
DTS Resource Center Launched
SQLServerCentral.com this week launched its second Resource Centers. This time, focusing on DTS. The DTS Resource Center focuses on tracking bugs, articles and books from throughout the Internet.
2002-05-29
52 reads
Microsoft SQL Server 2000 Driver for JDBC Released
The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java™ environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.
2002-05-29
3,342 reads
SQLsnake Worm Hits SQL Servers and Networks Hard
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,794 reads
Introduction to Stored Procedures
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,644 reads
Maintenance Plans - Behind the Scenes
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,421 reads
SQL Spy 4.0 Released as Freeware
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
137 reads
SQL Maintenance Plans - Under the Covers!
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,301 reads
Designing a Flexible Task Management Database
In this article by Jamie Voss, he shows the methodology he used to develop his task management database.
2002-05-20
6,328 reads
SQL Security Resource Center Opens
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
67 reads
Blogs
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Tomorrow: Webcast on SQL Server security
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
A New Word: the Wends
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Forums
should i prefer join or left join over exists or in
hi, I have seen people use exists when exists is required and no cols...
Should I create tables with dynamic SQL?
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Expression Error ( property 'Error' cannot be selected )
Hello there. I have the following Pipeline I want to get the property error...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers