Bypassing a Trigger - SQL School Video
Triggers are supposed to fire for every update, but in this video we see how you can bypass a trigger for an update.
2008-12-16
4,403 reads
Video
Writing a Basic MDX Query Pt.2 - SQL School Video
In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.
2008-12-11
6,741 reads
Writing a Basic MDX Query Pt.1 - SQL School Video
MDX is the query language for multidimensional queries, usually against SSAS cubes. Brian Knight introduces us to the basics of MDX in this video.
2008-12-09
9,159 reads
Using the Aggregate Transform - SQL School Video
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,434 reads
Creating Mirrored Backups - SQL School Video
In this SQL School video, Andy Warren examines one of the new features in SQL Server 2005: mirrored backups.
2008-12-02
4,269 reads
Using SSIS Precedence Constraints - SQL School Video
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
2008-11-27
5,092 reads
Using the Sort Transform - SQL School Video
This SQL School video shows just how you can sort the data in your SSIS packages.
2008-11-25
3,299 reads
Using Script Component as a Transformation - SQL School Video
Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.
2008-11-20
4,066 reads
Creating a Basic Policy in SSMS - SQL School Video
In SQL Server 2008, we have a new way of enforcing rules on our servers. This video has MVP Brian Knight showing us how to create a basic policy in Policy Based Management.
2008-11-18
2,765 reads
Using the File System Task - SQL School Video
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
2008-11-13
4,334 reads
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers