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,694 reads
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,694 reads
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,177 reads
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,676 reads
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,814 reads
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,615 reads
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,843 reads
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,754 reads
Learn the basics of how to audit changes on your SQL Server with MVP Andy Warren.
2009-03-10
5,663 reads
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
2009-03-05
3,665 reads
Learn how to use the SSMS GUI to modify tables in this SQL School video.
2009-03-03
3,061 reads
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers