Firebase is a NoSQL database, while Supabase is a relational database. The type of software you’re constructing determines which database is best for your project.
The post Firebase and Supabase: Key differences you need to know appeared first on SQLServerCentral.

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.

Mistakes occasionally happen. Occasionally, you make some ill-judged 'refinements' to working code and now just wish you could rewind your tab back in time an hour and forget the whole sorry episode. Now and again, SSMS just conspires against you and crashes unexpectedly, and you lose all your currently open query tabs, some of which you hadn't saved. SQL History offers a useful safety net in the event of any of these unfortunate events.
The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.

Learn how to create a copy of an existing database without any data using Integration Services.
The post Create an Empty Database Using SQL Server Integration Services appeared first on SQLServerCentral.

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?
The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.

SQL Monitor's Top procedures list makes it simple to find the procedures having the biggest impact on performance, allowing you to prioritize your tuning efforts, reduce risk and keep pace with the requirements of your growing database estate.
The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.

This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
The post Data Oriented Cloud Security Mechanisms appeared first on SQLServerCentral.

There are many great tutorials on syntax, performance, and keywords for invoking subqueries. However, I wish to discover a tip highlighting selected SQL subquery use cases. Please briefly describe three SQL subquery use case examples. For each use case, cover how a subquery interacts with outer queries and the T-SQL for implementing the use case. Review excerpts from each example to show the value of implementing the use case.
The post Three Use Case Examples for SQL Subqueries appeared first on SQLServerCentral.