2,906 reputation
21021
bio website datajini.com
location Frösön, Sweden
age 41
visits member for 2 years, 5 months
seen 13 hours ago

I'm an Oracle Database Specialist at DataJini, an Oracle consultancy that specialises in building solutions using MDD techniques.


13h
reviewed Looks OK How can I aggregate multiple results from another table using something like BOOL_AND?
1d
reviewed No Action Needed Optimal Table Index for hourly data
1d
reviewed No Action Needed How do I identify the program that called a stored procedure?
1d
reviewed No Action Needed Table-based custom type does not verify check constraints
2d
reviewed Edit Exporting table records to an INSERT script
2d
revised Exporting table records to an INSERT script
deleted 9 characters in body
2d
revised Automating SQL Server Merge Replication Processes
edited tags
2d
reviewed No Action Needed Stored Procedure Issue in Simple Select Statement
2d
reviewed Close Automating SQL Server Merge Replication Processes
2d
comment Automating SQL Server Merge Replication Processes
Which DBMS are we talking about?
Dec
18
reviewed Approve Scheduling an event every day at a given time
Dec
18
reviewed Reviewed Suspended query causing high CPU usage
Dec
18
reviewed Reviewed what is the difference between data migration and ETL?
Dec
18
comment what is the difference between data migration and ETL?
I see the distinction as data migration being a once-off process done to move data from one system to another, while ETL is a process used to move data between systems on a regular basis.
Dec
17
reviewed Reject BULK INSERT permission on a single database
Dec
17
comment Best approach to get last value inserted
Number 3 works well for me. Make sure you have an index on (device_id, date_inserted desc).
Dec
17
reviewed No Action Needed Best approach to get last value inserted
Dec
17
reviewed No Action Needed Partition by year and sub-partition by month mysql
Dec
17
reviewed No Action Needed How is it called when a DB supports FOR XML and XQUERY?
Dec
17
reviewed Approve Where do I find the tables that a role has access to in Vertica?