Tag Archives: security

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

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

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

Classifying Data with SSMS 17.5

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition. This is a quick look at this … Continue reading

Posted in Blog | Tagged , , , | 4 Comments

Enabling Guest in a Database–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The guest account exists in all your databases. This is installed by default, and guest is used to map … Continue reading

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

We Do Need To Upgrade

I advocate that we should get a long life from our database platforms. In fact, I like to think about a 7-10 year lifetime for many of my database instances. That means I’ll get beyond the 5 year lifetime that … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Are You Patched?

It’s been a few weeks since the Spectre/Meltdown bugs were announced for most CPUs. Microsoft has been working hard to build patches, and they’ve provided fixes for Windows and SQL Server. Other manufacturers have released fixes for other platforms, though … Continue reading

Posted in Editorial | Tagged , | 1 Comment

The GDPR Sky is Falling

David Poole wrote a nice summary of the GDPR regulations that come into force this spring in Europe. He covers a number of the sections, trying to provide a simple explanation of the potential issues from the perspective of a data … Continue reading

Posted in Editorial | Tagged , , ,