SQL Server and SDS


Wrangling MongoDB in VS Code? Now There's Documentation

The May update of Visual Studio Code has added documentation for using the popular MongoDB in Microsoft's lightweight, cross-platform code editor.

Clustering Non-Numeric Data Using Python

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.

Microsoft Releases SQL Server 2016 Service Pack 2

With a host of improvements based on customer and SQL community feedback, the SQL Server 2016 Service Pack 2 was released by Microsoft.

Leveraging Raw SQL in Entity Framework Core

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.

SQL Operations Studio Adopts VS Code Extension Model

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.

Q&A: Philip Japikse on Hands-On with ASP.NET Core and EF Core

'I think ASP.NET Core is the biggest game changer in the history of Web development using the Microsoft stack.'

Data Clustering with K-Means Using Python

Our Data Science Lab guru explains how to implement the k-means technique for data clustering, or cluster analysis, which is the process of grouping data items so that similar items belong to the same group/cluster.

What's New in Azure Data Development

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.

High Performance Object-Oriented Data Access with Dapper

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 Ships First v2.1 Previews of .NET Core, ASP.NET Core, Entity Framework Core

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.

Neural Network Dropout Using Python

Go hands-on with data scientist Dr. James McCaffrey as he explains neural network dropout, a technique that can be used during training to reduce the likelihood of model overfitting.

VS Code Bundled with Anaconda Python Distro

After hiring the original developer of a popular Python extension, taking over the project and hiring even more Python coders to further develop it, the Visual Studio Code team has announced the editor is now shipping with the popular Anaconda distribution.

Quick Tip: Switching to SQL Azure

If you're thinking about moving to the cloud, the first step might be the easiest.

Neural Network Time Series Regression Using Python

Learn how to do time series regression using a neural network, with "rolling window" data, coded from scratch, using Python.

Q&A with Leonard Lobel: Top New Security Features for Developers in SQL Server 2016

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.

Subscribe on YouTube