Instead of Trigger, Part 2 - SQL School Video
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,223 reads
Video
Instead of Trigger, Part 1 - SQL School Video
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
2009-07-07
7,471 reads
Configuring SQL Agent Operators - SQL School Video
Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.
2009-07-02
3,172 reads
Creating Indexed Views - SQL School Video
An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.
2009-06-30
7,479 reads
Adding a Computed Column to a Table (2) - SQL School Video
Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.
2009-06-25
4,261 reads
Adding a Computed Column to a Table (1) - SQL School Video
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,626 reads
Creating User-Defined Data Types - SQL School Video
Learn how you can create your own data types in this SQL School video. MVP Andy Warren explains the process of setting up user-defined data types.
2009-06-18
3,951 reads
Mastering SQL Server Profiler - Part 6: Creating Custom Traces
The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.
2009-05-21
8,949 reads
Mastering SQL Server Profiler - Part 5: Data Columns
The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.
2009-05-19
9,715 reads
Mastering SQL Server Profiler - Part 4: Profiler Events
The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.
2009-05-14
8,400 reads
Blogs
Schema evolution solved using Delta Lake & Databricks
By Gerard
Don’t know about you, but one of my least favourite data pipeline errors is...
Understanding Azure Geo-Redundant Storage
By John
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...
Prompt in ADS
By Steve Jones
Ever since VS Code and Azure Data Studio came out, people have been asking...
Forums
Licencing Information
Hi Guys, I have the following question I am hoping that you guys can...
Countermeasure to stop forum spam bots
There is a lot of spam from time to time. Is it possible to...
Ask SSC