SQL Server

Pro Members SQL Server Standard Members

Parsing Intents and Their Targets into SQL Queries with spaCy: Part 1

People use natural languages to communicate with each other. To efficiently interact with a machine, good knowledge of programming languages is required. Natural Language Processing (NLP) is here to enable human-machine communications through natural languages. This is however, a very general notion of what NLP is. Intuitively, it may seem that an NLP-enabled application understands human speech natively, like a…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 1

What is SQL (Structured Query Language)? SQL is a structured query language, a computer language in which the data stored in a relational database is stored, manipulated and retrieved. The structured query language (SQL) is the default language of the relationship database system. All relational database management systems, such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Should I Accept a Counteroffer or Move On?

This question comes from a busy professional. I told my boss that I’m going to resign, and he offered me twice my current salary if I stay, what should I do? Congratulation on the counteroffer. It says a lot about your value to their organization. Great job! Now for the hard part: deciding your next step. What was your reason…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 backup/restore problems

Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 3

SQL (Structured Query Language) – Indexes Indexes are special search tables that allow the database search engine to speed up data recovery. In short, an index is a pointer to the data in a table. An index in a database is very much related to an index which is present at the end of any book. For example, if you…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

How to Reject a Job Offer After Accepting It

This question comes from a busy professional. I accepted a job offer, but then received a much better one two weeks later. What is the right thing to do? 2nd company offered me 20% better pay with OT, closer to home, and better benefits. Congratulations on your great job offers! You did an amazing job attracting both companies. Please take…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Reporting Services

Troubleshooting SQL Server 2017 Reporting Services If you have problems with SQL Server 2017 Reporting Services (SSRS 2017), review this troubleshooting checklist to find potential solutions. 1. Check the SSRS logs if you have problem with Reporting Services. SSRS records many internal and external events to log files that record data about specific reports, debugging information, HTTP requests and responses,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 2

IBM DB2 Latest version 11.1. Developed in 1983. The language used is the C, C ++ assembler to write it. It is compatible with multiple versions of Windows, UNIX as well as Linux. Some functions are the following: It is very easy to install and configure, and the data is easily accessible. An individual can store the enormous amount of…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Effective Time Management For Business Success

Did you know that 69% of people waste time every day at work? Whether you own a budding small business, run a busy department, or manage a distracted team, it’s no surprise to you that the office is saturated with distraction. From social media sites to unnecessary meetings, the modern workplace is full of distractions keeping us from completing our…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register