SQL Archives - Page 108 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Basic architecture of Transaction Logs

September 28, 2015

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…

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

September 27, 2015

Pinal Dave

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

SQL Joins

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…

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

September 26, 2015

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…

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

September 25, 2015

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…

SQL SERVER – Finding If Date is LastDay of the Month

September 24, 2015

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…

SQL SERVER – Scope of ERROR_MESSAGE

September 23, 2015

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…

SQL SERVER – Security Considerations for Contained Databases

September 22, 2015

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: