We are pleased to announce the general availability of Foglight for SQL Server and Foglight for Oracle versions 5.7.5.35. This release provides the following significant enhancements: Performance In...
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...
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...
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...
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 ...
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...
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...
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...
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...
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Answer: I have received this question after watching my free webinar on group by conference by one of the user. I really lov...
I was trying to set up database mirroring in my freshly created Azure Virtual Machines and encountered an error. The error was talking about the connectivity problem, but it was something else. Let us...
Indexing data for fast and efficient retrieval is one of the data preparation tasks in data science. MongoDB is the most commonly used NoSQL database and the fourth most commonly used database (relati...
