How to Check Database Encryption in SQL Server? Step-by-Step Guide
|

How to Check Database Encryption in SQL Server? Step-by-Step Guide

Database encryption in SQL Server refers to encrypting data stored in a SQL Server database to protect it from unauthorized access. Encryption gives an extra layer of assurance by changing over information into an unreadable organize, rendering it futile to unauthorized people even if they pick up and get to the database. In this article, we’ll dig into…

Solutions Architect Data Analytics Core | Role Explained

Solutions Architect Data Analytics Core | Role Explained

The role of a solutions architect – data analytics – core is to connect business problems with technical solutions. They sit in the middle of business and people and technology, working as a bridge to connect business solutions with the intricateness of data analytics. What makes them a kind of trusted adviser is their expertise…

DB2 SQL Error SQLCODE 803 SQLSTATE 23505
|

DB2 SQL Error SQLCODE 803 SQLSTATE 23505

DB2 SQL Error SQLCODE 803 SQLSTATE 23505 means that an Insert or Update operation is violating a uniqueness constraint that is already in place. It occurs either after performing Load with the identity_override modifier or when the table gets altered to add an Identity clause with existing data. What Does SQLCODE = – 803 Mean?…

How I Use Terraform & Composer to Automate WordPress on AWS
|

How I Use Terraform & Composer to Automate WordPress on AWS

How I setup wordpress to deploy automatically on aws You want to make your wordpress site bulletproof? No server outage worries? Want to make it faster & more reliable. And also host on cheaper components? I was after all these gains & also wanted to kick the tires on some of Amazon’s latest devops offerings….

Is Automation Killing Old-School operations?
| |

Is Automation Killing Old-School operations?

I was shocked to find this article on ReadWrite: The Truth About DevOps: IT Isn’t Dead; It’s not even Dying. Wait a second, do people really think this? Truth is I have heard whispers of this before. I was at a meetup recently where the speaker claimed “With more automation, you can eliminate ops. You can…

What Engineering Roles Are Most in Demand At Startups?

What Engineering Roles Are Most in Demand At Startups?

I was just reading over StackOverflow’s 2017 Developer survey. As it turns out there were some surprising findings. One that stood out was databases. In the media, one hears more and more about NoSQL databases like Cassandra, Dynamo & Firebase. Despite all that MySQL seems to remain the most popular database by a large margin. Legacy indeed!…

Should We Be Muddying the Relational Waters? | Use Cases for MySQL & MongoDB

Should We Be Muddying the Relational Waters? | Use Cases for MySQL & MongoDB

Many of you know I publish a newsletter monthly. One thing I love about it is that after almost a decade of writing it regularly, the list has grown considerably. And I’m always surprised at how many former colleagues are actually reading it. So that is a really gratifying thing. Thanks to those who are,…

Scalability Tips & Greatest Hits

Scalability Tips & Greatest Hits

In the past two years, we’ve written a ton of material on scalability. Here are the greatest hits… Why Generalists Are Better at Scaling the Web The internet stack is a complex infrastructure of interlocking components. An scalability engineer must be adept at Linux, plus webservers, caching servers, search servers, automation services, and relational databases…