With a host of improvements based on customer and SQL community feedback, the SQL Server 2016 Service Pack 2 was released by Microsoft.
The extension model introduced with Visual Studio Code and subsequently tracked by the Visual Studio IDE is proving so popular it has been applied to SQL Operations Studio, Microsoft's cross-platform, open source data management tool.
If you're thinking about moving to the cloud, the first step might be the easiest.
SQL Server expert Leonard Lobel explains exactly how Always Encrypted, Dynamic Data Masking, RLS and more can make a real difference in securing your enterprise databases, plus he shares his favorite overall new feature in SQL Server 2016.
Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.
- By Dino Esposito
- 01/23/2018
The lightweight, cross-platform offering combines functionality found in tools like SQL Server Management Studio and the Visual Studio Code editor in order to help data developers and operations pros work with SQL Server, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.
SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data.
SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of changes to your data. Here's how to both create those tables and alter existing tables so they track the history of your data.
With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you’ve found them.
With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.
Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.
SQL Server 2017 will officially hit general availability on Oct. 2, Microsoft announced today at its Ignite conference in Orlando, Fla.
SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.
With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client.
The venerable relational database management system is now feature-complete, with support for Linux and containers running on Linux and Mac OS X, and it's available as a release candidate this week.
If you’re thinking about pursuing a Microsoft Certification, here’s how and why Peter went through the certification process for the second time, including his feedback on some of the resources available to you.
This more fully-fledged version of Microsoft's object relational/mapper is now at the initial beta testing stage, with quicker startups and a number of fixes from the preview, but there's also more work to do to resolve some issues that can impact EF providers. Also: a list of new features of the EF Core 2.0 preview released at Build.
- By Michael Domingo
- 05/25/2017
With previews announced at Microsoft's Build Conference, the database migration service will allow developers to migrate on-premises databases to the cloud without so much as a hiccup.
- By Michael Domingo
- 05/23/2017
Microsoft CEO Satya Nadella provided the framework of Microsoft's developer tooling and services so far and a nicely detailed glimpse into future direction. Then EVP Scott Guthrie detailed the vast number of new and upcoming offerings as a preview to the sessions taking place the rest of the week.
- By Michael Domingo
- 05/10/2017
The RDBMS formerly known as SQL Server vNext is now out as SQL Server 2017 Community Technology Preview 2.0.