If you read references to "Level Up", that's our Redgate conference.  It was internally described as: Level Up is Redgate’s way of celebrating learning and development, helping us all to...

We are having a work conference this week at Redgate. In previous years, we rented a space for a few days and literally ran a conference. Booths were from different...

Thoughts this crew might like this:

"Do not assume that index maintenance will always noticeably improve your workload."

• https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15#index-maintenance-strategy

Indeed. That's a bad one.

We don't have an IF really, but you can use CASE.

For sum of operating expenses, you could include a case when (materials or personal expenses) else 0 for the value....

Should be, they have it linked and listed from multiple places.

It's helpful if you post data in a consummable format, as in the DDL to create a table and the DML to insert data.

What I might do here is create...

What format are you logs? Any data can be loaded into SQL SErver in a table, but you usually need a process to run the import.

This comes from sys.sysprocesses. If you check the docs (https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-sysprocesses-transact-sql?view=sql-server-ver15), this is listed as the last time that the user executed something.

https://www.sqlservercentral.com/articles/sql-server-2019-build-list

Microsoft has published container images for SQL Server 2017 and 2019, but they use their own registry. mcr.microsoft.com

https://github.com/microsoft/containerregistry

If you query from the docker CLI, you can get the tags....

You can. If you use Transparent Data Encryption, then everything is encrypted and Excel can just query.

If you want just specific columns, you likely will want a stored procedure to...

You can also create a table as:

create table dbo.mytable(myid int)

You will have to understand what type of encryption is being used. If PHP is doing the encryption, then you may or may not need to decrypt the data. You...

First, there is no first and second records. Records in a database have no ordering. You'll have to better explain what you are looking for here, or what results are...