The data science doctor explains everything you need to know about clustering data, the process of grouping items so those in a group (cluster) are similar and items in different groups are dissimilar.
- By James McCaffrey
With a host of improvements based on customer and SQL community feedback, the SQL Server 2016 Service Pack 2 was released by Microsoft.
The ability to use SQL with Entity Framework Core has always been a cool feature. There's a new feature in Entity Framework Core that opens the door for whole new set of SQL-related functionality.
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.
'I think ASP.NET Core is the biggest game changer in the history of Web development using the Microsoft stack.'
Data developers using Microsoft's Azure cloud have several new offerings to work with as database services for MySQL and PostgreSQL, along with Azure Databricks, are now generally available.
Entity Framework is fabulous ... but it does impose some overhead. If you like working with data in an O-O kind of way but feel the "need for speed," then you should be looking at Dapper.
Microsoft has shipped the first preview of .NET Core 2.1 -- its modularized, open source, cross-platform evolution of the .NET Framework and runtime -- along with associated "Core" packages for ASP.NET and Entity Framework.
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.
In response to developer feedback, Microsoft is taking a page from the growing visual, low-code development approach to simplify Big Data analytics in the cloud with Azure Data Factory.
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
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.