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,386 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,730 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,142 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,424 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,249 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,073 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,287 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,052 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,753 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,323 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...