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...
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...
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...
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...
Prior to DBMS, Database Approach, Data Model — Part 1
Prior to Introduction of Database Management Systems (DBMS) The way computers manage data has changed dramatically in the last few decades. Today’s end users take the many advantages of a database system for granted. Not so long ago, computers used a less elegant as well as expensive approach to data management called a file-based system. File-Based System One way to...
How Do I Thank My Boss for a Pay Raise?
This question came from a busy professional. How do I thank my boss for a pay raise? I received a good raise because of my excellent performance over the years, but I wasn’t gushing over it. I had been with the company for about 8 years, and was the manager of two teams: the test and documentation groups. I received...
Troubleshooting SQL Server 2017 installation
Troubleshooting SQL Server 2017 installation If you have problems with SQL Server 2017 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2017, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster recommended – Memory...
AI-powered Search with spaCy — Part 1
One of those tasks AI powered application usually faces is the ability to understand what the user is asking about or what he/she wants to know. Actually, it’s a big challenge to make your code “understand’ user questions. In this article, you’ll see an example of how you can create “smart” code that can process a certain type of user...
What Are the Signs Indicating That an Employee Is About to Quit?
This question came from a busy business owner. What are the signs indicating that an employee is about to quit? Keeping a good employee It’s hard to tell if an employee is thinking of quitting, but to avoid losing good employees and performers, do the following: Setup one-on-one twice monthly meetings to discuss career opportunities and advancement options Identify each...
Troubleshooting security problems in SQL Server 2017
Troubleshooting security problems in SQL Server 2017 If you have security problems in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Dimension security is ignored by Power BI Desktop in SQL Server Analysis Services Multidimensional model. In this case, when you open the dimension, all the measures become visible, and even those that you have denied...