Supervised training of an artificial neural network entails training the network to associate defined patterns with specified labels. Optical Character Recognition is an example of supervised training, where each input pattern is mapped to an alphanumeric character. In unsupervised training, a neural network learns to extract recurring patterns from noisy data. One of the earliest […]
2026-03-06
1,094 reads
I know a lot of y’all lag behind on upgrading SSMS, but v22.3 just introduced something that you need to be aware of. It’s going to impact any of your users who DO upgrade their SSMS, or who use Github Copilot. There’s something that you can do in order to improve Copilot’s code quality and make it match your preferred coding standards.
2026-03-06
2026-03-04
3,142 reads
This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).
2026-03-04
This article presents a way to check and validate input before using it in your dynamic SQL queries to prevent SQL Injection problems.
2026-03-02
3,507 reads
Four years ago I wrote a blog on this site explaining why Python is better than C# and, arguably, most other programming languages. To redress the balance, here are 10 reasons why you might want to avoid getting caught up in Python’s oh-so-tempting coils – particularly when building large, long-lived systems.
2026-03-02
Introduction. Why AI Readiness Starts in the Database You probably don’t need machine learning today. Most organizations don’t. You already have reporting dashboards, operational workflows, and business intelligence that work just fine without neural networks or predictive models. That’s not a failure. It’s normal. The problem doesn’t show up immediately. It shows up a few […]
2026-02-27
2,086 reads
Beginning with SQL Server Management Studio 21, Microsoft stopped providing the direct download package/binaries to install SSMS, instead it just downloads the SSMS installer. This installer then starts the installation of SSMS and downloads what is needed to install SSMS. Sometimes there may be a need to do an offline installation where you do not have access to the internet. In this article, we walk through the steps to do an offline install of SSMS.
2026-02-27
In this next installments of the Modern Fabric Data Warehouse, we look at tools for developers.
2026-02-25
1,950 reads
Now that SQL Server 2025 has finally been released to the public, I was finally able to test and learn a lot about this command (named CREATE EXTERNAL MODEL), and I want to share my knowledge with you here. If you’re new to the world of AI, don’t worry, we’ll start with the basics and evolve to where this command fits in!
2026-02-25
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers