Evaluate

Evaluate

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

• SQL Server in Azure database choices and what they offer users

  SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading

• How SQL Server DevOps processes help break down data silos

  DevOps can help organizations dismantle data silos in SQL Server and other database systems -- and replace organizational silos with cross-functional teams. Continue Reading

• 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

• A closer look at Python-SQL Server 2017 integration

  Looking to take advantage of SQL Server 2017's support for Python? Here's what you need to know to get started on using the analytics programming language with Microsoft's database.Continue Reading

• Notre Dame seeks SQL Server performance baseline for run to cloud

  Establishing SQL Server performance baselines is a crucial first step for cloud migrations, says a University of Notre Dame DBA, who is using database monitoring software to do so.Continue Reading

• SQL Server 2016 Integration Services boosted by Linux support

  As SQL Server changes, so does Integration Services. See the latest SSIS updates, such as added Linux support and an Upgrade Wizard for SQL Server 2016.Continue Reading

• Capitalize on mobility in Microsoft SQL Server Reporting Services 2016

  SQL Server Reporting Services has gotten a face-lift over the past few years. Read on to take advantage of what's new.Continue Reading

• What do new SQL Server Standard Edition features mean for IT?

  Which SQL Server edition is right for you? After Microsoft upgraded the Standard Edition with features from the Enterprise one, a lower cost choice might be possible in some cases.Continue Reading

• SQL Server machine learning goes full throttle on operational data

  Artificial intelligence is a hot topic in IT, and Microsoft has made strides to synchronize SQL Server with machine learning tools for use in analyzing operational data pipelines.Continue Reading

• Four trends that will impact SQL Server DBAs in 2017

  Flash storage adoption, cloud computing's growth, Linux's increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.Continue Reading

• SQL Server on Linux signals Microsoft's changing development landscape

  Expert Joey D'Antoni explains what SQL Server on Linux and the addition of some Enterprise Edition features to the database's Standard Edition say about the changing face of Microsoft.Continue Reading

• Four free SQL Server tools every DBA can use

  Various performance issues can arise in the day-to-day grind of managing databases. We've rounded up four free SQL Server tools that can help make DBAs lives a little bit easier.Continue Reading

• What you need to know for upgrades to SQL Server 2016 version

  Before you upgrade to SQL Server 2016, review the hardware and software requirements and the supported upgrade paths to help make sure your deployment of the database goes smoothly.Continue Reading

• SQL Server SSD technology becoming a solid storage choice

  With recent improvements in solid-state drive technology, it's time to consider SSD devices for SQL Server storage uses. SSDs can address I/O performance problems, but wear is a worry.Continue Reading

• What is the benefit to Microsoft SQL Server Express on Azure?

  Microsoft recently announced that it has added Microsoft SQL Server Express to Azure. Expert Robert Sheldon shares what he sees as the benefits and pitfalls.Continue Reading

• SQL Server 2014 features enable hybrid cloud scenarios

  Microsoft continues to improve integration between on-premises data centers with Microsoft Azure. An expert looks at SQL Server 2014 features that enable hybrid cloud scenarios.Continue Reading

• Microsoft SQL Server 2016: Previews show promise for next year

  Microsoft SQL Server 2016 will be released next year. But in 2015, we've already had a glimpse into improved in-memory OLTP, security features, analytics and Stretch Database.Continue Reading

• How to get started with PolyBase in SQL Server 2016

  With PolyBase, when you use SQL Server 2016 as your data source, you have easy access to Hadoop and Azure Blob Storage data from whatever environment you're working in.Continue Reading

• Introducing DBCC CHECKDB for Analysis Services 2016

  DBCC CHECKDB, a long-awaited feature for SQL Server Analysis Services, provides the ability to perform database consistency checks against tabular and multidimensional databases.Continue Reading

• Comparing memory-optimized tables and disk-based tables

  In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O.Continue Reading

• Understanding the Microsoft Sync Framework

  An expert explains the Microsoft Sync Framework, a platform for synchronizing heterogeneous data distributed across applications, services and devices.Continue Reading

• SQL Server gets its first container management software

  DH2i's DxEnterprise is the first application container management software designed for SQL Server. Containerization boosts mobility and reduces downtimes.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

• Top three third-party SQL Server security auditing tools

  For most companies, SQL Server's security auditing tools aren't always enough to meet regulation requirements. The answer is third-party products.Continue Reading

• SQL Server 2016 preview shows off new features, improvements

  Experts discuss the public preview of SQL Server 2016 and the best new features as early adopters ready themselves to put SQL Server 2016 into production.Continue Reading

• How DH2i container management software can lower licensing fees

  Asante and Eversheds both cut SQL Server licensing costs using the new DH2i container management software, DxEnterprise. DH2i plans to compete with Microsoft.Continue Reading

