I will be speaking @ SQLSaturday #795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
2 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
2 reads
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will be speaking about dbachecks PowerShell module - dbachecks -...
2018-09-05
6 reads
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident.
Who’s...
2018-09-04
252 reads
Almost all the applications we use have a lot of options. And, sometimes we even stumble across them by accident. Who’s ever heard something like “Normal user don’t even...
2018-09-04
7 reads
I’m working on a project where I need to convert Firebird SQL code into T-SQL code.
No schema, just the modules....
2018-08-24
303 reads
Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon!
This...
2018-07-06
312 reads
Starting on 19th of July and during 3 days the Tuga IT 2018 Summer Edition will be happening in Lisbon!
This edition will have:
4 full-day workshops 38 breakout sessions (1...
2018-07-06
2 reads
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server.
The client provided the scripts...
2018-06-05
112 reads
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration...
2018-06-05
477 reads
In less than two weeks (on 16th June) it’s time for SQL Saturday Athens and I’m proud to announce that...
2018-06-04
296 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Hi everyone I am writing an SP where there is logic inside the SP...
Comments posted to this topic are about the item Planning for tomorrow, today -...
We have a BI-application that connects to input tables on a SQL Server 2022...
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; goWhat is the result? See possible answers