What is something only managers know and no low-level employees are aware of? One thing that many low-level employees are often not aware is how performance evaluation, salary discussions, raises and bonus are actually decided. Most employees think their manager is the only input into their performance evaluation and salary opportunities. This is not true. Quotas Most companies have performance...
SQL Server
Tips for using Very Large Databases in SQL Server 2019
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...
SQL Server Backups and The Cloud
It used to be that SQL Server backups were the topic of every other webinar that was hitting the airwaves. Nowadays, that’s not the case; so many things have happened that make the backups just automatic. Not the least of these is the fact that your cloud provider may well be taking care of backups for you, making sure they […]
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,...