Email Alerts
-
Top three SQL Server Denali features to watch
This issue’s feature article provides a guided tour of some of the features that make Denali so intriguing — ultra-fleet column-store indexes, a new high-availability component and data visualization technology that looks more sci-fi than real life. ... E-Zine
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Microsoft’s ‘big data’ push targets familiar products, new capabilities
In this interview, Microsoft executive Mark Kromer discusses newly unveiled Microsoft ‘big data’ features and products announced at last month’s PASS Summit 2011. SQL in Five
-
Three data warehouse maintenance tips for DBAs
Maintaining a data warehouse may be just another thing on a DBA’s to-do list, but there are reasons for doing it right. These data warehouse maintenance tips should help. Feature
-
Baffled by decision-support systems for SQL Server? You’re not alone
Many looking into decision-support systems for SQL Server are overwhelmed with choices -- BI system? Data warehouse? In-memory analytics? Get expert advice on what is what. Feature
-
Project Apollo casts light on column-store indexes in SQL Server Denali
Project Apollo, part of the bells and whistles that comprise the upcoming SQL Server Denali, is Microsoft’s innovation on the index. Column-store indexes work in a whole new way, and they have the potential to nimbly scan millions of rows in a second... SQL Server Denali
-
Q&A;: Exploring what’s hot: SQL Server virtualization, PowerPivot, PDW
Want the inside scoop on SQL Server virtualization, PowerPivot, parallel data warehouse and the upcoming Denali? Microsoft database expert Mark Kromer discuss these year-driving trends and more. SQL in Five
-
Q&A;: Scaling out with Parallel Data Warehouse for SQL Server 2008 R2
With the official release of R2’s Parallel Data Warehouse edition coming soon, Microsoft’s Mark Kromer breaks down the management and architecture considerations to be aware of. SQL in Five
-
A typical data warehouse design review
W.H. Inmon offers a thorough list of steps for a typical data warehouse design review in this excerpt from his book "Building the Data Warehouse," courtesy of Wiley. Book Excerpt
-
Data Warehouse Design Review Checklist
To ensure a quality data warehouse, you need a thorough design review. This chapter from the W.H. Inmon book "Building the Data Warehouse," offers steps for an effective review. Book Excerpt
-
Microsoft previews new SQL Server in-memory database features
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. News | 07 Nov 2012
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News | 01 Mar 2012
-
Microsoft SQL Server 2012 goes big -- data, that is
Microsoft database platform specialist Mark Kromer talks in this Q&A; about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year. Q&A; | 14 Feb 2012
-
Cost, proliferation power rise of SQL Server data warehousing
SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products. News | 19 Jan 2012
-
Microsoft releases final Parallel Data Warehouse preview
Microsoft has shipped the final technology preview of its new scale-out data warehousing software. The actual launch, however, has been pushed out. News | 07 Apr 2010
-
Microsoft releases final Parallel Data Warehouse preview
Microsoft has shipped the final technology preview of its new scale-out data warehousing software. The actual launch, however, has been pushed out. Article | 02 Apr 2010
-
Is there hidden knowledge in 'dirty' data?
As companies rush to clean up data warehouses and delete dirty data, are they losing valuable intelligence about customers? Article | 08 Dec 2005
-
Market for data warehousing tools surges
The data warehousing software market grew over 10% last year, driven by business intelligence projects, scalability and increased access to internal and external users. Article | 10 Nov 2005
-
TDWI conference highlights data warehouse basics
Data warehouse architect and author Richard Kimball today kicked off The Data Warehousing Institute (TDWI) conference with a 10-step program for achieving data warehouse success. Article | 09 Feb 2005
-
Expert: Stop stuffing data warehouses full
IT pros should stop stuffing data warehouses full and find ways to link data to and through external sources, according to experts at The Data Warehousing Institute (TDWI) conference. Article | 09 Feb 2005
- See More: News on SQL Server Data Warehousing
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider. Tip
-
Microsoft tailors BI capabilities for users, IT in SQL Server 2012
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management. Tip
-
With familiar tools, new toys, Microsoft BI stack casts wide net
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services. Tip
-
SQL Server-Hadoop highway to 'big data' ventures into new territory
Microsoft’s SQL Server-Hadoop connectors bridge the structured, relational database world with the unstructured universe of big data. For DBAs, there’s a whole lot to get used to. Tip
-
New to SQL Server PDW? First, tinker with client tools
Stepping into the SQL Server PDW environment means learning a whole new set of client tools. Learn about each as you take on Microsoft’s Parallel Data Warehouse. Tip
-
Data in the fast lane: Column-store indexes in SQL Server Denali
Column-store indexes in SQL Server Denali bring with them ultra-swift search capability, writes expert Roman Rehak, but in this early stage, there are limitations. Tip
-
Parallel Data Warehouse has speed, space, special requirements
Microsoft Parallel Data Warehouse is not like other software. The appliance for SQL Server 2008 R2 allows for mammoth workloads; it also has some specific data loading procedures. Tip
-
Where business intelligence project planning goes wrong
Maintaining a successful BI strategy isn’t always smooth sailing. The best way to avoid big mistakes is to know where others have gone wrong. Tip
-
Why BI? Business intelligence concepts defined
Don't let the value of BI get lost in technical jargon. This tip explains the purpose and components of a business intelligence system -- in plain English. BI 101
-
Making sense of Parallel Data Warehouse for SQL Server 2008 R2
SQL Server 2008 R2 will be released in two new editions, one of which has been dubbed Parallel Data Warehouse. But should organizations care? Tip
- See More: Tips on SQL Server Data Warehousing
-
Data warehousing 101
The preference of a transactional database vs. Data Warehousing depends on the depth of the query being performed. SQL Server Development Expert Joe Toscano details the pros and cons. Ask the Expert
-
The pros and cons of data warehousing
SQL Server expert Eric Brown explains the pros and cons of data warehousing. Ask the Expert
-
database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued...... Definition
-
relational database management system (RDBMS)
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Definition
-
Ensuring high availability of SSAS databases
In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS. Video
-
Building a data warehousing and BI solution
In part two of his series, Baya Dewald breaks down the process of creating a data warehousing and business intelligence solution, with details on the SSAS objects and processing options involved. Video
-
An introduction to SQL Server data warehousing concepts
New to data warehousing? In this short presentation, SQL Server expert Baya Dewald offers an introduction to the basic components of data warehousing, with details on relational and multi-dimensional concepts for SQL Server Analysis Services (SSAS).... Video
-
Microsoft previews new SQL Server in-memory database features
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. News
-
In data warehousing, cost-benefit’s the issue with backup compression
Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider. Tip
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Microsoft tailors BI capabilities for users, IT in SQL Server 2012
Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management. Tip
-
With familiar tools, new toys, Microsoft BI stack casts wide net
The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services. Tip
-
Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases
Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together? News
-
Microsoft SQL Server 2012 goes big -- data, that is
Microsoft database platform specialist Mark Kromer talks in this Q&A; about Microsoft SQL Server 2012 “big data” capabilities, as well as what SQL Server has in store for open source and cloud computing this year. Q&A;
-
Cost, proliferation power rise of SQL Server data warehousing
SQL Server data warehousing may have seemed a misnomer a few years ago. But many Microsoft shops with growing data needs are seeing the benefits of native products. News
-
Microsoft’s ‘big data’ push targets familiar products, new capabilities
In this interview, Microsoft executive Mark Kromer discusses newly unveiled Microsoft ‘big data’ features and products announced at last month’s PASS Summit 2011. SQL in Five
-
SQL Server-Hadoop highway to 'big data' ventures into new territory
Microsoft’s SQL Server-Hadoop connectors bridge the structured, relational database world with the unstructured universe of big data. For DBAs, there’s a whole lot to get used to. Tip
- See More: All on SQL Server Data Warehousing
About SQL Server Data Warehousing
In IT, data warehousing is a critical component of any business intelligent (BI) strategy. Not only does a data warehouse need to be adequately scalable and secure enough to house an organization's data, it also has to be equipped to assist in the reporting and analysis of that data. The BI platform included with Microsoft SQL Server is designed with an eye on data warehousing for business intelligence. Our SQL Server data warehousing topic page provides news, tutorials and best practices around the main SQL Server BI tools (Analysis Services, Integration Services, and Reporting Services) and how they fit into a SQL Server data warehousing solution. You'll also find details on Microsoft's latest BI editions – Master Data Services and the Parallel Data Warehouse edition of SQL Server 2008 R2 – with information on how and why to implement them.