SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. Try SQL Server 2016 Today. SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better.

SQL 2016–Install MSVC Patch Required

SQL Server According to Bob

There is a MSVC, runtime library patch needed by SQL Server 2016 and without the patch the SQL Server service can simply terminate (crash.) For complete instructions on applying this patch, read the Release Notes for SQL Server 2016 (look at section called “Install Patch Requirement (GA)”) If you have already installed SQL Server 2016 you have the option to just install the MSVC patch vs the complete SQL Server Critical Update. Uncategorized Setup SQL 2016

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Invited Talk at SuperComputing 2016!

John McCalpin

“Memory Bandwidth and System Balance in HPC Systems” If you are planning to attend the SuperComputing 2016 conference in Salt Lake City next month, be sure to reserve a spot on your calendar for my talk on Wednesday afternoon (4:15pm-5:00pm).

SQL 2016 – It Just Runs Faster: DBCC Scales 7x Better

SQL Server According to Bob

SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases. ‘It Just Runs Faster’ – Out of the box SQL Server 2016 DBCC provides you better performance, scale while shrinking your maintenance window(s.). SQL Server 2016 has been vetted by a wide range of customers. SQL Server 2016.

Does SQL Server 2016 Require Trace Flag -T8048?

SQL Server According to Bob

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Recommendation Unchanged: Prior to SQL Server 2016 enable –T8048 on larger systems. Trace flag –T8048 longer exists in SQL Server 2016. Uncategorized How It Works Memory SQL 2016

Azure 40

How It Works: SQL Server 2016 SSE/AVX Support

SQL Server According to Bob

As indicated, SQL Server 2016 added the use of SSE and AVX instructions in various code paths to improve performance. Version of SQL Server 2012, 2014, and 2016 using the Crypto* APIs take advantage of the hardware implementations through the API support. Uncategorized How It Works SQL 2016My recent posts. link]. link]. have generated discussions about the SSE and AVX support boundaries.

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

The result is a design for SQL Server 2016 that provides high availability for the most demanding workloads on the latest hardware with minimal impact and scalable for the future. However, if you are looking to accelerate your hardware, our Always On Availability Group design for SQL Server 2016 can keep pace. Prior to SQL Server 2016, it could take as many as 15 worker thread context switches across both the primary and secondary replicas to replicate a log block.

Reinventing Performance Testing: Continuous Integration

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser). – Cloud. – Agile. Continuous Integration (this post). – New Architectures. – New Technologies.

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward. ALTER COLUMN id bigint NOT NULL ; Thanks to the improvements in SQL Server 2016, this command changes metadata only , and completes immediately. There is an extended event specifically for the new metadata-only ALTER COLUMN operations supported in SQL Server 2016 onward. The ALTER TABLE.

Reinventing Performance Testing: New Architectures

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser). – Cloud. – Agile. – Continuous Integration. New Architectures (this post). – New Technologies.

Reinventing Performance Testing: New Technologies

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser). – Cloud. – Agile. – Continuous Integration. – New Architectures. New Technologies (this post).

Reinventing Performance Testing: Agile

Alex Podelko

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. I decided to publish a few parts here to see if anything triggers a discussion. It would be published as separate posts: – Introduction (a short teaser). – Cloud. Agile (this post). – Continuous Integration. – New Architectures. – New Technologies.

Welcoming Adrian Cockcroft to the AWS Team.

All Things Distributed

I am excited that Adrian Cockcroft will be joining AWS as VP of Cloud Architecture. Adrian has played a crucial role in developing the cloud ecosystem as Cloud Architect at Netflix and later as a Technology Fellow at Battery Ventures. Prior to this, he held positions as Distinguished Engineer at eBay and Sun Microsystems. One theme that has been consistent throughout his career is that Adrian has a gift for seeing the bigger engineering picture.

AWS 131

MXNet - Deep Learning Framework of Choice at AWS

All Things Distributed

