Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Implementing new applications, especially such major applications as enterprise resource planning (ERP) applications or financials, is a huge undertaking. Most businesses face two main choices when evaluating how to implement new applications...
When I look at Enterprise Manager or execute sp_helpdb '<db_name>' for a particular database, the database owner (DBO) appears to be a Windows NT user who hasn't been added to the SQL Server 7.0 server logins. (This NT user is a member of...
I want each row in a new table I'm developing to contain the Data Definition Language (DDL) of one of my existing SQL Server 2000 tables. Which system files do I need to manipulate to capture the DDL? I could use script generation to create this...
SQL Server Profiler can reveal only what's executing on SQL Server. But linked-server queries also execute on the Oracle server, so to fully analyze an Oracle linked-server query, you must use Oracle's SQL Trace facility. You can enable SQL Trace...
A set of consumer and privacy groups railed against the US government this week for not acting to investigate or block the sale of Windows XP, which Microsoft will release tomorrow. Microsoft competitors are backing some of the groups, which have...
In the good old days, SQL Server 4.2 manuals were small enough to ship in the box. Back then, you could read all the manuals cover to cover and be reasonably well versed in SQL Server's functionality...
When you develop .NET applications, you use the XmlTextReader class to parse XML documents. Although the .NET Framework provides full XML Document Object Model (DOM) support and Simple API for XML (SAX) classes, XML readers and writers present an...
The Microsoft SQL Server product team is accepting applications for the SQL Server 2000 Service Pack 2 (SP2) beta program. Only registered members of this private program will receive the beta version of SP2 for testing and evaluation purposes...