Building The SQLSaturday Orlando Marketing Plan-Part 32
I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...
2014-08-11
483 reads
SQLAndy
SSC Editorial: Titles Matter
Few things have more impact on our career than job titles. The job titles we’ve held tell future employers a...
2014-08-08
497 reads
Apply Now for the PASS Board of Directors
One of the better graphics I’ve seen in a Connector that shows the timeline:
My thoughts:
Should You Run for the...
2014-08-06
738 reads
Building The SQLSaturday Marketing Plan-Part 31
No viewed on LinkedIn yesterday. Increased the bid to $5 and now seeing views. Not sure it correlates, but probably....
2014-08-05
742 reads
Building The SQLSaturday Orlando Marketing Plan–Part 30
First, a quick update on the LinkedIn advetising campaign. One click so far, no registrations. More views than I expected...
2014-08-04
597 reads
Building The SQLSaturday Orlando Marketing Plan-Part 29
Received an email from LinkedIn that the ad was approved and so far we’ve spent a whopping 83 cents! Not...
2014-08-03
406 reads
Building the SQLSaturday Orlando Marketing Plan-Part 28
Today at lunch I looked at LinkedIn advertising. I only capture the last part to share here, but you put...
2014-08-01
567 reads
Building The SQLSaturday Orlando Marketing Plan–Part 27
Notes:
Email with the schedule went out this week, nice bump in registrations – we’re at 229 todayMailed the list twice (bad)...
2014-07-30
1,056 reads
The Growth Of SQLSaturday
A recent Connector showed the following stats for SQLSaturday for the fiscal year ending June 30, 2014 and mentioned 86...
2014-08-04 (first published: 2014-07-28)
7,617 reads
Building The SQLSaturday Orlando Marketing Plan-Part 26
More notes:
In hindsight it’s easy to see we should have worked on the email template first, then the flyers. Email...
2014-07-28
1,235 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