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,419 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,718 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,200 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,278 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,260 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,268 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,122 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,745 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,894 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,136 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
ALAMAT BCA KCP Majapahit Telp:08218154393
WA:08218154393 Jl. Majapahit No.112, Pandean Lamper, Kec. Gayamsari, Kota Semarang, Jawa Tengah 50161
ALAMAT KONTAK BCA KCP Ungaran Telp:08218154393
WA:08218154393 Ungaran Square, Jl. Gatot Subroto Blok A3-A4, Banaran Barat, Bandarjo, Kec. Ungaran Bar.,...
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers