2019-11-26
371 reads
Data Science
Data Science, BI, and Reports
Business Intelligence and Data Science are linked, and complementary. As Steve notes, both can help your organization make better decisions based on data.
2019-11-14
399 reads
Hosting a Machine Learning Model in ASP.NET Core 3.0
Microsoft introduced the ML.NET framework which can be used by developers to include machine learning models in their applications. In this article, Dino Esposito discusses hosting a machine learning model in ASP.NET Core 3.0.
2019-11-13
Building Machine Learning Models to Solve Practical Problems
Machine learning is a skill that many data professionals are learning as they plan their careers over the next five to ten years. In this article, Supriya Pande gives an overview of machine learning and walks through a practical example.
2019-10-14
2019-05-31
Pondering statistical significance in a world without .05
The latest edition of The American Statistician is...
2019-05-24
All Data is Dirty: Subjective Data, Likert Scales, and More
One of the things I like to point out in my Launching a Data Science Project talk is that all data is, by its nature, dirty. I figured I...
2019-05-16
How to show characteristics of study population in R with a single line of code
Interested in guest posting? We would love to share your codes and ideas with our community.
Category
Data Management
Tags
Data Management
Tips & Tricks
Another advantage of R, in addition to visualization, is the...
2019-05-16
What is Data Maturity?
Companies across the world are at different stages of experimenting with data and realizing what kinds of decisions can be made via deep analysis. Since these trials and realizations are happening at differing speeds, and often start from scratch within each organization, there are significant disparities in maturity between otherwise similar organizations.
2019-05-03
Machine Learning Digs Deeper into Azure with Custom Vision, Anomaly Detector
Microsoft's quarter of product announcements underscores its commitment to the cloud, its investment in machine learning as a core component of the modern enterprise, and an expansion of its focus on firstline workers who may not always have high-speed...
2019-03-30
Blogs
The Book of Redgate: We Value Teams
By Steve Jones
This value is something that I still hear today: our best work is done...
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
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