database-engine | LSM-Tree Key-Value Store based on RocksDB | Key Value Database library

I would like to get alerts when certain database errors occur. For instance, if a table or stored procedure is queried against that no longer exists, I want an alert.

I've tried creating alerts for these error codes (208, 2812) but they never trigger, no doubt due to the fact that there are only a handful of error codes that are logged, according to the docs.

From sys.messages:

Is there a way to change the event logged status?

I have a script that makes a backup of 3 sql databases.

I've attached the full script and its output in the two code blocks below. Don't be intimidated by their size, i'm simply calling the powershell cmdlet Backup-SqlDatabase at some point.

Backup-SqlDatabase documentation

https://docs.microsoft.com/en-us/powershell/module/sqlserver/backup-sqldatabase?view=sqlserver-ps

I have a .net framework 4.7.2 app with entity framework 6.1.2. The app uses an azure sql database which has -among others- a table with encrypted data. We have used the Always Encrypt feature of sql server in order to encrypt these data. The database schema is shown below.

The field Description in table Order is nvarchar(100) and the field Description in Note is nvarchar(100) and encrypted with Always Encrypt (deterministic encryption). Both columns are nullable and have a non-clustered index on them. Both tables have a few tens of millions of records.

We have the following query in our code: var user = DbContext.Set().FirstOrDefault(u => u.Notes.Any(n => n.Description == value)); This query used to run with with normal performance cost (few dozens msecs) before encrypting the field in our db. This completely changed after the encryption. The execution time changed to a few tens of secs.

I rebuilt all indexes but it changed nothing.The above code statement is translated from entity framework into something like:

Context: I'm trying to use SQL Server's Polybase to query data in parquet files. One of the steps required to do so is to create an external file format that maps to parquet. MSDN provides SQL sample below.

I know this question is repeated (Grant Select on a view not base table when base table is in a different database), but I have tried the proposed solution, without any luck.

My idea is grant limited access to data in certain databases through an intermediate database in which I create views. I do this to avoid granting specific permission on external tables every time I create a view. This is what I do:

• I have User_A and User_B
• User_A creates DATABASE_A1 and DATABASE_A2
• User_A creates VIEW_A in DATABASE_A1 that reads data from DATABASE_A2
• I set db_dataread role to User_B in DATABASE_A1, so they now can execute VIEW_A
• If User_B tries to execute VIEW_A, receives the message "The server principal 'User_B' is not able to access the database 'DATABASE_A2' under the current security context", which I expected, as the user has no rights on this database
• I then activate 'cross db ownership chaining' in both databases (not sure if I only need doing it in one), with these commands:

The main memory on the host is limited and hence the Bufferpool size for the mysql engine. Wondering whether any known solution for the MYSQL which allows the buffer pool extension to a nonvolatile random access memory (that is, solid-state drive or EBS volume in case of AWS infra) extension to the Database Engine.

[EDIT] I am able to find very old doc for sql server but didn't find anything on mysql. I am looking for any existing solution for mysql engine/innodb or good reference points for how to add that feature.

Reference

SQL Server doc

Using T-SQL, how can I retrieve the current configuration value that can be set with these commands?

I have a function app that is assigned a user assigned managed identity, and it uses that to connect to the SQL database. This was working fine for a few days, but then suddenly stopped working, without any changes to db or the function app.

I am trying to run a command using the C# namespace System.Diagnostics.

I use these commands to install SQL Server and SQL Server Management Studio.

For SQL Server, I downloaded the installer from: https://www.microsoft.com/en-us/download/confirmation.aspx?id=55994 and installed the basic version.

After that I want to use this: