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

SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video

January 2, 2013

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Every developer has a different habit. Some like to format the functions in upper case and some wants it in lower case. I often see developers listing the columns in SELECT clause in a different way. I have my own preference but I do respect the other developer’s preference as…

SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

January 1, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

First of all, happy New Year to all of you – 2013 has started! Every year I make at least one resolution, some I do for the public on my blog. The reason is simple – if I declare something in front of all of you, there is a good…

SQLAuthority News – Last Post of Year 2012

December 31, 2012

Pinal Dave

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

The year 2012 was the most interesting year. If I start listing what was special about this year – I think it will take me 2-3 days to just write a blog post about this subject. Let me pick few things which I would like to specifically call out. SQL…

SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)

December 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Here is the question received from user – the email was long and had multiple request from reader to resolve this error. Scenario: The user was trying to import data from Excel to tables in SQL Server Database. Every time he attempted to import the data he faced following error.…

SQL SERVER – Weekly Series – Memory Lane – #009

December 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future

December 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

Regular readers who are familiar with my blog will be also familiar with my interest in NuoDB. It is a very innovative new age database which follows 100% SQL, ACID and Elastically Scalability. Here is an earlier article on this subject where we explain why sharing will no more required…

SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.

December 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is the interesting conversation I recently heard between two teammates in one of the organizations I visited. DBA Jr: I can’t take transactional backup of the database. DBA Sr: What is the recovery model? DBA Jr: How to find the recovery model? DBA Sr: Go to SSMS >> Right…