Oracle Database 12cR2 Documentation is here
Oracle Database 12cR2 Documentation is here
Finally Oracle 12cR2 documentation is here also All Books for Oracle® Database Online is here Cheers Osama...
Oracle Database 12.2 released for Exadata on-premises
Oracle Database 12.2 released for Exadata on-premises
We live in exciting times, Oracle Database 12.2 for Exadata was released earlier today. The 12.2 database was already available on the Exadata Express Cloud Service and Database as a service for a fe...
SQL SERVER – Migrating AlwaysOn Availability Group to New AD Domain
SQL SERVER – Migrating AlwaysOn Availability Group to New AD Domain
As a part of my independent consulting, I also provide a high level overview of the migration strategy. As a part of this engagement, my client wanted me to provide steps to move AlwaysOn availability...
Using MySQL Database on AWS with Docker Cloud
Using MySQL Database on AWS with Docker Cloud
Docker is the most commonly used containerization platform. It provides a platform similar to a virtualization platform, with some added benefits: Docker containers are lightweight Multiple Docker c...
SSDT and Friends – .net meetup video
SSDT and Friends – .net meetup video
I did a talk at the london .net meetup. This was aimed at .net developers rather than DBA’s so there isn’t much talk about “why you should use source control” etc as everyone in the room used source c...
Devops without management buy in?
Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on...
What Does “monitorLoop” mean in the Blocked Process Report
What Does “monitorLoop” mean in the Blocked Process Report
Some trivia for your Friday. I recently got a question asking about what the attribute “monitorLoop” is in the blocked-process-report because it’s not really documented. You won’t find too much expl...
SQL SERVER – UpdateHADRResource – Failed to version-copy file – Exception data is: System.IO.IOException
SQL SERVER – UpdateHADRResource – Failed to version-copy file – Exception data is: System.IO.IOException
While applying patches on SQL server standalone instance, in the cluster, it failed with error as below in Summary.txt file. Let us learn about how to fix Exception data is: System.IO.IOException. Ove...
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
I was trying to help my client in generating a report large data set. After spending some time and understanding the schema, I could provide them the query to get the results. Now, he wanted to save t...
IoT Hub vs. Event Hub
IoT Hub vs. Event Hub
There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid choices for streaming data ingestion. My Microsoft colleague, Steve Busby, an IoT Technolo...
SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?
SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?
When you see something not behaving the way normal way, either it must be magic or in software terms it is an error or bug. This blog was inspired by someone who caught me unaware with this challenge ...
Oracle 12.2 New Feature: Longer object/column names
Oracle 12.2 New Feature: Longer object/column names
Hi, Maybe you have wanted to use longer object names to be more descriptive. The Oracle RDBMS now supports up to 128 positions for both object and column names! The current naming length convention is...