---
title: "Celebrating 25 Years of SQL Server"
publication: "DB Weekly"
issue: 223
published_at: "2018-09-28"
canonical_url: "https://dbweekly.com/issues/223"
---

This week's database news       

#223 — September 28, 2018 

[Read on the Web](https://dbweekly.com/issues/223)   

Database Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/vysqpylqkxgz84yycelk.jpg)](https://www.cockroachlabs.com/blog/sql-fmt-online-sql-formatter/)  

[sqlfmt: An Opinionated Online SQL Formatter](https://www.cockroachlabs.com/blog/sql-fmt-online-sql-formatter/) — Provide sqlfmt with some SQL, specify a target line width, and get back some better formatted SQL that takes SQL’s syntax into account. Ideal for blog posts or documentation. The [tool itself is here.](https://sqlfum.pt/) 

Matt Jibson   

[SQL Server 2019: Celebrating 25 Years of SQL Server and the Path Forward](https://cloudblogs.microsoft.com/sqlserver/2018/09/26/sql-server-2019-celebrating-25-years-of-sql-server-database-engine-and-the-path-forward/) — It’s 25 years since SQL Server first shipped on Windows NT(!) and alongside that Microsoft are announcing the latest version, SQL Server 2019, which has a big focus on ‘intelligence’, security, and hands-free performance tuning. 

Microsoft SQL Server Team   [![\](https://copm.s3.amazonaws.com/cc98744f.png)](https://www.jackdb.com/) 

[JackDB: A Modern Database Client](https://www.jackdb.com/) — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today. 

JackDB, Inc. sponsor   

[Amazon Aurora Now Supports Stopping and Starting of Database Clusters](https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-aurora-stop-and-start/) — Aurora clusters can now be stopped (for up to 7 days) and restarted making it more useful and affordable for development and test purposes. 

Amazon Web Services   

[Running a Database on EC2? Your Clock Could Be Slowing You Down](https://heapanalytics.com/blog/engineering/clocksource-aws-ec2-vdso) — A curious tale of a company discovering the EC2 instances running its Postgres cluster were particularly slow at getting the time and this had a performance hit on its analytics workload. 

Kamal Marhubi (Heap)   

[Cloudflare Adds a Fast Distributed Key-Value Store to Its Serverless Platform](https://blog.cloudflare.com/building-with-workers-kv/) — Cloudflare Workers is a ‘serverless’ compute platform that works across the popular cloud network and they’ve added a new, highly distributed, eventually-consistent key/value store to it. 

Stephen Pinkerton and Zack Bloom (Cloudflare)   

[Stack Overflow's 'The Incredible Growth of Amazon RDS' Report](https://aws.amazon.com/rds/stack-overflow-incredible-growth-amazon-rds-report/) — A report on Amazon’s Relational Database Service based on the results of Stack Overflow’s annual Developer Survey. It includes a particularly neat graph showing how database popularity and 2017-2018 growth correlate. [PDF.](https://d1.awsstatic.com/whitepapers/RDS/Stack-Overflow-The-Incredible-Growth-of-Amazon-RDS.pdf) 

Amazon Web Services, Inc.   

[AMD Eyes Data-Driven Server Upgrades](https://www.datanami.com/2018/09/26/amd-eyes-data-driven-server-upgrades/) — AMD is zeroing in on datacenter overhauls needed to handle faster data/analytics as a way to compete against Intel. 

Datanami   

[Webinar: Getting the Most Out of MongoDB on AWS](https://www.mongodb.com/webinar/building-modern-apps-with-the-mern-stack-and-gcp?jmp=cpress&utm_campaign=WW_CP_newsletter_sponsorship&utm_content=20180928&utm_medium=display&utm_source=dbweekly) — This webinar introduces the different ways you can go about deploying, managing and optimizing MongoDB on AWS. 

MongoDB sponsor   

[The Crimes of Chicago: Working with MongoDB from PowerShell](https://www.red-gate.com/simple-talk/sql/sql-development/the-crimes-of-chicago-working-with-data-in-mongodb/) — A .NET-oriented introduction to MongoDB which focuses on a practical example of working with a crime-related dataset and scripting things with PowerShell. 

Phil Factor   

[Archive MySQL Data in Chunks Using Stored Procedures](https://www.sqlgossip.com/archive-mysql-data-in-chunks/) 

SQL Gossip   

[How to Recover Data on Oracle without a Backup](https://blogs.oracle.com/sql/how-to-recover-data-without-a-backup) 

Chris Saxon   

[Using Machine Learning to Detect Column Types in Customer Files](https://liveramp.com/engineering/1023756/) 

Matt Hagy (LiveRamp)   

[The Changing Face of ETL](https://www.confluent.io/blog/changing-face-etl) — How stream processing with Apache Kafka and KSQL is the changing face of ETL and why this approach is being adopted. 

Robin Moffatt   

[DBDiagram: A Relational Database Diagram Design Tool](https://dbdiagram.io/) — Quick and simple tool to help draw database relationship diagrams using a simple DSL. 

Holistics   

[Blaze: A Blazing Fast Exporter for Your ElasticSearch Data](https://github.com/vktr/blaze) 

Viktor Elofsson    

Starting next week Database Weekly will have a dedicated jobs section, highlighting upcoming opportunities. Got a job or related service which you want to share here? [Get in touch](https://booking.cooperpress.com/jobs).        

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom