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,466 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,466 reads
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,740 reads
How can you randomly generate data? MVP Andy Warren shows how in this SQL School Video.
2009-01-15
3,231 reads
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,292 reads
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,299 reads
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,287 reads
Learn the basics of how to work with Management Studio in this SQL School video.
2009-01-01
8,169 reads
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,756 reads
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,917 reads
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,185 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers