SQL Server Magazine

Study Finds that Best-in-Class SMBs Are Reducing Time-to-Information by Using BI Solutions

The Aberdeen Group released a business intelligence benchmark report that shows best-in-class small-to-midsized businesses are able to provide end users with access to data in real-time or near real-time using a business intelligence application.

Change Data Capture w/o the SQL Server 2008 Relational Engine

Dev Connections: SQL Server 2008--What's in it for You?

This keynote outlines how SQL Server 2008 and Visual Studio Team System 2008 Database Edition GDR RC 1 give developers a comprehensive platform for building applications that manage data.

Generate Custom Reports via a Web Browser

Izenda recently announced the release of Izenda Reports 5.6, the latest version of its self-service reporting platform.

Jedox Provides an Open-Source, In-Memory BI Solution

Jedox's Palo Server offers data analysis and planning capabilities, and its in-memory data store retrieves data faster and improves system performance.

Create a BI Environment on a Mobile Device

Today, DSPanel announced the release of its Mobile Performance Canvas for SQL Server, which is a server that’s dedicated to mobile business intelligence (BI).

SSAS 2005: Cube Performance Tuning Lessons Learned

A recent project has forced me (which is a good thing) to learn both the internals of SSAS 2005 as well as various performance tuning techniques to get maximum performance out of the OLAP server.

Upcoming Scalability Experts Events

Scalability Experts (my employer) is providing several high-value presentations in the coming months on a variety of hot SQL Server topics.

The Meaning of the Microsoft MVP Award

Having recently been awarded my first Microsoft MVP award I quickly realized the award's true representation.

Microsoft Announces Awards for BI Customers

Microsoft gave out BI awards to customers in four categories at the Business Intelligence Conference.

Microsoft Unveils New Technologies at BI Conference

At the Business Intelligence Conference in Seattle yesterday, Microsoft announced several upcoming BI products, including a new release of SQL Server.

Microsoft BI Conference 2008 Gets Under Way

The Microsoft BI Conference got under way with announcements about "managed self-service" BI technologies ( Project Kilimanjaro) and improved data warehousing capabilities (Project Madison).

Next Generation IT Will Be BT (Business Technology)

Noel Yuhanna, a Forrester analyst, said that the IT is continuing to evolve, and the future lies in extending decision-making technology currently owned by IT out into the business (BT).

The Madison Solution and the Kilimanjaro Release Explained

Fausto Ibarra explains Microsoft's announcements of the Kilimanjaro BI-focused release of SQL Server and the Madison solution for delivering massively increased scalability.

New Products

Check out new and improved SQL Server–related products from PROPHIX Software, AVIcode, Panorama Software, and Embarcadero Technologies.

Measure Twice, Cut Once: The Importance of a Solid Dimensional Model

One of the first steps in an enterprise-class DW/BI project is the modeling process. Ensuring you have a solid dimensional model completed prior to entering later tasks in the DW/BI lifecycle is key to success.

BI Without the Data Warehouse

Michelle discusses the pros and cons of analyzing raw transactional data instead of extracted, transformed, and loaded data warehouse data.

BI without the Data Warehouse, Part 2

Michelle discusses the benefits of building a data warehouse rather than analyzing raw transactional data.

Data Warehouse Workloads and Use Cases

Determine the type of data warehouse you have and the workloads it uses so that you can then optimize its performance.

Desperately Seeking Samples

Educate yourself on the design and operation concepts for databases and data warehouses by taking advantage of Microsoft’s sample databases. Although the business scenarios are fictitious, they translate to real-world uses.