SQL Server

Pro Members SQL Server Standard Members

After Firing Me, My Old Boss Contacted Me Asking Work-Related Questions.

This question came from a job seeker. I was recently fired from a company. My old boss just contacted me asking work-related questions. Should I respond? Absolutely. But it’s the way you respond that is critical. Answer them as a consultant, only. You want to stay professional at all time Since you were fired, you should not be speaking to...

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.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

Tips for using backup and restore in SQL Server 2019

Tips for using backup and restore in SQL Server 2019 Use separate storage for the database backups. Ensure that you place your database backups on a separate physical location or device from the database files. You can use backup/restore of memory-optimized files on Azure Storage. In SQL Server 2019 memory-optimized filegroup files can be stored on Azure Storage. Backup/Restore of...

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.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

AI-powered Search with spaCy — Part 4

In the previous articles in this series, you learned how interrogative sentences of the most common types can be parsed, allowing you to extract the most descriptive words from a sentence to be used then for a search for a relevant answer. In other words, you learned to implement the ability to understand what the user is asking about or...

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.
Register
Already a member? Log in here
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.
Register
Already a member? Log in here
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.
Register
Already a member? Log in here
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.
Register
Already a member? Log in here
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.
Register
Already a member? Log in here
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.
Register
Already a member? Log in here