SQL Servers

Amazon Aurora expands reach, but maybe not far enough

Amazon has taken another big step in its quest to lure companies to swap out Oracle databases for AWS, but it can't remove every roadblock that might …

SEO

Index Seek vs Index Scan in SQL Server

Please explain the difference between Index Scan and Index Seek in MS SQL server with an sample example, since it will be helpful to know, what's the …

Databases

SQL Server 2017: A proven leader in database performance

<i>This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database</i> …

Databases

Compare SQL Server Page Splits for INT vs BIGINT vs GUID Data Types

By: Ben Snaidero | Read Comments | Related Tips: More > Database Design<p>Problem<p>A good point was brought up with a tip I wrote last month on using a …

Databases

SQL Operations Studio

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and</b> …

Databases

abc import: Import Your MongoDB, SQL, JSON, CSV Data Into Elasticsearch

<b>Edit:</b> abc import is featured on https://www.producthunt.com/posts/x-to-elasticsearch-sync.<p>We have built <b>abc import</b> to address the problem of indexing …

Databases

SQL Server DateTime Best Practices

By: Aaron Bertrand | Read Comments (2) | Related Tips: More > Dates<p>Problem<p>Dealing with date and time data in SQL Server can be tricky. I see a …

Databases

DSC Resource Kit Release November 2017

We just released the DSC Resource Kit!<p>This release includes updates to <b>10 DSC resource modules</b>. In these past 6 weeks, <b>53 pull requests</b> have been …

Software Development

Microsoft gets data-fabulous at NYC event

Microsoft announces Azure Databricks service, new Cosmos DB features, enterprise AI capabilities and more at its annual Connect(); event in New …

Databases

JSON parsing 10x faster than XML parsing

Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON is not actually a native type, it is just a plain …

Programming

AI is playing an ‘extremely important’ role in hybrid cloud, says Nutanix

Artificial intelligence (AI) is playing a key role in overcoming the difficulties of managing large amounts of data in a hybrid cloud environment, …

Business Technology

Microsoft

Webinar: Machine Learning in SQL Server 2017<p>As you explore machine learning scenarios in your cloud applications, the speed of your scoring …

Machine Learning

Making parallelism waits actionable

During PASS we announced changes to how users will be able to make parallelism waits more actionable – specifically the “infamous” CXPACKET. This …

Databases

Newsroom :: COMPAREX

<i></i> <b>11/09/2017 |</b> <i></i> COMPAREX Blog Editorial Team <b><br>Software Portfolio Management - Benefits, Challenges and Solutions</b><p>Gartner forecasts that by 2020, 24% of …

Databases

The Five Big Benefits of the Hybrid Cloud

The hybrid cloud offers a number of important capabilities that can benefit businesses of all shapes and sizes. These new capabilities enable …

Hybrid Clouds

Software Developer Job in Melbourne

<b>About the business and the role</b><p>Salary: $80,000 - 140,000 + Super<br>• Location: Melbourne (south east area) Must be based in Melbourne to APPLY<br>• Free Onsite …

Software Development

Synchronize Table Data Using a Merge Join in SSIS

Problem<p>We have a need to synchronize data in tables across SQL Server instances. There are multiple ways this can be done such as using link servers, …

Software Development

Filling in the blanks on MongoDB 3.6

Having been in preview for several months, the outline of MongoDB 3,6 is hardly a mystery. Only the actual release date (in December) still is. The …

MongoDB

Configure TDE encrypted database in SQL Server AlwaysOn Availability Group

TDE has been out there since SQL Server 2008 and it is widely used to protect data/log/backup files at rest. When I talked with DBAs sometimes, even …

Databases

Comtrade's latest HYCU release tightens bear hug around Nutanix

<b>+Comment</b> Comtrade's HYCU product snuggled up to Nutanix as its most friendly data protection platform. The latest release sidles even closer with a …

Virtualization

How do UPSERT and MERGE work in Oracle, SQL Server, PostgreSQL and MySQL

Introduction<p>Last week, Burkhard Graves asked me to answer the following StackOverflow question:<p>@vlad_mihalcea Hi Vlad, do you know this one: …

Databases

Three years in a row

We’re happy to report that Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magic Quadrant for Operational Database Management …

Business Intelligence

Microsoft adds new SQL database tools to Azure platform

Microsoft has added a range of new tools to the Azure cloud database in a bid to help companies improve the way they manage on-premise SQL databases …

Databases

How we did it: PASS 2017 Summit Session Similarity using SQL Graph and Python

I had previously shared a sneak preview of our upcoming session on Graph data processing in SQL Server. The talk is at the PASS Summit 2017. In that …

Python Programming

Why F#

F# is a functional-first language on the .NET platform, which focuses on helping you solve complex problems with simple, clean code. I’ll show you …

Programming

Microsoft Turns up the Heat on Oracle, Amazon, and IBM Databases

There was a saying a few years ago that when it comes to enterprise tech, choose wisely as you will never choose again. The reason for this is that …

Microsoft Azure

Microsoft Rests Its Modern Data Estate on a Foundation of SQL Server 2017

Database professionals and developers are already flocking to Microsoft's Linux-, cloud- and AI-friendly database, but Microsoft has more in store.

Enterprise Tech

Sentiment analysis with Python in SQL Server Machine Learning Services

One very popular machine learning scenario is text analysis. In this blog post, we will show you two different ways in which you can implement …

Machine Learning

How Microsoft's Intelligent Cloud Performed in Fiscal 1Q18

A Look at Microsoft's Segment-Wise Performance in 1Q18 PART 2 OF 12<p>How Microsoft’s Intelligent Cloud Performed in Fiscal 1Q18<p>Exceeds analysts’ …

Microsoft: Nadella’s Cloud Transformation Can Rack up Gains, Says Argus

Shares of <b>Microsoft</b> (MSFT) are up 23 cents at $84.10, after <b>Joseph Bonner</b> with <b>Argus Research</b> raised his rating on the shares to Buy from Hold, with a …

Microsoft