Machine learning is playing an increasingly important role in many areas of our businesses and our lives and is being employed in a range of computing tasks where programming explicit algorithms is infeasible. At Amazon, machine learning has been key to many of our business processes, from recommendations to fraud detection, from inventory levels to book classification to abusive review detection.

AWS 128

Expanding the AWS Cloud: Introducing the AWS Europe (London) Region

All Things Distributed

In just this past month we've had HSBC , ARM , Missguided , and most recently at re:Invent 2016 , Trainline , talking with us about how they are using AWS to transform and scale their businesses. At re:Invent 2016 , AWS announced Greengrass (in limited preview), a new service designed to extend the AWS programming model to small, simple, field-based devices.

AWS 118

Allez, rendez-vous à Paris – An AWS Region is coming to France!

All Things Distributed

Today, I am very excited to announce our plans to open a new AWS Region in France! Based in the Paris area, the region will provide even lower latency and will allow users who want to store their content in datacenters in France to easily do so. The new region in France will be ready for customers to use in 2017. Over the past 10 years, we have seen tremendous growth at AWS. As a result, we have opened 35 Availability Zones (AZs), across 13 AWS Regions worldwide.

AWS 127

Bringing the Magic of Amazon AI and Alexa to Apps on AWS.

All Things Distributed

From the early days of Amazon, Machine learning (ML) has played a critical role in the value we bring to our customers. Around 20 years ago, we used machine learning in our recommendation engine to generate personalized recommendations for our customers. Today, there are thousands of machine learning scientists and developers applying machine learning in various places, from recommendations to fraud detection, from inventory levels to book classification to abusive review detection.

AWS 118

Expanding the AWS Cloud: Introducing the AWS Canada (Central) Region

All Things Distributed

Lululemon Athletica is a Canadian athletic apparel company that is using AWS Lambda, AWS CodePipeline, and AWS CodeDeploy to rapidly build and deploy their digital marketing and e-commerce solutions for the upcoming 2016 holiday season. Par Werner Vogels, le 8 décembre 2016. Earlier this year, Amazon Web Services (AWS) announced it would launch a new AWS infrastructure region in Montreal, Quebec.

AWS 106

Transforming Development with AWS

All Things Distributed

In my keynote at AWS re:Invent today, I announced 13 new features and services (in addition to the 15 we announced yesterday). My favorite parts of James Bond movies is are where 007 gets to visit Q to pick up and learn about new tools of the trade: super-powered tools with special features which that he can use to complete his missions, and, in some cases, get out of some nasty scrapes. Bond always seems to have the perfect tool for every situation that he finds himself in. *.

A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016

SQL Shack

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases. It also supports to offload some read workloads to the secondary replica. We […]. AlwaysOn Availability Groups Clustering High Availability

Meet the Teams Competing for the Alexa Prize

All Things Distributed

On September 29, 2016, Amazon announced the Alexa Prize , a $2.5 Teams invited to participate without sponsorship will be announced on December 12, 2016. million university competition to advance conversational AI through voice. We received applications from leading universities across 22 countries. Each application was carefully reviewed by senior Amazon personnel against a rigorous set of criteria covering scientific contribution, technical merit, novelty, and ability to execute.

Spice up your Analytics: Amazon QuickSight Now Generally Available in N. Virginia, Oregon, and Ireland.

All Things Distributed

Previously, I wrote about Amazon QuickSight , a new service targeted at business users that aims to simplify the process of deriving insights from a wide variety of data sources quickly, easily, and at a low cost. QuickSight is a very fast, cloud-powered, business intelligence service for the 1/10th the cost of old-guard BI solutions. Today, I am very happy to announce that QuickSight is now generally available in the N. Virginia, Oregon, and Ireland regions.

Introducing the Alexa Prize, It’s Day One for Voice

All Things Distributed

