With the May 25th deadline looming closer, it’s easy to find resources on the topic of the EU’s General Data Protection Regulation and what it will mean for organizations around the globe. In fact, a search query now yields so many results that it becomes overwhelming trying to sort through them all; some facts are repeated over and over, while other questions seem to go unanswered no matter how you search for them.
In March of 2016 Microsoft announced the imminent release of the first private preview of SQL Server on Linux. Now available to everyone as a Community Technology Preview (CTP), we've been testing out using our DataFlex and Btrieve drivers with SQL Server running on both Linux (Ubuntu/Red Hat/Suse) and macOS (macOS!).
One of the most significant benefits of running MS SQL is the database recovery model. Your company’s information is its life-blood, and there are myriad methods to backup and preserve it. We will be discussing some basic techniques to preserve your data in a simple and efficient manner. We will not delve into Mirroring, Transaction Log Shipping or Replication; merely the actual backup of individual databases. The backup operations are dependent on the type of backup recovery model used.
While complex embedded SQL statements will let you do a lot of work in one statement, it is sometimes necessary to nest SQL statements to get the job done.
Oracle has created a site showing best practices for high availability.
SQL Native Client can be used rather than Microsoft Data Access Components (MDAC) to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features such as Multiple Active Result Sets (MARS), Query Notifications, User-Defined Types (UDT), and XML data type support.
Oracle 10g XE Client is different from the client that XE server install for you, first of all with XE Client we don't get the same configurations files that we get in a XE server. No tnsnames.ora, you need to use another notation to connect to a remote server also the windows registry keys are stored in another Windows registry directory.
You must change the FD (field definition) files and insert the macro command.
MySQL has two different types of licensing agreements.
Open Source license (GNU) and the other more applicable to developers is their Commercial license. Below are excerpts from the MySQL documentation.
NOTE: Since Mertech’s drivers are not open source; anyone using our drivers along with MySQL must purchase a Commercial license.