• Introducing row-level security in Azure SQL databases

  Row-level security, a new feature for Azure SQL databases, helps Microsoft database platforms get to the same level as Oracle and DB2.Continue Reading

• Vendors introduce three new SQL Server appliances

  If SQL Server appliances are on your radar, you have options, but the price tag is high. Do your homework before buying. Here are the current offerings.Continue Reading

• Seven reasons to upgrade to SQL Server 2012

  Support for early versions of SQL Server has ended. But rather than upgrade to SQL Server 2014, companies are turning to SQL Server 2012. Here is why.Continue Reading

• SQL Server database recovery tool retrieves by the table

  Kroll Ontrack's new SQL Server database recovery tool was developed from customer feedback. It recovers selected tables instead of the whole database.Continue Reading

• SIOS SANLess cluster helps keep Epicure websites up and running

  Direct-sales food distributor Epicure deployed a new server cluster to keep its websites from being overwhelmed -- and saved money on SQL Server and storage in the process.Continue Reading

• Scaling out or scaling up with Microsoft SSRS

  Basit Farooq explains the pros and cons of scaling out and scaling up when increasing the workload on the SQL Server Reporting Services (SSRS).Continue Reading

• Enbridge Inc. to virtualize all its servers

  Energy company Enbridge Inc. is in the process of virtualizing all of its servers to increase flexibility and cut costs. Not everyone is happy with this new direction.Continue Reading

• Pricing out the new Windows Azure SQL Database

  SQL Database -- formerly known as SQL Azure -- is the relational database product under the umbrella of Microsoft Azure, the company’s cloud infrastructure platform. Until recently, Microsoft offered two service plans: Web and Business. Both options...Continue Reading

• SQL Azure automatic backup keeps it 'business as usual'

  Robert Sheldon explains the business continuity features added to SQL Azure, including automatic backup, self-service restore, manual copy, and export and geo-replication. These features are meant to keep the data available, even when the system ...Continue Reading

• New Azure SQL subscription model has performance levels

  Robert Sheldon explains the new subscription model for Azure SQL Database coming out in 2015. The new model will have three service tiers -- basic, standard and premium. It will also have performance levels for each tier.Continue Reading

• Mavis Tire goes SANless with SIOS DataKeeper

  With DBAs rewarded for server performance and SAN specialists rewarded for server capacity, there can be a tug of war. Mavis Tire goes SANless with SIOS DataKeeper. SIOS Technology releases a survey about high availability and SAN.Continue Reading

• How to improve OLTP with SQL Server 2014 In-Memory

  Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage.Continue Reading

• Epworth Healthcare, Vecima choose DxConsole

  Epworth Healthcare and Vecima Networks are very different companies, but they both chose to use DH2i's DxConsole -- for very different reasons.Continue Reading

• Why Vecima Networks, Epworth HealthCare chose DxConsole

  Vecima Networks and Epworth HealthCare go through their separate checklists to pick their server application virtualization program -- DxConsole.Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.Continue Reading

• SQL Server 2014 etches itself in-memory

  Microsoft's flagship database is advancing into the largely undiscovered country of in-memory OLTP platforms -- and it's hoping to conquer.Continue Reading

• Microsoft takes No. 2 spot in competitive database market

  The $31 billion database management systems market saw a little shakeup in 2013. Find out which company Microsoft surpassed for the No. 2 spot.Continue Reading

• Guide to SQL business intelligence, analytics and data visualization

  This Essential Guide offers a closer look at SQL Server business intelligence features and tools that enable users to view, share and analyze data.Continue Reading

• 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

• Developments in SQL Server BI point to focus on self-service, users

  Today, business analytics is largely focused on self-service software and pushing business intelligence capabilities down to the end user. In this three-part handbook, we drill down on the trends and technologies serving to further the scope of SQL ...Continue Reading

• SQL Server 2014 adds In-Memory OLTP power boost, hybrid cloud support

  Microsoft's SQL Server 2014 database includes a speed-boosting engine for in-memory processing and support for mixing cloud and on-premises data sets.Continue Reading

• SQL 2014: Investigating Microsoft's latest database release

  Experts and analysts discuss the release of SQL Server 2014 and explore its new features, including in-memory online transaction processing, in this essential guide.Continue Reading

• What to consider when deploying In-memory OLTP in SQL Server 2014

  In this expert answer, Michael Steineke from Edgenet talks about what to consider when deploying In-memory OLTP in SQL Server 2014.Continue Reading

• Managing data with Enterprise Integration Management and SQL Server

  Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform.Continue Reading

• Finding the right problem for SQL Server 2014's in-memory OLTP

  Consultant Denny Cherry talks changes, misconceptions and what people really want from SQL Server 2014, which is generally available on April 1.Continue Reading

• Some new Windows Azure integration features in SQL Server 2014

  Microsoft is all about the cloud SQL Server 2014, especially if it's Microsoft's own cloud. That's why there is built-in Azure integration.Continue Reading

• SQL Server 2012 features: Weighing the benefits, limitations

  This guide explores the popular new features of SQL Server 2012 and offers tips for deciding if it's right for your organization.Continue Reading

• Five Windows Azure alternatives for SQL Server

  Just because you're an SQL Server shop doesn't mean you can't explore the cloud. Check out these five Azure alternatives to see what's out there.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

• SQL Server encryption features in SQL Server 2014

  Learn about SQL Server encryption features and enhancements in SQL 14, including Transparent Data Encryption and encrypting backups.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

• Digging through SQL Server OLAP storage models

  Learn how to distinguish among the three SQL Server OLAP storage models and decide which one is best in different use cases.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

• Eight key SQL Server 2014 features

  In-memory OLTP and columnar storage are just two of the eight key SQL Server 2014 features, according to this tip.Continue Reading

• Quiz: How well do you know SQL Server third-party tools and native tools?

  Test your knowledge of native and third-party tools for SQL Server with this brief quiz.Continue Reading

• Exploring third-party SQL Server tools

  Learn more about the capabilities of third-party and native tools for SQL Server in this essential guide.Continue Reading

• Q&A: Authors discuss the advantages of Microsoft Power View

  In this interview, the authors of a how-to book on Power View discuss the advantages for both business and IT.Continue Reading

• Get going with Microsoft Power View and SharePoint

  In this book excerpt, the authors explain Microsoft SQL Server Analysis Services and how to get started with Power View.Continue Reading

• Exploring Microsoft PowerPivot and collaborative business intelligence

  Learn the background of Microsoft Power View and how PowerPivot works with Microsoft Excel 2010 in part one of this book excerpt.Continue Reading

• Coping with the fast pace of new SQL Server versions

  Microsoft has upped the ante, releasing new SQL Server versions at a quicker pace. How will you adapt?Continue Reading

• SQL Server Data Tools 2012 makes developing DB projects easier

  SQL Server Data Tools 2012 can now do many of the tasks formerly reserved for SQL Server Management Studio. Find out more.Continue Reading

• Five third-party SQL Server schema comparison tools

  Over the years, many third-party schema comparison tools have popped up to support SQL Server.Continue Reading

• Five third-party SQL Server schema comparison tools

  Schema comparison tools let you compare object definitions in two databases. Read why they're important, and learn about five popular ones out there.Continue Reading

• Five third-party schema comparison tools

  Continue Reading

• Six SQL Server management tools you can't live without

  Expert Ashish Kumar Mehta lists six important SQL Server management tools, including BIDS, SSMS and SSDT.Continue Reading

• SQL 2014 features: Partitioned indexes and memory-optimized tables

  In this second of a two-part series on SQL 2014 features, Bob Sheldon dives into partitioned indexes and memory-optimized tables.Continue Reading

• SQL 2014 features: Extended buffer pool and columnar indexes

  Two major SQL Server 2014 features are its ability to extend the buffer pool and its implementing of clustered columnar indexes for improved querying.Continue Reading

• Evolution of Windows Azure SQL Database

  Learn about latest developments in SQL Azure technology, exploring its benefits and drawbacks in this comprehensive guide.Continue Reading

• SQL Server 2014 overview part 2: Availability and scalability features

  SQL Server 2014, due out at the end of this year, has availability and scalability features that highlight the database release.Continue Reading

• SQL Server 2014 overview part 1: In-memory, cloud integration features

  SQL Server 2014, due out at the end of this year, has in-memory and cloud integration features that highlight the database release.Continue Reading

• Up or out? Deciding on SQL Server scalability

  SQL Server scalability brings with it many questions, but prime among them is this: Should you buy more servers or bulk up the ones you have?Continue Reading

• The lowdown on SQL Server auditing tools

  Learn about the various components of SQL Server auditing tools such as server and database audit specifications as well as action groups.Continue Reading

• SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.Continue Reading

• Useful SQL Server 2012 features to become familiar with

  SQL Server expert Roman Rehak shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.Continue Reading

• Microsoft unveils GeoFlow 3-D SQL Server mapping tool

  Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end.Continue Reading

• Six top SQL Server 2012 management tools you should know about

  Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about.Continue Reading

• HIPAA compliance and SQL Server: Tricks and tools of the trade

  Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server.Continue Reading

• The pros and cons of virtualizing SQL Server environments

  What are the pros and cons of virtualizing SQL Server environments? Basit Farooq takes you through the potential good, bad and the ugly.Continue Reading

• Little-known features of Microsoft SQL Server 2012

  When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve.Continue Reading

• Essential SQL Server security tools

  Read this tip where writer Ashish Kumar Mehta shares his all-time favorite native and third-party SQL Server security tools.Continue Reading