Evaluate

Evaluate

Weigh the pros and cons of technologies, products and projects you are considering.

• SQL Server vs. MySQL: Learn the differences

  MySQL and Microsoft SQL Server relational databases have their pros and cons. Weigh the differences between SQL Server and MySQL features, costs, functionality and more. Continue Reading

• Pros and cons of using SQL Server audit triggers for DBAs

  Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading

• 5 trends for SQL Server environments as SQL Server 2019 looms

  SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading

• SQL Server 2019 improves Linux, container support

  The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved Linux and container support. Continue Reading

• The most useful new features in Microsoft SQL Server 2019

  SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading

• How Azure SQL DW Gen2 boosts cloud data warehouse's performance

  The Gen2 version of Azure SQL Data Warehouse gives Microsoft's cloud data warehouse a shot in the arm on performance, making it more competitive with rival technologies.Continue Reading

• A quick tutorial on SQL Server maintenance plans

  SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start.Continue Reading

• Common Data Service for Analytics eases Power BI integration

  Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is designed to simplify the process for users.Continue Reading

• Power BI Report Server adds new Power BI reporting options

  Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data sources users can connect to when building Power BI reports.Continue Reading

• Microsoft Cosmos DB takes Azure databases to a higher level

  Azure Cosmos DB brings a new element to the database lineup of Microsoft's cloud platform, offering multiple data models and a scalable environment for distributed applications.Continue Reading

• Five SQL Server database trends to be prepared for in 2018

  Here's a list of notable trends related to SQL Server that IT teams should be ready for over the next 12 months. Among them: increased use of the cloud, AI, Linux and containers.Continue Reading

• Dissect the SQL Server on Linux high availability features

  SQL Server 2017 on Linux gives IT shops greater flexibility, but there are some limitations and changes to the way high availability and failover are performed on Linux vs. Windows.Continue Reading

• How to use a SQL Server graph database to map data relationships

  Here are the basics you need to know to use the graph database features added in SQL Server 2017 to represent the relationships between different data elements in a graph structure.Continue Reading

• How to choose the right SQL Server on Azure deployment option

  There are two options for deploying SQL Server on the Azure cloud. Here's a look at how they differ to help you choose between using Azure SQL Database and running SQL Server on an Azure VM.Continue Reading

• Expect big data doings at upcoming Microsoft Ignite conference

  Ignite 2017 and the Microsoft data portfolio are the topics of this edition of the Talking Data podcast. On tap is a closer look at Azure Cosmos DB.Continue Reading