Tag: sql server

Community

The Route to Scalability

By Michael Otey – Despite the impressive Transaction Processing Performance Council (TPC) scores that Microsoft generated by using scale-out technology and SQL Server's federated-databases feature, it's too soon to count out scale-up technology based on SMP systems. Adding more processing po

Community

Database Scanner 4.0.1

By Brian Knight – Database Scanner 4.0.1 from Internet Security Systems (ISS) is a must-have for any DBA responsible for security. Database Scanner lets you set security policies on your SQL Server 7.0 and 6.x systems, then lets you audit your systems to see whether you're complying with those p

Community

70-026 SQL Server Administration

This exam will definitely challenge your knowledge of administration tasks within SQL Server. For those who perform all of their administration using Enterprise Manager, you'll need to get out ISQL and learn how to perform all of your administration tasks at a command line level. All the command

Community

sp__scramblepassword.sql

Michael Hotek tells us…I use this one for two purposes, attempts to crack security and handling stale logins. This procedure will scramble the password for the login you specify to a random 20 character string. I normally fire these off from monitoring procedures. The first one tracks when the