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.
Installing SQL Server adds SQL Server—specific performance counters to the Windows 2000 System Monitor (Performance Monitor in Windows NT 4.0). You can use these counters with the standard Win2K or NT performance counters to keep tabs on...
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...