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

SQLAuthority News – Resolutions of Year 2013 – Commitment to Myself

January 1, 2013

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…

SQL SERVER – What is Hekaton? – Simple Words Explanation

December 23, 2012

Pinal Dave

SQL

SQL Server

Readers of this blog will know that I recently attended SQL Server (PASS) Summit 2012. There were, of course, a lot of fascinating subjects and people, but let me talk about one of my favorites right now. Ted Kummert, corporate vice president of the Data Platform group at Microsoft, announced that the new version of SQL Server will include a feature called “Hekaton.” Hekaton is Greek for “hundreds,” and it was given this name for its ability to speed up database function 100x (possibly). It certainly increases application speed by 10x and nearly 50x for new, optimized applications.