(Serdar Yegulalp) You’ll find a slew of undocumented functions in SQL Server 7.0 and 2000, most of them used by Microsoft to perform internal tasks that might change from version to version of the product. (R)
Other News
Why use stored procedures?
(Parthasarathy Mandayam) Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: “Why tolerate the added development overhead?” After seeing the advantages, you may change your mind. (R)
Analyzing the Web
(John E. Simpson) The mantra of Web development used to be, “Content is king.” Don’t waste time prettying things up, we were advised (and we ourselves advised others); people are too busy, and download speeds are too slow, to crud your pages up with big images, Flash presentations, and other media t
Problems in Oracle Reports
(Noel Davis) Welcome to Security Alerts, an overview of recent Unix and open source security advisories. In this column, we look at problems in Oracle Reports, Skype for Linux, MediaWiki, Kate, Kwrite, Shorewall, ekg, libgadu, PHPNews, phpSurveyor, Affix, Heartbeat, and phpPgAdmin.
Index Tuning Wizard
(Gregory A. Larsen) There are a number of wizards in SQL Server 2000. One of these wizards is known as the index tuning wizard. The index tuning wizard is used for exactly what it sounds like; it is used for tuning indexes. This article will introduce you to the index tuning wizard and will explain
CISOs weigh in on open source
(Marcia Savage) Open-source software, security certifications, and emerging threats were among the topics a panel of CISOs pondered at the Black Hat Briefings in Las Vegas.
Understanding the sample search application for WebSphere Information Integrator OmniFind Edition
(Dana Morris) Organizations can use WebSphere Information Integrator OmniFind Edition to develop highly customized search applications to best fit their unique needs, requirements and mix of information sources. This article provides a technical overview of the WebSphere Information Integrator OmniF
Lack of Skilled Devs Slows Web Services
The lack of readily-available devs skilled in web services design and production continues to impede web services projects, according to the latest survey from Evans Data Corp.
Developing next generation Smart Clients using .NET 2.0 working with existing .NET 1.1 SOA based XML Web services
(Omar Al Zabir) .NET 2.0 introduces a lot of new features in Windows Forms and deployment technologies which takes Smart Client development to the next level. Previously we had to worry about too many issues including rich controls (owner drawn controls), multithreading, auto update and various othe
SQL Classes Encapsulation (simplified stored procedure calls, queries and DataSet Returns with .NET)
(Xodiak) So you have an application that has a SQL server backend. And now you have to deal with all the different SQL connection classes like SqlConnection, and SqlDataAdapter, and DataSet and SqlCommand. And then manage all these classes to work together so you can return a DataSet or run some Q