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.
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers