On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.
2017-05-15
5,212 reads
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
2009-08-11
11,701 reads
If you have trouble connecting to a busy server, you'll want to watch this installment of SQL School. MVP Andy Warren shows how you can use the dedicated administrator connection (DAC) in SQL Server 2005 and above.
2009-08-06
8,107 reads
Did you know that SQL Server maintains a great set of text logs about events on the server? MVP Andy Warren shows you how to get information out of the error logs in this SQL School video.
2009-08-04
9,980 reads
SQL School covers a basic topic this week. MVP Andy Warren shows the various ways to stop and start your services.
2009-07-30
5,180 reads
Learn how you can configure your SQL Server instance using T-SQL code and sp_configure. MVP Andy Warren hosts this SQL School video.
2009-07-28
4,991 reads
Continuing with his videos on Foreign Keys, MVP Andy Warren shows us how to set constraints between two tables.
2009-07-23
4,997 reads
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,554 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,188 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,317 reads
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC