Viewing 15 posts - 496 through 510 (of 6,032 total)
A better term for "NoSQL" databases would be "ACID-ish" databases.
June 12, 2019 at 1:16 pm
Here is one possibility. Back when we were upgrading servers from 2008 to 2014/2016, we encountered the issue described in the blog post below. Confirm that a SKU licensing misstep...
June 10, 2019 at 2:37 pm
Today, the modern IT professional has to be more "cosmopolitan" in regards to knowledge and expertise. It's not like the old days where someone could spend a decade embedded in...
June 6, 2019 at 2:46 pm
Another example of bad commenting in code are when the comments contain actual blocks of commented code with no explanation. Like, if someone tweaks a 100 line SELECT statement, there...
June 5, 2019 at 1:12 pm
But, thanks to advancements in automation and the expanding pace of the IT ecosystem, we're all basically becoming a Jack Of All Scripts and Master Of None.
May 31, 2019 at 5:20 pm
While I don't see biometrics as a complete identification solution or a replacement for passwords in all situations, I still think it could be a component of a more complete...
May 30, 2019 at 1:51 pm
"..Is it a big deal? I don’t know. Windows Server 2019 lists with Datacenter at $6155 and Standard at $972. That means it will cost me $5,183 for Always Encrypted on...
May 30, 2019 at 1:33 pm
A biometric ID is basically a "secret" hash, just like a password. Hackers can leverage network sniffing, spoofed login page, or some other man in the middle exploit to collect...
May 29, 2019 at 7:01 pm
I see you have posted the original resultset, however, so we know for sure what the goal is, please post a sample of what the resultset should look like after...
May 28, 2019 at 6:18 pm
My answer depends on the situation. If I'm at the bank applying for a car loan or enrolling my kids in school, and I'm asked about my occupation, then I'll...
May 24, 2019 at 1:42 pm
The fact that the documents are contained inside a database column is actually working against you. If the documents were contained in a folder, then several options would be available...
May 23, 2019 at 1:23 pm
In the early stage of developing on a new project, when I'm learning and creating, I don't mind working late and putting in more hours. In fact, I get a...
May 23, 2019 at 1:04 pm
"..The problem is that at some point a state based deployment process won't work. It's actually impossible for a state based approach to work in all situations. Simple actions, like...
May 21, 2019 at 1:56 pm
To reduce file size, MS Word documents are compressed using PKZIP format (a form of LZ compression). You can leverage BCP to export contents of a VARBINARY column to a...
May 20, 2019 at 3:04 pm
Who else here will be at SQL Saturday in Atlanta tomorrow?
May 17, 2019 at 6:52 pm
Viewing 15 posts - 496 through 510 (of 6,032 total)