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
Tag: sql server
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
Oracle unveiled a new online service that lets business customers create a business home page, or portal, using a Web browser and an array of graphical tools.
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
Order the Evaluation Edition* of SQL Server 2000—and explore how to build the next-generation of scalable Web applications. As a part of the Microsoft .NET Enterprise Servers, SQL Server 2000 offers you scalability for the most demanding environments. SQL Server 2000 dramatically reduces your time t
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
Microsoft Corp. is first to cross the application certification finish line for the new Windows 2000 Datacenter Server certification program with its own SQL Server 2000 Enterprise Edition database software.
Microsoft SQL Server 2000 introduced several features for querying database tables and receiving the results as an XML document. However, as shipped, Microsoft SQL Server 2000 does not allow changes to an XML document as database inserts, updates, and deletes or the loading of large XML files into S
As an enterprise test bed for Microsoft's product teams, we knew we'd be upgrading to SQL Server 2000 sooner than later. This has worked well, both for us and for the SQL Server development team, but it was not our primary motivation for upgrading.
Microsoft on Tuesday announced the completion of BizTalk Server 2000, its XML-enabled Business-to-Business (B2B) solution for companies of all sizes, and the final 2.0 release of the BizTalk Framework, which specifies how businesses should implement XML and Simple Object Access Protocol (SOAP) in th