SQL Server


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.

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.

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.

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.

Quick Tip: Switching to SQL Azure

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

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.

How to Query JSON Data with 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.

Second SQL Operations Studio Update Ships

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.

Managing Temporal Data in SQL Server 2016 and Azure SQL Database

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.

Tracking History in SQL Server 2016 and Azure SQL Database

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.

Retrieving and Updating JSON Objects in SQL Server 2016

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.

Two New Features in SQL Server Management Studio

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes.

Querying JSON Data in SQL Server 2016

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.

SQL Server 2017 Debut Highlights Ignite Conference

SQL Server 2017 will officially hit general availability on Oct. 2, Microsoft announced today at its Ignite conference in Orlando, Fla.

Working with JSON in SQL Queries

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.

Most   Popular
Upcoming Events

.NET Insight

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.