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 1 years, 11 months ago by Lowell.
• This reply was modified 1 years, 11 months 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 2 years, 3 months 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...

start at the basics:  can we narrow it down to see if it could have been a DBA process or a Business process?

did you have a scheduled job for statistics,...

In my environment, i have a very similar need, but much more robust.

• I need to script out the current permissions from a development database
•  restore a database from prod,

...

On SQL2019, i get an error trying to compile the code.

Msg 13822, Level 16, State 1, Procedure MyOpenRowSetTest4, Line 4 [Batch Start Line 7]

File 'd:\downloadedfiles\filethatdoesntexist.txt' cannot be opened...

Login failed for user 'brainiac' is the key.

EXECUTE xp_readerrorlog

and find out the specific reason why the login failed. it will tell you exactly the problem on the next line AFTER ...

if the SQL Service is stopped, one of the things it does is puts a pointer in  thelog, to track what is committed or not committed as far as transactions...