Community Circle
Search this blog
Steve’s tweets
- @bweissman @IrishSQL I think NULL 8 minutes ago
- Clients want you to see this: Keeping your Data Fresh in Power BI from @patrickdba at this year's @PASSDataSummit,… twitter.com/i/web/status/1… 32 minutes ago
- @DBAKevlar @jasonhorner @DoBoutAnything Do you use a single VM to monitor multiple Oracle databases? Or a 1:1? 58 minutes ago
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- 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
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- patching
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Clone
- SQL Compare
- 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 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
