sql engine

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Minimize the size of tempdb in SQL Server

Arthur Fuller discusses tempdb and explains what to do to shrink this database to its minimum size. These tips will help you optimize your system's use of tempdb. SQL Server automatically creates a database called tempdb for use as a workspace. When you specifically create a temporary table...

Tags: Microsoft SQL Server, SQL, Arthur Fuller, Databases, Programming languages, server, tempdb, SQL Engine, ALTER DATABASE, recovery mode, disk, SQL Server Newsletter, Database, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Technical articles 2006-10-23

SQL Engine (zip)

This is the most easily usable database engine that for CSV file just you have. You can access to CSV file as if it is a database by SQL language. SQL Engine is a database engine for Perl. It was made all Perl native code, so you don't have to...

Tags: Perl, SQL, CSV File, Database Engine, SQL Engine, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-03-08

Additional Resources

Microsoft Webcast Series for Lockheed Martin: What Aren't You Getting Out of SQL Server?

People may be familiar with SQL Server as a data platform, but may be missing out on some powerful capabilities SQL Server has "Under the hood" - Extract, Transform, Load ETL engine; the leading OLAP engine; SQL Server Analysis Services provides a dimensional analysis capability that goes far beyond "Pivot...

Tags: Webcast, Microsoft SQL Server, Lockheed Martin Corp., Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

Webcasts 2008-03-20

MSDN Webcast: New T-SQL and Engine Features, New Data Types for SQL Server Programmability (Level 200)

With Microsoft SQL Server Compact 3.5 and Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile devices to their full desktop client computers, benefiting from the power of SQL...

Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Webcast, Microsoft SQL Server, Server, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

Webcasts 2008-01-30

MSDN Webcast: SQL Server 2005 Essentials: Security Enhancements (Part 5 of 14) (Level 200)

Microsoft SQL Server 2005 features the integration of the Common Language Runtime CLR component of the .NET Framework for Microsoft Windows. Since the CLR is hosted in the SQL Server engine, users are able to use the CLR security features. This webcast covers the security enhancements in SQL Server 2005....

Tags: Security, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, CLR, .Net, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management

Webcasts

MSDN Webcast: SQL Server 2005 Essentials (Part 05 of 14): Security Enhancements (Level 200)

Microsoft SQL Server 2005 features the integration of the Common Language Runtime CLR component of the .NET Framework for Microsoft Windows. Since the CLR is hosted in the SQL Server engine, the users are able to use the CLR security features. This webcast covers the security enhancements in SQL Server...

Tags: Security, Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, CLR, .Net, Databases, Enterprise Software, Software Development, Software/Web Development, Software, Data Management

Webcasts

How does WSUS connect to WMSDE?

I do not know anything about SQL except it is a database and it is treated differently.I have installed WSUS on a win2k3 server enterprise edition named "newb1", but now I noticed that the SQL desktop engine is not running even though it says so in services. On the lower...

Tags: Microsoft Windows Server Update Services, server, SQL, SQL Desktop Engine, squaly

Discussion threads 2007-02-27

SQL Server 2000 On Win 2000 Professional

I want to install sql 200 server on win 2000 professional.Which is the appropriate version of sql server for win 2000 professionalregardsamarSQL 2000 Personal Edition. The various flavors and requirements of SQL are detailed here:http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.aspI would recommend Microsoft SQL Server 2000 Desktop Engine (MSDE 2000):http://www.microsoft.com/sql/msde/downloads/download.aspPurely depends on your requirements, if...

Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft Windows 2000, SQL, techadmin@..., windows

Q&A 2005-03-01

Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Service Pack 4 (Intel) (exe)

SQL Server 7.0 Service Pack 4 (SP4) addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine MSDE 1.0 since their ship date. Because SQL Server Service Packs are cumulative, SP4 includes all fixes from previously released Service Packs, and can be applied to an original...

Tags: Microsoft SQL Server 7.0, Microsoft SQL Server, Microsoft Data Engine, Service Pack, Microsoft Corp., Intel Corp., SQL Server 7.0 Service Pack 4, Databases, Enterprise Software, Software, Data Management

Software downloads 2002-08-24

MSDN Webcast: Introduction to Microsoft SQL Server 2005 Express Edition (Level 300)

SQL Server Express is based on SQL Server 2005 technology and includes the unique Application XCopy feature. However, its networking and security features differ from other SQL Server 2005 editions. This webcast examines the differences between SQL Server 2005 Express Edition and the rest of the SQL Server 2005 family....

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, SQL Server Express, Databases, Enterprise Software, Software, Data Management

