SQL Server

Pro Members SQL Server Standard Members

How Do Product Managers Break Down Requirements into User Stories?

How do Product managers break down requirements into user stories? A good product manager doesn’t “break down” requirements into user stories, they start with good user stories and work from there. The whole point of using user stories is that they are how you communicate “requirements” to your development teams. If you’ve already got a list of “requirements” then you’re…...

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 stored procedures in SQL Server 2019

Tips for using stored procedures in SQL Server 2019 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:…...

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 10

In this tenth part in the series, we are continuing to discuss how you might take advantage of linguistic features available in spaCy. In particular, we’ll look at how you might obtain necessary information related to the task of meaning extraction, when it comes to understanding of user input coming in the form of request utterances. From the previous parts,…...

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

Concept of Relational Database Model – Part 2

Join Operation A join operation combines linked tuples of different relationships if and only if a particular join condition is met. It is noted ?. For example, if there are two tables: EMPLOYEE and SALARY; Evaluation: ∏EMP_NAME, SALARY (EMPLOYEES ?. For example, if there are two tables EMPLOYEE and SALARY; Evaluation: (EMPLOYEE ?. For example, if there is two tables…...

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

Coronavirus: Tips to staying Motivated and Active

Social Distance doesn’t mean Isolation. Use current technology to stay connected:  Call, FaceTime, Web conference, Zoom, Skype your connections with coworkers and friends. Setup regular on-line meetings with your managers and co-workers.  Setup one-on-one meetings to stay connected. Have Virtual Lunches with friends:  FaceTime or Skype with friends to plan, cook, and eat lunch/dinner together.  Schedule these healthy and nutritious…...

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 DBCC commands in SQL Server 2019

Tips for using DBCC commands in SQL Server 2019 Try to run the DBCC commands when there are no other disk I/O operations, such as disk backups, replication and so on. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains several filegroups and you need to check…...

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

Concept of Relational Database Model – Part 1

Definition of Relational Database The relational database management system consists of all modern database management systems, such as SQL, MS SQL Server, IBM DB2, Oracle, My-SQL and MS-Access. Data is displayed in groups (rows) in RDBMS. A relational database is the most commonly used database. It contains several tables, and each table has its own primary key. The RDBMS was…...

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

Coronavirus: 3 Tips to Working From Home

Many companies are directing their employees to work from home during the current coronavirus.  But for those of us that are not used to working from home, this transition is stressful.  We can easily be distracted with laundry, kids, or a feeling of isolation. Here are a few tips for staying productive.   Double your efforts to illustrate status and…...

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 temporary tables in SQL Server 2019

Tips for using temporary tables in SQL Server 2019 Try to avoid using temporary tables inside your stored procedure. Using temporary tables inside stored procedure reduces the chance to reuse the execution plan. Use Table data type instead of temporary tables whenever possible. A Table data type is a special data type that used for temporary storage of a set…...

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 9

In the previous parts, you’ve learned a lot about how to use linguistics features in spaCy to interpret a user query’s intent. Continuing with this topic in this part, we’ll cover to extract intent from user input, using different pattern based on syntactic dependency labels. As a quick refresher, we’ll look at the role of the direct object/transitive verb pair…...

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