All Articles - SQL Authority with Pinal Dave

SQL SERVER – Changing Default Installation Path for SQL Server

November 11, 2012

Earlier I wrote a blog post about SQL SERVER – Move Database Files MDF and LDF to Another Location and in the blog post we discussed how we can change the location of the MDF and LDF files after database is already created. I had mentioned that we will discuss how…

SQL SERVER – Beginning New Weekly Series – Memory Lane – #002

November 10, 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 favorite…

SQLAuthority News – #SQLPASS 2012 Book Signing Photos

November 9, 2012

Pinal Dave

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

SQL PASS, SQLAuthority Author Visit

I am at SQLPASS 2012 and the event is going great. Here are few of the random photos and random news. We had participated in three different book signing event today. SQL Queries 2012 Joes 2 Pros Book 1 Launch and Book Signing SQL 2012 Functions Book Launch at Embarcadero…

SQLAuthority News – Learning, Community and Book Signing at #SQLPASS 2012

November 8, 2012

Pinal Dave

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

SQL PASS, SQLAuthority Book Review

SQLPASS event is going excellent we are having great great fun! We are having book signing events and the response is overwhelmingly positive. I am glad that all of you love our books and I totally appreciate your support. Rick and I both are feeling very motivated to write more…

SQLAuthority News – 2 New Books – FREE Books and Book Signing at #SQLPASS 2012

November 7, 2012

Pinal Dave

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

Joes 2 Pros, SQL PASS, SQLAuthority Book Review

As an author the most interesting task is to participate in Book Signing Events. If you are at SQLPASS – we are going to have a lot of book signing events. Here is the good news! MY NEW BOOKS ARE OUT! SQL 2012 Functions Limited Edition Click to Expand This…

SQLAuthority News – #SQLPASS 2012 Schedule – Where can You Find Me

November 6, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL PASS

Yesterday I wrote about my memory lane with SQLPASS. It has been a fantastic experience and I am very confident that this year the same excellent experience is going to be repeated. Before I start for #SQLPASS every year, I plan where I want to be and what I…

SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011

November 5, 2012

Pinal Dave

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

SQL PASS

Today is the first day of the SQLPASS 2012 and I will be soon posting SQL Server 2012 experience over here. Today when I landed in Seattle, I got the nostalgia feeling. I used to stay in the USA. I stayed here for more than 7 years – I studied…

SQLAuthority News – Why I am Going to Attend #SQLPASS Summit 2012 – Seattle

November 4, 2012

Pinal Dave

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

I am going to Seattle I once again attend SQLPASS this year. This will be my fourth SQLPASS. Lots of people ask me why I am going to SQLPASS every year. Well there are so many different reasons for that. I go to SQLPASS because – I love it! Here…

SQL SERVER – Beginning New Weekly Series – Memory Lane – #001

November 3, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

I am introducing a new series today. This series is called “Memory Lane.” From the last six years and 2,300 articles, there are fantastic articles I keep revisiting. Sometimes when I read old blog posts I think I should have included something or added a bit more to the topic. …

SQL SERVER – Function to Round Up Time to Nearest Minute Interval

November 2, 2012

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

Though I have written more than 2300 blog posts, I always find things which I have not covered earlier in this blog post. Recently I was asked if I have written a function which rounds up or down the time based on the minute interval passed to it. Well, not earlier, but it is here today about how to create a function to round up time to nearest minute interval.