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.

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 131

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

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. There is an extended event specifically for the new metadata-only ALTER COLUMN operations supported in SQL Server 2016 onward.

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 131

What I Read in 2016

Tim Kadlec

A time where my waistline expands as I feast on mountains of holiday sweets and the list of books I want to the read expands just as quickly as everyone shares their favorite reads from 2016. Ah, the end of the year. As always, I enjoyed every book on this list at least a little—I don’t have the patience or desire to get through books that I’m not finding interesting in some way.

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 126

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 115

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. *.

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.

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.

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.

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.

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.

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 94

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 101

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.

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.

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.

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

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

All Things Distributed

In June 2015, Amazon Web Services announced that it would launch a new AWS infrastructure region in India. Today, I’m happy to announce that the Asia Pacific (Mumbai) Region is generally available for use by customers worldwide. The opportunity to revolutionize.

AWS 83

A Hungry Neighbor is an Angry Neighbor

All Things Distributed

I am very grateful that I have had the opportunity to meet with President Shimon Peres several times. Especially the first time, which was a 1:1 in his presidential residence, was an unforgettable experience. After I explained in 5 minutes the power of cloud for unlocking digital business building for everyone, he went on a lecture of half an hour how bringing economic prosperity to the region was crucial to achieving a long lasting peace. "A A hungry neighbor is an angry neighbor".

Cloud 77

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.

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

#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

71

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.

New Ways to Discover and Use Alexa Skills

All Things Distributed

Since January 2016, selection of Alexa smart home API skills has grown by more than 5x. Introducing New Features That Make It Easier for Customers to Discover and Use Your Alexa Skills. Alexa, Amazon’s cloud-based voice service, powers voice experiences on millions of devices, including Amazon Echo and Echo Dot, Amazon Tap, Amazon Fire TV devices, and devices like Triby. that use the Alexa Voice Service.

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.

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

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

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

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