|
| |
| | Microsoft SQL Server - Wikipedia, the free encyclopedia |
 | | SQL Server 7.0 was the first true GUI based database server, and a variant of SQL Server 2000 was the first commercial database for the Intel IA64 architecture. | | | About the time Windows NT was coming out, Sybase and Microsoft parted ways and pursued their own design and marketing schemes. | | | It supports a superset of Structured Query Language (SQL), the most common database language. |
|
http://en.wikipedia.org/wiki/Microsoft_SQL_Server
(687 words)
|
|
| |
| | Migrating Sybase Databases to SQL Server 2000 |
| | SQL Query Analyzer is a graphical query tool that enables you to visually analyze the plan of a query, execute multiple queries simultaneously, view data, and obtain index recommendations. | | | SQL Server 2000 updates statistics automatically, so the SQL Server query optimizer is more likely than the Sybase query optimizer to make the best choice of index use. | | | SQL Query Analyzer provides the graphical diagram of the showplan information, which is used to report data retrieval methods chosen by the query optimizer. |
|
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0661.mspx
(5716 words)
|
|
| |
| | Sybase SQL Server - Wikipedia, the free encyclopedia |
| | In 1993 the codevelopment licensing agreement between Microsoft and Sybase ended and the companies parted ways while continuing to develop their respective versions of the database management system. | | | This was a computer that only did relational database. | | | Ashton-Tate divested its interest and Microsoft became the lead partner after porting SQL Server to Windows NT. |
|
http://en.wikipedia.org/wiki/Sybase_SQL_Server
(226 words)
|
|
| |
| | SDSI: InterBase vs Sybase SQL Server And MS SQL Server |
| | SQL Server VARCHAR columns are limited to 255 bytes of data. | | | The SQL Server architecture is designed to support either the OLTP environment or the DSS environment; not both. | | | Like Microsoft SQL Server, installation of a Sybase database requires that space for the RDBMS and any databases be pre-allocated and therefore suffers from all of the same problems with respect to transaction logs, VARCHAR edits, record deletions, bulk data loading and large queries. |
|
http://www.sphere-data.com/docs/ib_vs_ss.shtml
(13030 words)
|
|
| |
| | FAQs about Sybase SQL Server 11.0.x |
| | SQL Server 11.0.x uses more memory than the previous release because of new internal data structures. | | | SQL Server uses a search path to find system stored procedures. | | | Timeslice errors resulting from a dbcc memusage call occur only on multi-engine servers, and are more likely to occur on servers that have a large procedure cache. |
|
http://eshop.sybase.com/detail/1,6904,1208,00.html
(3182 words)
|
|
| |
| | Tuning and Measuring Performance of Sybase SQL Server 11 on Windows NT |
| | The problems associated with configuring SQL Server 11 with a data cache that is larger than physical memory are obvious. | | | In both of these examples, the system had 128MB and SQL Server 11 was configured to use 96MB for its data cache. | | | In SQL Server 10 for Windows NT the "Runnable Process Search Count" (or cschedspins) parameter needed to be tuned with much care because high values could be detrimental in several cases. |
|
http://eshop.sybase.com/detail/1,6904,2489,00.html
(4931 words)
|
|
| |
| | DBMS Server Comparison Supplement - November 1996 - Sybase SQL Server 11 |
| | Sybase uses locking as its concurrency control mechanism; it can lock data pages or entire tables. | | | Sybase supports its own proprietary Transact-SQL language, a super-set of the Entry Level ANSI SQL-92 standard, with various extensions for functions, stored procedures, triggers, and performance-improvement features. | | | Instead of using "work-around" mechanisms, such as triggers, b uffer tables, or snapshots in files, the Sybase Replication Server propagates changes from a source database through an API of the logging and journalling subsystem. |
|
http://www.dbmsmag.com/9611d54.html
(2359 words)
|
|
| |
| | Sybase SQL Server 11 Dba Survival Guide |
| | SQL - Specific Databases - Databases - Computers and Internet - Subjects - Sybase | | | SQL - Specific Databases - Databases - Computers and Internet - Subjects - General | | | A lot of the examples still reference version 10.x (not a big deal however). |
|
http://www.literacyconnections.com/0_0672308886.html
(380 words)
|
|
| |
| | Amazon.ca: Books: Mastering Sybase SQL Server 11 |
| | This in-depth guide to extracting top performance from Sybase System 11 SQL Server covers performance-tuning and database design issues making it a must for data architects, developers, and other computing professionals working with Sybase in a Client/Server environment. | | | This in-depth guide to extracting top performance from Sybase SQL Server II covers performance-tuning and database design issues making it a must for data architects, developers, and other computing professionals working with Sybase in a Client/Server environment. | | | Subjects > Computers & Internet > Databases > Specific Databases > SQL > Sybase |
|
http://www.amazon.ca/exec/obidos/ASIN/0070116628
(302 words)
|
|
| |
| | Sybase Inc - Sybase Information Management - Database Servers, Web Services, Data Modeling |
| | Used in conjunction with Replication Server, Replication Agent for DB2 allows you to effectively distribute IBM DB2 UDB data throughout heterogeneous computing environments. | | | The Mainframe Connect allows data to be queried or full read/write access to mainframe data, from CICS, IMS/TM, and DB2/MVS environments. | | | Highly scalable relational database optimized for unsurpassed query performance in business intelligence and large data warehouses. |
|
http://www.sybase.com/products/databaseservers
(711 words)
|
|
| |
| | seldin - Sybase/SQL Server was planted on the web with TreeWay |
| | Reviewed SQL code for inefficiencies and instructed programmers on how to optimize code. | | | Handled day-to-day activities of maintaining servers, performing dump backups, emptying logs, created databases, storage devices and stored procedures, as well bcp’d tables and ftp’d data across servers. | | | - As Unix / Sybase Administrator, installed and maintained HP 9000 K420 with 4 CPU's. |
|
http://members.aol.com/lmseldin/sybase.htm?941735585
(453 words)
|
|
| |
| | Sybase's SQL Server gains muscle (InfoWorld) |
| | One feature not in the new version, however, is row-level locking, which would be used for locking particular rows of a database. | | | In addition to the new name and support for the company's new Impact Now Adaptive Component Architecture Version 11.5 of the database will offer new functionality in the areas of parallel computing, recovery, access control, and security. | | | Currently in beta testing and expected to ship by year's end on Windows NT and Unix, Version 11.5, formerly referred to as Gryphon, will act as the relational data store within Sybase's new architecture. |
|
http://www.infoworld.com/cgi-bin/displayArchive.pl?/97/15/t21-15.20.htm
(434 words)
|
|
| |
| | Sybase: Adaptive (SQL) Server Links - Tek-Tips |
| | Sybase, Inc. home page We're dedicated to making sure companies have "Information Anywhere." That means providing the products and services to tie together different information systems, and distribute that information to whoever in your company needs it. | | | The Data Warehouse Datawarehouse.com is a one-stop resource for industry professionals who want to keep abreast of the latest developments in information systems and data warehousing technology. | | | Write SQL queries with "Zero" knowledge of SQL. |
|
http://www.tek-tips.com/links.cfm?pid=187
(512 words)
|
|
| |
| | SQL Server vs Sybase |
| | SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. | | | Microsoft SQL Server and Sybase ASE have a common heritage because, until version 4.2, Microsoft simply licensed Sybase's database server software. | | | In comparison with SQL Server 2000, Sybase ASE 12.5 supports all known platforms, including Windows-based platforms, AIX-based systems, HP-UX systems, Linux Intel, Sun Solaris and so on. |
|
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_sybase.htm
(1551 words)
|
|
| |
| | SwisSQL - Migrating Sybase to SQL Server. SwisSQL Sybase to SQL Server Migration Tool. |
| | Online migration: SwisSQL Sybase to SQL Server offers an intuitive wizard that helps you to directly connect to the Sybase database in your network. | | | The tool handles the conversion of procedures, triggers, tables, views, indexes, conditional and control statements, inbuilt functions, transaction statements, SQL statements and other Sybase database objects. | | | Wizard-based approach to connect and fetch Sybase objects |
|
http://www.swissql.com/products/sybase-to-sqlserver/sybase-to-sql-server.html
(512 words)
|
|
| |
| | Amazon.com: Books: The Sybase SQL Server Survival Guide |
| | If you are a database developer or programmer working with Sybase System 11 SQL Server, this book can save you many frustrating hours of trial and error while schooling you in hard-to-find techniques for streamlining the development process. | | | If you are experienced with other database servers this book is the handy reference book that explains how Sybase interprets the basics of database programming and development. | | | It is a great "quick-reference" book with a Sybase perspective on database development and programming. |
|
http://www.amazon.com/exec/obidos/tg/detail/-/0471127450?v=glance
(1051 words)
|
|
| |
| | Exploring Sybase SQL Server |
| | Subject: Exploring Sybase SQL Server To: jod@ccat.sas.upenn.edu (Jim O'Donnell) Date: Fri, 6 Mar 1998 15:25:31 -0500 (EST) Exploring Sybase SQL Explorer http://www.cobb.com/syb/ (Link inactive 5 May 2004) A partial electronic version of the Cobb Group's monthly, subscription-based, print journal for database administrators and developers. | | | Managing very large databases with Sybase The information explosion has created many new challenges in the area of database management. | | | Subscribers have access to back issues, Recent Online Contents: ECG launch page "Exploring Sybase SQL Server" is part of the Enterprise Computing Group's suite of client/server and networking journals. |
|
http://gort.ucsd.edu/newjour/e/msg02451.html
(220 words)
|
|
| |
| | Amazon.com: Books: Sybase SQL Server 11 Unleashed |
| | It describes the ways to handle sybase admin tasks using the non-graphical interfaces. | | | This book covers most things you want to know - whether you are a DBA or a developer, but perhaps not always in as much depth as you'll need. | | | Of course this might say more about the efficacy of Sybase than the book, but we aren't reviewing RDBMs here. |
|
http://www.amazon.com/exec/obidos/tg/detail/-/0672309092?v=glance
(1137 words)
|
|
| |
| | ACC: Requirements to Connect to SYBASE SQL Server |
| | NOTE: The SQL Server ODBC driver included with Microsoft Access for Windows 95 version 7.0 is designed to work with only Microsoft SQL Server. | | | To connect to SYBASE, you need to use the SQL Bridge product or buy the Net-Libraries from Sybase for each client computer. | | | The following is a list of Net-Libraries that Microsoft has confirmed to work with Microsoft Access/ODBC and SYBASE SQL Server: |
|
http://support.microsoft.com/default.aspx?scid=kb;en-us;96468
(629 words)
|
|
| |
| | dBforums - Sybase vs. SQL Server |
| | Assuming that there is a significant reason to develop this with | | | acquire so I can mimic a sybase database environment on my development | | | Hers is a link to the developers version |
|
http://www.dbforums.com/t677680.html
(1091 words)
|
|
| |
| | ACCU Reviews: Sybase SQL Server 11 Unleashed |
| | Most of the book is spent on the latter but it also does a good job on all of the major topics with the one exception; no mention is made of the Window based tools that come with the NT version. | | | Certainly our office copies are much more likely to be found on a developers desk than on a shelf. | | | The book is a re-work of the well-respected Sybase 10 version and follows in its footsteps. |
|
http://www.accu.org/bookreviews/public/reviews/s/s001554.htm
(390 words)
|
|
| |
| | Sybase Inc - Application Server, Wireless, Database Management, Web Services |
| | Find out how Sybase solutions deliver an information edge for your organization. | | | Learn how to go from reactive to proactive business intelligence in a free Webinar featuring Dr. Ralph Kimball, a leading data warehousing authority. | | | As China gears up for the Beijing 2008 Olympics and its bold “Digital Cities” initiative, open source technologies, Linux and Sybase are at the forefront of planning. |
|
http://www.sybase.com
(119 words)
|
|
| |
| | Sybase SQL server and Replication server on one NT box |
| | If the system search path includes the SQL binaries or DLL's, problems will occur with the Replication server... | | | Installation should be done in different directories, otherwise upgrading one of them would be difficult without changing anything on the other. | | | Sybase variable: remove it from the system variables and put it in the user variables. |
|
http://www.xs4all.nl/~reinoud/ntsqlrep.html
(758 words)
|
|
| |
| | 2.1.2 Sybase SQL Server |
| | It includes the SQL Server Kernel, Process Manager, Query Optimizer, system databases, and application data. | | | The flexibility in hardware and OS system makes our on-line archive system portable and easy for upgrading in hardware. | | | Sybase SQL Server is available on many hardware platforms under a variety of operating systems. |
|
http://sma-www.harvard.edu/private/memos/138/node5.html
(187 words)
|
|
| |
| | Online Sybase SQL Server Courses - Learn Sybase SQL Server Administration! |
| | Get training courses in Visual Basic, SAS, RDBMS, C / C++ Programming, Oracle, UNIX, networking, server admin, programming, and more. | | | You get 306 complete IT programming and system administration courses, including these Sybase programming courses, for | | | Get all of our general IT courses and save big! |
|
http://www.e-learningcenter.com/sybase.htm
(382 words)
|
|
| |
| | Sybase: Using SQL Server |
| | This course is for database administrators who want to learn about using and managing Sybase System 11. | | | Sybase: Using SQL Server introduces users to SQL Server and how to use it to create manage and access database information. | | | Simulations that allow users to practice course skills even if they don't have access to Sybase SQL Server |
|
http://www.online-education.biz/catalog/sybc02.htm
(102 words)
|
|
| |
| | Migrating from Sybase to SQL Server |
| | The experience I gained by working on this project has led me to write this article to show Sybase database administrators (DBA’s) and managers the steps that should be followed to migrate from a Sybase database to an SQL Server 2000 database. | | | It will be necessary to heavily test the behavior and resultsets of all programming logic in script files and stored procedures prior to completing the conversion. | | | In this article Sayed shares his experiences in migrating from Sybase to SQL Server...I was involved in a recent project to migrate a Sybase database to Microsoft SQL Server 2000. |
|
http://www.devarticles.com/c/a/SQL-Server/Migrating-from-Sybase-to-SQL-Server
(345 words)
|
|
| |
| | SwTech.com - Sybase SQL Server |
| | SQL Server 11 White paper - Performance Optimized for Real-World | | | Sybase SQL Server Release 11.0.x Online Books List | | | A paper describing the performance improvements delivered in Sybase SQL Server 11. |
|
http://www.swtech.com/db/sybase
(104 words)
|
|
| |
| | sybase |
| | You could also use the accompanied Wisql program | | | This software package contains the minimum set up requirement | | | contain important information connecting to the Sybase SQL |
|
http://cisnet.baruch.cuny.edu/Garnett/spring98/sybase.htm
(155 words)
|
|
| |
| | Sybase/SQL Server Developer |
| | If you believe you are the perfect match for this position, please send your resume as a Word attachment & include the 5-digit position identifier (14753) IN THE SUBJECT LINE TO: sgamail@sgainc.com | | | One of SGA's major Financial Clients in Jersey City, New Jersey is looking for a strong Sybase / SQL Server developer. | | | Candidate muust have a strong experience with DTS, Transact SQL, Shell/Perl scripting and writing stored procedures/triggers. |
|
http://www.net-temps.com/job/hm4l/14753/sybase_sql_server_developer.html
(135 words)
|
|
| |
| | dBforums - Sybase SQL Server -> MS SQL Server |
| | I can't rewrite the program because it's 10.000's lines of code and our | | | The cause of the problem is that Microsoft OLE DB Provider for SQL Server | | | With the Microsoft OLE DB Provider for SQL Server (SQLOLEDB), when you try |
|
http://www.dbforums.com/t656707.html
(300 words)
|
|
| |
| | VB,PB, SYBASE, SQL SERVER |
| | * More than five years of software development experience * Three years experience in banking software development(includes VISA and ATM) * Excellent with Visual Basic 6,VBA, PB 7,MS SQL Server 7, ORACLE, Sybase | | | Programming Knowledge: Visual Basic 6,Power Builder 7 Databases: RDBMS: MS SQL Server 7,ORACLE, Sybase,MS Access Reporting tools : Crystal Reports Web Technologies :Visual InterDev 6.0, ASP, DHTML, JavaScript Operating Systems Knowledge : Proficient with MS-Windows 95, 98 NT v4.0, Languages :C,C++, Assembly Language | | | This site was last updated on Sunday, July 24, 2005 Product and company names mentioned herein may be trademarks of their respective owners. |
|
http://www.it-careernet.com/rad/_contractors/0000008d.htm
(126 words)
|
|
| |
| | linked server SQL Server-->Sybase |
| | sybase database but i can't see the ODBC driver for sybase. | | | I installed the ASE 12.5 on win2003 machine and have sql server also on | | | i need to create linked server from sql server database to |
|
http://www.lazydba.com/sql/1__8643.html
(47 words)
|
|
| |
| | BeBits - Sybase/MS SQL Server Connectivity |
| | As usual Sybase being the robust product that it is....well...it just works. | | | Sybase ASE 11.9.2 on a Solaris 2.7 Server | | | Sybase ASE 12.0 on a Solaris 2.7 Server |
|
http://www.bebits.com/app/2889
(266 words)
|
|
| |
| | Sybase Developer's Handbook, Sybase SQL Server, Sybase Reviews |
| | This powerful handbook is aimed at Sybase SQL Server System XI developers. | | | Sybase Developer's Handbook, Sybase SQL Server, Sybase Reviews | | | The writer assumes that you have worked with Sequel Server for a few years to take full advantage of this handbook. |
|
http://www.exam-ta.ac.uk/sybase399.htm
(151 words)
|
|
| |
| | Sybase: Adaptive (SQL) Server FAQ - Tek-Tips |
| | As a general rule, Sybase docs are unusually good (naturally, they have some flaws--what manuals don't?), but they are always a good place to start and they're better than you might expect if you've used other vendor's DB products. | | | The PDF versions have indexes (that unfortunately contain links that don't work)--but you can find the page "manually". | | | Where in the world do Tek-Tips members come from? |
|
http://www.tek-tips.com/faqs.cfm?fid=2495
(207 words)
|
|
| |
| | Sybase/SQL Server DBA |
| | SQL Server administration required - versions 6 through SQL Server 2000. | | | The ideal candidate will have excellent Sybase skills including Sybase ASE, DBA and Sybase Replication Server administration - versions 11.5 through 12.5 on HPUX, Solaris & Windows. | | | "Our blue chip client is currently seeking a Sybase/SQL Server DBA to administer databases and DBMSs. |
|
http://www.jobxpresso.com/jobs/jobspec_4134.html
(90 words)
|
|
| |
| | Adaptive Server Enterprise 12.5.1 (Core Documentation Set) |
| | Using Sybase Failover in a High Availability System | | | XA Interface Integration Guide for CICS, Encina, and TUXEDO | | | Contents of the Adaptive Server Enterprise 12.5.1 (Core Documentation Set) Collection |
|
http://sybooks.sybase.com/onlinebooks/group-as/asg1251e/@Generic__CollectionView
(63 words)
|
|
|