Webcasts 2005-11-08

Troubleshoot waiting and blocking issues in SQL Server 2005

Waiting and blocking, two of the most common problems SQL Server users encounter, can touch many aspects of SQL Server, so any investigation of them benefits from a solid understanding of how SQL Server works. Conversely, studying waiting and blocking is a good way to learn even more...

Tags: Microsoft SQL Server, Server, Microsoft SQL Server 2005, Addison-Wesley, Chapter Coverage, Databases, Enterprise Software, Software, Data Management

Book chapters 2006-12-19

FlySpeed DB Migrate To SQL Server (zip)

Transfer databases from any engine to Microsoft SQL Server quickly and reliably. FlySpeed DB Migrate to SQL Server expedites the migration from your current engine into MS SQL. Migrate your entire database complete with structure and data, or transfer data from the source database into an existing structure. Get access...

Tags: Microsoft SQL Server, Server, Active Database Software, Databases, Storage, Enterprise Software, Software, Data Management, Hardware

Software downloads 2008-06-02

StelsEngine - fast in-memory SQL JDBC engine (zip)

StelsEngine is a fast in-memory SQL engine for storing and processing tabular data in Java applications. Using StelsEngine, you can make processing data in your software considerably easier and quicker. StelsEngine is as easy to use as possible since it implements the JDBC API standard. Features it is JDBC Type...

Tags: JDBC, SQL, StelsEngine, Programming Languages, Databases, Java, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2006-06-14

Xerox Delivers Scalable Printer Management Solution With Microsoft Data Engine

When the Xerox Global Services group set out to develop its first device management application, it needed to include a lightweight, low-cost database engine for data storage. Xerox selected Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), a royalty-free, redistributable data engine built on core SQL Server technology. MSDE 2000...

Tags: Xerox Corp., Printer, Microsoft Data Engine, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

Case studies

Detach the application from the database

I try to figure how to detach the database from the application. I'm a DBA, I work for a software develpment company. We have client that use our software with both SQL Server and Oracle. How can we get ride of developing two applications, one for Oracle, one for SQL...

Tags: database, detach the application, DLL, Microsoft SQL Server, oracle, Oracle Corp., server, software, sql server, werewolf_@...

Discussion threads 2006-07-25

Microsoft SQL Server 2000 Desktop Engine (MSDE) Installation, Deployment, and Patching

This Support WebCast will provide information about how to create custom installation packages that include Microsoft SQL Server 2000 Desktop Engine MSDE by using merge modules or MSDE prepackaged Windows Installer files. This WebCast will also talk about the methods you can you to apply service packs to an existing...

Tags: Desktop, Microsoft SQL Server, Microsoft SQL Server 2000, Microsoft Data Engine, Microsoft Corp., Databases, Enterprise Software, Software, Data Management

Webcasts

SQL Server Backup (zip)

SQL Server Backup is a backup and restore utility for Microsoft SQL Server. It's user-friendly wizard lets you backup and restore SQL Server database to local harddisk or remote network driver easily and quickly. The flexible design enables you can restore database with a new name or move database files...

Tags: Microsoft SQL Server, SQL Server Backup, Backups, Databases, Enterprise Software, Software, Data Management

Software downloads 2006-04-07

MSDN Webcast: SQL Server 2005 Masterclass: An In-Depth Look at Integration Services (Level 300)

Data Transformation Services DTS was introduced in Microsoft SQL Server 7.0 to provide a way to move data between different databases and systems. In SQL Server 2005, the DTS engine is named SQL Server Integration Services, and it provides an easier way for the developers to develop and manage this...

Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management

Webcasts 2005-11-15

Database Workbench (exe)

Cross database engine developer IDE for InterBase, SQL Server, Firebird, MySQL, Oracle, NexusDB, MSDE including many tools like: Visual Object Editors, Schema Browser, Test Data Generator, SQL Insight SQL Intellisense, Cross Database Migrator and Compare, Object Templates, SQL Catalog, Stored Procedure Debugger, Two-way Visual Query Builder, Dependency Browsing, Data Export...

Tags: SQL, Database Engine, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2006-05-12

123SQL (zip)

123SQL is a small portable sqlengine aimed for pda's. Useful for browsing data imported from spreadsheet tables via SQL syntax like commands. It is based on proprietary database design and SQL browsing engine.Version 1.4.3 is a bug fixing release.

Tags: SQL, 123SQL, PDAs, Programming Languages, Productivity, Databases, Handhelds, Hardware, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-11-28