Search results
Results from the Health.Zone Content Network
Log shipping is the process of automating the backup of transaction log files on a primary (production) database server, and then restoring them onto a standby server. This technique is supported by Microsoft SQL Server, [1] 4D Server, [2] MySQL, [3] and PostgreSQL. [4] [5] Similar to replication, the primary purpose of log shipping is to ...
Rollback (data management) In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations are performed. [1] They are crucial for recovering from database ...
Continuous data protection. Continuous data protection ( CDP ), also called continuous backup or real-time backup, refers to backup of computer data by automatically saving a copy of every change made to that data, essentially capturing every version of the data that the user saves. In its true form it allows the user or administrator to ...
Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application. Stored procedures in SQL Server are executable server-side routines. The advantage of stored procedures is the ...
HTTP File Server – User-friendly file server software, with a drag-and-drop interface; lighttpd – Resource-sparing, but also fast and full-featured, HTTP Server; Lucee – CFML application server; Nginx – Lightweight, high performance web server/reverse proxy and e-mail (IMAP/POP3) proxy; NetKernel – Internet application server; Qcodo ...
SQL Server Notification Services is a platform developed by Microsoft for the development and deployment of notification applications based on SQL Server technology and the Microsoft .NET Framework. Notification Services offers a scalable server engine on which to run notification applications, with multi-server capability-providing flexibility ...
SQL Server Reporting Services ( SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS ( SQL Server Analysis Services) and SSIS ( SQL Server Integration Services ). Administered via a web interface, it can be used to prepare and deliver a variety of ...
SQL CLR or SQLCLR ( SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment. This technology, introduced in Microsoft SQL Server 2005, allow users for example to create the ...