The 11-year-old Microsoft SQL Server 2008 database management software is reaching the end of its support on 9 July. The applications that use databases running on this software will be at risk of security and stability issues.
On self-managed databases, upgrading to the latest database version comes with a lot of risks. Many IT departments within companies go by the motto: “If it’s not broken, don’t fix it”.
Microsoft made it very clear that it would not be updating SQL Server 2005 after its extended support date and even left it vulnerable to Spectre and Meltdown by not releasing patches for the dated version.
Updating SQL Server versions may seem daunting, but the benefits far outweigh the effort it takes for a migration. In the last major version update, SQL Server 2016 introduced simpler backup functionality, database stretching, and always-encrypted communications with the database, to name just three features.
While backing up the database may be the last thing on the typical database administrator’s mind, it’s become increasingly important to do so. In SQL Server 2008, it’s clunky and causes headaches for many admins. However, in SQL Server 2016, one can easily set up an automated backup to Azure storage and let it run on smart backup intervals. Backing up offsite also reduces the need for disaster recovery for onsite damage.
Database stretching allows admins to push less frequently accessed data to an Azure database, automatically decided by SQL Server 2016. This reduces the admin of manually looking through what must be kept and what must be shipped off or deleted. It also reduces the size of the database, which also increases the performance of the applications that access it. The best part of this functionality is it automatically retrieves the less accessed records from Azure when users request it, without the need for manual intervention.
Always-encrypted communications are becoming more and more relevant to many companies, especially those operating in European regions after the introduction of GDPR. Encryption keys were previously managed by the admin, but now encryption is always handled by the client. Furthermore, the keys to encrypt and decrypt data are stored outside of SQL Server altogether. This means data stored in the database is always encrypted, and no longer for the eyes of a curious database manager.
The built-in reporting tools have also vastly improved with the addition of new reporting metrics and a modern look. It includes support for Excel reports for keeping documentation and Power BI for automated, drag-and-drop personalised reporting. Best of all, it removes the dreaded Active X controls, which made the reporting in a webpage feel very clumsy and bloated in previous versions.
A lot has changed in the past ten years in the world of SQL Server database management, and it’s not worth running into problems before Microsoft ends support for SQL Server 2008.
Did an earthquake take out SA Internet?
Seabed avalanches caused by an earthquake could have cut several undersea cables, leading to one of South Africa’s biggest Internet outages yet, writes ARTHUR GOLDSTUCK.
There is still no official explanation for freak breaks 11 days ago in two separate undersea cables that provide international access to South Africa’s Internet users. However, as reported in the Sunday Times yesterday, the most common causes of such breaks are damage by ship anchors and earthquakes at sea.
However, the freak occurrence of two separate cables being cut simultaneously far out at sea, as happened on the morning of 16 January, can only be explained by sea-bed activity. One of the cables was cut in two places, and it is widely believed that a third major cable was also cut.
The cable damage mostly occurred in or near an area called the Congo Canyon, which starts inland and extends 220km into the sea. It is known for having the world’s strongest “turbidity currents”, underwater sediment avalanches over hundreds of kilometers, which are known to destroy undersea cables.
The most likely culprit is a 5.6 magnitude earthquake that struck the Atlantic Ocean near Ascension Island shortly before the cables were cut on the morning of 16 January. The earthquake occurred just before 8am South African time, and local ISPs reported losing international access from just before 10am. The epicentre of the earthquake was more than a thousand kilometres off the coast of Africa, but disturbances caused by seismic activity at sea become more powerful as they approach the coast. Combined with turbidity currents, this could well have taken out all cables in the area.
The West Africa Cable System (WACS) was cut in two places, and the South Atlantic 3 (SAT3) cable in one location. Industry insiders believe that the Africa Coast to Europe (ACE) cable was also cut, but it has not been publicly confirmed.
South Africa is connected to the global Internet via seven such cables, with a total capacity of 42.3 terabits per second (tbps). These cables, in turn, connect to additional cables connecting the West and East coasts of Africa, with a single cable running from Angola to Brazil providing another 40 tbps.
However, it emerged in the past week that smaller ISPs in South Africa had bought capacity on only one or two cables. In a freak occurrence, two of the most commonly used cables, the WACS and SAT 3 cables, were cut simultaneously, plunging millions of Internet users into data darkness.
Customers of the major mobile network operators – Vodacom and MTN – were largely unaffected, as these tend to have both part-ownership and access to most of the cables running up both the East and West coasts of Africa.
Visit the next page to read about how ISPs have battled to reroute access, how massive resources are needed to deal with these kinds of outages, and when the ship will reach the breakage points.
Lenovo express-delivers new range from CES to SA
Lenovo has unveiled its new range of ThinkBook laptops, barely two weeks after they were showcased at the Consumer Electronics Show in Las Vegas.
The company’s newest sub-brand, ThinkBook, is intended to meet the demand for more aesthetically pleasing, yet agile and powerful devices.
The new range is aimed at small and medium enterprises. According to the Small Enterprise Development Agency (SEDA), there are more than 2-million SMEs in South Africa – although there are only 667,433 in the formal sector. This tallies with estimates in recent editions of SME Survey, produced by World Wide Worx, which suggest 650,000 active, formal businesses in South Africa. These SMEs employ about 14% of the South African workforce.
Lenovo argues that access to affordable, yet efficient, technology is a crucial factor in aiding business success and contributing towards the success of the nation. The company has found, in its own research, that younger people prefer working, creating and communicating online “with stylish devices that make a statement”. This means they require streamlined laptops which can be used to collaborate from any remote location, to enhance productivity.
Lenovo said in a statement on Thursday night: “Backed by customer research, ThinkBook is specially designed for SMEs, who typically purchase consumer laptops for perceived design and price advantages but can no longer rationalise their lack of extended services and warranties – core needs of any business. ThinkBook allows growing firms to keep a competitive edge in attracting today’s young tech-savvy execs with trendy yet cost-effective devices.
Thibault Dousson, general manager of Lenovo for Europe, Middle East and Africa, said at the launch event: “With the capacity, SMEs have to grow and upskill the country’s workforce, they are perfectly positioned to bridge the gap between the public sector and large enterprise. Bearing in mind the demands of the digital economy, this sector needs skills and resources in order to compete, and that is where devices such as the ThinkBook come in.”
In South Africa, ThinkBook laptops are now available in 13-, 14- and 15-inch variants. The flagship ThinkBook 14 and ThinkBook 15 devices are powered by Windows 10 Pro and up to 10th Gen Intel Core processing, which Lenovo says combines high performance with intuitive, time-saving features. Options include Intel Optane memory, WiFi 6, and discrete graphics.
The ThinkBook 15 comes at just 18.9mm thin, while the ThinkBook 14 is a mere 17.9mm, both with FHD displays and two Dolby Audio speakers, dual-array, Skype certified microphones and a USB 3.1 (Gen2, Type-C) port.
Lenovo has also introduced the ThinkBook S series, including an elegant 13.3-inch ThinkBook 13s. The sleek and light device is constructed of a metallic finish on an all-aluminium chassis, alongside a narrow bezel display. As with the ThinkBook 14 and 15, the ThinkBook 13s also features advanced Intel processing and an FHD display, Dolby Vision and Harman speakers with Dolby Audio.
Visit the next page to read about the design and features of the new ThinkBook range.