Understanding referential integrity is important for anyone working with databases. It can help you design better forming systems. Learn the basics of foreign keys in this SQL School video.
2009-07-21
8,590 reads
This edition of SQL School brings us a look at how to set single user mode for your SQL Server instance.
2009-07-16
4,192 reads
Database Mail is an essential part of administering SQL Server for most people. MVP Andy Warren brings us part 2 of how to set up this subsystem.
2009-07-14
6,330 reads
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
2009-07-09
5,242 reads
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,505 reads
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,251 reads
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,485 reads
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
2009-06-30
2,683 reads
Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.
2009-06-25
4,264 reads
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
2009-06-24
2,538 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers