Database Recovery

Key Benefits of Using Power BI with SQL Server

In this article we will explore the key benefits of using Power BI from Microsoft with SQL Server Database You may not be aware of the fact that Microsoft was providing BI or Business Intelligence since a long time in its SQL Server but this time in the latest 2016 SQL Server Version, its offering the Power BI that comes packed with features that were missing in the earlier versions. Power BI is now capable of presentation layer technologies like OLAP or Online Analytical Processing and...

Read more »

Row Level Security in SQL Server 2016 – The Basics

In this article we introduce you to row level security features in SQL Server 2016 In case, you ever wished to have security for your data at the record level, then your wish is fulfilled in the new SQL Server 2016 version that comes with an interesting Row Level Security Feature. Well, it is a concept that offers security right at the row level in a database layer and not at the application layer. This feature is particularly beneficial when the user required control on access of data at...

Read more »

Optimizing your Windows Server while working on SQL Server Database

In this article we look at some of the customizations you need to make on the Windows Server while running a SQL Server instance on it. Working on SQL Server Database on a system that is already installed with a default Windows Server implementation can be a tricky thing. Without proper planning, some processes and settings of Windows server can conflict with your SQL Server implementation. So, check out some easy ways to optimize your Windows Server while working on an SQL Server...

Read more »