All Articles - SQL Authority with Pinal Dave

SQL SERVER – Script: Current IO Related Waits on SQL Server

May 9, 2015

Playing around with DMVs is so much fun. Many a times we need little inspiration and a problem in hand to solve. Out of many things I monitor, I have personally seen folks having trouble in finding what is going wrong when the server turns slow. In a recent conversation…

SQL SERVER – Backup Failure – Error: 3203, Severity: 16, State: 1

May 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

In the recent past, I have been writing about different error messages on SQL Server that one encounters. Thanks to my blog readers who have been sharing a lot of errors with me either by email or by blog comments and asking for solution. If I find something interesting and…

SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079

May 7, 2015

Pinal Dave

SQL

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: I know quite a lot of things about SSIS but every single time when I read notes from the field, I realize that there are so many small but very important features exist. A similar concept has been Using Package Configurations in SSIS 2012 and Beyond. Packages are the most critical part of the SSIS and configuring it correctly is extremely important.

SQL Server – Knowing the Use of Deprecated or Discontinued Features

May 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Deprecated Feature

Upgrading your SQL Server environment is inevitable and I know most many are doing this given SQL Server 2005 support will end first half next year. Whenever I get in front of customers, I have questions always coming my way around upgrades. In a recent session, I had one of…

SQL SERVER – Generating Row Number Without Ordering Any Columns

May 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order.

SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger

May 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is an interesting comment from one of my previous blogs on how to change the compatibility level of SQL server post posted earlier. Some of these comments are interesting and can provide some interesting extension to blog ideas like this. So the comment was: Under what circumstances would SQL…

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

May 3, 2015

Pinal Dave

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

SQL Function, SQL Scripts

If you ask me – there are certain questions not appropriate for an interview as they are often very subjective. There are some questions, which really do not help to identify if the candidate has the necessary skills or not. Here is one such question, if you ask me in the…

SQLAuthority News – Presented 3 Technical Session at Great Indian Developer Summit 2015

May 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

GIDS

Great Indian Developer Summit is my favorite technology event and I have been extremely happy to present technology sessions here for over 5 years. Just like every year, this year, I presented three technology session on SQL Server 2014. This time the event was at two locations. First one is Bangalore and the…

SQL AZURE – How to Disable and Enable All Constraint for Table and Database

May 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

Recently I wrote blog to enable and disable all constraints in the database SQL SERVER – How to Disable and Enable All Constraint for Table and Database. One of my reader told me that this trick of sp_msforeachtable doesn’t work in Azure SQL Database (WASD). It is interesting that a lot…

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

April 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, Snapshot, SQL Backup and Restore, SQL Scripts

[Note from Pinal]: This is a 78th episode of Notes from the Fields series. What do you do when data is deleted accidentally or you are facing disaster? Well, there are plenty of the things, you can do, but when in panic quite often people make mistakes which just intensify the disaster. Database snapshot…