Search found 30 matches: dba

Return to advanced search

Re: To all MySQL experts

... What is the MySQL equivalent of SQL Server 2016 Always Encrypted technology or is there anything similar in MySQL that can act as AE? https://dba.stackexchange.com/questions/158725/what-is-the-mysql-equivalent-of-sql-server-2016-always-encrypted-technology Conclusion Transparent Data ...
by Otto
Sun Sep 02, 2018 9:02 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: To all MySQL experts
Replies: 13
Views: 2180

Re: error al borrar registro con xbrowse, tdophin, mysql

... la consulta para hacer el DELETE o como lo hago ahora, uses DELETE LOW_PIORITY, asi te borra el registro sin problemas, saludos... :shock: https://dba.stackexchange.com/questions/21483/delete-low-priority-row-visibility
by joseluisysturiz
Fri Jul 13, 2018 3:07 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: error al borrar registro con xbrowse, tdophin, mysql
Replies: 8
Views: 1508

Application security and Code review

... AD for ( only ) First name, Last Name, and Userid to populate xBrowse as a look up table to add employees to a Drivers table. I informed the Sql DBA that I needed two new fields added and I would be using those new fields to incorporate the new LDAP enhancement and this was his responce: http://i67.tinypic.com/308dxyb.jpg ...
by Rick Lipkin
Wed Oct 11, 2017 2:21 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Application security and Code review
Replies: 15
Views: 4583

Re: How to speed up your MySQL queries 300 times

... called my attention: "Totally misleading title. It should be named "MySQL for beginners", because this is really database 101 for DBA's. What is less known is that most SQL functions totally ignore indexes and incite a full table scan. Or that adding indexes like pepper and salt ...
by ariston.ap
Tue May 16, 2017 11:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to speed up your MySQL queries 300 times
Replies: 8
Views: 1376

Re: OT Recordset question

... select 2 union select 3 union select 4 unionselect 5 union select 6 union select 7 union select 8 union select 9) A; reference http://dba.stackexchange.com/questions/75785/how-to-generate-a-sequence-in-mysql
by Marcelo Via Giglio
Tue Nov 03, 2015 2:45 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: OT Recordset question
Replies: 6
Views: 690

Re: How many INDEX can create ON MySql and How to use it?

... clause that are automatically created with usual index functions like any other rdd. Creation of physical index files should only be done by the DBA managing the database otherwise you might get very bad results. 5) Any rdd function like SET RELATION are 100% supported biu you can do it like ...
by AHF
Sat Jun 27, 2015 4:43 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How many INDEX can create ON MySql and How to use it?
Replies: 8
Views: 2466

Re: Consulta Ado con Fw vs VB

google translator:

Si la consulta es usar muchas veces este es un trabajo DBA
Prueba MySql Query Analyser.
by AHF
Tue Jun 23, 2015 6:59 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consulta Ado con Fw vs VB - Solucionado
Replies: 16
Views: 4035

Re: Ms Access (ADO) in a network with multiple users?

... Server... and that can be expensive in an Enterprise setting and does not lend itself to the 'free version' and YES, you will need to get the IT DBA staff involved in setting up the Sql Server and set up the initial permissions, ownership rights and the initial connection user, but once that ...
by Rick Lipkin
Fri Jun 12, 2015 1:36 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Ms Access (ADO) in a network with multiple users?
Replies: 2
Views: 748

Re: ADO RDD xHarbour

... it to 0 ado will try forever otherwise throws error. I think we should set it to 60 seconds then ask the user if he likes to continue trying. The DBA from our client advise us to do the following: Place a timer pinging to the server When it fails close the connection and open a new one. The recordsets ...
by AHF
Tue May 26, 2015 8:31 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: ADO RDD xHarbour

... they still must be there, but are just not accessible, hence why you have to Compact and Repair the database from time to time. And, my guess when DBA's tune their MS Sql and Oracles of the world, deleted records are purged during that process. In any case .. in my experience as a developer with ...
by Rick Lipkin
Fri Apr 10, 2015 12:42 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO RDD xHarbour
Replies: 1047
Views: 441927

Re: Clase TTABLE insertar Registros en Tablas SQL Lexico XBASE

... Linux (Con previa definicion de Idiomas), versiones, integridad referencial, entre otras experiencias. Hoy cuando llegue Horacio "tecnico y DBA" le pedire los script de los bat que hacen los respaldos de las bases de datos. Hemos probado varias opciones y los tiempos de respuestas debe ...
by jnavas
Tue Mar 10, 2015 9:17 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase TTABLE insertar Registros en Tablas SQL Lexico XBASE
Replies: 15
Views: 3541

Re: RDDADS.lib for Harbour and Borland

... to a specific location granting access to a specific record. Dbf tables and indexes are so simple to manage, we never think on the need to have a DBA on-site or any sort of special maintenance rituals to keep our database healthy. The beauty of ADS is that you get to keep all that while adding ...
by reinaldocrespo
Tue Jan 27, 2015 2:29 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: RDDADS.lib for Harbour and Borland
Replies: 24
Views: 4614

Re: Request for Advice

... hourly and funding information... meaning I had local data in over 50 locations and had to distribute my .exe to each server. I had one of the Dba's 'challenge me' to take that Enterprise application and migrate the data ( all the data ) to Sql Server. To sweeten the pot .. the DBA gave me ...
by Rick Lipkin
Fri Aug 23, 2013 5:53 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Request for Advice
Replies: 16
Views: 4898

Re: Close ADO-connection

... the server. I would presume all my legacy applications using Ms Sql would suffer from the same connection problem Yes. curiously why none of the DBA's would have noticed an excessive amount of open connections ? They should have. When an organisation has both Oracle and sql servers most DBAs ...
by nageswaragunupudi
Thu Aug 01, 2013 7:34 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Close ADO-connection
Replies: 34
Views: 10261

Re: Close ADO-connection

... as well :| I would presume all my legacy applications using Ms Sql would suffer from the same connection problem and curiously why none of the DBA's would have noticed an excessive amount of open connections ? .. and even how Ms Sql manages those as concurrent or not :?: Rick Lipkin
by Rick Lipkin
Thu Aug 01, 2013 5:12 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Close ADO-connection
Replies: 34
Views: 10261
Next

Return to advanced search