SQLskills joining Pluralsight is a good news for all
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,078 reads
Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...
2012-09-06
1,078 reads
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,863 reads
I’m nowhere near where I needed to be. I am not digging enough. I’m not learning enough. Learning opportunities are...
2012-08-25
1,300 reads
I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed...
2012-08-09
3,379 reads
Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen...
2012-08-04
1,280 reads
I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...
2012-07-28
1,646 reads
From time to time, I will be posting links that I encountered during the week. This is also one way...
2012-07-06
823 reads
I have two goals that I have sought to achieve by mid-year of 2012. The deadline I set for myself...
2012-06-29
1,472 reads
I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...
2012-06-22
797 reads
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,036 reads
By Steve Jones
This value is something that I still hear today: our best work is done...
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
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...
At work we've been getting better at writing what's known as GitHub Actions (workflows,...
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