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.

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/

Monday, June 3, 2019

Windows And SQL Server 2008 And 2008 R2 End Of Life

Windows Server 2008/2008 R2 and SQL Server 2008/2008 R2 are on their extended support phase now. July 8, 2019 for SQL Server 2008/2008  R2 and January 14, 2020 for Windows Server 2008/2008 are the end-of-life dates. Once you hit these dates, you will essentially be running those machines at your own risk in this bloated age of cyber attacks. 

Following are the options you have
Path 1:  The first path is the traditional evolutionary path of upgrading to a newer version of Windows Server and SQL Server. 

Path 2:  If you do not want to upgrade to the latest server versions—don’t worry—Microsoft has you covered. Microsoft recently announced a few options for those who want to continue on Windows Server 2008/2008 R2 and SQL 2008/2008 R2. To save money, you could simply move your Windows Server 2008/2008 R2 and SQL 2008/2008 R2 to Azure by using the Azure Hybrid Use Benefit. The only cost you would incur would be computed and infrastructure.

Read more at https://community.connection.com/windows-sql-server-2008-2008-r2-end-life-coming-soon-now/

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-eff...