you can backup and restore, too and from an S3 bucket, will that help?

you need to set up a few things in rds first, and make sure of permissions on...

i suspect you are missing part of a join statement, or have an incorrect logic in your trigger...like joining on parentId, but not ChildId. can you show the definition of...

it's the service account that is running the SSRS Service that needs access.

You'll need to modify the Reporting Services Configuration Manager Subscription settings.

if the path is a unc path ,...

just suggesting to check the basics...database mail has a dependency on dotnet 3.5, which is not installed in an operating system by default, and is easy to mis-remember the dependency....

i think you may have toggled mixed mode authentication, but that setting requires a stop and start of the SQL service, as it is only loaded at that time.

it will...

well dang. i found that SSC is scrubbing my posts if i paste the commands i previously used  in linux.

i had a script in python that worked everywhere in windows,...

so deadlock information is capture int eh system health extended event, in the stack of files it saves.

here's a really good stack of queries i put together and use on...

here's an example i use pretty frequently. it's a stored procedure, that is calling Adam Machanic's sp_whoisactive.

if there are no long running transactions, It bails out gracefully, but if something...

so as Johan mentioned, linked servers leverage tempdb. so if you are adding a WHERE or an ORDER BY, or joining it to your local data, the whole table goes...

I happen to be in the middle of a vector project. i downloaded SQL2025, and while i can  use the vector data type, the built in functions related to vectors...

I've been doing some stuff with the new [vector] data type as a result of some efforts related to AI projects. in both 2025 and Azure, the data type exists,...

hey i found it. the sys.partitions has two new-ish columns xml_compression and xml_compression_desc

the code below is something i use for scripting indexes, but if i was scripting a table, i...

I agree, San Level snapshots like Veeem and Pure are awesome; they issue the dbcc freeze command, and the backup, even when say, 30TB, takes seconds. And then issues the...

so there are a few things you can tweak yourself...and I am under the impression that nothing is faster than a native backup with the optional settings.

three specific optional flags...

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

yes, it's annoying. you must literally use a string, and not a variable that happens to be a string.

The work around is to build the query string and execute it....

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