Introduction Data security is a very important concern in any enterprise solution supporting the Health Insurance Portability and Accountability Act (HIPAA), Sarbanes Oxley, PII (names, driver license...
We’ve always had features to version our code, but it’s been harder to version the objects in our databases. With the increasing use of DevOps and continuous delivery, the pain of managing database sc...
Chickens, Pigs, and Goats How's your luck in controlling all the animals on a scrum? If you're familiar with scrum projects, I'm sure you've heard the story of the chicken and the pig who considered ...
This post to teach how you generate SSH Key For the Cloud Download and install PuTTY or PuTTYgen from here. Open the software it will be like this Set the Type of key to generate option to ...
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has now been renamed to the Docker Community Edition. So what does this me...
When database development is done using the graphical (GUI) tools in the SQL Server Management Studio (SSMS) or via simple scripts, they often fail to specify a name to each individual constraint. Thi...
Today’s blog is originated from a blog interaction. After hardening a server, my friend was not able to start SQL Browser service. When we try to start from services, we get below standard error, whic...
Question: Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? Answer: You might have heard this advice many times but never got a complete answer to “Why”? Most of the bl...
In Part 1, I have outlined a few (my pick) 12cR2 new features useful for Developers and DBAs. In the part 2, I am going to discuss a few more new features. Read/Write and Read-Only Instances Read-w...
This is one of the common question which is asked via emails to me. “How to apply the patch in AlwaysOn Availability Group configuration?” OR “What are the steps we should do and things to take care w...
There’s no fighting progress. Decades ago database administrators managed and controlled everything – the OS, network, storage and database. Times have changed and DBAs have had to evolve (i.e. accept...
A couple of days ago Oracle finally provided us with an on-premises download for Oracle 12.2 Database. Go and download load it from here or Download the Database App Development VM with 12.2 (This is...
