The Current Book
Search this blog
Steve’s tweets
- @erikdarlingdata Friday night change of pace 48 minutes ago
- @erikdarlingdata long as I'm not downrange. More I'd like you to make a video of you making asparagus, or something else 59 minutes ago
- @MJSwart @bertwagner That made me smile. Thanks, I needed that 1 hour ago
Friends of Redgate
SQL in the City Summit
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career
- cell phone
- Cloud Computing
- computers
- containers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- Dev Connections
- 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 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
- virtualization
- webinar
- windows
- work
Daily Archives: May 23, 2011
Hints Are Not Always Better
I have always thought that an index seen was preferable to an index scan. It seems like the general rule that so many DBAs and developers follow, looking to convert every scan in an execution plan to a seek. Often … Continue reading
Collation Conflicts in a SQL Server Join
I went to run this query recently: select TOP 10 * from users a inner join Banned b on a.username = b.username and got this lovely message. I’d seen that message before, so I knew what was wrong. The collations … Continue reading
