Community Circle
Search this blog
Steve’s tweets
- @ChrisHyde325 @sqlstudent144 @lovee_charms I learned from Dive Into Python, but I like the idea of a game themed bo… twitter.com/i/web/status/1… 8 hours ago
- @sqlatspeed Sending lots of energy her way. Hope things go well 9 hours ago
- @HiltonHHonors Just FYI, links in your promotion today don't work, then I try to fill out a Contact US form and it… twitter.com/i/web/status/1… 10 hours ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Change Automation
- SQL Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Daily Archives: May 17, 2011
Checking Permissions
Someone posted this query recently: select a.*,name, b.* from sys.database_principals a, sys.database_permissions b where permission_name = ‘INSERT’ and b.grantee_principal_id = a.principal_id That’s a little ugly, so let’s fix it: SELECT a.name, a.principal_id, a.is_fixed_role , a.default_schema_name , b.permission_name, b.permission_name … Continue reading
Working Long or Working Hard
Seth Godin has some very interesting things to say and often makes me think with his short posts on the world. I saw him speak a few years ago, enjoyed it, and while I don’t always agree with the way … Continue reading