SQL Server

The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature enabling you to distribute read-only workloads such as reporting and analytics across built-in replicated secondary replicas within the same region. You can use this by specifying ApplicationIntent=ReadOnly in your connection string, your queries are then automatically routed to these replicas. Key benefits? Optimize…

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.

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.

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.

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.

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

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.

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

Article explains about the importance of DbString params

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

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!

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!

A good article on available options on Azure SQL DB.

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.

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.