SQL Server According to Bob

JUNE 3, 2016

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.

Servers 40

Servers Hardware Transportation Software Engineering 40

SQL Server According to Bob

JUNE 15, 2016

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

Servers 40

Servers Software Engineering Database Processing 40

John McCalpin

OCTOBER 16, 2016

“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).

Systems 40

Systems Technology Technology Latency 40

SQL Server According to Bob

JUNE 3, 2016

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.

Servers 40

Servers Design Hardware Cache 40

SQL Server According to Bob

JUNE 22, 2016

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

Azure Design Software Engineering Servers 40

SQL Server According to Bob

JUNE 6, 2016

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.

Hardware 40

Hardware Software Engineering Servers Software 40

SQL Server According to Bob

SEPTEMBER 26, 2016

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.

Hardware 40

Hardware Design Availability Benchmarking 40

All Things Distributed

NOVEMBER 22, 2016

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

AWS Open Source Scalability Programming 131

All Things Distributed

OCTOBER 24, 2016

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

AWS Open Source Education Cloud 131

SQL Performance

APRIL 17, 2020

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.

Servers 58

Servers Testing Efficiency Analytics 58

All Things Distributed

SEPTEMBER 29, 2016

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

AWS IoT Innovation Internet 131

Tim Kadlec

DECEMBER 30, 2016

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.

Education 40

Education Games Entertainment Analytics 40

All Things Distributed

NOVEMBER 30, 2016

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

AWS Lambda Artificial Intelligence Mobile 126

All Things Distributed

DECEMBER 8, 2016

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

AWS Cloud Lambda Innovation 115

All Things Distributed

DECEMBER 1, 2016

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

Development 115

Development AWS Lambda Open Source 115

All Things Distributed

NOVEMBER 15, 2016

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.

Analytics 111

Analytics Availability Media Social Media 111

Alex Podelko

OCTOBER 18, 2016

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.

Performance Testing 100

Performance Testing Performance Testing DevOps 100

All Things Distributed

NOVEMBER 14, 2016

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.

Entertainment 98

Entertainment AWS Testing Design 98

All Things Distributed

SEPTEMBER 29, 2016

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.

Artificial Intelligence 100

Artificial Intelligence Healthcare AWS Government 100

Alex Podelko

OCTOBER 20, 2016

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.

Architecture 100

Architecture Performance Testing Performance Testing 100

Alex Podelko

OCTOBER 28, 2016

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

Technology 100

Technology Technology Performance Testing Performance 100

Alex Podelko

OCTOBER 13, 2016

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.

Performance Testing 100

Performance Testing Performance Testing Systems 100

All Things Distributed

OCTOBER 17, 2016

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

AWS Infrastructure Cloud Analytics 94

All Things Distributed

MARCH 11, 2016

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

AWS Hardware Retail Virtualization 101

All Things Distributed

OCTOBER 12, 2016

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.

Scalability 92

Scalability Analytics Lambda Cache 92

All Things Distributed

MAY 10, 2016

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.

Lambda 92

Lambda Serverless Architecture AWS 92

All Things Distributed

JUNE 10, 2016

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.

Lambda 90

Lambda Serverless Architecture AWS 90

All Things Distributed

JANUARY 6, 2016

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

Games AWS Cloud Latency 95

All Things Distributed

JUNE 26, 2016

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

AWS Healthcare Blockchain Cloud 83

All Things Distributed

SEPTEMBER 27, 2016

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

Cloud 77

SQL Server According to Bob

NOVEMBER 29, 2016

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.

Servers 43

Servers Virtualization Hardware Scalability 43

SQL Server According to Bob

JULY 12, 2016

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

Servers 40

Servers Design Engineering Database 40

Allen Holub

JULY 8, 2016

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

71

SQL Server According to Bob

OCTOBER 3, 2016

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.

Servers 40

Servers Development 40

Professor Beekums

DECEMBER 11, 2016

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.

Development 66

Development Internet Internet Software 66

All Things Distributed

JUNE 27, 2016

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.

Healthcare 65

Healthcare Education Development Design 65

SQL Shack

JULY 13, 2020

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.

Availability 80

Availability Database Servers 80

SQL Server According to Bob

NOVEMBER 8, 2016

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

Cache Storage Media Database 40

Professor Beekums

DECEMBER 18, 2016

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

Development 63

Development AWS Code Software 63

SQL Server According to Bob

JULY 13, 2016

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

Media Servers Virtualization Azure 40

SQL Server According to Bob

AUGUST 23, 2016

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

C++ Software Engineering Servers Code 40

SQL Server According to Bob

JUNE 27, 2016

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

Games Azure Servers Testing 40

Uber Engineering

JULY 26, 2016

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

Engineering 87

Engineering Open Source Database Architecture 87