T-SQL Tuesday #110 – Automate All the Things
From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...
2019-01-08
7 reads
Blog Posts
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source...
2019-01-08
396 reads
What product to use to transform my data?
If you are building a big data solution in the cloud, you will likely be landing most of the source data into a data lake. And much of this...
2019-01-08
7 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop...
2019-01-08
223 reads
Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment
Pre-conference Workshop at SQLSaturday Chicago – 825
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Chicago on March 23rd 2018! This...
2019-01-08
2 reads
A Monumental Migration to SQL Server 2016 - Part 1
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...
2019-01-07
4 reads
ArithAbort and SQL Agent Failures
ARITHABORT
I was coding along one day, working on rolling out some monitoring for a client—monitoring that I had used for previous...
2019-01-07
256 reads
ArithAbort and SQL Agent Failures
ARITHABORT can be a short termed head scratcher. Pay close attention to what has changed in the environment. Test alternatives. And check those connection strings.
Related Posts:
Failed to Create the...
2019-01-07
8 reads
Azure SQL DB VS SQL Server For the DBA
Being the start of the new year and with new projects most likely starting again I would like to share...
2019-01-07
304 reads
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
299 reads
Blogs
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Retro Data 2025 – Slidedeck
You can find the slides of my session on the €100 DWH in Azure...
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Forums
Is there a way for SP to know who called it?
Hi everyone I am writing an SP where there is logic inside the SP...
Planning for tomorrow, today - database migrations
Comments posted to this topic are about the item Planning for tomorrow, today -...
Bottlenecks on SQL Server performance
We have a BI-application that connects to input tables on a SQL Server 2022...
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