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.

Interview Question of the Week #015 - How to Move TempDB to Different Drive

Here is one of the most popular questions I often come across-<p><b>Question</b> – How to move the TempDB to different drive when the log files are</b> …

Databases

SQL SERVER – Is XP_CMDSHELL Enabled on the Server?

I am not a big fan of using command line utilities in general. But from time to time I do explore and play around with command line tools that make …

SQL Servers

SQL SERVER – Script – Removing Multiple Databases from Log Shipping

Have you ever come across a situation where you have large number of databases in log shipping and you have to remove all of them? If you use SQL …

Databases

SQL SERVER – Finding What Policies Are Enabled on Our Databases

When I wrote about Policy Management last week (SQL SERVER – Introduction to Policy Management), lesser did I know I will get queries from blog …

Databases

SQL SERVER – Walking the Table Hierarchy in Microsoft SQL Server Database – Notes from the Field #076

[Note from Pinal]: This is a 76th episode of <b>Notes from the Field</b> series. Hierarchy is one of the most important concepts in SQL Server but there are …

Databases

SQLAuthority News – Presenting 3 Technology Session at GIDS 2015

Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. …

SQL Servers

SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server

How many times you had a problem where you have deployed a high availability solution, but the application is not able to use database and getting …

SQL Servers

Interview Question of the Week #016 – How to Take Database Offline

Here is the question, I received in the recent conference where I was presenting on Database Technology.<b>Question:</b> What does it mean by Taking …

Databases

SQL SERVER – How to View the Dirty Pages In Memory of a Database?

I always get an opportunity to talk on topics that are basic from time to time. As I was preparing for GIDS 2015 (Great Indian Developer Summit) this …

Databases

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 …

SQL Servers

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 …

SQL Servers

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 Servers

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 …

Comment on SQL SERVER – Puzzle – ISNUMERIC and Unexpected Results – SQL in Sixty Seconds #076 by Thirmal Sangisetti

–Here you used space that ASCII Value IS 32 So it’s giving “0”SELECT ISNUMERIC(‘ ‘) —This is SPACESELECT ‘THIRMAL’+CHAR(32)+’SANGISETTI’ –This is …

SQL Servers

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

Databases

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 Servers

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> …

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

Comment on SQL SERVER – Combined Multiple .SQL files into One Single File by Jurandir Balestero

Hi Pinel, do you know how combine when the script have accentuation, my DB has portuguese language, I use type, but don´t usefull.

SQL Servers

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.<p><i>How</i> …

SQL Servers

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 …

SQL Servers

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.<p>Though I had clarified that all …

Databases

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

SQL Server 2014 was released earlier this year and it has been extremely popular in Microsoft world. Here is the announcement for everyone, who have …

SQL Servers

Comment on SQL SERVER – SSMS: Server Dashboard Report by SQL SERVER - SSMS: Performance Dashboard Reports - Home Page details - Journey to SQL Authority with Pinal Dave

[…] we discussed in detail what the SSMS: Server Dashboard Report looks like when working with SQL Server Management Studio standard reports. These …

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

In the Linchpin People mindset, it’s not about how busy you are, but how valuable you are. You don’t increase your value to your organization by your</i> …

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 …

SQL Servers

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 …

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