9 Tips for Better Database Design

| May 2, 2016

article image
One problem that I have seen is when data modeling occurs at the same time as software development. This is like building the foundation before completing the blueprints. In the past, planning seemed an obvious step before starting development. Development teams would not create databases without planning just like architects would not build buildings without blueprints. In application development, it is critical to understand the nature of the data. Planning is often ignored so that developers can just “start coding”. The project starts and when issues come up, there is no slack in the schedule to address them. Developers take shortcuts with the intent to fix them later but this rarely if ever happens. Careful planning is how to ensure that you end up with a proper database that is not hacked together. If you don’t spend the time and effort upfront addressing the data required by the processes, you’ll pay for it later with a database that must be reworked, replaced or scrapped.

Spotlight

F-Secure Corporation

Nobody knows cyber security like F-Secure. For three decades, F-Secure has driven innovations in cyber security, defending tens of thousands of companies and millions of people. With unsurpassed experience in endpoint protection as well as detection and response, F-Secure shields enterprises and consumers against everything from advanced cyber attacks and data breaches to widespread ransomware infections.

OTHER ARTICLES

A Cloudy Future: Data Center Demand and COVID-19

Article | April 15, 2020

COVID-19 has altered our world. In this series of stories, Data Center Frontier explores the strategic challenges the pandemic presents for the data center and cloud computing sectors as we navigate this complex new landscape. We begin with a look at how COVID-19 is impacting demand for digital infrastructure. The COVID-19 Coronavirus pandemic has reinforced the importance of data centers and cloud computing for our society. In the early days of the crisis, the data center

Read More

All-out SaaS for IT operations management

Article | April 9, 2020

Software-as-a-service (SaaS) is an old friend that has been an established business model since the 1960s. It is a broad term referring to everything from platform to software and various other technology ecosystems that are offered to customers on a consumption pay-per-use model. In 2019, the SaaS market was estimated to be worth $141 billion. The 2020 market is projected to reach the $157 billion mark. When compared with figures from 2014 when the industry was said to be worth $63.19 billion, the growth is exponential.

Read More

Understand the role of infrastructure as code in DevOps

Article | February 28, 2020

Infrastructure as code plays a prominent role in enterprise DevOps shops. Use this chapter excerpt to understand why -- and to learn the basics of some common IaC tools. As technology evolves at a faster and faster pace, collaboration between teams, such as development and IT operations, becomes increasingly important to satisfy end user and business demands. DevOps aims to foster that collaboration, as well as improve application deployment times and quality. To succeed with DevOps, however, IT teams must be open to change. "DevOps is a culture different from traditional corporate cultures and requires a change in mindset, processes, and tools," writes Mikael Krief in the book Learning DevOps: The complete guide to accelerate collaboration with Jenkins, Kubernetes, Terraform and Azure DevOps.

Read More

COVID-19 and the IT sector: Challenges and Opportunities

Article | July 30, 2020

