Pro Members

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
Pro Members SQL Server Standard Members

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

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 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 Do You Work with Someone Who Expects Flawless Work?

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

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 1)

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

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

Some useful tips for using XML in SQL Server 2019

Some useful tips for using XML in SQL Server 2019 Consider replacing OPENXML with the XML nodes() function. The nodes() function is useful when you want to shred an xml data type instance into relational data. The result of the nodes() function is a rowset that contains logical copies of the original XML instances. Use CROSS APPLY to get data…...

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 2

In the first article of this series, you learned some techniques you might use to process user questions, extracting the key word or phrase from it to perform a search on the web. You saw some examples of how to deal with certain types of user questions, finding the most important pieces of information in it. In this part, you’ll…...

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 Do You Work with Someone Who Refuses to Respond to Emails?

This question came from a job seeker. How do you work with someone who refuses to respond to emails because it creates a paper trail? The first rule of good business is to keep a paper trail of all official business interactions. It will save you much frustration and miscommunication. If someone is afraid of a “paper trail” – it…...

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

Useful SQL Server 2019 features

Useful SQL Server 2019 features 1. Memory-optimized TempDB metadata. In SQL Server 2019 Microsoft introduces a new feature that is part of the In-Memory Database feature family. This is memory-optimized TempDB metadata. Now the system tables involved in managing temporary table metadata can be moved into latch-free non-durable memory-optimized tables. Use the following script to turn on the memory-optimized TempDB…...

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