A friend reading on his phone wanted one file instead of 100s of scripts. I combined multiple .SQL files into one single file from the command prompt.
EXCEL / SQL SERVER – Extract the Domain from an Email Address
I took the long route to extract the domain from an email address in Excel by going through SQL Server. This is the simple Excel formula I should have used.
SQL SERVER – Finding Max Value From Multiple Values
How do you find the max value from multiple values or variables without IF or CASE? A short trick with VALUES and MAX works in SQL Server 2008 and later.
SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050
Tim Radney asks if you know your data’s classification, and explains why data professionals must know what data they hold and how sensitive it is.
SQL SERVER – Beginning Reading Transaction Log File
What is the SQL Server transaction log, why do we need it and how does it work? A beginner’s first step toward reading transaction log file content.
Getting the Most From a Conference
Get the most from a conference by planning sessions, meeting people with useful questions, and turning notes into tested action.
SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause
What is the difference between an INNER JOIN and WHERE clause join? Very little in results or speed, but I explain why I still prefer INNER JOIN.