SQL Server

Find the 19 interesting developer stories on topic SQL Server

Reduce NULL Storage in SQL Server with Sparse Columns
csharp.com · Apr 02, 2025

SQL Server Sparse Columns optimize storage by not allocating space for NULL values, improving efficiency. They support filtered indexes and column sets for dynamic queries but add a 4-byte overhead for non-NULL values, requiring careful use.

sql-server

Importing a Database into VS Code - Microsoft Community Hub
techcommunity.microsoft.com · Jul 09, 2024

About This article will talk through how one can import an existing database that lives on a SQL Server either on prem or in Azure onto a local machine.

vscode sql-server

New and Enhanced Features in SQL Server 2022
mssqltips.com · Oct 28, 2022

Learn about some of the new features and enhancements in SQL Server 2022 and things you should consider adopting when moving to SQL Server 2022.

sql-server

UNION And UNION ALL SQL Operators
c-sharpcorner.com · Jul 05, 2022

The primary difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set, but union all returns all rows after.

sql-server

Azure SQL Database now supports powerful geo-replication features for all service tiers | Azure Blog and Updates | Microsoft Azure
azure.microsoft.com · Jul 03, 2022

azure sql-server

SQL Server Profiler Extension for Azure Data Studio
mssqltips.com · Dec 26, 2021

Learn how to install and use the SQL Server Profiler extension for Azure Data Studio to use against on-premises and cloud databases.

sql-server ide

JSON in SQL Server: The Ultimate Guide
databasestar.com · Oct 24, 2021

JSON is a popular format for storing data. Learn how to store JSON in SQL Server and how to use related functions in this guide.

sql-server

SQL Concatenation for comma seperated list using XML PATH() without COALESCE
kodyaz.com · Oct 24, 2021

Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE

sql-server

SQL Server Hidden “Load Evil” (Performance Issue)With Dapper
jithilmt.medium.com · Oct 12, 2021

Article explains about the importance of DbString params

dapper sql-server

SQL SERVER - SUM(1) vs COUNT(*) - Performance Observation - SQL Authority with Pinal Dave
blog.sqlauthority.com · Jul 05, 2021

sql-server

What does SET NOCOUNT ON do? - Brent Ozar Unlimited®
brentozar.com · Jun 17, 2021

sql-server

.NET Interactive with SQL!| .NET Notebooks in Visual Studio Code
devblogs.microsoft.com · Mar 09, 2021

vscode dotnet sql-server

How to Write Efficient Query? – Interview Question of the Week #300
blog.sqlauthority.com · Nov 04, 2020

Question: How to Write Efficient Query? Answer: There is no right or wrong answer to this question. Let us learn about it today.

sql-server

Database Profiling with Visual Studio | Visual Studio Blog
devblogs.microsoft.com · Aug 12, 2020

Have you ever been tasked with diagnosing a slow performing web application and suspected the database was to blame? Looking into your database tier requires specific tools, now you can quickly and easily investigate using the database profiling tool in Visual Studio’s Performance Explorer!

visual-studio sql-server databases

Multiple post-deployment scripts with SQL server project
medium.com · Jul 14, 2020

visual-studio sql-server

Understanding Numerical Data Types in SQL
academy.vertabelo.com · Nov 19, 2019

Want to know how cover the numeric and decimal data types of ANSI SQL and examine some functions that convert data from one type to another? Find out!

sql-server

Azure SQL DB Design Note: Choosing the Right Database Reservation Size
techcommunity.microsoft.com · Sep 25, 2019

A good article on available options on Azure SQL DB.

azure sql-server

Enter data privacy. Exit SQL Server 2008.
red-gate.com · Jun 30, 2019

SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implications, as James Boother from Microsoft Gold Partner, Coeo, explains.

sql-server

How to Connect to Your Local SQL Server From Inside Docker
jack-vanlightly.com · Jun 06, 2019

If you are running an ASP.NET Core application from Docker and connecting to a SQL Server running on your PC then you might find you can't connect to it. In this post we'll look at what you need to do to make sure your containerized app can access SQL Server hosted on your own PC.

sql-server docker