Tag Archives: security

Spread the Word about Basic Security

I went with my daughter the other day to set up her bank account. She’s becoming a young adult and this is one of those items we need to get done, especially in today’s world of electronic banking and money … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Replication Silliness

I wrote an editorial asking about things that needed to be done to improve replication. There are plenty of things that need help, but as I was testing some replication, I got this the other day. I am trying to … Continue reading

Posted in Blog | Tagged , | Leave a comment

Classifying Sensitive Data

Our databases store all kinds of data in them, depending on the purpose of your database. Most of us create tables and store data in response to some requirement or necessity in our organizations. Our decisions should be driven by … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Move a Stored Procedure to a New Schema–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Securing the Things

I would venture to guess that a lot of the data that will be produced in the next few years will come from various “things” that are implemented by companies, users, and governments. We tend to refer to the Internet … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Software Has Bugs

Every once in awhile I have someone I meet complaining about software quality, usually with regards to some piece of Microsoft software. I’ll invariably hear how there shouldn’t be bugs in SQL Server or Windows, and Microsoft isn’t testing their … Continue reading

Posted in Editorial | Tagged , | Leave a comment

The Poor State of Secure Coding

Security is becoming a bigger issue all the time. More companies are getting hacked and losing control of data. It seems every week there’s a new disclosure from some firm. Recently OneLogin had a breach, which is very disturbing as … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Consider the Downside

Technologists are often seen as cynical and disappointed by how poorly much code is written or maybe because an application architecture isn’t well designed. I hear no shortage of complaints over other people’s code, one of the reasons I think … Continue reading

Posted in Editorial | Tagged | Leave a comment

Audio Attacks

There are running jokes about how Amazon Alexa and Google Home are susceptible to visitors in your home. It’s become a bit of test from some geeks who will walk in your house and call “Hey, Alexa” out loud to … Continue reading

Posted in Editorial | Tagged | Leave a comment

Security and Patching Struggles

A couple weeks ago we had a huge security issue with the WannaCry ransomware racing across the world. I was out of the office, and mostly offline, so I was a bit out of touch. However, many organizations were affected, … Continue reading

Posted in Editorial | Tagged , , | Leave a comment