Blog : What’s On Our Mind?

Sharing Our Point of View
By Eric Russo | On October 6th 2015
Row-level security never got this easy with SQL Server 2016
Security has been one of the focus area by Microsoft SQL Server product team. Almost all the releases either have some new security feature or enhancement of an existing features. The same story continues with SQL Server 2016 as well. There are many security features like “Always Encrypted”, “Dynamic Data Masking”, “enhancement of Transparent Data Encryption” and “Row-Level Security” added in SQL Server 2016. In this blog we would talk about Row-Level security feature. Row-level security provides fine-grained…
By JP Chen | On October 1st 2015
Scripting Out the Logins, Server Role Assignments, and Server Permissions
As we move into new locations such as offices, apartments, or houses, we need to have the new keys given to us. Obviously, we do not want the keys for our old locations to work on the new ones. Unlike relocations in real life, we will want the SQL Servers authenticated logins and Windows authenticated logins to work on the new servers as we migrate the databases. Imagine there are over one hundred logins in the source…
By Robin Caputo | On September 30th 2015
Many companies need part-time database administrators. Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work. Other times there’s a persistent need for such fractional services, like covering for DBAs on vacation or family leave. Many companies also maintain databases that do not require the services of a full-time DBA, but do need to be monitored and maintained. But the overriding need for fractional DBAs is driven by the stunning growth in the amount of data…
By Chuck Ezell | On September 29th 2015
If you’ve worked with database technologies for any length of time, you may have heard of a process known as data purging. Although it might seem that an organization would want to keep all its data for data mining and analysis, there is a finite amount of storage available to warehouse those bits and bytes. When data is not purged regularly, the tables in a database can grow so large that performance begins to deteriorate. Purging is an important aspect of database performance tuning. Techopedia defines it as: Methods that permanently…