Viewing 15 posts - 1 through 15 (of 5,111 total)
is anyone using a KVM switch to jump between a home PC and a work laptop?
It's something I considered for some time, but I ended up switching to a...
June 25, 2025 at 4:01 pm
Primary Key and Identity are different "things". A PRIMARY KEY is a CONSTRAINT, where as IDENTITY is a property of a column/table. A PRIMARY KEY isn't an IDENTITY.
DROPing your PRIMARY...
June 19, 2025 at 1:59 pm
Are you able to provide some sample data, and DDL and DML, as what results you might be expecting for those values? I'm having some difficulty visualising what your data...
June 18, 2025 at 3:51 pm
No, it means that any connections that aren't local will have no access, which I'd argue is most connections in most environments.
June 17, 2025 at 1:13 pm
Have you looked at VSCode instead? ADS is built on top of VSCode, so it has a similar look and feel. Yes it's not going to be 100% feature...
June 17, 2025 at 8:39 am
I'm looking for a replacement to ADS, as I'm a Linux user at home and Microsoft have decided to retire it. My searching frequently brings me to DataGrips, which looks...
June 16, 2025 at 3:58 pm
Sorry, double post due to502 error.
March 27, 2025 at 4:13 pm
Anyone noticing a round of replies to posts that "feel" suspiciously like someone fed the OP's question into one of the chat-bot AIs and posted the "answer"?
It's not an...
March 27, 2025 at 4:10 pm
Sooooooo.... something weird is happening on another thread, one I started. Converting job_id to join to another table.
I believe that posts are also being removed due to being...
January 7, 2025 at 2:14 pm
It has become a "thing". The Net/Ops groups for a lot of companies are responsible for all of that.
And, no... I'm not saying that's a good thing. 🙁
I know...
December 17, 2024 at 10:13 am
I've been using MSSQLOLEDB since at least VS 2016, so no, that's isn't the problem. Plus VS 2022 is 64 bit. If MSSQLOLEDB isn't working, I would suggest you haven't...
December 12, 2024 at 3:19 pm
Both SQLNCLI11 and SQLOLEDB are deprecated/discontinued. Have you tried using a modern driver like MSSQLOLEDB?
December 12, 2024 at 2:08 pm
You can also make use of Project/Package Parameters and link their values to the configuration you are working in within VS. Coincidentally, I wrote something for Phil on this...
November 20, 2024 at 2:49 pm
Deploying to your production environment is no different to your development one; you can do this from your project in Visual Studio. Why do you feel it would be different?
November 18, 2024 at 2:11 pm
(Somehow, I posted this in the Fantasy Football topic...)
I think that shows you how burned out you still are. 😉
I read a couple of Steve's posts about it last...
November 12, 2024 at 2:59 pm
Viewing 15 posts - 1 through 15 (of 5,111 total)