Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.
In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.
Everyone should be running DBCC CHECKDB on their systems. We not have some help in determining if we are doing this.
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?
With each recent version of SQL Server, Microsoft has added features that can be used to improve query performance with much less effort than traditional index and query tuning require. First was Query Store, introduced with 2016. When enabled, this feature allows you to easily find regression in query performance due to changing execution plans. […]
SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?
Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows Server 2016.
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
CSTelpon : 0853-73737551 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan,...
CSTelpon : 0853-73737551 Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti,...
Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota Depok, Jawa Barat 16454
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers