SQL Tips and Tricks Archives - Page 243 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Weekly Series – Memory Lane – #007

December 15, 2012

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…

SQL Contest – Result of Cartoon Contest

December 14, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier we had an excellent contest ran with the help of Embarcadero Technologies. We had two different contests on the same day sponsored by the kind folks at Embarcadero. Here are the details of the winners. 1) Win USD 25 Amazon Gift Cards (10 Units) We had announced that we will…

SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore

December 13, 2012

Pinal Dave

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

Two years ago I spoke at Southeast Asia SharePoint Conference 2011, Singapore and I had a fantastic time to present to the Singapore audience. The session was very well received and lots of interest was generated. The event is back again this year and with much bigger scale. I will be…

SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12

December 12, 2012

Pinal Dave

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

SQL in Sixty Seconds

Today is 12/12/12 – I am not sure when will I write this kind of date again – maybe never. This opportunity comes once in a lifetime when we have the same date, month and year all have same digit. December 12th is one of the most fantastic day in…

SQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve

December 11, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is the question received just this morning. “Pinal, Our application is much different than other application you might have come across. In simple words, I would like to call it Asynchronous Updated Application. We need your quick opinion about one of the situation which we are facing. From business…

SQL Authority News – Download SQL Server Data Type Conversion Chart

December 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Datatypes are very important concepts of SQL Server and there are quite often need to convert them from one datatypes to another datatype. I have seen that deveoper often get confused when they have to convert the datatype. There are two important concept when it is about datatype conversion. Implicit…

SQL SERVER – Weekly Series – Memory Lane – #006

December 8, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane