Standard Members

Pro Members SQL Server Standard Members

How to make accurate estimates in an Agile environment – Part 2

This is the second installment of a 3-Part article regarding a question from a busy SQA Huddle Lead professional: How can we create more accurate estimates in an Agile space? With all our analysts as beginner, in an Agile space, I don’t believe they have been exposed to any concept of “resource estimation” or “test execution rate”, and therefore providing...

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

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2)

Useful Undocumented SQL Server 2016 DBCC Commands (Part 2) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2016. 1. DBCC errorlog This DBCC command can be used to truncate the current SQL Server log. You can use this command when you rarely...

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

A Holistic View of Database Management System (DBMS) – Part 3

Relational Model The widespread data model in DATABASE MANAGEMENT SYSTEM (DBMS) is the Relational Model. It is mainly a scientific model than any other models. This particular model is based on first (1st) order predicate logic as well as describes a relation or table as an n-ary relation or table. The key highpoints of this relational model are: · 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.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

How to Make Accurate Estimates in an Agile Environment – Part 1

Part 1 Today’s question comes from a busy SQA Huddle Lead professional: How can we create more accurate estimates in an Agile space? With all our analysts as beginner, in an Agile space, I don’t believe they have been exposed to any concept of “resource estimation” or “test execution rate”, and therefore providing a good baseline of “how many TCs...

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

Useful Undocumented SQL Server 2016 DBCC Commands (Part 1)

Useful Undocumented SQL Server 2016 DBCC Commands (Part 1) In this article, you can find the description of some useful undocumented DBCC commands, and find out how you can use these commands in SQL Server 2016. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax: DBCC addinstance (objectname, instancename)...

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

A Holistic View of Database Management System (DBMS) – Part 2

ARCHITECTURE The design of a Database Management System (DBMS) relies on its architecture. It can be centralized or else decentralized or hierarchical. The architecture of a Database Management System (DBMS) can be perceived as either one (1) tier or multi (N) tier. Multi (N) tier architecture distributes the full system into connected however independent multiple (n) modules, which can be...

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
Development Pro Members Standard Members

How Can We Tackle Multiple Language Issues Within Our Portal?

Today’s question comes from a busy entrepreneur: How can we tackle multiple language issues within our portal? I am currently involved in the management of a B2B platform, eWorldTrade. The problem is that we cannot hire thousands of customer service representatives to deal with the huge number of clients registering everyday belonging to different countries. The problem with most 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

Troubleshooting problems with deadlock in SQL Server 2016

Troubleshooting problems with deadlock in SQL Server 2016 If you have problems with deadlock in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many deadlock bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the time this...

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

A Holistic View of Database Management System (DBMS) – Part 1

Introduction Database is a group of associated data as well as data is a pool of facts and figures which can be administered to create information. Generally data signifies recordable details. Data helps in creating information, which is grounded on facts. For an instance, if an individual have data about grades achieved by every students, an individual can then determine...

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
Development Pro Members Standard Members

How can I Grow Business on a Large Scale?

Today’s question comes from a busy entrepreneur: How can I grow my accounting and bookkeeping business on a large scale? . Even though the question is specifically regarding “accounting and bookkeeping” – the answer will work for most other small businesses. “On a large scale” can mean different things to different people. For this article, we will equate “on 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.
Register
Already a member? Log in here