SQL SERVER – 2008 Star Join Query Optimization

Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries related to BI are presently facing an increase in workload. At present, when queries are sent to very large databases, millions of rows are returned. Also the users have to go through…
Read More

SQLAuthority News – SQL Server R2 Resources Downloads, Documentations

Microsoft SQL Server 2008 R2 November Community Technology Preview Building on SQL Server 2008, R2 provides an even more scalable data platform with comprehensive tools for managing your databases and applications, improving the quality of your data, and empowering your users to build rich analyses and reports using tools they…
Read More

SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions

What is Business Intelligence

Business intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is an umbrella term that refers to an assortment of software applications for analyzing an organization’s raw data for intelligent decision making for business success. BI as a discipline includes a number of related activities, including decision support, data mining, online analytical processing (OLAP), querying and reporting, statistical analysis and forecasting.

Read More

SQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)

I have wonderful experience at my recent Business Intelligence tour. I will write down in detail about my experience at different location. However, today I would like to talk about one particular question which was asked at all the locations. It was about SQL Server Accelerator for Business Intelligence (BI).…
Read More

SQL SERVER – What is Data Mining – A Simple Introductory Note

According to MacLennan et al. (2009), data mining is defined as “the process of analyzing data to find hidden patterns using automatic methodologies.” Consider the following simple example that explains this concept. By analyzing the data on the items purchased from a supermarket or a chain of such stores, information…
Read More

SQLAuthority News – Application and Multi-Server Management

SQL Server 2008 R2 – Application and Multi-Server Management SQL Server Technical Article Title: SQL Server 2008 R2Application and Multi-Server Management Introduction Writers: Geoff Allix Technical Reviewers: Joanne Hodgins, Omri Bahat, Morgan Oslake Published: February 2010 SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and…
Read More

SQLAuthority News – Future of Business Intelligence and Databases – Article by Nupur Dave

This article is submitted by Nupur Dave Future of Business Intelligence and Databases The term business intelligence (BI) was coined by Howard Dresner in the early 1990s. He defined Business Intelligence as “a set of concepts and methodologies to improve decision making in business through use of facts and fact-based…
Read More
Menu