Registration opened today and teams have until October 28, 2016 to submit their applications. The competition will officially start on November 14, 2016 and run until November 2017, concluding with an award ceremony to be held at AWS re:Invent in Las Vegas, NV. In the past voice interfaces were seen as gimmicks, or a nuisance for driving “hands-free.” The Amazon Echo and Alexa have completely changed that perception.

#NoEstimates, An Introduction.

Allen Holub

Estimates are waste. Not only are they not necessary, but they introduce dysfunction into the team. We should really just stop doing them. This thinking comes from the #NoEstimates movement (of which I’m a card-carrying member), which came onto the scene a couple years ago when @WoodyZuill created the #NoEstimates hash tag on Twitter. NoEstimates… Agility #NoEstimates agile

72

DBCC Trace Flags 2562 and 2549

SQL Server According to Bob

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes. The SQL Server 2016 design change uses the CheckScanner instead of the MultiObjectScanner improving I/O behavior. This is behavior is unchanged in SQL Server 2016. Uncategorized DBCC SQL 2016

The SQL Server Installer Version 2: Just Install It!

SQL Server According to Bob

SQL Server 2016 Developer Edition. SQL Server 2016 Evaluation Edition. SQL Server 2016 Express Edition. SQL 2016 SetupBack in July, I told you about a new installation experience for SQL Server. One of our goals from the outset was to ensure we could iterate and enhance this experience as we obtained feedback from the community. Today, we are proud to announce Version 2 of the new SQL Server Installer. Here is the opening screen from running the installer.

What Makes A Senior Software Developer?

Professor Beekums

UPDATE 2017-01-01: This post has a follow up. Most engineering organizations will have to answer the question: “What makes a software developer a senior developer?” This is a challenging question because it is extremely subjective. Search for the answer on the internet and you will get many different answers. Some will contain criteria that are also subjective themselves which adds additional difficulty to the question.

How It Works (It Just Runs Faster): Auto Soft NUMA…

SQL Server According to Bob

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to changes in our SQL Server and NUMA configurations. Bob blogged about a new SQL Server 2016 feature called Auto Soft NUMA. As I’ve hit the road and talked more about SQL Server 2016: It Just Runs Faster , I’ve received some questions about how Auto Soft NUMA works and how to recognize how SQL Server detects a NUMA configuration and makes decisions to partition it even further.

How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM

SQL Server According to Bob

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. SQL Server 2016 has been enhanced along with Windows 2016 to detect a direct access volume (/dax.) SQL Server 2016 is designed to detect non-volatile storage devices. SQL 2016 How It Works It Just Runs Faster

Cache 40

Expanding the AWS Cloud: Introducing the AWS US East (Ohio) Region

All Things Distributed

In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint. Today I am very happy to announce the opening of the new US East (Ohio) Region. The Ohio Region is the fifth AWS region in the US. It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14.

AWS 86

Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups

SQL Shack

A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […]. In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. You should go through the following articles and build the infrastructure before proceeding with this article.

Beware of Developers Who Do Negative Work

Professor Beekums

UPDATE 2016-12-25: This post has an important follow-up. At some point in every software developer’s career, we work with someone who does negative work. The notion of negative work may sound a little strange. Someone can do no work by just… not working. How does negative work happen? One example of this is an awful developer that was once at the same company as me. He made 2 changes to the code base over his 6-month tenure there

The SQL Server Basic Installer: Just Install It!

SQL Server According to Bob

Today we are introducing the new Basic Installer experience for SQL Server 2016 Express , SQL Server 2016 Developer , and SQL Server 2016 Evaluation Editions. We actually launched this functionality for SQL Server 2016 Express Edition when SQL Server 2016 RTM was announced but didn’t really promote this. As an option to downloading the compressed media above, you can execute the new SQL installer for SQL Server 2016 Developer.

Media 40

Create Table – Disk vs In-Memory Optimized

SQL Server According to Bob

Uncategorized Performance SQL 2016I had an interesting e-mail discussion related to the performance of create table. The test being executed was a tight loop of create table statements. The assumption put forth was in-memory optimized table creation was slower and they expected it to be faster. We are not talking about the performance of inserts, updates, deletes and selects but instead looking at the time it takes to perform create table.

C++ 40

10 Lessons from 10 Years of Amazon Web Services

All Things Distributed

The epoch of AWS is the launch of Amazon S3 on March 14, 2006, now almost 10 years ago. Looking back over the past 10 years, there are hundreds of lessons that we’ve learned about building and operating services that need to be secure, reliable, scalable, with predictable performance at the lowest possible cost. Given that AWS is a pioneer in building and operating these services world-wide, these lessons have been of crucial importance to our business.

AWS 98

What Am I Working On (RDORR): SQL Server On Linux

SQL Server According to Bob

That is exactly what I started doing in Mar 2016. Uncategorized Linux SQL 2016To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. To others this is new information. Yes, SQL Server runs on Linux! We are in active, private preview and working towards the public preview release. Read More: [link]. Sneak Peak Demo: [link]. It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux.

Games 40

Serverless Reference Architecture with AWS Lambda

All Things Distributed

Building your applications with only managed components has become very popular, and AWS Lambda plays a crucial role in that. I see a tremendous interest in examples how to build such applications, and articles such as " The Serverless Start-Up - Down With Servers! about teletext.io are read eagerly around the globe. If you are looking for more examples there are the Lambda Serverless Reference Architectures that can serve as the blueprint for building your own serverless applications.

Why Uber Engineering Switched from Postgres to MySQL

Uber Engineering

By Evan Klitzke. Introduction. The early architecture of Uber consisted of a monolithic backend application written in Python that used Postgres for data persistence. Since that time, the architecture of Uber has changed significantly, to a model of microservices and … The post Why Uber Engineering Switched from Postgres to MySQL appeared first on Uber Engineering Blog. Architecture Open Source Data Database Infra MySQL Postgres Uber Data

Accelerating Data: Faster and More Scalable ElastiCache for Redis

All Things Distributed

Fast Data is an emerging industry term for information that is arriving at high volume and incredible rates, faster than traditional databases can manage. Three years ago, as part of our AWS Fast Data journey we introduced Amazon ElastiCache for Redis , a fully managed in-memory data store that operates at sub-millisecond latency.

Expanding the Cloud: Introducing the AWS Asia Pacific (Seoul) Region

All Things Distributed

In November, Amazon Web Services announced that it would launch a new AWS infrastructure region in South Korea. Today, I’m happy to announce that the Asia Pacific (Seoul) Region is now generally available for use by customers worldwide.

Games 95

Converting Your Ionic 2 Mobile App To NativeScript

The Polyglot Developer

As many of you know, I had been using Apache Cordova based frameworks such as Ionic Framework for a long time. They are convenient and easy to use when it comes to rapidly developing cross platform applications. The problem with using Apache Cordova frameworks such as PhoneGap, Ionic Framework and Onsen UI is the performance limitations that come with them, particularly because of their use of the platform web view.

Serverless Reference Architectures with AWS Lambda

All Things Distributed

Building your applications with only managed components has become very popular, and AWS Lambda plays a crucial role in that. I see a tremendous interest in examples how to build such applications, and articles such as " The Serverless Start-Up - Down With Servers! about teletext.io are read eagerly around the globe. If you are looking for more examples there are the Lambda Serverless Reference Architectures that can serve as the blueprint for building your own serverless applications.

Dockerizing MySQL at Uber Engineering

Uber Engineering

Uber Engineering’s Schemaless storage system powers some of the biggest services at Uber, such as Mezzanine. Schemaless is a scalable and highly available datastore on top of MySQL ¹ clusters. Managing these clusters was fairly easy when we had … The post Dockerizing MySQL at Uber Engineering appeared first on Uber Engineering Blog. Architecture Ansible Containers Docker GTID Mezzanine MySQL Percona Puppet Schemaless