SQL

• The curious case of trailing spaces in SQL
• Sample query to demonstrate influence of collation in Sql Server
• An example of Common Table Expression and Window function usage...
• Use SQL Server Profiler to see if a connection is pooled
• Building a Nums table (quickly)
• Invoke parameterized stored procedure with PowerShell
• Techniques learned in SQLtopia: Look Ma, no loops!
• Exploring window functions
• Deploying a Database Project does not create artefacts for custom schemas
• T-SQL: Remove all rows from all tables in your schema
• Update from localtime to UTC or any other timezone with Oracle
• Simulate AutoIncrement
• Using a collection as parameter for a stored procedure
• Searching made easy
• tweaking Oracle SQL Developer
• Experimenting with Oracle and PL/SQL
• Select best 3 laptimes for each player
• Multiple joins explained
• Select the first 50 words of an article
• Custom ordering with MySQL
• Custom ordering