#sql-server
SQL Server stories
- posts
- 10
- snippets
- 2
- stories
- 20
- videos
- 6
- tools
- 2
-
blobeater.blog ·
Azure SQL Managed Instance: Boost Performance with Read-Scale Out | All About Tech (opens in a new tab)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…
-
csharp.com ·
Reduce NULL Storage in SQL Server with Sparse Columns (opens in a new tab)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.
-
techcommunity.microsoft.com ·
Importing a Database into VS Code - Microsoft Community Hub (opens in a new tab)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.
-
mssqltips.com ·
New and Enhanced Features in SQL Server 2022 (opens in a new tab)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.
-
c-sharpcorner.com ·
UNION And UNION ALL SQL Operators (opens in a new tab)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.
-
azure.microsoft.com ·
Azure SQL Database now supports powerful geo-replication features for all service tiers | Azure Blog and Updates | Microsoft Azure (opens in a new tab) -
mssqltips.com ·
SQL Server Profiler Extension for Azure Data Studio (opens in a new tab)Learn how to install and use the SQL Server Profiler extension for Azure Data Studio to use against on-premises and cloud databases.
-
databasestar.com ·
JSON in SQL Server: The Ultimate Guide (opens in a new tab)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.
-
kodyaz.com ·
SQL Concatenation for comma seperated list using XML PATH() without COALESCE (opens in a new tab)Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE
-
jithilmt.medium.com ·
SQL Server Hidden “Load Evil” (Performance Issue)With Dapper (opens in a new tab)Article explains about the importance of DbString params
-
blog.sqlauthority.com ·
SQL SERVER - SUM(1) vs COUNT(*) - Performance Observation - SQL Authority with Pinal Dave (opens in a new tab) -
brentozar.com ·
What does SET NOCOUNT ON do? - Brent Ozar Unlimited® (opens in a new tab) -
devblogs.microsoft.com ·
.NET Interactive with SQL!| .NET Notebooks in Visual Studio Code (opens in a new tab) -
blog.sqlauthority.com ·
How to Write Efficient Query? – Interview Question of the Week #300 (opens in a new tab)Question: How to Write Efficient Query? Answer: There is no right or wrong answer to this question. Let us learn about it today.
-
devblogs.microsoft.com ·
Database Profiling with Visual Studio | Visual Studio Blog (opens in a new tab)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!
-
medium.com ·
Multiple post-deployment scripts with SQL server project (opens in a new tab) -
academy.vertabelo.com ·
Understanding Numerical Data Types in SQL (opens in a new tab)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!
-
techcommunity.microsoft.com ·
Azure SQL DB Design Note: Choosing the Right Database Reservation Size (opens in a new tab)A good article on available options on Azure SQL DB.
-
red-gate.com ·
Enter data privacy. Exit SQL Server 2008. (opens in a new tab)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.
-
jack-vanlightly.com ·
How to Connect to Your Local SQL Server From Inside Docker (opens in a new tab)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.