Using Views and Synonyms for Abstraction - SQL School Video
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,391 reads
Video
Creating a Synonym for a Table - SQL School Video
New in SQL Server 2005, Synonyms replace aliases from previous versions. Brian Knight shows how they can be created and used.
2009-01-20
2,697 reads
Generating Random Results - SQL School Video
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,179 reads
Disabling Indexes - SQL School Video
There are times that you do not want indexes to be updated and used. Brian Knight shows how you can accomplish this with a new SQL School video.
2009-01-13
3,259 reads
Post SQL Server 2008 Upgrade - SQL School Video
After you complete an upgrade to SQL Server 2008, Brian Knight goes over some things you might want to do first.
2009-01-08
3,233 reads
SQL Server Options to Avoid - SQL School Video
Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.
2009-01-06
6,253 reads
SQL Server Management Studio for Beginners - SQL School Video
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
8,088 reads
Moving TempDB - SQL School Video
Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.
2008-12-30
4,729 reads
Creating One-Time Jobs - SQL School Video
SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.
2008-12-23
3,878 reads
Using the CheckSum Function - SQL School Video
There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.
2008-12-18
6,111 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
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