SQL Server 2017 Reporting Services: The Basics Part 5
We’re now on Part 5 of our SQL Server Reporting Services Basics Series. In this installment, we’ll learn how to...
2019-03-21 (first published: 2019-03-09)
3,419 reads
Blog Posts
There is Now A Delete Activity in Data Factory V2!
Data Factory can be a great tool for cloud and hybrid data integration. But since its inception, it was less...
2019-03-21 (first published: 2019-03-07)
1,907 reads
Using docker named volumes to persist databases in SQL Server
I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...
2019-03-21
414 reads
Disabling and enabling triggers
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now...
2019-03-20 (first published: 2019-03-06)
2,320 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content,...
2019-03-20
370 reads
Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.
Problem: SQL server database refresh / restore...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-20
19 reads
SheLeadsTech Community
ISACA, which is primarily an Audit and Compliance professional organization, has recently started an initiative with the following purpose:
ISACA’s SheLeadsTech...
2019-03-20
324 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
659 reads
The Curiously Large CASE Statement
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to "transform" data per business rules to help better understand the data...
2019-03-20
2 reads
The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
666 reads
Blogs
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
Forums
Is there some good routines for updating SQL Server database objects with GitHub
At work we've been getting better at writing what's known as GitHub Actions (workflows,...
The Tightly Linked View
Comments posted to this topic are about the item The Tightly Linked View
Build a Test Lab of SQL Server 2025 on Windows Server 2025 using Hyper-V Virtual Machines
Comments posted to this topic are about the item Build a Test Lab of...
Question of the Day
The Tightly Linked View
I try to run this code on SQL Server 2022. All the objects exist in the database.
CREATE OR ALTER VIEW OrderShipping
AS
SELECT cl.CityNameID,
cl.CityName,
o.OrderID,
o.Customer,
o.OrderDate,
o.CustomerID,
o.cityId
FROM dbo.CityList AS cl
INNER JOIN dbo.[Order] AS o ON o.cityId = cl.CityNameID
GO
CREATE OR ALTER FUNCTION GetShipCityForOrder
(
@OrderID INT
)
RETURNS VARCHAR(50)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @city VARCHAR(50);
SELECT @city = os.CityName
FROM dbo.OrderShipping AS os
WHERE os.OrderID = @OrderID;
RETURN @city;
END;
go
What is the result? See possible answers