[25] Windows Power Shell DSC Learning Series - How to replace DSC Pull server database as Access database?

As we know, the default database of PowerShell DSC is ESENT file database, or Access database in oleDB form (database file suffix: mdb). Under the default installation mode, if the Pull server is installed with xDscWebService DSC resources, the default mode is ESENT file database; how to change the storage database of the Pull server into Acces ...

Posted by rrhody on Tue, 18 Dec 2018 01:54:04 -0800

Usage of SQL Server FOR XML PATH and STUFF functions

FOR XML PATH, in fact, it is to show the query result set in XML form, and the results of multiple lines in the same line. Let's write an example below: Suppose we have a workflow:      CREATE TABLE [dbo].[Workflow_Action]( [WorkflowSchema] [nvarchar](128) NULL, [ActionSchema] [nvarchar](128) NULL, [ActionName] [nvarchar](64) NU ...

Posted by Monshery on Mon, 17 Dec 2018 21:36:04 -0800

Oracle 12c Series (9) | Upgrade pdb database by unplug and plug

For Oracle database upgrade operation, the upgrade steps are similar between each version. First, Oracle software is upgraded, and then the data dictionary tables in the database are upgraded. In Oracle 12c, when we integrate databases through containers, the upgrade mode becomes more flexible. After integration, I can choose ...

Posted by ayok on Mon, 17 Dec 2018 10:30:04 -0800

12 - (OLTP) String Search for HTAP Database PostgreSQL Scenario and Performance Testing - Fuzzy Query before and after

Label PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing background PostgreSQL is a database with a long history, which can be traced back to 1973. It was first awarded by the 2014 Computer Turing Prize winner and the originator of relational database. Michael_Stonebraker PostgreSQL has similar functions, performance, architectur ...

Posted by Koobazaur on Sun, 16 Dec 2018 23:24:03 -0800

Net Programmers Learn Oracle Series (15): DUAL, ROWID, NULL

1,DUAL table 2,ROWID type 2.1,Using ROWID to Query Data 2.2,Updating data with ROWID 3,NULL value 3.1,NULL and empty strings 3.2,NULL and Functions 3.3,NULL and Index 3.4,NULL and SQL 4,summary 1, DUAL table DUAL is a virtual table in Oracle, which is used to form the grammatical rules of SELECT. Oracle system guarantees that t ...

Posted by Dookster on Sun, 16 Dec 2018 17:18:04 -0800

Oracle Wait Events: Wait for scn ack

wait for scn ack is a waiting event that may be common in RAC environments, meaning waiting for a SCN response across instances. Top 5 Timed Events Avg %Totalr ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ...

Posted by 00tank on Sun, 16 Dec 2018 10:03:03 -0800

Oracle11g migrates from single instance + ASM to RAC+ASM

A few days ago, when my department colleagues were working on the project, the customer asked to migrate the single instance + ASM database to RAC+ASM. After that, the God sorted out some ideas and operation details and published them on the company's public number. I saw itching in the future, so I planned to do an experiment ...

Posted by Jewbilee on Sun, 16 Dec 2018 02:06:03 -0800

Dynamic SQL of mybatis (3) The use of where, set and trim Tags

In our last blog, we briefly introduced the use of choose when other wise. In this blog, we will talk about another similar label: where, set, trim. 1. The role of where tags: Insert a where if there is a return value in the element contained in the tag; if the characters after where begin with AND and OR, they are excluded. For instance ...

Posted by jmboblee on Sat, 15 Dec 2018 21:54:03 -0800

[ArcSDE/Oracle] Configure Oracle so that SQL can operate on ST_GEOMETRY type

To use the relevant dynamic link libraries in sde, you need to install arcsde and oracle beforehand. 1. Test cases select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual; 2. Configure listener.ora, tnsname.ora and extproc.ora If the following error occurs: ORA-28595: Extproc agent: invalid DLL path ORA-06512: In "SDE. ...

Posted by Grayda on Sat, 15 Dec 2018 19:42:03 -0800

Lazy Gadget: T4 Automatically Generates Model,Insert,Select,Delete and Method of Exporting Excel

I wrote an article before, lazy gadget: Automatic Generation of Model,Insert,Select,Delete and Method of Exporting Excel But some people find this method troublesome. In fact, I do feel a bit troublesome, the trouble is the string stitching. At this time, I think of T4 template. Students who have used EF's Database First to automatically genera ...

Posted by Rippie on Sat, 15 Dec 2018 16:48:03 -0800