Tag Archives: security

Granting CONTROL on a database–#SQLNewBlogger

Posted on August 9, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wanted to grant a login the CONTROL permission on a database. This wasn’t a simple as I expected. … Continue reading →

Posted in Blog | Tagged , | 2 Comments

The Combinations of Software

Posted on July 19, 2018 by

Security issues seem to be appearing more frequently, not less. I’d expect that we would be getting better at writing software, and I think many of us are. The problem is that more and more people are writing software and … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Storage that Expires

Posted on July 18, 2018 by

Whether you like the idea of the GDPR (and the new California law), I’m sure you agree that these laws will likely change our data handling in business. Even if they are weakened through legal challenges, many companies have already started to comply … Continue reading →

Posted in Editorial | Tagged , , | 1 Comment

Code I Can’t Live Without–T-SQL Tuesday #104

Posted on July 10, 2018 by

Bert Wagner has a good invitation this month, a T-SQL Tuesday question about code, specifically code you can’t live without. I’ve got my thoughts below. This is a monthly blog party, and you can participate. Write a post on this … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Setting Up Pi-Hole.Net

Posted on July 6, 2018 by

I saw a tweet a short time ago from Drew Furgiuele about pi-hole.net. He noted this was a near use of a Raspberry Pi, and I wanted to give it a try. I got one awhile ago, and used it … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Republish: The Opportunistic Hacker

Posted on May 26, 2018 by

Still in Ireland: The Opportunistic Hacker.

Posted in Editorial | Tagged | Leave a comment

Getting All Users

Posted on May 15, 2018 by

I saw someone that wanted to get all users from all databases on their instance. Seems like that ought to be simple, right? The user wanted to use sp_MSforeachdb to query users, but wanted a single result set for all … Continue reading →

Posted in Blog | Tagged ,

Taking Shortcuts

Posted on April 28, 2018 by

Many of us work in situations where we feel pressure to get work done at a pace that’s faster than we might like to move. In some sense, this is the nature of life, where customers and clients always want … Continue reading →

Posted in Editorial | Tagged , ,

Good Security Needs Layers

Posted on April 18, 2018 by

How many of you have wanted to know who started or stopped a SQL instance? Probably a few of you, as disruption to the service can affect customers. Most of us are concerned with the changes made inside SQL Server … Continue reading →

Posted in Editorial | Tagged

If only the US would follow …

Posted on March 19, 2018 by

I saw this blog from Allan Hirt and I wish the US would adopt something strong like this. I’d actually like this to apply to all organizations, but certainly critical services need to be secure. If you follow the link, you’ll see that … Continue reading →

Posted in Editorial | Tagged , | 1 Comment