Tag Archives: security

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

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

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

Still in Ireland: The Opportunistic Hacker.

Posted in Editorial | Tagged | Leave a comment

Getting All Users

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 , | Leave a comment

Taking Shortcuts

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 , , | Leave a comment

Good Security Needs Layers

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 | Leave a comment

If only the US would follow …

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

Is Security Catching On?

This is a good sign, as a poll shows people want security over convenience, especially younger people. Surprisingly this is also true for older people, who likely don’t trust much of our new technology. This is the first time that a … Continue reading

Posted in Editorial | Tagged

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4 It seems that the Microsoft tools team is trying to build us better tools that come with the platform. There are … Continue reading

Posted in Blog | Tagged , ,

Republish: Elevation of Privileges

It’s another day in the office in the UK and I’m republishing Elevation of Privileges while  I’m stuck in meetings all day.

Posted in Editorial | Tagged