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...
Oracle 12.2 In-memory New Features
Oracle 12.2 In-memory New Features
I was able to attend the Oracle Open World 2016 event this past fall. Last April, I posted a nice series on In-memory, material I had gathered from Oracle PM Andy Revenes (heck of a nice guy). Here a...
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
If you are coming to this page by searching, then I am sure that you are in big trouble. I have come across this error and my SQL Server was not getting started. When I looked into ERRORLOG, I found b...
Oracle Behavior Differences Between Releases
Oracle Behavior Differences Between Releases
A question came to me from a DBA friend asking about SQL differences between releases of the database. IE: behavioral differences in SQL processing. The question posed by this person was that they fe...
SQL: Different ways to generate sequence
SQL: Different ways to generate sequence
There was a question from the op regarding adding a new column to a query output by generating the cyclic sequence numbers from 1 to 3. Select A =identity(int,1,1),B,C from table_abs1,A,412,B,133,C,9...
Setting up a MySQL read replica in Amazon RDS
Setting up a MySQL read replica in Amazon RDS
Introduction Deploying MySQL on Amazon RDS has more benefits than traditional datacenter deployment; for example we don’t have to purchase and manage hardware for replacing failed disks or upgrading ...
Now NOT to Handle Exceptions
Now NOT to Handle Exceptions
Oracle Database raises an exception when something goes wrong (examples: divide by zero, duplicate value on unique index, value too large to fit in variable, etc.). You can also raise exceptions when ...
Monday Coffee 2017-02-06
Monday Coffee 2017-02-06
A lot’s been said about last week’s Gitlab outage so I’m not going to go over the details here but I do want to talk about one point that was when I was watching the guys fix the issue live on youtube...
Using Extended Events in Azure
Using Extended Events in Azure
Over the past 6 months I have been trying to push myself to use extended events (XEvents) over SQL trace, once you get past the learning curve it’s probably the way to go. If you are operating in the ...
SQL SERVER – SQL Server: Getting OS information using DMV
SQL SERVER – SQL Server: Getting OS information using DMV
I am used to exploring what is available in the technology of love – SQL Server. As I was exploring into one of the simplest set of DMVs which have been available for ages. There are several ways to g...