Manage
Learn to apply best practices and optimize your operations.
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