Creating a Linked Server - SQL School Video
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
2009-04-07
6,405 reads
Video
Using OpenRowSet - SQL School Video
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
2009-03-31
3,168 reads
Using SP_MSForEachDB and SP_MSForEachTable - SQL School Video
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,399 reads
Using the Union Statement - SQL School Video
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,747 reads
Creating Striped Backups - SQL School Video
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,588 reads
Using Intersect - SQL School Video
This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.
2009-03-17
4,821 reads
Removing Audit History - SQL School Video
MVP Andy Warren continues his series of videos on auditing with a look at removing old data. In this video, learn how to develop an easy system to keep a rolling history, removing anything older than a set number of days.
2009-03-12
1,724 reads
Basic Auditing - SQL School Video
Learn the basics of how to audit changes on your SQL Server with MVP Andy Warren.
2009-03-10
5,634 reads
Formatting SSAS Measures - SQL School Video
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
2009-03-05
3,547 reads
Creating and Modifying Tables in SSMS - SQL School Video
Learn how to use the SSMS GUI to modify tables in this SQL School video.
2009-03-03
3,051 reads
Blogs
Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Forums
Transactions/Second
Hello.Does anybody have a way to identify what transactions ran in an interval (i.e....
How to update status with conflict data where chemical temp table have same chem
How to update status with conflict data where chemical temp table have same chemical...
Blob to ADF to Stored proecure
I'm reading file from BLOB through ADF and I would like to pass the...
Ask SSC