Self-service Reporting in SQL Server “Denali”
Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...
2010-11-14
609 reads
pturley
Cloudy Days Ahead
Microsoft is investing heavily in cloud computing with several online services available
under the Azure Platform.
SQL Azure
The SQL Azure cloud...
2010-11-13
400 reads
PASS 2010 Summit Announcements and New SQL Server Developments
To say that this was a very full conference would be an understatement. The
SQL Server platform has grown to be...
2010-11-13
476 reads
Join us at PASS 2010!
Please join as at the 2010 global summit for the Professional Association for SQL
Server in Seattle. The conference is the...
2010-10-13
482 reads
Product Review: SnagIt 10
Screen captures have become part of our computer culture… “I’ll send you a screen
shot of the window so you can...
2010-09-02
496 reads
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
611 reads
Project Phoenix: a Chance to Support the Community and Build a Career
Do you know someone with an IT background who could use a break, is passionate about
technology and wants to make...
2010-08-04
496 reads
2010 Microsoft BI Conference: Directions in Microsoft BI
The combined Microsoft BI Conference and TechEd in New Orleans last week was a great
experience. The shear magnitude of the...
2010-06-21
1,157 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,438 reads
Portland SQL Saturday / Code Camp 2010
Today was the Portland SQL Saturday and Code Camp at the University of Portland and
it was a great experience. I...
2010-05-23
419 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