This question came from a busy business owner. How do you deal with a toxic coworker? If someone at the office is making you feel consistently stressed or unmotivated, you might be dealing with a toxic coworker. Most importantly don’t take it personally and keep your interactions always profession. Don’t let this toxic behavior damage your professional, emotional and physical...
SQL Server
Troubleshooting problems with connection to SQL Server 2017
Troubleshooting problems with connection to SQL Server 2017 If you have problems with connection to SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Check that you specify the SQL Server name correctly. If you get the error message indicates that “Specified SQL Server not found” check that you specify SQL Server name correctly and SQL Server...
Data Warehousing with ORDBMS, Parallel and Distributed System – Part 6
THE ETL (EXTRACT TRANSFORMATION LOAD) PROCESS This section explains the 4 main processes of the data warehouse. They are extract (data from operating systems as well as transferred to the data warehouse), transform (data in internal format as well as organization of the data warehouse) as well as cleanse (to ensure quality of use sufficient for decision making) as well...
How to Effectively Network as an Introvert
This question came from a busy business owner. How can I effectively network as an introvert? First, I would recommend that you stop thinking of yourself as an introvert. Labeling yourself usually boxes you in to some preconceived behaviors. Everyone has things that makes them uncomfortable. Simple practice will help you be more comfortable in any situation. Here are some...
Troubleshooting problems with AlwaysOn Availability Group in SQL Server 2017
Troubleshooting problems with AlwaysOn Availability Group in SQL Server 2017 If you have problems with AlwaysOn Availability Group in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Ensure the accounts under which SQL Server 2017 is running are correctly configured. Microsoft recommends use the same domain user account for the partners in AlwaysOn Availability Group. If...
Data Warehousing with ORDBMS, Parallel and Distributed System – Part 5
Benefits of Data Warehousing Includes the use of the data warehouse, Find the right information Presentation of information. Hypothesis test Information discovery Transmit the analysis Tangible benefits (quantified / measurable) it includes: Improved product inventory. Lower production costs. Improved selection of target markets. Improved management of assets as well as liabilities. Intangible benefits (difficult to quantify) it includes: Increase productivity...
How to Set Up an Organizational Structure For a 5-Year-Old Business
Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management, and work-life balance strategies. This question came from a busy business owner. How do I...
Troubleshooting SQL Server 2017 In-Memory OLTP
Troubleshooting SQL Server 2017 In-Memory OLTP If you have problems with In-Memory OLTP in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. You may notice a temporary decrease in performance for In-Memory OLTP transactions when using In-Memory OLTP with Always On availability groups. This problem occurs when the availability group is configured to use the synchronous-commit...
Data Warehousing with ORDBMS, Parallel and Distributed System – Part 4
Administration and Management of Data Warehouse The data warehouse management includes: Security as well as precedence management. Screening updates from multiple sources Checking data quality. Manage as well as updating the metadata. Reviewing as well as report on the use of the data warehouse as well as its status. Data cleaning Replication, sub-configuration as well as distribution of data. Backup...
When Leaving Early Is a Bad Thing
Hello, this is Laura Lee Rose – author of the business and time management books TimePeace: Making peace with time – The Book of Answers: 105 Career Critical Situations – and I am a business and efficiency coach that specializes in time management, project management, and work-life balance strategies. This question came from a business professional. How do managers feel...