programmer group

MySQL lock classification you should know

Lock in MySQL Lock is a means to solve the resource competition in the concurrent environment, among which optimistic concurrency control, pessimistic concurrency control and multi version concurrency control are the main technical means of database concurrency control (see my previous article for details), and the lock in MySQL is one of the pessimistic concurrency control. There are many kinds of locks in MySQL. We can classify them...

chandlerdba.wordpress.com chandlerdba.wordpress.com

Oracle Table Prefs

V. Quick post for me really: Some SQL to tell me all of the Table Prefs for any specific table (All Oracle 19 prefs) You could always just query DBA_TAB_STAT_PREFS select * from user_tab_stat_prefs where table_name = '&&TABLE'; But that only tells you what you have explicitly set for a table, which will override any GLOBAL prefs. The order that prefs are used is TABLE -> GLOBAL -> DEFAULT. If some DBA has changed a global pref,...

agileadvice

The Rules of Scrum: The top PBIs are small enough (effort) that several can fit into a single Sprint

Product Backlog Items (PBIs) that are at the top of the Product Backlog (in other words, those which are to be done next), need to be small enough that the Scrum Team can comfortably complete all the work for them within a single Sprint.  The Product Owner should be spending a little time every Sprint to split “large” PBIs into small PBIs.  The Product Owner relies on the team to estimate if they are small enough.  If the PBIs...

databasejournal.com databasejournal.com

Administering SQL Server 2005 Integration Services - Page 4

Logging Packages Execution The two main types of logging possible with packages in SSIS are Logging within the Package—Logging within the package is logging tasks that are built into the package at design time using the SSIS Designer. This form of logging is covered in Chapter 11. Console Logging—This form of logging is independent of the package design and is handled by the tool executing the package. This is the type of...

databasejournal.com databasejournal.com

Administering SQL Server 2005 Integration Services

SQL Server 2005 Management and Administration By Ross Mistry, Chris Amaris, Alec Minty, and Rand Morimoto Published by Sams Publishing ISBN-10: 0-672-32956-5 ISBN-13: 978-0-672-32956-2 Buy this book Chapter 5: Administering SQL Server 2005 Integration Services SQL Server 2005 Integration Services (SSIS) replaces the SQL Server 2000 Data Transformation Services (DTS). SSIS provides for the following data...