SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
Artist or Scientist?
In your work, are you an artist or a scientist? Steve Jones knows we need to be both, but when is each appropriate?
CRUD Operations in SQL Server using Python
This article goes through a process to show how you can use Python to perform create, read, update, and delete (CRUD) operations on SQL Server data.
Managing database changes using Flyway: an Overview
This article describes the principles of using Flyway migrations to build a database from scripts, to a specified version, and to track, manage and apply all database changes.
Bronze Age Development
The slow pace of Visual Studio development had a number of problems over the years, but Microsoft has dramatically changed the way they build their software for the better.
How to Restore an Agent Job that was Dropped
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
How to Restore an Agent Job that was Dropped
Once upon a time, you had one job, well actually two jobs. The first SQL Server agent job was important, the other was a test. You have decided you do not need the test agent job. Quick right-click on a job name, remove, confirm, done. When you refreshed the list, the test job was still […]
Create Azure VM from a VHD image
Learn how to create an Azure VM image that can be used to quickly deploy new Azure VMs that are preconfigured based on your image settings.
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works.
PostgreSQL Python Integration
Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language and Python is a high level, interpreted general purpose language. This article covers basic integration of Python with PostgreSQL apparently how we can establish connection with PostgreSQL database using Python program and perform CRUD operations on […]
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Wisma Mulia Telpon/WA:08137887595
BCA KCP Wisma Mulia Telpon/WA:08137887595.Jl. Gatot Subroto No.42 Suite G02, Kuningan Bar., Kec. Mampang...
BCA KCP Altira Sunter Tlpn/Wa 0853.7373.7551
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, Sunter Jaya, Kec....
BCA KCP Soepomo Telpon/WA:08137887595
BCA KCP Soepomo Telpon/WA:08137887595.Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers