The Current Book
Search this blog
Steve’s tweets
- Day 28, Sabbatical Part Deux voiceofthedba.com/2020/02/19/day… 15 hours ago
- @spaghettidba On the list for Mrs way0utwest and I. Venice is near the top of our global desires 19 hours ago
- @spaghettidba I want to go to Italy 19 hours 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
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- 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 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
- 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
