Questions About the GDPR That You Were Too Shy to Ask

The General Data Protection Regulation (GDPR) will affect organisations in countries around the world, not just those in Europe. The GDPR regulates how personal data is stored, moved, handled, and destroyed. Not following the regulation will lead to dire consequences for your organisation. As a data professional or developer, you may have many questions and might be wondering how it will affect the way you will do your job. William Brewer answers common questions about the GDPR that you were too shy to ask. … Read more

Crossing the Line: Skill Atrophy

0
0
In this blog series titled “Crossing the Line,” I will explore the various aspects, concerns, and successes associated with the transition from coder to manager. Reader participation is highly encouraged. I am interested in your stories of experience, challenges, and successes in this regard. Please share in the comment section of the post. Developing a … Read more

Don’t Stop Learning

A few years ago, I found myself teaching an in-depth SQL Server Reporting Services (SSRS) class at a local tech center. I had some great students in the class, who were engaged and excited about the material. During the breaks, they talked about their careers, and how what they learned would help them do their … Read more

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.… Read more

SQL Server Coming in on Another Platform

Why release SQL Server as a Linux, as well as Windows, application? It baffled many DBAs when it was announced, though most shrugged and decided that it must be part of Microsoft’s long-term wrestling match with Oracle. When Microsoft previewed an early version of the Linux SQL Server on Ubuntu and Red-Hat, with ‘core relational … Read more

How Can DevOps Concepts Provide Value in Digital Transformation Projects?

For some of us, DevOps means startups, cloud, fast-moving social media applications and Extreme Programming (XP). What about large corporate IT initiatives, Digital Transformation projects, and business process re-engineering? Can DevOps be relevant and appropriate? Mohammad Rizvi argues from experience that it most certainly can be.… Read more

Conversations with Gran about Databases

So, what’s going on in your databases world this week, young man? I paused, as always, a little unsure of what I was getting myself into. I’d been having these little “technical chats” with Gran ever since her ‘computer incident’, when a blue screen informing her of a “Fatal error: catastrophic failure“, had thrown her … Read more

Missing Data

In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation. … Read more

The Wrong Way to Clean Up the Internet

Having successfully fought several privacy battles, granting people the right to have themselves taken off Google search, and to have their records deleted from databases, it looks as if the European Union may soon want to regulate and license what you can watch on YouTube or other video content sites, and the audio-visual content you … Read more

Providing the Necessary Tools and Reports for Very Large IT Projects

For the larger development project using Agile/DevOps, there will always be the problem of comprehensive tooling and reporting. An all-encompassing ALM Integrated Development Environment will have some of what you need but is unlikely to meet your special requirements; Neither will a DevOps toolchain. Where do you start? You'll need to specify up-front what those requirements are, as Mohammad Rizvi explains.… Read more

When is the Data Deleted?

Imagine that your business is providing a service to individuals, and you charge by the amount of usage. You are trading your service internationally and need to keep a record of who among your customers does what. You then produce invoices and keep accounts. Your customers pay via a third-party service. So far so good. … Read more

Mixing MongoDB and Relational Databases in the Enterprise

Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?… Read more

The SQL Server Features that Time Forgot

Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well, amongst the marketing people anyway. What happens to all the exciting TLAs that are bandied about when a new version launches? It's mixed, it seems. Adam Machanic's classic post, The SQL Hall of Shame, has inspired Rob Sheldon to look back at some of the features that, though worthy, have may have failed to hit the mainstream.… Read more

IT Aphorisms for Developers

Developers enter their trade fizzing with untamed creative energy. They envision spending their days dashing out intricate algorithms that compile first time, developing creative applications that dazzle colleagues and users alike, before leaving the office each evening, with a swagger in their step, to work their new GitHub ‘side project’, which will one day soon … Read more

Should You Consider Agile for Very Large IT Projects?

Many large organisations are compelled to embark on wide-ranging business-transformation IT projects. They are difficult to manage because, in the intervening months before the end of the project, the changing business environment will have forced further changes on the business. Agile holds out the promise of managing these changes more easily. Mohammad Rizvi explains, from experience, some of the the issues you are likely to face, and how you can solve them.… Read more

Who was that masked man anyway?

Whenever you require a visit to the doctor, or hospital, a lot of personal data will likely be recorded, alongside details of your condition, the treatment you required, drugs prescribed and so on. At some point, you might have signed a consent form, one of the clauses of which allowed your data to be analyzed … Read more