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,044 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,627 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,134 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,678 reads
Blogs
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Removing the REST Endpoint in the Data API Builder
By Steve Jones
The more I work with the Data API Builder (DAB), the more I lean...
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
Forums
Replace OLEDB source editor task with a powershell script
I want to replace all the oledb source editors as shown below with powershell...
Sending SQL Query Result via an Email in ADF
New to Azure Data Factory, and as a starting point, we're trying to see...
AlwaysOn Standard o Enterprise edition
Hi everyone, I need advice from the experts, this is the structure I created...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers