Data Privacy Summit
SQL in the City 2018
Search this blog
Steve’s tweets
- RT @TheSQLGuru: Does anyone know a Sybase guru, preferably one familiar with their replication subsystem? I have a client looking for some… 5 hours ago
- @abjbradford Congrats 5 hours ago
- RT @SQLGrillen: Just confirmed food, drinks, venue, hotels and flights of speakers...... now all we need is people. Please remember, if yo… 10 hours ago
Tags
- administration
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- bloopers
- business
- Business Intelligence
- career
- career
- cell phone
- Cloud Computing
- computers
- conferences
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- hardware
- high availability
- Humor
- life
- Linux
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- SQLServer
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- TopTenSkills
- travel
- tsqlt
- vacation
- version control
- virtualization
- windows
- work
Tag Archives: security
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
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
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
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
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
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
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.
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
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 security, SQLNewBlogger, syndicated, T-SQL
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 Database Weekly, security, upgrades
