SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Zora's SQL Tips

Hi! I am Zora Stalin, an IT geek and a passionate learner of technology. Besides my job as an Information Technology Analyst, I love searching and sharing new things that excite me help for others.

Archives: March 2017

A Perfect Solution to Resolve SQL Server Error 211

SQL Server Schema is basically a collection of SQL Objects that includes the tables, related columns, its entries, or other components. Due to this, it becomes easy for a user to access the database in the more reliable and effective way. However, there are some situations such as destruction in… Read more

0 comments, 656 reads

Posted in Zora's SQL Tips on 28 March 2017

How easy to implement RLS (Row Level Security) in SQL SERVER 2016 (New Feature)

To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.
Problem 1 Suppose, you have a Multi-tenant e-commerce website and different companies registered on your website and you have centralized single database for all the client. Now as a product owner it is your responsibility that one tenant’s…

Read more

0 comments, 1,379 reads

Posted in Zora's SQL Tips on 27 March 2017