Filter by topic
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.
