SQL Server

Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 5

Data Abstraction Layer In an illustrated view, an individual can understand in what way the dissimilar models work together. Consider this from the highest level, the external model. The external model is the view of the end user data. Generally, a database is a business system that meets the needs of numerous services. On the other hand, a service is…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

How to Deal with Rude and Difficult Team Members

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Editorials Security SQL Server

TIL: Columnar Encryption Might Be Susceptible to Abuse

I was reading a post talking about some SQL encryption technologies and statements (because, you know, that’s what I do just sitting around…) and found a new potential vulnerability that I’d never really considered before. I don’t pretend that I know *all the things* about security and encryption – it’s a constant process to keep learning and figuring out what […]

Pro Members SQL Server Standard Members

Some tips for using SQL Server 2019 file and filegroups

Some tips for using SQL Server 2019 file and filegroups Consider placing the tempdb log files on other physical disk arrays than those with the data files. Because logging is usually more write-intensive, it is important that the disk arrays containing the tempdb log files have sufficient disk I/O performance. Set the maximum size of the data and log files…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

AI-powered Search with spaCy — Part 3

In the previous articles of this series, you saw some examples of how you might use spaCy’s linguistic features to process user input, extracting the key word or key phrase from it to use then them for a search on the web. In. In the second part, you saw how to handle some complicated cases; for example, you looked at…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 4

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…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

How to Change Your Resume to Get More Interviews

This question came from a job seeker. I am having a hard time earning job interviews and I think I know why. My resume may give the impression of job-hopping. I hope you can help me! I am having a hard time earning job interviews for job positions in the legal industry. I have a college degree in paralegal studies…....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Exploring OLTP in SQL Server 2019 (Part 2)

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’,…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2019 Reporting Services

Tips for using SQL Server 2019 Reporting Services SQL Server 2019 Reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality. You can download SSRS 2019 at here: https://www.microsoft.com/en-us/download/details.aspx?id=100122 Consider hosting a database catalog used for SSRS in an Azure SQL Managed Instance. In SSRS 2019 you can host a database catalog used for SSRS in an…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale and Standard Member Monthly - Fall Sale members only.
Log In Register