SQL Server supports working with JSON data and provides many different functions that can be used. SQL Server 2022 has expanded the ability to check if the JSON format is valid using the ISJSON function which we will cover in this article.
2023-06-19
In this article, we will discuss the purpose and use of the WHERE LIKE clause in SQL Server and how it can help you construct more efficient queries.
2023-06-02
The tip, Views in SQL Server, explored the purpose of views, creating views examples, and benefits of views. A view is a virtual table that references the actual database tables stored in the database. What if someone changes the underlying table structure, such as renaming the column, adding a new column, or dropping the table? What is the impact of changing schema on views? How can we stop any schema changes if the view references the schema?
2023-05-08
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]
2023-05-03
8,353 reads
As much as we tell people to use SCHEMABINDING and avoid SELECT *, there is still a wide range of reasons people do not. A well-documented problem with SELECT * in views, specifically, is that the system caches the metadata about the view from the time the view was created, not when the view is queried. If the underlying table later changes, the view doesn't reflect the updated schema without refreshing, altering, or recreating the view. Wouldn't it be great if you could stop worrying about that scenario and have the system automatically keep the metadata in sync?
2023-04-17
Microsoft reads your feedback, but doesn't always build it. However, your votes can sway them at times. Today Steve asks what you'd like to see added to SQL Server.
2022-08-05
161 reads
In this article, we cover how to install SQL Server 2022.
2022-07-27
In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.
2022-07-15
In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage.
2022-07-13
2022-06-27
35,505 reads
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
Telegram..@Euchemstore1 Telegram..@Euchemstore1 Email..euchemstore@gmail.com Email..euchemstore@gmail.com DMT (N,N-dimethyltryptamine) is a powerful hallucinogenic compound found naturally in...
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers