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

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 1 year, 1 month 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 1 year, 4 months ago by Lowell.
• This reply was modified 1 year, 4 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...