Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]
It's easy for most of us to get caught up in work and not stop to think about the larger picture, or the longer term. Steve Jones thinks you should make time for both of these.
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
This article explains the basic components of a tech stack, and the decisions and requirements that affect how and where monitoring tools generally, and a specialist SQL Server monitoring tool like SQL Monitor, in particular, fit into your stack.
Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.
Kubernetes is a technology Steve thinks will be important in the future and knowing a bit more about it can be important for your career.
In this article we look at using AWS Performance Insights to help monitor and troubleshoot SQL Server performance issues when running on RDS.
This article will look deeper at the Azure SQL Database - Hyperscale edition, which was moved into General Availability (GA) in May 2019. This followed a bit of a preview time, when I first learned about how it worked in detail. I was impressed with the work being done, some of which will make it […]
Your PowerShell process for database comparison and deployment is running smoothly, and your instinct is to 'leave well alone'. However, you continually need to delve into the script to tweak comparison settings or add a new command line switch. Phil Factor proposes a way to avoid this using SQL Compare projects.
Window functions can be life savers by making a complicated SQL calculation easy. A window function combines that logic and provides row by row or window by window feedback. Read on to learn more!
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Dsn. Wadas Jl. Magelang No.Km. 12, RT.08/RW.03, Wadas, Tridadi, Kec. Sleman, Kabupaten Sleman, Daerah...
Telp/wa 085169998803 Kavling Tofi, Blk. A No.3, RW.Sektor XI, BSD City, Kec. Serpong, Kota...
Telp/wa 085169998765 Jl. Tebet Raya No.25 B Blok CI, Tebet Tim., Kec. Tebet, Kota...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers