(877) 775-9282 support@sqlwatchmen.com

Row-Level Security – Concept to Proof

Row-Level Security (RLS) is one of the most often asked for features that I hear from customers.   Done correctly, Row-Level Security ensures data segregation for users in a single database. This ensures each user can only view or manipulate data that they can access....

read more

Attitude of a DBA

Is a DBA just a button clicker? Can a good DBA be replaced by anyone who knows the same technical skills? 'Supporting the business' can be a lot more involved. What Does a DBA (Database Administrator) Do Anyway? Some people think a DBA simply Tweets, Facebooks,...

read more

Best Practices for Database Schema Design (Beginners)

In this article, we will discuss a few common design decisions when defining a Schema. We’ll focus on the planning stage. There are many opinions about what is ‘best’. Here we discuss some basic guidelines which may or may not be best for your specific needs. There are two primary ways a database is used. One is Online Transaction Processing (OLTP) and the other is […]

read more