This question came from a busy professional. Being a manager how do you deal with rude and difficult team members? This is difficult because often it’s a manner of perception or perspective. What some employees deem rude may seem “direct” or “accurate/precise” to others. What some employees find difficult may be diversity in the work place. Not many of us...

Types of Data Models Record-Based Logical Data Models Logical data models based on records deliver concepts that users can understand, however data are not far from the way is kept on the computer. Three known data models of this kind are relational data models, hierarchical data models, as well as network data models. The relational model signifies data in the...

Enabling In-Memory OLTP in new and existing databases To create a new database and enable In-Memory OLTP in it, you can use the following script: CREATE DATABASE DemoOLTPDB ON PRIMARY ( NAME = DemoOLTPDB_data, FILENAME = ‘D:dataDemoOLTPDB.mdf’, size=500MB ), FILEGROUP DemoOLTPDB_IMOLTP_FG CONTAINS MEMORY_OPTIMIZED_DATA ( NAME = DemoOLTPDB_FG_Container, FILENAME = ‘D:dataDemoOLTPDB_FG_Container’ ) LOG ON ( NAME = ExamBook762Ch3_IMOLTP_log, FILENAME = ‘D:dataDemoOLTPDB_log.ldf’,...

Control of Data Redundancy Ideally, the database approach stores each piece of data in a place in the database. In certain cases, there is still data redundancy to increase system performance. However, this redundancy is controlled as well as minimized through application programming by introducing the least amount of redundancy as much as possible in the database design. Data sharing...

This question came from a busy professional. My boss told me that she expects my work to be flawless when she checks it and I responded “okay” with a smile. She told me to stop smiling. How should I have reacted? This is a sticky situation. Don’t Judge If this is uncharacteristic of her, then she may be having a...

SQL Server has for long been Microsoft’s flagship database product. It has emerged one of the most popular Relational Database Management Systems (RDBMS) available in recent times. To meet the demands of the businesses and enterprises, many features have been added to the newer versions of SQL Server such as the In-Memory OLTP Engine. Support for OLTP was first introduced...