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.
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...
Publicly, Microsoft loves and supports Java. But let's face it, Java is a four-letter word to most people in Redmond. Microsoft architects (especially the .NET folks) probably wouldn't mind if Java and its related platforms simply faded away so...
Congratulations to Marek Skotnica, PC programmer analyst at Nova Hut Ostrava in the Czech Republic, and Nikola Milic, manager of the statistical department at Cyprus-based Tradal. Marek won first prize of $100 for the best solution to the October...
SQL Server 2000's integrated Analysis Services functionality came out on top in several categories in the recent 2001 OLAP Survey, conducted by Survey.com and published by The OLAP Report. The survey asked more than 644 OLAP users from 46...