Everything about Data By SQLAuthority

By Pinal Dave | All technology news from the world of data, SQL Server, MySQL, NoSQL, Big Data and everything data.

Databases
Databases

SQL SERVER - How to Learn SQL Server 2014 - Video Tutorial

As December begins the realization is that Year 2014 is about to come to an end. The month of November was a travel month for me. I have travelled to …

SQL SERVER - Beginning with SQL Server Security Aspects

<b>SQL Server Security Aspects</b><p>This article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server …

SQL SERVER - Puzzle - ISNUMERIC and Unexpected Results - SQL in Sixty Seconds #076

It has been a long time since I have asked, puzzled on this blog so let us have fun time together with ISNUMERIC function. If you get the correct …

SQL SERVER - Do You Know Your Data’s Classification? - Notes from the Field #050

[Notes from Pinal]: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that …

SQL SERVER - Finding Max Value From Multiple Values

Here is a question which I have received a few days ago.<p><i>“I have three different variables, I want to find out which one of them has the maximum or</i> …

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 …

SQL SERVER - Activity Monitor to Identify Blocking - Find Expensive Queries

Recently when I was busy working on my next course for Pluralsight, one of my friend pinged me for some help over messenger. And the conversation …