(ORCS Webteam) Sometimes you cannot log in locally to a SQL server, so you need to make a remote connection. Usually this is over the Internet using TCP/IP. Tools that you can use to connect to a remote SQL server are Enterprise Manager, Query Analyzer, or even through code. Enterprise Manager and Q
Other News
Configuring MySQL for Linux
(Mike Chapple) You have three main tasks to complete the basic configuration of your Linux MySQL server: –Create the grant tables –Start the server –Verify server function
SwisSQL Helps Major ERP Vendor in Database Migration from Oracle to SQL Server
(Narayana Vyas Kondreddi) The ERP vendor, a global provider of customized enterprise solutions developed Aircraft maintenance solutions. Its Enterprise Asset Management for aviation, consists of modules covering all areas of enterprise management for the fixed wing aircraft and helicopter maintenanc
Oracle Puts Integration At Its Core
(Yvonne L. Lee) At the Oracle Open World conference in December, Oracle announced Oracle 10g Release 2, a set of updates that will enable its products to build applications that integrate with other applications.
How to Configure Virtual Server 2005 in Order to Setup a Test SQL Server Cluster
(Brad M. McGehee) There are a lot of DBAs who want to learn how to cluster SQL Server. There are also a lot of companies who may have a production SQL Server cluster, but not a test SQL Server cluster. In both cases, the reason for this is that clustering hardware is very expensive, and setting
Custom Script Callbacks in ASP.NET
(Dino Esposito) ASP.NET client callbacks represent a neat and elegant way to execute server-side code without posting and refreshing the current page. I discussed ASP.NET callbacks in the August and December 2004 installments of Cutting Edge, considering them from the perspective of rendered pages m
DB2 Environment (Sample Chapter)
(Susan Lawson) DB2 operates as a formal subsystem of z/OS. DB2 utilities run in the batch environment, and applications that access DB2 resources can run in the batch, TSO (Time Sharing Option), USS (UNIX System Services), IMS (Information Management System), or CICS (Customer Information Control S
DB2 UDB and Linux on iSeries — What a Fit
(Doug Mack) Genealogists actively seek information on family members, some tracing their roots back several centuries. They want photos, dates of birth, death and marriage, diplomas—anything they can get their hands on that helps them form their family history. Many of them also write family history
No Code Can Hide from the Profiling API in the .NET Framework 2.0
(Jay Hilyard) Since the inception of .NET, the common language runtime (CLR) profiling API has been the mechanism to use to inspect what the runtime is doing under the covers. Many profilers simply report how much time is spent in a given routine, file, or class, but the profiling API is much more c
E-Commerce: Customizing and Extending the Commerce Starter Kit: Part 2…
(Chris Sully) This series of articles is examining some of the issues around building a traditional B2C shopping cart e-commerce site using ASP.NET (VB.NET) and SQL Server using the Commerce Starter Kit (CSK) as a starting code base. In this article we’ll take a look at the shopping cart impleme