(Ben Richardson) In 2017, SQL Server introduced support for Python language which opened the door for creating machine learning models using SQL Server. The SQL Server machine learning services along with Python support can be used to create a model that is capable of prediction.
Community
SQL Convert Date Functions and Formats
(Rajendra Gupta) In this article, we will explore various SQL Convert Date formats to use in writing SQL queries.
STDelete: Deleting vertices in geometry objects
(Simon Greener) SQL Server Spatial, unlike spatial database type systems such as PostGIS, does not provide coordinate editing functions:
Flow Object.values(…)
(David Walsh) JavaScript typing utilities, like Flow and TypeScript, have become popular in JavaScript apps of all sizes. As I mentioned in our Script & Style Show typing podcast, typing is a great way to implicitly implement documentation and validation.
Visual Studio Tips – Trace Points
(Jeremy Hutchinson) Tracepoints are not a new feature, they’ve been in Visual Studio since 2005, but they are a new feature to me.
Db2 Application Testing Considerations
(Craig S. Mullins) Testing application programs is a discipline unto itself and there are many considerations and nuances to be mastered to be able to test software appropriately.
Should I Be Using the ASP.NET Core SPA Templates?
(Shawn Wildermuth) I’ve been writing demos for Vue, Angular, and React for my SignalR micro-courses over on my Wilder Minds site. For Angular and React, I started out with the the SPA templates, but I found them confusing and hard to do a minimal example.
First Steps in porting Markdown Monster WPF App to .NET Core 3.0
(Rick Strahl) Today I took the day to explore what it would take to port Markdown Monster to .NET Core. Most of the examples I’ve seen so far for ports or running applications on .NET Core are pretty trivial – you can see how the process works, but just looking at those examples I had a million ques
HA for MySQL and MariaDB – Comparing Master-Master Replication to Galera Cluster
(Ashraf Sharif) Galera replication is relatively new if compared to MySQL replication, which is natively supported since MySQL v3.23. Although MySQL replication is designed for master-slave unidirectional replication, it can be configured as an active master-master setup with bidirectional replicati
Monitoring your Oracle APEX environment; when is a good time to do an upgrade?
(Dimitri Gielis) Yesterday Oracle released Oracle APEX 19.1. We typically upgrade our environment within a week.