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,250 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,521 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,275 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,491 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,280 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,645 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,967 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
9,161 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,782 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,452 reads
Blogs
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
A New Word: Fawtle
By Steve Jones
fawtle – n. a weird little flaw built into your partner that somehow only...
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Forums
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Encoding URLs
Comments posted to this topic are about the item Encoding URLs
Question of the Day
Encoding URLs
I have this data in a table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers