Firebase and Supabase: Key differences you need to know
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.
PASS Data Community Summit registrations are open!
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.
Coming Out of the Cloud
Google announced a local version of their cloud databases that companies can install for developers.
Create an Empty Database Using SQL Server Integration Services
Learn how to create a copy of an existing database without any data using Integration Services.
SQL Prompt Safety Net Features for SSMS: SQL History
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.
Use DDL Triggers to Automatically Keep SQL Server Views in Sync
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?
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
Data Oriented Cloud Security Mechanisms
This article looks at security mechanisms in the cloud that can help protect your data, with specific examples in AWS.
The Loss of Knowledge
The loss of developer knowledge can be impactful for an organization. Steve notes that they should do more to retain their staff.
Three Use Case Examples for SQL Subqueries
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.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP MT Haryono CSTelpon : 0853-73737551
Jl. MT. Haryono No.657, Wonodri, Kec. Semarang Sel., Kota Semarang, Jawa Tengah 50242
BCA KCU SEMARANG CSTelpon : 0853-73737551
Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers