Blog Home Page - Page 343 of 829 - SQL Authority with Pinal Dave

Sep28

Readers bump into this blog because it tries to simplify some of the most complex topics into a digestible format. I am a strong believer of this and try to bring some of these topics from time-to-time. Even I find some of these topics confusing, if I can understand them…

Sep27

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Joins

No Comments

It is very common of interviewers to ask questions which are a bit off and sometimes not used in daily life. Here is such question I heard the other dya. Question: What is Left Semi Join Showplan Operator? Answer: There are few interesting kinds of joint operations exists when execution…

Sep26

SQL SERVER – How to Restore Corrupted Model Database from Backup?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Another email from one of my blog reader, which made me think about the incorrect information which is available on the internet. Hi Pinal, I have corruption in model database and due to that SQL Service is not able to start. Here are the messages in SQL ERRORLOG 2015-09-23 21:45:07.00…

Sep25

SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I always try to keep myself up-to-date with latest release of SQL Server. As a part of that I wanted to upgrade my SQL Server 2016 CTP2.2 to CTP2.3 version. While doing in-place upgrade I was blocked with few error and I was not able to proceed. Here is the…

Sep24

SQL SERVER – Finding If Date is LastDay of the Month

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

As I said many times before SQL Server does not stop amazing me continuously. It does not matter how many questions and issues I have come across so far there are always new things to learn. Here is the question which I was asked – How do we know if…

Sep23

SQL SERVER – Scope of ERROR_MESSAGE

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

SQL Server supports Error handling efficiency. You can do this with the help of TRY and CATCH blocks. If there is an error you can get the exact error message using the system function ERROR_MESSAGE(). I will demonstrate it using the following code BEGIN TRY SELECT 1+'SQL' AS RESULT END…

Sep22

SQL SERVER – Security Considerations for Contained Databases

Pinal Dave

SQL

SQL Server, SQL Server Security

I have written a number of blogs around contained databases in the past which you can search. In today’s blog we will talk about security considerations when working with contained databases. With contained authentication, the database can contain authentication information for the database users. This makes it considerably easier to move databases between servers. Some of the other blogs for reference are:

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Basic architecture of Transaction Logs

Interview Question of the Week #038 – What is Left Semi Join Showplan Operator?

SQL SERVER – How to Restore Corrupted Model Database from Backup?

SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”

SQL SERVER – Finding If Date is LastDay of the Month

SQL SERVER – Scope of ERROR_MESSAGE

SQL SERVER – Security Considerations for Contained Databases

SQLAuthority News – Reset Messaging (SMS/Text) Icon Count in Android Jelly Bean

SQL SERVER – Fix Error: 8111 – Cannot define PRIMARY KEY constraint on nullable column in table – Error: 1750 – Could not create constraint. See previous errors

SQL SERVER – Fix: Error: 1505 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name and the index name

SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video

SQLAuthority News – Delhi Women Safety – 2400th Blog Post – A Milestone

SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

SQL SERVER – Weekly Series – Memory Lane – #015