Search this blog
2026 Redgate Summit – New York City

-

18 Year MVP Awardee

Tags
- administration
- AI
- AIExperiments
- auditing
- Azure
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- encryption
- Flyway
- Friday Poll
- FWTips
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- Microsoft
- misc
- monitoring
- networking
- PASS
- Performance
- powershell
- presentations
- Redgate
- Redgate Monitor
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- tools
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- words
- work
Search this blog
Steve’s Tweets
Tweets by way0utwestOlder Posts
Meta
Tag Archives: security
The Opportunistic Hacker
You’re sitting in Starbucks, working. You need to use the restroom and you ask the hip, cool looking person sitting coding next to you, with whom you’ve chatted with for the last hour about C# and SQL, to watch your … Continue reading
Source Code Security
I’m not surprised, and I had expected to read about something like this much sooner. Apparently someone at the ride sharing company, Uber, posted a security key online in a GitHub distribution. I assume this was some sort of code repository … Continue reading
Posted in Editorial
Tagged encryption, security, software development
Comments Off on Source Code Security
ALTER SCHEMA TO ADD PERMISSIONS
I’m sure some of you have wanted to do this: ALTER SCHEMA Steve AUTHORIZATION Steve You realize this doesn’t work, and you can’t grant the user Steve, rights to his schema after it’s created. You can do this: CREATE SCHEMA … Continue reading
Posted in Blog
Tagged security, sql server, syndicated, T-SQL
Comments Off on ALTER SCHEMA TO ADD PERMISSIONS
Allowing a User to Create Objects in a Schema
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues. I want to give a developer rights to create … Continue reading