Tags » SQL Authority

SQL SERVER - The Why of BIML - Notes from the Field #051

: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it.  1,161 more words

SQL Authority

SQL SERVER - Search Records with Single Quotes

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. 62 more words

SQL Authority

SQL SERVER - Combined Multiple .SQL files into One Single File

Here is an interesting problem which I enjoyed solving yesterday.

There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. 211 more words

SQL Authority

EXCEL / SQL SERVER - Extract the Domain from an Email Address

Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address. 137 more words

SQL Authority

SQL SERVER - Finding Max Value From Multiple Values

Here is a question which I have received a few days ago.

“I have three different variables, I want to find out which one of them has the maximum or highest value. 169 more words

SQL Authority