Monday, December 9, 2019

Encryption, Decisive Factor to lose the WWII

Germany and Japan were gaining momentum to win world war II and concur the world. Some crucial decisions have changed the complexity of the game upside down.
Until late 1942, the United States was not in the war as an active participant, though they were indirectly supporting their allays. In late 1941, Japan decided to give them a run by attacking Pearl Habour so that Japan can expand its control in Asia to Pacific whereas German is extending its powers through Europe. Japan wanted to destroy US Aircraft carriers so that they can get control of the pacific. However, on that day aircraft carriers were not in the port. After the Pearl Habour attack, the US wanted to give it back to Japan by attacking Tokoyo which they did successfully.

Image result for pearl harbour attack
Pearl Harbor Attack: Reference www.atomicheritage.org

Then Japan decided that they have to destroy the aircraft carrier which was escaped during the last attack. Japanese admiral, Yamamoto planed for a trap by attacking Midway island which is somewhat mid between Japan and the USA. Yamamoto divided his troops into three. First troops have to attack the bases in Midway, while his air troops will destroy the US aircraft carriers which will come rescue.

But,
this plan was de-coded by the US naval intelligence in Pearl Harbour. So the USA moved his troops close to the Midway way before the arrival of Japan's troops. Also, they had another set of troops waiting for Japan's arrivals.

Though the Japanese are more superior than the US naval troops, they were able to withstand the Japan attack, mainly due to the fact that the US was able to decode the encrypted messages of Japan communication.







Tuesday, September 17, 2019

Migrating On-Premises Microsoft SQL Server Business Intelligence Solution to Azure

Some organizations are looking at the possibility of migrating their Microsoft Business Intelligence solutions to the cloud due to cost-effectiveness, easier maintenance, scalability, etc. However, they are running current solutions on-premises which have been servicing their stakeholders for years. Because of this, with the cost factor and the time factor, it might not be feasible to start a new solution from scratch. Although they would like to lift and shift the existing solution to the cloud as-is, there are a lot of issues with that migration. Mainly, some of the existing features may not be compatible with the cloud. This article looks at how on-premises Microsoft Business Intelligence solutions can be migrated to an Azure environment.

Wednesday, August 28, 2019

SQL Server ALTER TABLE ADD Column overview


In this article, we will explore SQL Server ALTER TABLE ADD Column statements to add column(s) to an existing table. We will also understand the impact of adding a column with a default value and adding and updating the column with a value later on larger tables.

Naive Bayes Prediction in SQL Server

This is the second article of the data mining series.
https://www.sqlshack.com/naive-bayes-prediction-in-sql-server/

Tuesday, August 27, 2019

Wednesday, July 31, 2019

Introduction to SQL Server Data Mining

Prediction, is it a new thing for you? You won’t believe you are predicting from the bed to the office and to back to the bed. Just imagine, you have a meeting at 9 AM at the office. If you are using public transport, you need to predict at what time you have to leave so that you can reach the office for the meeting on time. Time may vary by considering the time and the day of the week, and the traffic condition etc. Before you leave your home, you might predict whether it will rain today and you might want to take an umbrella or necessary clothes with you. If you are using your vehicle then the prediction time would be different. If so, you don’t need to worry about the rain but you need to consider the fuel level you need to have to reach to the office. By looking at this simple example, you will understand how critical it is to predict and you understand that all these predictions are done with your experience but not by any scientific method.

Read full article https://www.sqlshack.com/introduction-to-sql-server-data-mining/

Monitoring SQL Server Analysis Services with Extended Events

Monitoring is an essential aspect in any system and it is an important factor in SQL Server Analysis Services as well. Monitoring will help troubleshoot, audit operations and sometimes monitoring is needed to support various standards and legislation. SQL Server Analysis Services (SSAS) is an OLAP tool used for analysis of data and in many cases SSAS multidimensional cubes and tabular models contain data from many sources and therefore it might be essential to audit who is accessing what. Also, when there are performance issues in SSAS, monitoring needs to be enabled. This article discusses what options SQL Server provides to enable monitoring for SSAS.

Read this article https://www.mssqltips.com/sqlservertip/6121/monitoring-sql-server-analysis-services-with-extended-events/

Encryption, Decisive Factor to lose the WWII

Germany and Japan were gaining momentum to win world war II and concur the world. Some crucial decisions have changed the complexity of the ...