By David Litchfield – With Microsoft SQL Server 2000 and 7 comes a “helper” service, the SQLServer agent. The Agent is responsible for restarting the database service if it stops for some reason, has a role to play in replication and runs scheduled jobs. As the public role can submit jobs to the SQ

By Dennis Fisher – Security researchers have found a new flaw in Microsoft Corp.’s SQL Server database software. The problem lies in the SQL Server agent, which is responsible for various functions, including running scheduled jobs and restarting the database service if it stops. By default,

By Michael Otey – BI–and the OLAP and data-mining technologies that comprise it–are aimed squarely at delivering strategic business advantages.

by Brad M. McGehee – This third part of the SQL Server Performance Audit series covers the operating system.

By Ed Scannell – The next generation Office 11, scheduled to ship in 2003, will leverage XML so that it runs on a diverse collection of client devices from Tablet PCs, to PDAs, notebooks, and PCs. These devices in turn will facilitate user collaboration courtesy of a single Microsoft data sto

By Luis F. Medina – Will you be another statistic? Is the connection to your database server mutually exclusive? Has database security become an empirical concept among database administrators in your company? If the probability of an attack in the future is determined by your observations of securi

By Sam Costello – Microsoft Corp. released a patch for a vulnerability it called “critical” that could allow an attacker to take complete control of Windows 2000 systems. The company also released a cumulative patch for SQL Sever 7.0 and 2000 that repaired a new security hole.

By GARY H. ANTHES – The modern database era began in 1970, when E.F. Codd published his paper “A Relational Model of Data for Large Shared Data Banks.” His ideas enabled the logical manipulation of data to be independent of its physical location, greatly simplifying the work of application developer

By Dan Seewer – Think of a view as another table within the database. Views are often referred to as virtual tables since no physical table exists in the database: A view is merely a “stored query” that returns a result set that can be used in SQL. The view can then be used as part of other SQL quer

As the Windows platform continues to evolve to address changing business computing needs, many organizations currently on UNIX platforms are turning to Windows to run their new client and server business applications. They’re discovering that moving to the Windows platform does not require abandonin