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 ,...

tools like DBBeaver, DB Browser for SQL Lite and Database Browser portable, all can open a SQLLite db and give you a decent GUI interface to fiddle with it.

I created...

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 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.

You can downgrade or upgrade Enterprise to Standard, and Vice Versa, if you have the key for the target edition.

I had started grabbing all the enterprise edition objects via a...