this is the  educational part about learning to code...working through the errors.

I am assuming you are using mySQL workbench for development.

there is an output window that might actually be hidden,...

still based on the same old code from ten years ago, this is what i do today: it's just a handfull of legos/snippets, assembled into the shape of something i...

• This reply was modified 2 months, 1 week ago by  Lowell. Reason: spelling

that's a decent list of interview questions to test if you have any experience doing any of those steps. i my self ask variants of some of these questions, and...

In Azure, the procedures sp_GetDDL and sp_GetDDLa would have to be installed in each database; so 10 dbs = 10 copies, sorry

we don't have the ability to leverage ability to...

I believe your error is related to firewall denying your connection.

it might be technically visible as far as dns/server name resolution, and maybe even allows a ping, but wherever your...

change the database compatibility to SQL2019 prior to the items below.

the optimizer is different between versions, so it's pretty standard to have to, at a minimum, rebuild statistics with full...

my knee jerk reaction is two fold.

did you run pip import compute_tau on the server itself? all your libraries you have need to be accessible to SQL's version of python,...

• This reply was modified 5 months, 1 week ago by  Lowell.
• This reply was modified 5 months, 1 week ago by  Lowell.

i would suggest two things here. python can grab data into a dataframe, and then export out parquet files.

once the file is created, use GnuPG to create an encrypted version...

oh yeah, and stubborn old me only likes varchars..so if you have a table that has a name with nvarchar, like  below, you'd have to find and replace all the...

spcghst440 / Tim C, thank you very much for pointing out that gap!

I've been using this for literally a decade or more, and so far , in my environment, i...

if you are comfortable with PowerShell, this example command will get all end users, including those that are members via a group-within-a-group:

here i am assuming you found a group named...

see if this script can help you visualize the actual blocker(s).

this is what I use, I am sure I picked it up here on SSC and further enhanced it. for...

it's permissions.

you have permissions, but the account running the SQL service does not.

regardless of who is running the SQL command executing xp_cmdshell, once outside of SQL server, xp_cmdshell runs as...

• This reply was modified 9 months, 1 week ago by  Lowell.

a piece of the puzzle here is connectivity. are you already using cnames to point to the server, so with a simple DNS change, you can say PRODSERVER points to...

the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:

1. if you use UNC paths for your backup directory, you must...