Viewing 15 posts - 1,246 through 1,260 (of 59,061 total)
Nothing, anywhere, is perfectly secure. There are always vulnerabilities. We just don't always know what they are until it's far too late.
However, I still land where I always land...
July 24, 2023 at 1:53 pm
There are also hidden dangers to "Autonomy" and that is the danger of being "forgotten" or "pigeon-holed" or coming across as a bit arrogant. For example, if you answer the...
July 24, 2023 at 3:30 am
This is a beautifully written article and the order of revelation is spot on. Of course, I cannot be sure but it looks like something that AI would write (and,...
July 24, 2023 at 2:58 am
One of the things that people seem to forget it that it was almost 2023 by the time 2022 came out. It may have gone past the "plan the funding...
July 22, 2023 at 11:06 pm
Thank you so much, Jeff! I was looking for something like xp_DirTree. Will try it out. Thanks.
Although it's more than a decade old, good things don't need to change...
July 22, 2023 at 10:48 pm
Hi everyone,
I have a directory of many csv files such as
C:\Temp\NP-001.csv
C:\Temp\NP-002.csv
C:\Temp\NP-003.csv
In each csv file, there are 5 columns: Name, DOB, MemberID, Address, Email
We need to somehow loop through each...
July 21, 2023 at 7:24 pm
But it blows up when I try:
Select * From Query1 Where tmpResult1 = 'D'
That, good Sir, is what I'm talking about being the problem. That is...
July 21, 2023 at 7:13 pm
I still think it's screwy that SQL Server made a query plan that does column computations BEFORE removing rows according to conditions in the Where clause.
In calculated columns...
July 21, 2023 at 2:40 pm
I think you may have correctly identified the problem... Someone who is more knowledgeable about PoSh than I may have a bit of magic that I don't know about but...
July 21, 2023 at 12:36 am
If I'm reading all of this correctly, another issue with filtering the calculated columns of a view is that all of the rows must first be materialized and then the...
July 21, 2023 at 12:27 am
Here's the updated post that actually takes advantage of JSON. No need for TRIM() or STRING_SPLIT() functions because the source is in a proper JSON ARRAY format. Again,...
July 20, 2023 at 10:22 pm
All good reasons for why I have a serious dislike for XML, JSON, and a couple of other things when it comers to SQL.
Thanks for the info, Jeffrey. And, I'm...
July 19, 2023 at 9:19 pm
You may want to validate the return value from OPENJSON - I believe it returns an NVARCHAR and that could have a significant impact on performance.
Damn! Awesome catch, Jeffrey! ...
July 19, 2023 at 8:07 pm
@Ric,
Ok... so I'm only 14 years late in seeing this the first time. 😀
I've not needed to work with JSON up until now. It's gotten out of hand in our...
July 19, 2023 at 7:12 pm
posted code
Heh... you posted while I was writing the code. Thanks, Jonathan.
July 19, 2023 at 5:58 pm
Viewing 15 posts - 1,246 through 1,260 (of 59,061 total)