SQL Server

Missing-the-multiple-values-custom-field-in-MSP_EpmProject_UserView-in-Project-Server-2019-database

Query Multiple Values Lookup Table Field Project Server 2019

In this post, we’re gonna learn how to query multiple values lookup table field from Project Server 2019 database. You may also like to read Query Enterprise Custom Fields from Project Server Database Query Multiple Values Lookup Table Field Project Server 2019 Missing Multiple Value Lookup Fields in MSP_EpmProject_Userview In Project Server 2019, specifically, in …

Query Multiple Values Lookup Table Field Project Server 2019 Read More »

How to get the update level in SQL Server 2016

Consider you need to install a new Cumulative Update or Service Pack on your current SQL Server, but you don’t know what’s the current update level that already installed in your environment!! In this article, we will explain How to get the update level in SQL Server 2016 and detect the current installed Cumulative Update / …

How to get the update level in SQL Server 2016 Read More »

Enable Auditing in SQL Server 2016

How to Configure Auditing in SQL Server 2012/2016

In this post, we will explain how to set up and configure auditing in SQL Server. Auditing in SQL Server 2012/2016 SQL Server introduces new auditing capabilities that provide track database usage audit and I think it’s invaluable to all database administrators. Auditing in SQL Server can be implemented at The server level. The database …

How to Configure Auditing in SQL Server 2012/2016 Read More »