Managing and Configuring Databases

Last Updated On : Tuesday, May 22, 2018Managing and Configuring Databases Overview Database administrators are often responsible for configuring and managing database infrastructure, such as the location of database files, and issues such as database encryption, which do not have a direct impact on users of the database. This lesson covers managing and configuring the […]

Configuring Additional SQL Server Components

Last Updated On : Wednesday, May 23, 2018Microsoft SQL Server 2012 database administrators (DBAs) must be able to deploy not only the Database Engine but also Analysis Services and Reporting Services in either Native or SharePoint integrated mode. In this chapter, you learn about the new FileTable feature and configuring Integration Services security and support […]

Miscellaneous Statements

Last Updated On : Thursday, October 19, 2017Miscellaneous Statements: In this post we will discuss the miscellaneous statements or DBCC statements, their functions, and the permissions required to run them are as follows: DBCC dllname (FREE) Unloads a specific extended stored procedure DLL from memory. The user must be a member of the sysadmin fixed […]

Row-Level Compression

Last Updated On : Tuesday, May 26, 2015Row-level compression works by using more efficient storage formats for fixed-length data. Row-level compression uses the following strategies to save space: 1) Storing fixed-length numeric data types and CHAR data types as though they were variable-length data types. 2)Not storing NULL or 0 values. 3)Reducing metadata required to […]

Deploying and Configuring SharePoint Integration

Last Updated On : Tuesday, May 26, 2015You can deploy Analysis Services and Reporting Services as shared services in a SharePoint farm. Deploying Analysis Services and Reporting Services enables you to use features such as PowerPivot for Microsoft SharePoint and Power View, a Reporting Services interactive report designer. To deploy Reporting Services, Power View, and […]