Manage

SQL Server Data Warehousing

• New SQL Server 2017 features give good reasons for fast upgrades

  The new SQL Server 2017 adds support for Linux and a variety of other new features that could justify upgrades to the revamped database platform, even coming so soon after the 2016 release. Continue Reading

• Conquer real-time operational analytics in SQL Server 2016

  Analytics helps improve business operations, and SQL Server 2016 users can master it -- in real time, using operational data in a transactional database. Continue Reading

• Shining a light on SQL Server storage tactics

  A good storage plan is key to proper database management no matter what system database administrators are working in. Without a sufficient SQL Server storage plan, the system may run out of space or process tasks too slowly. This handbook examines ... Continue Reading

• What's new in 2016's SQL Server AlwaysOn Availability Groups

  Microsoft has added Distributed Transaction Coordinator support, optimized log transport and other features to AlwaysOn Availability Groups in SQL Server 2016. Continue Reading

• Testers give an early view of Microsoft SQL Server 2016

  Community Technology Previews show the creation process for Microsoft SQL Server 2016. SQL Server experts Denny Cherry and Joey D'Antoni share what they've learned in beta testing. Continue Reading

• Limited public preview opens for Azure SQL Data Warehouse

  Microsoft opened the preview of Azure SQL Data Warehouse, a petabyte-scale, distributed columnar data warehouse service with massively parallel processing.Continue Reading

• 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.Continue Reading

• 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

• 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

• 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

• 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.Continue Reading

• 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 ...Continue Reading

• 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.Continue Reading

• Building a data warehouse in SQL Server: Eight tips to get started

  When building a data warehouse using SQL Server technologies, there are some challenges you may face. SQL Server database expert Baya Pavliashvili addresses some of the most common issues.Continue Reading

• 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.Continue Reading

• 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.Continue Reading

• Q&A: Tips for making data warehouses manageable

  New technologies are allowing companies to gather more and more data at lightning speeds, and that means data warehouses are becoming overburdened and inefficient, according to Craig Mullins, director of technology planning at BMC Software Inc. ...Continue Reading