SQL Server and SDS


Enabling Enterprise AI for Everyone with SQL Server

Microsoft believes artificial intelligence is so powerful it should be "democratized" so organizations and developers of all types can use it to transform and improve their business practices.

ASP.NET Core: Learning the Ropes, Part 2

Eric Vogel provides many code samples to show how to use Entity Framework Core for an ASP.NET Core MVC application.

Developers Request, and Get, Database Project for SQL Data Warehouse in Visual Studio

Promising that developers can "save weeks of development effort," Microsoft today answered their request for database project support in Visual Studio to target Azure SQL Data Warehouse projects.

Subqueries in LINQ

If someone tells you that LINQ doesn't support subqueries ... well, they're not wrong. But they're also not entirely correct, either. With LINQ you can meet many of the goals of SQL subqueries including the ability to build complex queries out of simpler ones.

What's New in Azure Data Studio (Formerly SQL Operations Studio)

The October release of Azure Data Studio includes preview support for SQL Server 2019 and more.

Speed Up Your Application with SQL Server In-Memory Tables

If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even better in SQL Server 2016, 2017 and Azure.

The Fastest Data Access Possible with Compiled Procs

If, in your "need for speed," you're looking to access and update your data as fast as possible, you can get to that goal by combining memory-optimized tables with compiled procs.

When You're Your Own DBA: Speeding Up SQL Server

You're not a DBA but you're responsible for managing your organization's SQL Server installation. Here are some tips on what you can do to speed up all your data access.

SQL Server 2019 Preview Bakes In Big Data

Microsoft introduced a preview of the latest edition of its flagship RDBMS, SQL Server 2019, highlighting new Big Data capabilities integrated into the core database engine.

Speeding Up Queries: How to Think About Query Plans

If you want to speed up your SQL Server queries you need to know how your application and your users actually use your database.

Microsoft Warns of SQL Server 2008 End of Support in Less than a Year

In less than a year, Microsoft will end support for SQL Server 2008, meaning no more updates and no more support of any kind, but perhaps more problems on the security and compliance fronts for organizations that don't migrate to newer options.

Q&A with Scott Klein: SQL Server's Built-In Intelligence Features

Scott Klein, CTO at Cloud and Devices, explains how enterprises can leverage the built-in intelligence features of SQL Server 2017 to ensure DevOps pays off.

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.

Most   Popular
Upcoming Events

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.