Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.
Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.
Learn how to query data in Azure Data Explorer using Python.
Are DBAs going to be responsible for financial accounting for cloud resources as a part of their job? Steve has a few thoughts today.
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel.
The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how the tool works, and this one continues the series. In this article, I want to look at the database dashboards and how you can customize them. The other articles in this series on ADS works […]
Today Steve asks about on-call responsibility for you and how you view this as part of your job, or in your job search.
In this article, we look at how to setup different ways to handle pipeline failures and notifications when working with Azure and Azure Data Factory.
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
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...
BCA KCP Dewi Sartika Telp:cs.(0821)3111185 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati,...
BCA KCP Menara Imperium Telpon/wa.0853.7373.7699.Jl. HR Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota...
Tlp/WA.(+62 821°3111°179 Jl. Daan Mogot No.95, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers