Viewing 15 posts - 541 through 555 (of 6,041 total)
Of course, most of us already code assertions (more or less) into our T-SQL, and this type of defensive coding may constitute half of the lines of code written for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 26, 2019 at 2:21 pm
I believe the T-SQL language could benefit from assertions, perhaps declared using an new ASSERT clause. For example, the following query would abort with an error when the actual rowcount...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 25, 2019 at 5:58 pm
Personally identifying data should be protected and regulated like hazardous material. Even with the owner's consent, there should be guidelines regarding how the data is stored and used. For example,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 23, 2019 at 3:05 pm
While we're on the topic of digital data posted on the web getting used out of it's original context, one major issue is meta-data embedded in the files. For example,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 23, 2019 at 2:53 pm
Of the big 5 data companies (Google, Amazon, Apple, FaceBook, Microsoft), Microsoft is the one I would expect to get HealthVault right, at least on the technical and security side...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2019 at 5:06 pm
I believe that having my health records stored in an online vault that can be accessed by my physicians or myself is very useful. However, all the apps, bots, and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2019 at 1:28 pm
I've been playing around with some free alternatives, not interesting in any of the online only type of tools. Apex has a free data modeling tool you may want...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 19, 2019 at 5:49 pm
I wonder if Jeff Bezos has Alexa turned on in his home, or if Lary Page uses Google Nest for home monitoring. I suspect they probably don't, or maybe they...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 18, 2019 at 3:30 pm
Step 1, notify the DBA, and explain in detail how you as a developer were able to drop a production database in the first place, so the DBA can revoke...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 18, 2019 at 1:28 pm
If this is how landlords want to be, then when checking into a rental, I'm temporarily pulling the plug on the internet router, except maybe for the couple of hours...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 18, 2019 at 1:21 pm
I'm surprised that Microsoft hasn't invested in the development or acquisition of a good basic ERD tool over the years. It wouldn't need to be anywhere near as robust as...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 18, 2019 at 1:11 pm
It is frustrating that the diagramming tool built into SSMS hasn't evolved in any significant way since 2005.
One thing you can do is print to diagrams to PDF documents or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 17, 2019 at 5:20 pm
There have been so many new database engines introduced over the past decade, I don't see the need for a new one. When building out an enterprise scope solution, the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 17, 2019 at 3:21 pm
About all I've seen in the past is where date/time columns are updated with the database server's GETDATE(), and the local time on the server is set to corporate headquarter...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 17, 2019 at 1:44 pm
Years ago, you could google "filetype:config +uid +password" and get links to 100s of config files located on ftp or even live web servers where the admin didn't properly setup...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 17, 2019 at 1:27 pm
Viewing 15 posts - 541 through 555 (of 6,041 total)