Yearly Archives - 2020

How to execute a T-SQL command to every table in SQL Server database

sp_MSforeachtable is a stored procedure that is mostly used to apply a T-SQL command to every table, iteratively, that exists in the current database. Examples on how to use it: 1-Perform an unconditional reindex over all tables in the database: EXEC sp_MSforeachtable 'DBCC DBREINDEX(''?'')' 2-Truncate all tables in the database: EXEC sp_MSforeachtable 'TRUNCATE TABLE ?' 3-Get the information about the...

Exception Handling in Angular 10

I am using Angular 10 and when I click to open Persons page I get “Nulljector error” and redirect me to the home page . NullInjectorError: No provider for PersonServiceProxy! <a ng-reflect-router-link="/app/main/phonebook" href="/app/main/phonebook">phonebook </a> The solution : Add your ServiceProxy to providers in "\angular\src\shared\service-proxies\service-proxy.module.ts". Open service-proxy.module.ts fileIn @NgModule > providers > Add this Line “ApiServiceProxies.PersonServiceProxy” like this

How to manage when you’re between jobs

Has the COVID-19 crisis left you without a job? There are few things more anxiety inducing losing your job unexpectedly. You suddenly have the pressure to find new work, keep your household moving, and make ends meet without a consistent income. The added stress of facing a pandemic only makes it all harder to...

Scalable Solutions by Nile Bits Take Care of The Business Needs of Today: GoodFirms

Nile Bits is a proponent in the software development field that has etched its name in the good books of GoodFirms. About the Company Nile Bits, founded in 2014, located in Canada and Egypt, offers the best and most effective software development, testing, and mobile app development solutions. The company offers full-cycle services that leverage professionalism and...

Coronavirus (COVID-19) Announcement

Since Nile Bits always put the safety of its employees first. Also Nile Bits aware of its responsibilities towards our community and its safety to prevent further spread of Coronavirus (COVID-19). Therefore, Nile Bits decided to allow work from home for all its employees. We worked on enhancing our working remotely plan by enabling all...