Tips for using Very Large Databases in SQL Server 2019 Avoid using SQL Server Management Studio to maintain Very Large Databases. Because using SQL Server Management Studio is very resource expensive, use stored procedures and Transact-SQL statements, in this case. For heavily accessed table with text/image columns, place this table in one filegroup and place text/image columns in a different...
Pro Members
Database Model and E-R Diagram – Part 1
Database Models A database model defines the logical structure and structure of a database and defines how the data is stored, called up and updated in a database management system. While the relational model is the most commonly used database model, there are other models: Flat Data Model Entity-Relationship Model Relational Model Record base Model Network Model Hierarchical Model Object-oriented...
What Is the Difference Between Program, Product, and Project Manager Roles?
What is the difference between program, product, and project manager roles? I’ve been both a program manager and a product manager at IBM. While day to day activities tend to vary from team to team even within the same company here’s a quick overview of roles. Technical Program Manager: Responsible for driving the day to day execution of a agreed-upon...
Tips for using linked servers in SQL Server 2019
Tips for using linked servers in SQL Server 2019 Rewrite remote queries so, that the most work will be performed on the remote server, not the local server. You can run the remote query from Management Studio and take a look at the query plan to find out which parts of the remote query are performing on the remote server...
AI-powered Search with spaCy – Part 8
In the previous articles in this series, you’ve learned a lot of different techniques that might be used for modifying a search string submitted by a user to a search engine, in order to obtain more relevant results. Thus, for example, you looked at how to find noun chunks and enclose them in double quotes in part 7, and how...
Database Management System at a Glance – Part 2
Database Management System Architecture The design of a DBMS depends on its architecture. It can be central or decentralized or hierarchical. The architecture of a DBMS can be viewed as a level or as multiple levels. An architecture with n levels divides the entire system into n linked but independent modules that can be modified, changed, changed or replaced independently...
What Should I Do if My Manager is Taking Advantage of Me?
What should I do if my manager is taking advantage of me? I’ve been working at a small firm for a few months. The owner quickly found out that my skills surpass the job, so she’s overworking me with no change in pay or title, while she works less. One thing that is working to your disadvantage is that you...
Tips for using indexed views in SQL Server 2019
Tips for using indexed views in SQL Server 2019 Avoid creating indexes on a view when the queries that use the view don’t contain JOINs or aggregations. In this case, the queries will not take advantages of the view’s indexes and the queries performance will be the same. Don’t create index on column(s) which values has low selectivity. For example,...
Database Management System at a Glance – Part 1
Definition of Database The Database is an interdependent collection of data that is used to retrieve, insert, and delete data efficiently. It is also used to organize data in the form of a table, chart, views and reports, etc. For example: The university Database organizes data about the administrator, employees, students and teachers etc. With the Database, you can easily...
What should I do if I’m realizing being a product manager is not for me?
What should I do if I’m realizing being a product manager is not for me? Discovering early that you’re not doing what you enjoy (or aren’t succeeding at it) is probably a gift. Two possible situations: You know what you’d like to do (or try) next. Have a frank but humble discussion with your current manager about it. If there’s...