The year of the pandemic – that is how many of us will remember 2020 for generations to come. Challenging circumstances brought by the sudden and devastating spread of coronavirus (COVID-19) has made us witness the world making quick changes to remote working, businesses struggling to survive, the distress of social distancing rules, the emotional rollercoaster for people isolating, an overall crisis for health systems and the economy of countries, no matter where you were in the world. When reflecting on what it has meant so far, however, we must realise that it’s not all doom and gloom. As Albert Einstein once said, “in the midst of every crisis lied a great opportunity”. The crisis has prompted companies to reinvent and accelerate digital plans, to adopt new technologies and sales models in order to adapt and survive – and for Managed Service Providers (MSPs) to step up to support businesses and employees in every way possible. On the other hand, let’s also not forget what the changes have meant for the health of our ecosystems. With industries across varied sectors forced to work remotely and shut down operations, the changes have led to benefits for the environment – and we could argue that such break was something that our planet was desperately in need of. Even now, as we start to see our way out of this situation, it’s hard to believe how it all happened. For most countries, it was a similar case: we were hearing news about a new virus spreading in China; and before we knew more about it, the virus arrived in our own territories. It seemed unlikely, and yet, a few days later, the virus was quickly spreading, and lockdown restrictions came into effect for almost every nation in the globe. Millions of workers around the world had to leave the office and make a quick switch to remote working, without much notice at all. In the initial stages of lockdown, MSPs had to work around the clock to help customers that weren’t ready for flexible working, to enable people to work from home. As every other industry and business type, MSPs also encountered challenges. Not being able to help a client on-site can sometimes significantly affect the speed of project delivery. So, adjustments had to be made, wherever possible, to deliver services remotely, as quickly and seamlessly as possible. “We are all in this together” is a phrase that became widespread in the UK. IT professionals, like many other sectors, had to support each other, and they have been working together as a community, to assist clients, businesses, and the wider public, since working from home was suddenly imposed for the vast majority. In the technology space, there is a lot of knowledge to share and to work with, which has led to many tech leaders and companies offering free advice, webinars and other tools to help with the struggles that have risen in the midst of the pandemic. Shifting priorities based on customer needs In the initial stages of the pandemic, MSPs played a critical role providing small and medium sized businesses with the tools and the IT infrastructure to keep their business running. Enabling office-based workers to continue their work from home was only the first step, however. The sudden shift to remote working has required new tools and exposed new security vulnerabilities. All around the world, we saw an increasing number of cyber-attacks and threats taking place. Remote working means many people were using personal computers for work and business purposes, and so, products that are designed to keep personal computers protected became essential. MSPs have also focused on increasing security measures for protecting password and identities for customers. Passwords on their own are not secure enough and can be easily compromised, so it has been a case of quickly deploying password management and Multi-factor Authentication (MFA), also known as two-factor authentication (2FA). MFA immediately increases security and ensures that clients’ accounts are significantly less likely to be compromised. In a few simple steps, IT providers can deploy MFA to help protect an organisation against breaches due to lost or stolen credentials. Beyond helping employees to work from home securely, MSPs have assisted companies in implementing cloud-based applications, and managing access and restrictions to certain applications, especially for furloughed staff. Embracing opportunities in the post-pandemic landscape The spread of Covid-19 has made remote working the new norm, but how likely is this to become a permanent thing? Many employers and workers have started to believe that working from home will become more and more common for employees, even after the threat of the virus is gone. It’s difficult to know what the final picture will be, but it’s remains a fact that, as offices gradually re-open after lockdown, employers are increasingly looking at new ways of flexible working. Many organisations that have been forced to work from home have been functioning remotely with little to no issue, so it stands to reason that the future of work will become more flexible. Video-calls, online training sessions, webinars, online meetings, it all sounds too familiar now, doesn’t it? Remote working was already popular, though for a long time it wasn’t much more than a much-appreciated working benefit offered by employers, as part of the ‘job perks’ package. The pandemic only accelerated the need for remote working capabilities, and now telecommuting seems to be taking over as the new norm. The IT landscape has mutated, and quite possibly it has changed for good. Technology leaders will have to continue to listen to the evolving needs and demands of the users and the markets in which they operate. For MSPs, it means the crisis is bringing opportunities to provide value to clients seeking support for enhanced mobility and flexible working. Now that work-from-home setups are in place, there’s room for improving remote access solutions and security measures. Cloud migrations, which are expected to increase after the pandemic, present an opportunity for remote employees to improve collaboration and business resiliency. There will be a push towards more robust cloud-based solutions, and these migrations are likely to become one of the top opportunities for the months to come to drive revenue for MSPs, as well as VoIP solutions, business continuity and hardware sales. The pandemic seems to have accelerated the demand for cloud services and security solutions. MSPs will play an important role in finding the best solutions for every business type, to enable them to work more flexibly and effectively. IT providers will be increasingly tasked with the job of securing devices and protecting employees as they work remotely, especially for SMBs.

Read More

Spotlight

F-Secure Corporation

Nobody knows cyber security like F-Secure. For three decades, F-Secure has driven innovations in cyber security, defending tens of thousands of companies and millions of people. With unsurpassed experience in endpoint protection as well as detection and response, F-Secure shields enterprises and consumers against everything from advanced cyber attacks and data breaches to widespread ransomware infections.

Events