Tag: SQL

The next version of Microsoft's SQL Server relational database management system is now available, and along with it comes a special offer designed specifically to woo Oracle customers. Until the end of this month, Oracle users can migrate their databases to SQL Server 2016 and receive the necessary licenses for free with a subscription to Microsoft's Software Assurance maintenance program. Microsoft announced the June 1 release date for SQL Server 2016 early last month. Among the more notable enhancements it brings are updateable, in-memory column stores and advanced analytics. As a result, applications can now deploy sophisticated analytics and machine ... Read More

Microsoft calls SQL Server 2016 the “biggest leap forward” in the 27-year evolution of the SQL Server database. As we’ll see, despite the excess of hype, the SQL Server 2016 database offers enterprises a number of attractive new capabilities, including built-in R analytics, querying of external Hadoop and Azure data stores, and neat management and data security features. Further, SQL Server 2016 improves the in-memory OLTP engine, in-memory columnstore, and Azure cloud integrations introduced in SQL Server 2014. It also offers a reasonable staged upgrade for existing SQL Server installations. Whether all of these improvements -- and Microsoft’s offer of ... Read More

Feed: . Author: Idera. We are excited to announce the release of a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL Server 2016’s Query Store. Troubleshoot issues and execute tasks that follow best practices to keep the Query Store tuned to the database workload.With the free tool, display all properties of all Query Stores per SQL Server instance in a single summary table. This overview allows you to compare properties across Query Stores, to identify quickly the origin of performance problems, and to select quickly a Query Store to modify its properties and ... Read More

Cubes. (source: Michael Pardo on Flickr). For more on how Uber uses Hadoop and Spark, check out the Strata + Hadoop World NY 2016 session with Praveen Murugesan "Big data processing with Hadoop and Spark, the Uber way." Uber’s mission is to provide “transportation as reliable as running water, everywhere, for everyone.” To fulfill this promise, Uber relies on making data-driven decisions at every level, and most of these decisions can benefit from faster data processing. For example, using data to understand areas for growth or accessing of fresh data by the city operations team to debug each city. Needless ... Read More

Reviewed by: Denzil Ribeiro, Mike Weiner, Arvind Shyamsundar, Sanjay Mishra, Murshed Zaman, Peter Byrne, Purvi Shah SQL Server 2016 introduces changes to the default behavior of checkpoint. In a recent customer engagement, we found the behavior change to result in higher disk (write) queues on SQL Server 2016 vs. the same workload on SQL Server 2012. In this blog we’ll describe the changes, options are available to control these and what impact they might have on workloads that are upgrading to SQL Server 2016. In this specific case changing the database to use the new default behavior of checkpoint proved ... Read More

When to collect statistics: The decisions made by the cost-based optimizer are crucial in determining the performance of a Big SQL query, and the optimizer makes its decisions based on statistical information it has about the data being queried. Therefore, accurate and up-to-date statistics on the data are the most crucial weapon to ensure optimal Big SQL performance. As such, statistics should be collected whenever: a new table is populated with data, an existing table’s data undergoes significant changes: new data added, old data removed, existing data is updated a table is synchronized from Hive using the HCAT_SYNC_OBJECTS stored procedure ... Read More

We are pleased to announce the full release of the Microsoft ODBC Driver 13.1 for SQL Server. The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for C/C++ based applications. What’s new Always Encrypted You can now use Always Encrypted with the Microsoft ODBC Driver 13.1 for SQL Server. Always Encrypted is a new SQL Server 2016 and Azure SQL Database security feature that prevents sensitive data from being seen in plaintext in a SQL instance. You can now transparently encrypt the data in the application, so that SQL Server or Azure SQL ... Read More

Key takeaways Learn about the current state of NoSQL databases in terms of industry adoption Read about tools that will help improve the developer productivity when working on NoSQL based applications Understand multi-model database concept and the pros and cons of multi-model database option versus polyglot persistence approach How to use NoSQL databases and big data technologies (like Hadoop and Spark) together to solve big data problems Learn how to integrate NoSQL databases with other emerging trends like microservices and container technologies like Docker. NoSQL databases have been around for several years now and have become the ... Read More

Warp speed. (source: Pixabay). Spark has emerged as the infrastructure of choice for developing in-memory distributed analytics workloads. It provides high-level abstractions in multiple languages (e.g., Java, Scala, and Python) that hide the underlying data and work distribution operations such as data transfer to and from the Hadoop Distributed File System (HDFS) or that maintain resiliency in the presence of system failures. Spark also provides libraries for relational Online Analytical Processing (OLAP) using SQL, machine learning, graph analytics, and streaming workloads. These features enable developers to build complex analytics workflows quickly to support different data sources in various operating environments ... Read More

Apache Spark is becoming very popular and widely used in the big data community. There are several reasons for Spark getting such rapid traction. These include its in-memory processing capabilities, support for a wide range of engines for various use cases such as streaming, machine learning, and SQL, and the ability to develop in multiple languages such as Python and Scala. The interest and momentum around Spark is very real in the market. In early June, MapR announced an enterprise-grade Apache Spark distribution. The reason for doing so was straightforward—make it easier for you to adopt Spark as the primary ... Read More