A Joes 2 Pros tip on finding apostrophes in string and text: how to search for a single quote with LIKE when a quote also ends the string.
SQL SERVER – Tips from the SQL Development Series – Wildcard – Querying Special Characters – Day 2 of 35
Tips for Querying Special Characters with wildcards, since some symbols are tricky to pattern match. Examples use the [Grant] table in the JProCo database.
Loading Data From an API Into SQL Server
Loading data from an API into SQL Server takes paging, JSON staging, retries, and durable checkpoints so a failed request can resume safely.
SQL SERVER – Interview Questions and Answers – Guest Post by Rick Morelan – Day 27 of 31
A guest post by Rick Morelan, author of the Joes 2 Pros series, on the few interview questions that come up again and again and separate good answers from great.
SQL SERVER – Azure Interview Questions and Answers – Guest Post by Paras Doshi – Day 25 of 31
Azure interview questions and answers in a guest post by SQL Azure expert Paras Doshi, starting with what SQL Azure is and what cloud computing means.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 – CTE- Joins
Day 16 of my interview questions and answers series covers CTE and joins, starting with why a CTE makes complex queries easier to read and maintain.
Interview Questions and Answers – FAQ Day 14 of 31
FAQ Day 14 of my interview series starts with the basic functions of the master, msdb, model, tempdb and resource databases in SQL Server 2008.