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...
SQL Server
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...
Troubleshooting SQL Server 2016 System Stored Procedures
Troubleshooting SQL Server 2016 System Stored Procedures If you have problems with SQL Server 2016 system stored procedures, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many system stored procedures bugs were fixed in SQL Server 2016 service packs, you should install the latest SQL Server service pack. At the...
Switching Careers Gracefully
Today’s question comes from a busy professional: Life circumstances, interests, financial obligations, and the job market can all create the need to change careers multiple times throughout your life. What advice can you offer people who need or want to change careers? This could include tips on going back to school, leveraging your network in a new industry, writing a...
Comparing A Stored Procedure Call Using Ado.Net and Entity Framework
Calling a stored procedure and returning the results as a collection of a POCO is a lot easier to write in Entity Framework than traditional Ado.Net. The following example makes a comparison. To begin this editorial, I create a stored procedures in the AdventureWorks sample database for SQL Server, where I return a few columns from the HumanResources.Employee table, and […]
Troubleshooting problems with views in SQL Server 2016
Troubleshooting problems with views in SQL Server 2016 If you have problems with views in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many bugs with views in SQL Server 2016 were fixed in SQL Server service packs, you should install the latest SQL Server service pack....
Options we have for patching SQL Server Instances — (Part 1)
Author: Basit A. Masood-Al-Farooq In this first part of the two part article series, we will first explore the various SQL Server patch types. Next, we will explore the different options we have to patch SQL Server. Types of patches available for SQL Server The following are the main types of patches available for SQL Server: Service Packs A service...
Distributed Databases with Client Server Architectures Part – 7
An Outline of Client – Server (CS) Architecture As it was mentioned in the article introduction, full scale Distributed Database Management Systems (DDBMS) have not been advanced to support every category of functionalities which was discussed so far. As an alternative, distributed database applications are being established in the background of the client – server (CS) architectures. It is at...
How to Tell Your Boss No Without Saying
Today’s question comes from a busy professional: I’m looking for advice on how to say no to your boss without actually using the word “no.” Often we are asked to work over the weekend, stay late at night or attend an event that conflicts with a personal event like a concert or a wedding. How do we say no to...
Troubleshooting SQL Server 2016 Roles
Troubleshooting SQL Server 2016 Roles If you have problems with SQL Server 2016 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...