How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
Developer – 10 Phrases Developer Use Too Often
I am a developer and so are most of my friends. Here are 10 phrases every developer says too often, from ‘I can fix that’ to ‘That’s not my code’.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.
SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
How did Notes from the Field start? Here is the story behind the series and a roundup of the 2013 episodes on performance tuning and database health.
SQL Server Performance Stack: Look Beyond the Query
Tuned every query and SQL Server is still slow? David Klee looks at the SQL Server performance stack, from storage and virtualization to the network. He also explains why a baseline matters.
Investigating a Past Slowdown With the system_health Session
Nobody was tracing when it got slow. The system_health session was. Here is how to read what it kept before the files roll over.
SQL SERVER – Learning More About SQL Wait Stats
Are SQL Wait Stats still relevant for performance tuning? Absolutely. Here is what I told a customer in Delhi and where to start learning about them.