MySQL stored procedures are objects containing one or more SQL statements for reuse. They often contain business logic. Robert Sheldon demonstrates how to create and call stored procedures.

Audit systems: a good idea or a mess to maintain?

by Ben Kubicek

SQLServerCentral.com

Editorial

Audit systems can be a good idea, but they can also be a mess to maintain.

It's Not Yours

by Steve Jones

SQLServerCentral.com

Editorial

We may talk about our databases, but hopefully most of us know we don't own the data.

It's the Engineers

by Steve Jones

SQLServerCentral.com

Editorial

The staff that build your systems are more important than your choice of technology.

Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking

by Steve Jones

SQLServerCentral.com

Learn about the permissions associated with Dynamic Data Masking as well as some of the security implications of using this feature.

Production Subsets

by Steve Jones

SQLServerCentral.com

Editorial

Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.