All Articles - SQL Authority with Pinal Dave

SQL SERVER – Evaluation Period Has Expired – How to Activate SQL Server?

June 22, 2015

Sometimes we are in a hurry that we forget activities that are pending. A typical example would be like walking into a room and we keep thinking about why we were there in the first place. Isn’t that common? Or I think age is catching on me for sure. Some…

Interview Question of the Week #025 – How to Implement Paging in SQL Server?

June 21, 2015

Pinal Dave

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

SQL Scripts

Here is a very popular question when SQL Server interview consists of live coding example. Question: How to implement paging in SQL Server? Explain with the help of script. Answer: Here is the script to implemented paging in SQL Server 2005. USE AdventureWorks GO DECLARE @StartRow INT DECLARE @EndRow INT…

SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server

June 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts

I have been getting my hands dirty working with PowerShell commands for a fun learning experience and few have made to this blog. The after effect of this is that I have been pinged for few queries on them too. Recently I got a call from one of my friend…

SQL SERVER – Database Snapshots and Replica Causing Write Delays

June 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Snapshot, SQL Backup and Restore

For folks who have not worked with SQL Server Database snapshot feature, please refer to the blog I wrote sometime back (SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot). I am giving this reference because some might not be aware of this powerful capability with…

SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085

June 18, 2015

Pinal Dave

SQL

C Sharp, Notes from the Field, SQL Function, SQL Scripts, SQL Server

This is an 85th episode of Notes from the Field series. SSMS is my favorite IDE. I work with many different databases and different IDE. However, I get extreme comfort when I am working with SSMS. Though I like SSMS does not mean it is the best tool and it can accomplish all the tasks when I want it to do. Here is one of the task – converting file results to comma delimited result. However, my friend Kevin came in the rescue. He helped me out in this situation.

SQL SERVER – Stress free life with Spotlight for SQL Server DBA

June 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Dell, SQL Backup and Restore

Being on the cutting edge of technology is something that we need to be prepared as IT professionals. Newer capabilities get into the software almost every single day and it is difficult to keep track of what is getting added into the software’s we work with. I am a firm…

SQL SERVER – SPARSE Property Doesn’t Carry Forward Using SELECT INTO

June 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

During one of the recent posts on a SQLBangalore UG FB page, one of the members asked an interestingly simple question. He was asking why is it that when you use SELECT-INTO to create a new table the triggers are not getting carried forward as part of the definition. A…

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…

Interview Question of the Week #024 – What is the Best Recovery Model?

June 14, 2015

Pinal Dave

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

SQL Backup and Restore

Here is one of the most popular questions I often see people asking on the internet. Question: What is the best recovery model for my database? Answer: Every situation is different and each situation has different needs for the recovery model. SQL Server offers three recovery models: full recovery, simple recovery and…

SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG

June 13, 2015

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, SQL Server Security

Errors related to logins are one of the most searched in this blog. Many of the blogs that talk about these errors are the ones that get viewed often too. This is one of the interesting errors, which you might see in your environments. One of my blog reader contacted me and told that their event log and ERRORLOG is full of below the messages: