Everything about Data By SQLAuthority on Flipboard

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

SQL SERVER – Storing Data in Hindi, Chinese, Gujarati and Tamil (or any other) Language in the Same Table

Long time ago, I have written a blog which talks about multi language support available with SQL Server.SQL SERVER – 2005 – Multiple Language …

Databases

SQL SERVER – List the Name of the Months Between Date Ranges – Correction

Earlier I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How …

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 …

Databases

SQL SERVER – Beginning with SQL Server Security Aspects

SQL Server Security AspectsThis article is the high-level overview of the SQL Server security best practices and aspects. Ensuring SQL Server …

Security

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 …

Databases

SQL SERVER – Curious Case of Disappearing Rows – ON UPDATE CASCADE and ON DELETE CASCADE – T-SQL Example – Part 2 of 2

Yesterday I wrote a real world story of how a friend who thought they have an issue with intrusion or virus whereas the issue was really in the code. …

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 …

Databases

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 …

Databases

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 …

Microsoft Excel

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 …

Databases

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.How

Databases

SQL SERVER – Search Records with Single Quotes – Part 2

Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER – Search Records with Single Quotes. Here …

Databases

SQL SERVER – Search Records with Single Quotes – SQL in Sixty Seconds #075

Earlier I wrote two blog posts about Search Records with Single Quotes in two parts. Refer the blog posts over here.• Search Records with Single …

Databases

SQL SERVER – Learn SQL Server 2014 Online in a Day – My Latest Pluralsight Course

Click here watch SQL Server 2014 Administration New Features. SQL Server 2014 was released earlier this year and it has been extremely popular in …

Databases

SQL SERVER – SSMS: Server Dashboard Report

The term dashboards come from the automobile world where it meant as instrumentation or controls for operating a vehicle. In the IT parlance, the use …

Databases

SQL SERVER – Automate Database Operations for Success – Notes from the Field #035

[Note from Pinal]: This is a 35th episode of Notes from the Field series. Doing this faster and easier is always our goal. We all want to do thin …

Databases

SQL SERVER – Introduction to SQL Server Management Studio Reports

I get a ton of questions over mail and one of the most theme is always around Performance tuning and troubleshooting. To add to this confusion, even …

Databases

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 …

Activity Monitor

MySQL – Add a Column at Particular Ordinal Position in Table

Sometimes you may need to add a column at a particular ordinal position in the table. In SQL Server there is no option to do it via SQL although you …

MySQL

Developer’s Life – Every Developer is a Iron Man

Iron Man is another superhero who is not naturally “super,” but relies on his brain (and money) to turn him into a fighting machine. While …

Iron Man

SQL SERVER – Find Blocking Using Blocked Process Threshold

In my previous blog I was talking about my friend Jim who was on a consulting assignment and was asking me for some help around blocking. Though the …

Databases

SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio

Recently, while working on a demo about backup, I realized that in management studio, now there is a new option in the backup screen called a URL. …

Databases

SQL SERVER – In-Memory Databases and Caching Wars

The In-Memory Database and In-Memory Caching market is heating up and we (the users) are the real winners. Exciting!!!• SAP, the giant application …

Databases

SQL SERVER – SSIS Component Error Outputs – Notes from the Field #034

[Notes from Pinal]: Error confuses people and stops the operations. Developer search more on error online rather than best practices. Lots of people …

Databases

SQL Server 2012 Service Pack 2 is Available

Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all …

Sql Server

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available …

Databases

SQL SERVER – How to Get SQL Server Restart Notification?

Few days back my friend called me to know if there is any tool which can be used to get restart notification about SQL in their environment. I told …

Databases

Developer’s Life – Every Developer is a Chhota Bheem

Chhota Bheem is a cartoon character that is extremely popular where I live. He is my daughter’s favorite characters. I like to say that children love …

SQL

MySQL – Video Course – MySQL Backup and Recovery Fundamentals

Data is the one of the most crucial things for any organization and keeping data safe is the biggest challenge for any DBA. This is true for any …

MySQL