Unlocking Power with Updatable Views in SQL Server
An updatable view in SQL Server is a view that allows modifications such as INSERT, UPDATE, or DELETE operations on the underlying tables through the view.
2024-04-22
5,270 reads
Views
Views in SQL Server 2019 with SSMS
This article explores how to create and use views in SQL Server 2019 using SSMS.
2021-12-27
6,788 reads
Introduction to Indexed Views in SQL Server
This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.
2020-02-25
19,925 reads
SQL and T-SQL for Beginners in 229 minutes
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
26,808 reads
Blogs
Focus on Core Skills
By Brian Kelley
Core skills depends on the position, but the point is that ensuring you have...
A New Word: Zverism
By Steve Jones
zverism – n. the wish that people could suspend their civility and indulge in...
SQL Server Source Control on a $0 Budget
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
Forums
Is GenAI Coming Faster Than You Think?
Comments posted to this topic are about the item Is GenAI Coming Faster Than...
Local Storage Options
Comments posted to this topic are about the item Local Storage Options
DeepSeek: What is new with this AI technology?
Comments posted to this topic are about the item DeepSeek: What is new with...
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers