Today Steve talks about deployments and whether you should roll forward or roll back.

Find Duplicate Rows in SQL Server with a CTE

by Additional Articles

MSSQLTips.com

T-SQL

This tip demonstrates how find and list allf duplicate rows in a dataset using a Common Table Expression (CTE).

Detecting Issues

by Steve Jones

SQLServerCentral.com

Editorial

How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.

Guarding Against SQL Injection at the Database Layer (SQL Server)

by Ted

SQLServerCentral

This article presents a way to check and validate input before using it in your dynamic SQL queries to prevent SQL Injection problems.

Python is good, but not perfect – here are 10 reasons to avoid it

by Additional Articles

SimpleTalk

Python

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.

Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI

by SQL Expert

SQLServerCentral

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 […]

Having a Little Fun at SQL Server Central

by Steve Jones

SQLServerCentral

SQL Server Central

Steve reminisces on some of the fun times he's had at SQL Server Central.

SSMS 22 Offline Installation

by Additional Articles

MSSQLTips.com

Management Studio (SSMS)

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.