All Articles - SQL Authority with Pinal Dave

July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage

April 22, 2007

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Utility

The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day as first day of the week using…

All Articles errorcircle-600x400

SQL SERVER – Fix : Error 1418 – Microsoft SQL Server – The server network address can not be reached

April 22, 2007

Computer Network, SQL Error Messages, SQL Server, SQL Server Security, SQL Utility

Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command
The server network endpoint did not respond because the specified server network address cannot be reached or does not exist.

All Articles interview-600x341

SQL Server Interview Questions and Answers Complete List Download

April 21, 2007

SQL Interview Questions and Answers

Best Practices, Database, SQL Scripts, SQL Server

This is summary blog post for SQL Server Interview Questions and Answers. Click here to get free chapters (PDF) in the mailbox.

All Articles interview-600x341

SQL Server Interview Questions and Answers – Part 6

April 20, 2007

SQL Interview Questions and Answers

Database, SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 5

April 19, 2007

SQL Interview Questions and Answers

Database, SQL Cursor, SQL Download, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 4

April 18, 2007

SQL Interview Questions and Answers

DBA, SQL Download, SQL Function, SQL Joins, SQL Scripts, SQL Server, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 3

April 17, 2007

SQL Interview Questions and Answers

Database, Software Development, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Sub Query, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 2

April 16, 2007

SQL Interview Questions and Answers

Database, Software Development, SQL Collation, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Server DBCC, SQL Server Security, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Part 1

April 15, 2007

SQL Interview Questions and Answers

Software Development, SQL Cursor, SQL Download, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.

SQL Server Interview Questions and Answers – Introduction

April 15, 2007

SQL Interview Questions and Answers

Database, DBA, SQL Download, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server, SQL Server Security, SQL Stored Procedure, SQL Trigger

Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.