SQL Server Data Warehousing
New & Notable
Data Warehousing
SQL Server Data Warehousing News
-
January 31, 2014
31
Jan'14
Five SQL Server 2012 business intelligence features
The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.
-
March 25, 2013
25
Mar'13
SQL Server big data technologies should be a major DBA focus
Microsoft platform architect Mark Kromer says in this Q&A; that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date.
-
January 08, 2013
08
Jan'13
Brian Larson talks SQL Server business intelligence
Author Brian Larson shares his wisdom and insight regarding SQL Server business intelligence and makes some suggestions for companies new to BI.
-
November 07, 2012
07
Nov'12
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.
SQL Server Data Warehousing Get Started
Bring yourself up to speed with our introductory content
-
In-memory from xVelocity to the memory-optimized columnstore index
Robert Sheldon explains the history of in-memory technology from the xVelocity in-memory analysis engine to the memory-optimized columnstore index. Continue Reading
-
AlwaysOn Availability Groups
AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. Continue Reading
-
Using SQL Server Management Studio Table Designer to create a table
Creating a table correctly in SQL Server can be pretty tricky, but using SQL Server Management Studio Table Designer makes it easier. Continue Reading
Evaluate SQL Server Data Warehousing Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
SQL Server 2014 columnstore index: the good, the bad and the clustered
SQL Server 2014 adds options for the clustered and the nonclustered columnstore index. Robert Sheldon shares the good and the bad. Continue Reading
-
Quintillion creates flash pool to escape SQL Server bottlenecks
Quintillion runs SQL Servers on VMs, and PernixData gave them a way out of the storage bottleneck, bringing their data closer to the database. Continue Reading
-
Examining SQL Server 2012 data warehouse appliances
Take a look at some HP and Dell SQL Server 2012 data warehouse appliances to see if any might fit your business needs. Continue Reading
Manage SQL Server Data Warehousing
Learn to apply best practices and optimize your operations.
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints. Continue Reading
-
Guide to SQL Server data management and data quality
This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services. Continue Reading
-
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. Continue Reading
Problem Solve SQL Server Data Warehousing Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
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. Continue Reading
-
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. Continue Reading
-
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. Continue Reading