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
Tag: sql server
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
Microsoft is replacing proprietary database protocols with the XML standard to better position its SQL Server database for next-generation Internet applications. The company is adding new interfaces based on XML to its OLE DB for OLAP protocol from next spring, taking effect when Microsoft relea
Windows® 2000 provides a host of innovative services to satisfy the most demanding security needs. DESIGNING SECURE WEB-BASED APPLICATIONS FOR MICROSOFT® WINDOWS 2000 provides an authoritative, end-to-end view of all the major Windows 2000 security services. This book gives you a solid foundation in
Server options affect the behavior of SQL Server on a global scale. There are a significant number of configuration options available for tuning a server. The first thing many inexperienced DBAs will do is tweak as many server options as possible. This is the wrong approach. In many cases, the defau
Every day, organizations move vast quantities of information between corporate, branch, and mobile offices using distributed database applications. The challenge is to deliver this data quickly and reliably across a mix of disparate networks and computing platforms. By offering a variety of replicat
By Ken Spencer-Data-access code is usually the foundation to building any Web application. Developers typically write ADO code that uses either the Command or Recordset object and sets various properties. Then, the code either executes a SQL statement or calls a stored procedure. Creating this code